public void fillGridTop5(DataGridView GV)
{
string query = String.Format("SELECT top 5 date_and_time,description,credit,debit,balance FROM Transactions where userid={0} order by date_and_time desc", Session.user.id);
BuisnessLogic bl = new BuisnessLogic();
DataSet ds = bl.Adapter(query);
GV.DataSource = ds.Tables[0];
}
public void fillGrid(DataGridView GV)
{
string query = String.Format("select transaction_id,date_and_time,description,credit,debit,balance from transactions where userid={0}", Session.user.id);
BuisnessLogic bl = new BuisnessLogic();
DataSet ds = bl.Adapter(query);
GV.DataSource = ds.Tables[0];
}
public void searchStatements(DataGridView GV, String search)
{
String query = String.Format("SELECT transaction_id,date_and_time,description,credit,debit,balance from [Transactions] where ([description] like '%" + @search + "%' or [date_and_time] like '%" + @search + "%') and userid={0}", Session.user.id);
Console.WriteLine(query);
BuisnessLogic bl = new BuisnessLogic();
DataSet ds = bl.Adapter(query);
GV.DataSource = ds.Tables[0];
}