how to fetch a particular field in a dataset?

[Guest]

Hi,

The dataset is filled with the queryresult like this:
sda = New SqlDataAdapter(sqlstring, ConnectString)
dt = New DataSet()
sda.Fill(dt)

Is it now possible to fetch a particular field of a particular record, like
SqlDataReader and the GetValue() method?

Thanks

 

[Guest]

Hi,

Yes, you can use
DataRow[] rows = dt.Select("CLAUSE"); //CLAUSE = like a where clause
without WHERE
//to extract a row or some rows.
if (rows!=null && rows.Length>0)
rows[0].ItemArray[x]; //where x is a index in ItemArray...

Bye

 

[Guest]

Sorry the code is for a 'DataTable dt', but you can use a DataTable in place
of your DataSet and it will work.

Hi,

Yes, you can use
DataRow[] rows = dt.Select("CLAUSE"); //CLAUSE = like a where clause
without WHERE
//to extract a row or some rows.
if (rows!=null && rows.Length>0)
rows[0].ItemArray[x]; //where x is a index in ItemArray...

Bye

Hi,

The dataset is filled with the queryresult like this:
sda = New SqlDataAdapter(sqlstring, ConnectString)
dt = New DataSet()
sda.Fill(dt)

Is it now possible to fetch a particular field of a particular record, like
SqlDataReader and the GetValue() method?

Thanks

 

[Cor Ligthert [MVP]]

a,

A dataset is a wrapper around datatables and datarelations
Datatables holds datarows and datacolumns.
Datacolumns describes the items in a datarow

Therefore
ds.tables(0).rows(0).item(0) is the first item in the first row in the first
table of your dataset ds.
However there are a lot of overloads therefore
ds.tables(0).rows(0).item("columname") gives the same.

Be aware that it are always objects that are returned in a so called non
strongly typed dataset, and therefore you have to cast even if it is with a
string with "ToSring"

I hope this helps,

Cor

 

[Guest]

Thanks

a,

A dataset is a wrapper around datatables and datarelations
Datatables holds datarows and datacolumns.
Datacolumns describes the items in a datarow

Therefore
ds.tables(0).rows(0).item(0) is the first item in the first row in the first
table of your dataset ds.
However there are a lot of overloads therefore
ds.tables(0).rows(0).item("columname") gives the same.

Be aware that it are always objects that are returned in a so called non
strongly typed dataset, and therefore you have to cast even if it is with a
string with "ToSring"

I hope this helps,

Cor