public DataTable filterItemTrace(string item)
{
try
{
OleDbConnection connect = new OleDbConnection();
OleDbCommand cmd = new OleDbCommand();
connect.ConnectionString = connection_string;
connect.Open();
cmd.Connection = connect;
cmd.CommandText = @"Select [date], [DnInv], [VC],[In],[Out],[Balance] FROM trace WHERE Item = '" + item + "';";
OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
DataTable data_table = new DataTable();
adapter.Fill(data_table);
connect.Close();
return(data_table);
}
catch (Exception)
{
TableBuilder tb = new TableBuilder();
return(tb.fillTableTrace());
}
}