C# DataTable Column 목록 얻기
1. 정의
- DataTable에 속해 있는 컬럼목록을 String[] 에 Setting하기
2. 방법1 - LINQ 메서드 이용
- String[] colNm = datatable.Columns.Cast<DataColumn >()
.Select(x => x.ColumnName)
.ToArray();
3. 방법2 - LINQ 쿼리 이용
- String[] colNm2 = (from dc in datatable.Columns.Cast<DataColumn >()
select dc.ColumnName).ToArray();
4. 방법3
- var arrayNames = (from DataColumn x in datatable.Columns
select x.ColumnName).ToArray();
5. 방법4
- DataTable dt = new DataTable();
foreach (DataColumn dc in datatable.Rows.Columns)
{
if (dc.ColumnName == "MyColumn")
{
// Do code
}
}
6. 방법5
- // For each DataTable, print the ColumnName.
foreach (DataTable table in dataSet.Tables)
{
foreach (DataColumn column in table.Columns)
{
Console.WriteLine(column.ColumnName);
}
}