How do I retrive the data from a table by passing a parameter to a stored Procedure and store it in a DataSet

See more:

C#3.0

C#

stored-procedure

Below is my code,I am not able to retrieve the data and store it in the Dataset ds, I am a beginner so don't know how to solve this.




public static DataSet GetTestDetails(string testVariable)
{

SqlConnection sqlConn = new SqlConnection();
sqlConn.ConnectionString = ConfigurationManager.AppSettings["connTestConn"];
SqlParameter parameter1 = null;
try
{
parameter1 = new SqlParameter("@TestVariable", SqlDbType.VarChar);
parameter1.Value = testVariable;
DataSet ds = SqlHelper.ExecuteDataSet(sqlConn, "TestStoredProcedure", parameter1);
return ds;
}
finally
{
parameter1 = null;

if (sqlConn != null && sqlConn.State == ConnectionState.Open)
{
sqlConn.Close();
}
}

}


thanks in Advance :)