/// <summary> /// Списък на таблиците /// </summary> public List <string> GetTables() { List <string> listTables = null; using (SqlConnection sqlConnection = DBUtilsMSSQL.OpenConnection(_ConnectionString)) { listTables = GetTables(sqlConnection); sqlConnection.Close(); } return(listTables); }
/// <summary> /// Списък на колонките в таблицата /// </summary> public List <DBTableColumn> GetTableColumns(string tableName) { List <DBTableColumn> listTables = null; using (SqlConnection sqlConnection = DBUtilsMSSQL.OpenConnection(_ConnectionString)) { listTables = GetTableColumns(sqlConnection, tableName); sqlConnection.Close(); } 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(); } }