return all records using Web Service

[IsMale]

Hi.

I am new to web services. Could someone please help me with the scripts below?

I will be parsing a GroupID to the web service. This web services will the connect to a stored procedure which will return all records belonging to the GroupID. My problem is how do i "return" the row and columns of data to the C# page that is requesting the Web Service?

heres part of my Web service scripts...
Thanks

[PHP] [WebMethod]
public string FetchRecords(int GroupID, string View){
SqlCommand command = new SqlCommand();

DataSet dataSet = new DataSet();

string sp = "";
if (retriveNum != null){
sp = "sp_GetAllRecords";
}
else
sp = "sp_GetTop10Records";

SqlDataAdapter dataAdapter = new SqlDataAdapter(sp, Connection_string);
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;

dataAdapter.SelectCommand.Parameters.Add("@GroupID ", SqlDbType.Int);
dataAdapter.SelectCommand.Parameters["@GroupID"].Value = GroupID;


}[/PHP]

[nateraaaa]

I believe the DataTable object is serializable and can be sent as a response via XML. Try returning a DataTable with the row and column data.

 DataTable dataTable = dataSet.Tables[0];  
 

Nathan