其实要达到这个目的很简单,我们以SqlCommand执行一个存储过程为例,看看怎么样让它返回一个DataSet.
我们先来看下面这段代码:
我们先来看下面这段代码:
public
DataSet PickNumber()
{
SqlCommand comm = new SqlCommand();
comm.CommandText = "PickNumber";
comm.Connection = Sqlcn;
comm.CommandType = CommandType.StoredProcedure;
SqlParameter ParameterCount = new SqlParameter();
ParameterCount.ParameterName = "@Count";
ParameterCount.SqlDbType = SqlDbType.Int;
ParameterCount.Value = XH.DataAccess.DataAccess.PersonCount;
ParameterCount.Direction = ParameterDirection.Input;
comm.Parameters.Add(ParameterCount);
sad = new SqlDataAdapter(comm);
try
{
sad.Fill(ds,"PickNumber");
XH.DataAccess.DataAccess.iState = 0;
}
catch(System.Exception)
{
XH.DataAccess.DataAccess.iState = 4;
}
finally
{
sad.Dispose();
}
return ds;
}
{
SqlCommand comm = new SqlCommand();
comm.CommandText = "PickNumber";
comm.Connection = Sqlcn;
comm.CommandType = CommandType.StoredProcedure;
SqlParameter ParameterCount = new SqlParameter();
ParameterCount.ParameterName = "@Count";
ParameterCount.SqlDbType = SqlDbType.Int;
ParameterCount.Value = XH.DataAccess.DataAccess.PersonCount;
ParameterCount.Direction = ParameterDirection.Input;
comm.Parameters.Add(ParameterCount);
sad = new SqlDataAdapter(comm);
try
{
sad.Fill(ds,"PickNumber");
XH.DataAccess.DataAccess.iState = 0;
}
catch(System.Exception)
{
XH.DataAccess.DataAccess.iState = 4;
}
finally
{
sad.Dispose();
}
return ds;
}
看完上面这段代码是不是觉得原来是这么的简单了呢?我们还可以这样做,根据执行的存储过程或者SQL语句的类型,如果是SELECT语句,我们就这样写:
sad.SelectCommand
=
comm;
如果是INSERT语句,就依此类推,就说这么多了。