public void FillGrid(DataGridView GV) { string query = "select * from [CurrentTransaction]"; Business_Logic BBL = new Business_Logic(); DataSet ds = BBL.Adapter(query); GV.DataSource = ds.Tables[0]; }
public void FillGrid(DataGridView GV) { string query = "select * from StorageInfo"; Business_Logic BBL = new Business_Logic(); DataSet ds = BBL.Adapter(query); GV.DataSource = ds.Tables[0]; }
public void updateFillGrid(DataGridView GV) { string query = "update values into table StorageInfo * from StorageInfo"; Business_Logic BBL = new Business_Logic(); OleDbDataAdapter adapter = new OleDbDataAdapter(); OleDbCommandBuilder build = new OleDbCommandBuilder(adapter); DataSet ds = BBL.Adapter(query); adapter.Update(ds); GV.DataSource = ds.Tables[0]; }
public void searchFillGrid(DataGridView GV, Storage_DB sDB, String se) { if (se == "***All***") { string query = "select * from StorageInfo"; Business_Logic BBL = new Business_Logic(); DataSet ds = BBL.Adapter(query); GV.DataSource = ds.Tables[0]; } else { string query = String.Format("select * from StorageInfo where item = '{0}'", se); Business_Logic BBL = new Business_Logic(); DataSet ds = BBL.Adapter(query); GV.DataSource = ds.Tables[0]; } }