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; }