public static DataSet ExecuteDataset(Int32 empid)
{
SqlParameter[] param = new SqlParameter[1];
SqlParameter p1 = new SqlParameter(PARAM1NAME, empid);
param[0] = p1;
return(_sqlHelper.ExecuteDataset(PROCEDURE_NAME, param));
}
public static DataSet ExecuteDataset(string Username, string Password)
{
_sqlHelper = new IISQLHelper(InsideInningDB.InsideInning_CONNECTIONSTRING);
SqlParameter[] param = new SqlParameter[2];
SqlParameter p1 = new SqlParameter(PARAM1NAME,Username);
SqlParameter p2 = new SqlParameter(PARAM2NAME,Password);
param[0] = p1;
param[1] = p2;
return _sqlHelper.ExecuteDataset(PROCEDURE_NAME, param);
}
public static DataSet ExecuteDataset(string Username, string Password)
{
_sqlHelper = new IISQLHelper(InsideInningDB.InsideInning_CONNECTIONSTRING);
SqlParameter[] param = new SqlParameter[2];
SqlParameter p1 = new SqlParameter(PARAM1NAME, Username);
SqlParameter p2 = new SqlParameter(PARAM2NAME, Password);
param[0] = p1;
param[1] = p2;
return(_sqlHelper.ExecuteDataset(PROCEDURE_NAME, param));
}
public static DataSet ExecuteDataset()
{
return(_sqlHelper.ExecuteDataset(PROCEDURE_NAME, null));
}
