Please Help me- Returning DataSet from a Web Service

Hi All
My Web Service is returning a DataSet. I realized that we cannot
return a DataReader.. Normally we can use a DataReader( when not
using Web services) and access it as below to assign values of columns
of returned rows to Labels in the client aplication such as:
while (dtrJobDetails.Read())
{
l_shortjobdesc.Text = dtrJobDetails["shortjobdesc"].ToString();
}
where dtrJobDetails is a DataReader.
But now I am forced to return back a DataSet.. Is there anyway of
showing the individual column values returned from a DataSet in
individual labels like we do in a DataReader as above... I dont want
to show it in a DataGrid or a DataList...
Please help me.. I have been trying to figure this out since two
days..
Any help will be highly appreciated...
Thanks,
SumairaHi, you could try something like
DataSet oDS = ' Retrieved from your webservice'
Response.Write(oDS.Tables[0].DefaultView[0].Row["Blah"].ToString());
hth
Mark
"Sumaira Ahmad" <sumaira.ahmad@.gmail.com> wrote in message
news:1627c5ae.0411011325.75864c65@.posting.google.com...
> Hi All
> My Web Service is returning a DataSet. I realized that we cannot
> return a DataReader.. Normally we can use a DataReader( when not
> using Web services) and access it as below to assign values of columns
> of returned rows to Labels in the client aplication such as:
> while (dtrJobDetails.Read())
> {
> l_shortjobdesc.Text = dtrJobDetails["shortjobdesc"].ToString();
> }
> where dtrJobDetails is a DataReader.
> But now I am forced to return back a DataSet.. Is there anyway of
> showing the individual column values returned from a DataSet in
> individual labels like we do in a DataReader as above... I dont want
> to show it in a DataGrid or a DataList...
> Please help me.. I have been trying to figure this out since two
> days..
> Any help will be highly appreciated...
> Thanks,
> Sumaira
foreach (DataRow dr in ds.Tables[0])
{
l_shortjobdesc.Text = dr["shortjobdesc"].ToString();
}
note: you should avoid databinding with DataReaders as it may cause
blocking/scaling/resource problems, because databinding is slow, and occurs
after the query. passing datasets is a much better solution. it adds very
little overhead, but frees the query pipe quickly, releasing the locks.
-- bruce (sqlwork.com)
"Sumaira Ahmad" <sumaira.ahmad@.gmail.com> wrote in message
news:1627c5ae.0411011325.75864c65@.posting.google.com...
> Hi All
> My Web Service is returning a DataSet. I realized that we cannot
> return a DataReader.. Normally we can use a DataReader( when not
> using Web services) and access it as below to assign values of columns
> of returned rows to Labels in the client aplication such as:
> while (dtrJobDetails.Read())
> {
> l_shortjobdesc.Text = dtrJobDetails["shortjobdesc"].ToString();
> }
> where dtrJobDetails is a DataReader.
> But now I am forced to return back a DataSet.. Is there anyway of
> showing the individual column values returned from a DataSet in
> individual labels like we do in a DataReader as above... I dont want
> to show it in a DataGrid or a DataList...
> Please help me.. I have been trying to figure this out since two
> days..
> Any help will be highly appreciated...
> Thanks,
> Sumaira