public static API_SqlServer map_Table_Data(this API_SqlServer SqlServer, Table table)
{
var sqlQuery = "select * from [{0}].[{1}].[{2}]".format(table.Catalog, table.Schema, table.Name);
table.TableData = SqlServer.executeReader(sqlQuery);
return(SqlServer);
}
public static List <string> database_Names(this API_SqlServer sqlServer)
{
var names = new List <string>();
var sqlQuery = "select name from master..sysDatabases";
foreach (DataRow row in sqlServer.executeReader(sqlQuery).Rows)
{
names.add(row.ItemArray[0].str());
}
return(names);
}
public static API_SqlServer add_Viewer_QueryResult <T>(this API_SqlServer sqlServer, T control, string sqlQuery)
where T : Control
{
control.clear();
var dataTable = sqlServer.executeReader(sqlQuery);
var dataGridView = control.add_DataGridView();
dataGridView.DataError += (sender, e) => { // " dataGridView error: {0}".error(e.Context);
};
dataGridView.invokeOnThread(() => dataGridView.DataSource = dataTable);
return(sqlServer);
}
