Esempio n. 1
0
 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());
     }
 }