retrieve the data included in DataTable

[tuzojazz]

Hi:

I'm programing an asp.net (VB code) which calls a web service function which returns a DataSet.

A DataTable is included in the DataSet.

How Can I retrieve the data included in the DataTable?

can I use something like an OleDbDataReader to read stream of data rows?

Thanks!

 

[DotNetGnat]

bind the datatable to the datagrid...something like this:

mydatagrid.DataSource = mydatatable
nydatagrid.DataBind()

-DNG

 

[tperri]

You can use a Data Reader to read through the data as well. It just depends on what you want to do with the returned data as to how you read/display it.

 

[ca8msm]

If you want to access the DataTable in the DataSet, you can just reference the relevant table i.e.

myDataSet.Tables(0)

You can then bind this table directly to a data control (i.e. a GridView) or you can loop through it (faq855-5662).




____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[tuzojazz]

Can I use something like

myDataSet.Tables(0).Columns(1)

or what is the correct syntax?

When I get data column in this way, I get the data type just as the DataSet contain it?

 

[ca8msm]

what is the correct syntax?

Have you read the FAQ I linked to?


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.