"zarish" <shahrukh@hotmail.com> wrote in message
news:usLiFurcDHA.856@tk2msftngp13.phx.gbl...
> 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(sqlQuery,conn);
> SqlDataReader reader = comm.ExecuteReader();
> while(reader.Read())
> {
> Console.WriteLine(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.
>
>
>