/// <summary> /// Списък на колонките в таблицата /// </summary> public List <DBTableColumn> GetTableColumns(SqlConnection sqlConnection, string tableName) { string commandText = "SELECT cl.COLUMN_NAME " + " , cl.DATA_TYPE " + " FROM INFORMATION_SCHEMA.COLUMNS cl " + " WHERE cl.TABLE_NAME = " + DBUtilsMSSQL.ParameterString(tableName) + " ORDER BY cl.ORDINAL_POSITION "; List <DBTableColumn> listTableColumns = new List <DBTableColumn>(); using (DataTable dtTables = new DataTable()) { DBUtilsMSSQL.Fill(dtTables, commandText, sqlConnection); foreach (DataRow drTable in dtTables.Rows) { DBTableColumn col = new DBTableColumn(); col.Name = drTable["COLUMN_NAME"].ToString(); col.DataType = drTable["DATA_TYPE"].ToString().ToLower(); col.Caption = col.Name; col.VComponent = this.GetVisualComponent(col.DataType); listTableColumns.Add(col); } } return(listTableColumns); }
/// <summary> /// Списък на таблиците /// </summary> public List <string> GetTables(SqlConnection sqlConnection) { string commandText = "SELECT '['+tb.TABLE_SCHEMA+'].['+tb.TABLE_NAME+']' AS TABLE_ID " + " , tb.TABLE_NAME " + " FROM INFORMATION_SCHEMA.TABLES tb " + " WHERE tb.TABLE_TYPE = 'BASE TABLE' " + " ORDER BY tb.TABLE_SCHEMA, tb.TABLE_NAME "; List <string> listTables = new List <string>(); using (DataTable dtTables = new DataTable()) { DBUtilsMSSQL.Fill(dtTables, commandText, sqlConnection); foreach (DataRow drTable in dtTables.Rows) { listTables.Add(drTable["TABLE_NAME"].ToString()); } } return(listTables); }
public void FillTable(DataTable table, string columns, string tableName) { if (columns == "") { return; } if (tableName == "") { return; } string commandText = "SELECT " + columns + " FROM " + tableName; using (SqlConnection sqlConnection = DBUtilsMSSQL.OpenConnection(_ConnectionString)) { DBUtilsMSSQL.Fill(table, commandText, sqlConnection); sqlConnection.Close(); } }