public static DataTable GetTableColumns(string strTblName) { string strQuery = string.Format(@"SELECT TABLE_NAME,COLUMN_NAME,DATA_TYPE,CHARACTER_MAXIMUM_LENGTH,ORDINAL_POSITION,IS_NULLABLE,CHARACTER_OCTET_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '{0}'", strTblName); DataSet ds = GetDataSet(strQuery); if (!TableColumnList.ContainsKey(strTblName)) { TableColumnList.Add(strTblName, GetDataTableByDataSet(ds)); } return(GetDataTableByDataSet(ds)); }
public static DataRow GetTableColumn(string strTblName, string strColumnName) { if (!TableColumnList.ContainsKey(strTblName)) { GetTableColumns(strTblName); } if (TableColumnList.ContainsKey(strTblName)) { DataRow[] rows = TableColumnList[strTblName].Select(string.Format("COLUMN_NAME = '{0}'", strColumnName)); if (rows.Length > 0) { return(rows[0]); } } return(null); }