return a recordset from ado.net

[zarish]

hi
i am trying to return a recordset from my web service to my c# app.


[WebMethod]
public SQLDataReader getAllCities()
{
string sqlQuery = "select CityName from city";
SqlCommand comm = new SqlCommand(sqlQ uery,conn);
SqlDataReader reader = comm.ExecuteRea der();
while(reader.Re ad())
{
Console.WriteLi ne(reader[0]);
}
return reader;
}


but i dont know how to return it.

also how can i view the results , when i invoke the webservice?



thanx

Zarish.

[Ivar]

Re: return a recordset from ado.net


Hi,

Just use SqlDataAdapter, use SqlDataAdapter. Fill() to fill DataSet, return
DataSet instead of SQLDataReader.

"zarish" <shahrukh@hotma il.com> wrote in message
news:usLiFurcDH A.856@tk2msftng p13.phx.gbl...[color=blue]
> hi
> i am trying to return a recordset from my web service to my c# app.
>
>
> [WebMethod]
> public SQLDataReader getAllCities()
> {
> string sqlQuery = "select CityName from city";
> SqlCommand comm = new SqlCommand(sqlQ uery,conn);
> SqlDataReader reader = comm.ExecuteRea der();
> while(reader.Re ad())
> {
> Console.WriteLi ne(reader[0]);
> }
> return reader;
> }
>
>
> but i dont know how to return it.
>
> also how can i view the results , when i invoke the webservice?
>
>
>
> thanx
>
> Zarish.
>
>
>[/color]