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]

[code=vbnet]
SqlConnection objconn = new SqlConnection(" server=<ServerN ame>;database=< DatabaseName>;u id=<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.Coun t; intLoop++)
{
MessageBox.Show (dt.Columns[intLoop].ColumnName);
}[/code]