void loadToComboBox(string par1, string par2, SqlDbType type, string procedureName, string displayMember, string valueMember, ComboBox comoBoxName) { SqlParameter[] array = { new SqlParameter(par1, type) { Value = par2 }, }; var cmd = db.cmd(procedureName, array); var dt = db.returnDataTable(cmd); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds, procedureName); comoBoxName.DataSource = ds.Tables[procedureName]; comoBoxName.DisplayMember = displayMember; comoBoxName.ValueMember = valueMember; //SqlParameter[] array = { // new SqlParameter("@companyId", SqlDbType.Int) { Value = companyId }, // }; //var cmd = db.cmd("selectProductsForSpecificCompany", array); //var dt = db.returnDataTable(cmd); //SqlDataAdapter da = new SqlDataAdapter(cmd); //DataSet ds = new DataSet(); //da.Fill(ds, "selectProductsForSpecificCompany"); //productCombo.DataSource = ds.Tables["selectProductsForSpecificCompany"]; //productCombo.DisplayMember = "productName"; //productCombo.ValueMember = "productName"; //refreshDataGridView(); }
public void refreshDataGridView() { SqlParameter[] array = { new SqlParameter("@role", SqlDbType.NVarChar) { Value = noaaCombo.SelectedItem }, }; var cmd = db.cmd("selectPerson", array); var dt = db.returnDataTable(cmd); dataGridView1.DataSource = dt; }
public void refreshDataGridView() { SqlParameter[] array = { new SqlParameter("@companyId", SqlDbType.Int) { Value = companyId }, }; var cmd = db.cmd("selectAllCompanyReciepts", array); var dt = db.returnDataTable(cmd); dataGridView1.DataSource = dt; }
public void refreshDataGridView() { SqlParameter[] array = { new SqlParameter("@companyId", SqlDbType.Int) { Value = companyId }, }; var cmd = db.cmd("selectProductsForSpecificCompany", array); var dt = db.returnDataTable(cmd); dataGridView1.DataSource = dt; //DataTable dt = new DataTable(); //db.openConnection(); //dt.Load(cmd.ExecuteReader()); //db.closeConnection(); //dataGridView1.DataSource = dt; }