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.