protected void Page_Load(object sender, EventArgs e) { MyiTestDataDataContext db = new MyiTestDataDataContext(); int iduser = (int)(Session["idlogin"]); st_GetUserInfoResult user = db.st_GetUserInfo(iduser).FirstOrDefault(); if (user != null) { txtUsername.Text = user.iUserName; } }
protected void Page_Load(object sender, EventArgs e) { MyiTestDataDataContext db = new MyiTestDataDataContext(); //if (Session["UserName"] != null) { gdv_User.DataSource = db.st_GetUserInfo(Convert.ToInt32(Session["idlogin"])); gdv_User.DataBind(); lblUserName.Text = gdv_User.Rows[0].Cells[1].Text; lblCreatedDate.Text = gdv_User.Rows[0].Cells[6].Text; lblEmail.Text = gdv_User.Rows[0].Cells[3].Text; lblSumBuonus.Text = db.st_GetBonus(Convert.ToInt32(Session["idlogin"])).ToString(); float sumtest = (float)db.st_GetSumTest(Convert.ToInt32(Session["idlogin"])); float summark = (float)db.st_GetMark(Convert.ToInt32(Session["idlogin"])); lblSumMark.Text = summark.ToString(); lblSumTest.Text = sumtest.ToString(); double avg = Math.Round((double)(summark/sumtest),2); lblAvgMark.Text = avg.ToString(); } }