GETTING DATA FROM A DataSet ??

[glenn]

Can anyone tell me how to pull data from a dataset?

In my Page_Load function, I use the following code:

Dim str As String
Dim ds As System.Data.Dat aSet
Dim dt As System.Data.Dat aTable
Dim dr As System.Data.Dat aRow
Dim dc As System.Data.Dat aColumn

ds = UserTypeQueryMe thod()

For Each dt In ds.Tables
For Each dr In dt.Rows
For Each dc In dt.Columns
if dr(dc) = "owner" then
msgbox(dc.Defau ltValue.ToStrin g())
if dc.DataType <> DBNull then
'GET THE VALUE OF THE COLUMN IN A ROW IN A
TABLE
end if
end if
Next dc
Next dr
Next dt

[Sahil Malik [MVP C#]]

ds.Tables(0).Ro ws(0)(0) ' <--- Somethin' Like that.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.ma.../13/63199.aspx
----------------------------------------------------------------------------

"glenn" <gl***@discussi ons.microsoft.c om> wrote in message
news:E0******** *************** ***********@mic rosoft.com...

Can anyone tell me how to pull data from a dataset?

In my Page_Load function, I use the following code:

Dim str As String
Dim ds As System.Data.Dat aSet
Dim dt As System.Data.Dat aTable
Dim dr As System.Data.Dat aRow
Dim dc As System.Data.Dat aColumn

ds = UserTypeQueryMe thod()

For Each dt In ds.Tables
For Each dr In dt.Rows
For Each dc In dt.Columns
if dr(dc) = "owner" then
msgbox(dc.Defau ltValue.ToStrin g())
if dc.DataType <> DBNull then
'GET THE VALUE OF THE COLUMN IN A ROW IN
A
TABLE
end if
end if
Next dc
Next dr
Next dt

[sloan]

You are trying to treat a DataSet, as one used to treat ADODB.RecordSet s.

This isn't good practice.

I'd look into the concept of "strongly typed" datasets. you can google that
and find alot of info.

If you don't want to use strongly typed datasets...then I think the issue is
the Column. I don't think this is the info itself, but rather the metadata
about the columns.
Aka, the EmpID, LastName, FirstName

and not the
123,Smith,John
234,Jones,Mary

...


"glenn" <gl***@discussi ons.microsoft.c om> wrote in message
news:E0******** *************** ***********@mic rosoft.com...

Can anyone tell me how to pull data from a dataset?

In my Page_Load function, I use the following code:

Dim str As String
Dim ds As System.Data.Dat aSet
Dim dt As System.Data.Dat aTable
Dim dr As System.Data.Dat aRow
Dim dc As System.Data.Dat aColumn

ds = UserTypeQueryMe thod()

For Each dt In ds.Tables
For Each dr In dt.Rows
For Each dc In dt.Columns
if dr(dc) = "owner" then
msgbox(dc.Defau ltValue.ToStrin g())
if dc.DataType <> DBNull then
'GET THE VALUE OF THE COLUMN IN A ROW IN A TABLE
end if
end if
Next dc
Next dr
Next dt

[VHD50]

Your code basically loops through each DataTable in the DataSet and get the
value of each "cell" if that "cell" is not null ---> You are pulling data
from the dataset already... :) Declare this varibale along with the others:
Dim dataPulledFromD S As String = ""
Then in the for loops, right upder the line "'GET THE VALUE OF THE COLUMN IN
A ROW IN A TABLE" put in
dataPulledFromD S = CStr(ds.Tables( dt).Rows(dr).It em(dc))
MsgBox(dataPull edFromDS)

Hope this helps,
VHD50.

"glenn" wrote:

Can anyone tell me how to pull data from a dataset?

In my Page_Load function, I use the following code:

Dim str As String
Dim ds As System.Data.Dat aSet
Dim dt As System.Data.Dat aTable
Dim dr As System.Data.Dat aRow
Dim dc As System.Data.Dat aColumn

ds = UserTypeQueryMe thod()

For Each dt In ds.Tables
For Each dr In dt.Rows
For Each dc In dt.Columns
if dr(dc) = "owner" then
msgbox(dc.Defau ltValue.ToStrin g())
if dc.DataType <> DBNull then
'GET THE VALUE OF THE COLUMN IN A ROW IN A
TABLE
end if
end if
Next dc
Next dr
Next dt