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???