如何通过将参数传递给存储过程并将其存储在DataSet中来从表中检索数据 [英] How do I retrive the data from a table by passing a parameter to a stored Procedure and store it in a DataSet

问题描述

下面是我的代码，我无法检索数据并将其存储在Dataset ds中，我是初学者所以不知道如何解决这个问题。









public static DataSet GetTestDetails（string testVariable）

{



SqlConnection sqlConn = new SqlConnection（）;

sqlConn.ConnectionString = ConfigurationManager.AppSettings [connTestConn];

SqlParameter parameter1 = null;

尝试

{

parameter1 = new SqlParameter（@ TestVariable，SqlDbType.VarChar）;

parameter1.Value = testVariable;

DataSet ds = SqlHelper.ExecuteDataSet（sqlConn，TestStoredProcedure，parameter1）;

返回ds;

}

终于

{

parameter1 = null;



if（sqlConn！= null && sqlConn.State == ConnectionState.Open）

{

sqlConn.Close（）; < br $>
}

}



}





感谢提前：）

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 :)

推荐答案

尝试

C# Dataset Tutorial [ ^ ]

http：// www.dotnetperls.com/dataset [ ^ ]

http://www.homeandlearn.co.uk/csharp/csharp_s12p6.html [ ^ ]

Try
C# Dataset Tutorial [^]
http://www.dotnetperls.com/dataset[^]
http://www.homeandlearn.co.uk/csharp/csharp_s12p6.html[^]

这篇关于如何通过将参数传递给存储过程并将其存储在DataSet中来从表中检索数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！