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