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