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);
}
public TableColumnCollection(Table owner, TableColumnList columnDefs)
{
this.m_owner = owner;
this.m_columnDefs = columnDefs;
}
internal TableColumnCollection(Table owner, TableColumnList columnDefs)
{
m_owner = owner;
m_columnDefs = columnDefs;
}
