asp.net help

[abeetha.m]

i wrote some code here,in this code stored procedure is returning a datareader objectSqlConnection sqlConnection1 = new SqlConnection("Your Connection String");SqlCommand cmd = new SqlCommand();SqlDataReader reader;cmd.CommandText = "StoredProcedureName";cmd.CommandType = CommandType.StoredProcedure;cmd.Connection = sqlConnection1;sqlConnection1.Open();reader = cmd.ExecuteReader();sqlConnection1.Close();now::: in the same is there any method which returns dataset???

[Bhushan]

Hi,Instead of a DataReader, make use of DataSet object.You can have a function which will return a dataset.example: System.Data.DataSet function_name(){//your code herereturn //your dataset object.}