62,072
社区成员
发帖
与我相关
我的任务
分享
public static DataSet ExecuteDataSet(CommandType cmdType, string cmdText, SqlParameter[] cmdparms)
{
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
try
{
cmd.CommandType = cmdType;
cmd.CommandText = cmdText;
foreach (SqlParameter parms in cmdparms)
{
cmd.Parameters.Add(parms);
}
cmd.Parameters.Clear();
da.SelectCommand=cmd;
da.Fill(ds);
}
catch (System.Exception ex)
{
throw new Exception(ex.Message);
}
return ds;
}
public DataSet SelectByID(int CaID)
{
string sql = "SELECT * FROM CATEGORY WHERE CaID=@CaID";
SqlParameter[] parms ={
new SqlParameter("@CaID",SqlDbType.Int,4)
};
parms[0].Value = CaID;
DataSet ds = SqlHelper.ExecuteDataSet(CommandType.Text, sql, parms);
return ds;
}