how to get first row results

[Gert Albertse]

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!)
"Gert Albertse" <Ge**********@discussions.microsoft.com> wrote in message
news:38**********************************@microsof t.com...

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?

[Kostadin Kostov]

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

"Gert Albertse" wrote:

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?

[Gert Albertse]

I'm using IDbDataAdapter and a dataset

"Karl Seguin" wrote:

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!)
"Gert Albertse" <Ge**********@discussions.microsoft.com> wrote in message
news:38**********************************@microsof t.com...

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]

Kostadin answered your question then...

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

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

Cheers,
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!)
"Gert Albertse" <Ge**********@discussions.microsoft.com> wrote in message
news:1B**********************************@microsof t.com...

I'm using IDbDataAdapter and a dataset

"Karl Seguin" wrote:

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!)
"Gert Albertse" <Ge**********@discussions.microsoft.com> wrote in message news:38**********************************@microsof t.com...

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?