public DataTable GetMenuList(int ChildId)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@childid", ChildId);
return(ObjDb.ExecuteDataset("sp_get_menu", param).Tables[0]);;
}
public DataSet Select()
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Mode", "ViewActive");
return(objDBBridge.ExecuteDataset(_spName, param));
}
public DataTable setmatches()
{
DataSet mydataset = new DataSet();
SqlParameter[] dtm = new SqlParameter[1];
//dtm[0] = new SqlParameter("@setno", setno);
//mybridge.ExecuteDataset("getsetmatches", dtm);
DataTable dtmatches = new DataTable();
dtmatches = mybridge.ExecuteDataset("getsetmatches", dtm).Tables[0];
//if (dtmatches.Rows.Count != 0)
// {
// //DataRow drmatches;
//dtmatches = dtmatches.Rows[0];
return(dtmatches);
//}
}
public DataSet GetAgentBalance()
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Mode", "AgentBalance");
return(objDBBridge.ExecuteDataset(_spName, param));
}