首先：
using xsystem.DB;
函数使用
public int AnimalAdd(string AnimalName, string AnimalSex)
{
int rowsAffected;
SqlParameter[] parameters = {
new SqlParameter("@AnimalID", SqlDbType.Int,4),
new SqlParameter("@AnimalName", SqlDbType.VarChar,50),
new SqlParameter("@AnimalSex", SqlDbType.Char,2)};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = AnimalName;
parameters[2].Value = AnimalSex;
SQLHelper.RunProcedure("MS_Animal_ADD", parameters, out rowsAffected);
return (int)parameters[0].Value;
}
public DataSet AnimalsGet(string AnimalSex)
{
string strSql = "select * from [Animal] where AnimalSex=@AnimalSex;";
SqlParameter[] parameters = {
new SqlParameter("@AnimalSex", SqlDbType.Char,2)};
parameters[0].Value =AnimalSex;
DataSet ds=SQLHelper.Query(strSql, parameters);
return ds;
}
