public static DataTableStore GetDataTableStore(ISQLConnectionSettings tmpSettings, string query) { SqlAbstractConnector sqlConnector = SetConnector(tmpSettings); sqlConnector.EvntInfoMessage += SqlConnector_EvntInfoMessage; DataTableStore dataTableStore = GetDataTableStore(sqlConnector, query); sqlConnector.EvntInfoMessage -= SqlConnector_EvntInfoMessage; return(dataTableStore); }
static DataTableStore GetDataTableStore(SqlAbstractConnector sqlConnector, string query) { DataTableStore data = new DataTableStore(); try { using DataTable dt = sqlConnector.GetTable(query); data.Set(dt); dt?.Dispose(); } catch (Exception err) { data.Errors = $"{err.Message}{Environment.NewLine}{message}"; } return(data); }
public void Set(DataTableStore dataTable) { lock (locker) { if (dataTable?.Data?.Rows?.Count > 0) { Data = dataTable.Data.Copy(); Errors = null; } else { Data = new DataTable(); Errors = dataTable?.Errors; } } EvntDataTableChanged?.Invoke(this, new BoolEventArgs(true)); }