C# - get value of a column in a DataRow

[Chet]

I have a DataRow from a table in a data set. One of the columns has a
name of "COMPANY_TICKET_ID" and I'm trying to get this column's value
with the following:

foreach( DataRow[] row in ds.Tables[ 0 ].Rows )
Console.WriteLine( row[ "COMPANY_TICKET_ID" ].ToString() );

I get an error - cannot implicity convert type 'string' to 'int'.

What am I missing? Thanks.

 

[Curt_C [MVP]]

row[x] expects the INT of the row index, not the column "name"

 

[Patrick Steele [MVP]]

I have a DataRow from a table in a data set. One of the columns has a
name of "COMPANY_TICKET_ID" and I'm trying to get this column's value
with the following:

foreach( DataRow[] row in ds.Tables[ 0 ].Rows )
Console.WriteLine( row[ "COMPANY_TICKET_ID" ].ToString() );

I get an error - cannot implicity convert type 'string' to 'int'.

The Rows property returns a DataRowCollection that you are iterating
over with the foreach. However, each item in a DataRowCollection is a
DataRow, not a DataRow[]. Use:

foreach(DataRow row in ds.Tables[0].Rows )

Now that 'row' is a DataRow, you can index it by either index position
(int) or column name (string).

 

[Nick]

foreach(DataRow row in ds.Tables[0].Rows)
Console.WriteLine(((int)row["COMPANY_TICKET_ID"]).ToString());