Learning DataSets!

JenniQ · February 5th, 2005, 03:23 PM

Hey, this is a easy question - I feel kinda dumb asking it but I am learing the concepts of DataSets and DataTables, etc.

I have a DataTable. I output the contents of a column like so:

Response.Write(DT.Rows[0].Table.Columns["ProductID"].ToString());

And the output is "ProductID", but not the value. If I do a simple databind to a datagrid I get this:

ID Quantity ProductID Cost Size Color
1 1 27 29.95 1 21

I want to retrieve the value! which is "1".

What am I doing wrong?

mehdi62b · February 5th, 2005, 04:34 PM

you should write,

Code:

DT.Rows[rowNumber][ColumnNumber or ColumnName].ToString();

Quote:

quote:DT.Rows[0].Table.Columns["ProductID"].ToString());

in this you wrote,
Rows[0].Table gives you the DataTable that contains Rows[0] then Columns["ProductID"].ToString() gives you the name of DataColumn(Columns["ProductID"]).

_____________________________
Mehdi.
software engineering student.
Looking for a good job for summer 2005.

JenniQ · February 5th, 2005, 04:52 PM

That makes sense now.

The dataset is a very complex and extensive .net component. I guess that is a good thing, but it sure makes it tuff to learn.

Thank you for your help.