protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// === modified by jeffery
//dsorder = Maticsoft.DBUtility.DbHelperSQL.Query("SELECT Are,count(Are) as 'Sum' FROM Room GROUP BY Are ");
QPS.NEW.DAL.SQLHelper sqlHelper = new NEW.DAL.SQLHelper(null);
dsorder = sqlHelper.GetDataSet("SELECT Are,count(Are) as 'Sum' FROM Room GROUP BY Are ",
CommandType.Text,
null);
// ===
DataList2.DataSource = dsorder;
DataList2.DataBind();
bind();
//if (Session["username"] ==null)
//{
// unLog.Visible = true;
// userLoginfo.Visible = false;
//}
//if (Session["username"] != null)
//{
// username = Session["username"].ToString();
// Label1.Text = username;
// unLog.Visible = false;
// userLoginfo.Visible = true;
// string query = "select DContent from Document where DType='5' ";
// DataSet doc = Maticsoft.DBUtility.DbHelperSQL.Query(query);
// Repeater1.DataSource = doc;
// Repeater1.DataBind();
//}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string query = "select DContent from Document where DType='3' ";
// === modified by jeffery
//DataSet ds= Maticsoft.DBUtility.DbHelperSQL.Query(query);
QPS.NEW.DAL.SQLHelper sqlHelper = new NEW.DAL.SQLHelper(null);
DataSet ds = sqlHelper.GetDataSet(query, CommandType.Text, null);
// ===
}
protected void Page_Load(object sender, EventArgs e)
{
string query="select DContent from Document where DType='3' ";
// === modified by jeffery
//DataSet ds= Maticsoft.DBUtility.DbHelperSQL.Query(query);
QPS.NEW.DAL.SQLHelper sqlHelper = new NEW.DAL.SQLHelper(null);
DataSet ds = sqlHelper.GetDataSet(query, CommandType.Text, null);
// ===
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// === modified by jeffery
//dsorder = Maticsoft.DBUtility.DbHelperSQL.Query("SELECT Are,count(Are) as 'Sum' FROM Room GROUP BY Are ");
QPS.NEW.DAL.SQLHelper sqlHelper = new NEW.DAL.SQLHelper(null);
dsorder = sqlHelper.GetDataSet("SELECT Are,count(Are) as 'Sum' FROM Room GROUP BY Are ",
CommandType.Text,
null);
// ===
DataList2.DataSource = dsorder;
DataList2.DataBind();
bind();
//if (Session["username"] ==null)
//{
// unLog.Visible = true;
// userLoginfo.Visible = false;
//}
//if (Session["username"] != null)
//{
// username = Session["username"].ToString();
// Label1.Text = username;
// unLog.Visible = false;
// userLoginfo.Visible = true;
// string query = "select DContent from Document where DType='5' ";
// DataSet doc = Maticsoft.DBUtility.DbHelperSQL.Query(query);
// Repeater1.DataSource = doc;
// Repeater1.DataBind();
//}
}
}
