To retrieve the column name.

[bsaira]

Hi,

I am coding in C#.

I need help finding simple way to retrieve a fields (or
columns) collection from a Dataset without filling it
first.

I cannot find the property of columnname.
Please help..

Thanks.

[aliasruel]

Hi,
Try this code...


DataSet1.Tables[0].Rows[0][fieldname];


regards,
ruel

Hi,

I am coding in C#.

I need help finding simple way to retrieve a fields (or
columns) collection from a Dataset without filling it
first.

I cannot find the property of columnname.
Please help..

Thanks.

[GayathriP]

SqlConnection objconn = new SqlConnection("server=<ServerName>;database=<DatabaseName>;uid=<UserID>;pwd=<Pwd>");
objconn.Open();
 
//This will not fill data as the where condition is specified as 1=2
SqlDataAdapter sa = new SqlDataAdapter("select query where 1=2", objconn);
 
DataTable dt = new DataTable();
 
sa.Fill(dt);
 
for (int intLoop = 0; intLoop < dt.Columns.Count; intLoop++)
{
MessageBox.Show(dt.Columns[intLoop].ColumnName);
}