public DataTable SelectByCriteria(string strCriteria)
{
DataSet ds = null;
SqlParameter[] parms =
{
new SqlParameter("pCriteria", strCriteria),
};
ds = SqlServerDAL.ExecuteDataset(strConnectionString, CommandType.StoredProcedure, "sp_UserMenuSelectByCriteria", parms);
return(ds.Tables[0]);
}
public DataTable SelectByID(int sintUserid, int sintMenuid)
{
DataSet ds = null;
SqlParameter[] parms =
{
new SqlParameter("pUserID", SqlDbType.SmallInt, 2, ParameterDirection.Input, false, 5, 0, "UserID", DataRowVersion.Current, sintUserid),
new SqlParameter("pMenuID", SqlDbType.SmallInt, 2, ParameterDirection.Input, false, 5, 0, "MenuID", DataRowVersion.Current, sintMenuid),
};
ds = SqlServerDAL.ExecuteDataset(strConnectionString,
CommandType.StoredProcedure,
"sp_UserMenuSelectByID",
parms);
return(ds.Tables[0]);
}