private void OrderDetailsGrid_Load(object sender, EventArgs e)
{
DataSet dsProducts = DbAccess.ReturnDataSet("Select * From [Order Details] Where OrderID="
+ EmployeeOrder.veri);
dgvOrderDetails.DataSource = dsProducts.Tables[0].DefaultView;
}
public void cmbEmployee_SelectionChangeCommitted(object sender, EventArgs e)
{
DataSet dsOrders = DbAccess.ReturnDataSet("Select * From Orders Where EmployeeID ="
+ cmbEmployee.SelectedValue.ToString());
dgvOrders.DataSource = dsOrders.Tables[0].DefaultView;
}
private void dgvOrder_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataSet dsProducts = DbAccess.ReturnDataSet("Select Sum(Quantity) From [Order Details] Where ProductId="
+ dgvOrder.CurrentRow.Cells[0].Value.ToString());
MessageBox.Show(dsProducts.Tables[0].Rows[0][0].ToString());
}
private void Form1_Load(object sender, EventArgs e)
{
DataSet dsCategories = DbAccess.ReturnDataSet("Select CategoryId, CategoryName From Categories");
cmbCategory.DataSource = dsCategories.Tables[0].DefaultView;
cmbCategory.DisplayMember = "CategoryName";
cmbCategory.ValueMember = "CategoryId";
}
private void Category_Load(object sender, EventArgs e)
{
cmbCategory.Items.Clear();
DataSet dsEmployee = DbAccess.ReturnDataSet("Select * From Suppliers");
cmbCategory.DataSource = dsEmployee.Tables[0].DefaultView;
cmbCategory.DisplayMember = "CompanyName";
cmbCategory.ValueMember = "SupplierID";
}
public void EmployeeOrder_Load(object sender, EventArgs e)
{
cmbEmployee.Items.Clear();
DataSet dsEmployee = DbAccess.ReturnDataSet("Select * From Employees");
cmbEmployee.DataSource = dsEmployee.Tables[0].DefaultView;
cmbEmployee.DisplayMember = "FirstName";
cmbEmployee.ValueMember = "EmployeeID";
}
private void cmbCategory_SelectionChangeCommitted(object sender, EventArgs e)
{
DataSet dsOrders = DbAccess.ReturnDataSet("Select * From Products Where SupplierID =" + cmbCategory.SelectedValue.ToString());
dgvOrder.DataSource = dsOrders.Tables[0].DefaultView;
}
private void cmbOrders_SelectionChangeCommitted(object sender, EventArgs e)
{
DataSet dsOrders = DbAccess.ReturnDataSet("Select * From Orders Where CustomerID ='" + cmbOrders.SelectedValue.ToString() + "'");
dgvCustomers.DataSource = dsOrders.Tables[0].DefaultView;
}
