public DataSet SQLDB(string str_bjh)
{
try
{
SqlConnection CS = new
SqlConnection("Password = 123456;User ID = sa;"
+ "Initial Catalog = xsgl_en;"
+ "Data Source = (local)");
string sql="sp_test";//存储过程名称
SqlCommand selectCMD = new SqlCommand();
selectCMD.CommandText=sql;
selectCMD.Connection=CS;
selectCMD.CommandType = CommandType.StoredProcedure;
SqlParameter myParm = new SqlParameter("@bjh", SqlDbType.NVarChar, 10);
myParm.Direction = System.Data.ParameterDirection.Input;
myParm.Value = str_bjh;
selectCMD.Parameters.Add(myParm);
SqlDataAdapter myCommand = new SqlDataAdapter();
myCommand.SelectCommand=selectCMD;//主要是加这句
DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet, "Results");
return myDataSet;
}
catch(Exception ex)
{
return DataError(ex);
}
}
在C#中如何利用存储过程返回dataset??假设这个存储过程有一个参数
最新推荐文章于 2015-09-23 17:09:30 发布