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;
}