how to get first row results

[Guest]

If my query results are more tha one row, how do I point to the firstrow and
the to the second row etc, to bind the data to textboxes?

 

[Karl Seguin]

are you getting the data into a SqlDataReader? A dataset??? ?

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)

 

[Guest]

How do you read your query results ? If you're using DataSet use:
myDataSet.Tables[0].Rows[Index]
If you're using DataReader, just use ReadNext method

Regards,
Kostadin Kostov

 

[Guest]

I'm using IDbDataAdapter and a dataset

are you getting the data into a SqlDataReader? A dataset??? ?

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)

 

[Karl Seguin]

Kostadin answered your question then...

//c#
ds.Tables[0].Rows[0]["ColumnName"]

'vb.net
ds.Tables(1).Rows(0)("ColumnName")

Cheers,
Karl