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