public void Rebind() { DbLayer db = new DbLayer(); DataList1.DataSource = db.GetDataSet("select * from newsportal").Tables[0]; DataList1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DbLayer db = new DbLayer(); DataList1.DataSource = db.GetDataSet("select name,UserType,Date,BlogContent from Blog where Active='true'").Tables[0]; DataList1.DataBind(); } }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { DbLayer db = new DbLayer(); //DataSet ds = db.GetDataSet("SELECT t.FirstName,t.LastName,ta.ExpertiseArea, ta.WorkExperience,ta.ComfortableLevel,ta.Qalification,ta.ProjectAchievement,ta.Remark, ta.LastUpdate from TrainerAdvancePro ta inner join TrainerRegistration t ON t.UserId=ta.Userid "); DataSet ds = db.GetDataSet("SELECT t.UserId, t.FirstName,t.LastName,ta.ExpertiseArea, ta.WorkExperience,ta.ComfortableLevel,ta.Qalification,ta.ProjectAchievement,ta.Remark, ta.LastUpdate from TrainerAdvancePro ta inner join TrainerRegistration t ON t.UserId=ta.Userid where ta.ExpertiseArea='" + drpExperties.SelectedValue + "' and ta.Qalification='" + drpQali.SelectedValue + "' and ta.ComfortableLevel='" + drpComfor.SelectedValue + "'"); DataList1.DataSource = ds.Tables[0]; DataList1.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { lblError.Text = ""; DbLayer db = new DbLayer(); DataSet ds = db.GetDataSet("SELECT UserType,Active from Login where userId='" + teachername.Value.Trim() + "' and Password='******' "); if (ds.Tables[0].Rows.Count > 0) { if (Convert.ToBoolean(ds.Tables[0].Rows[0][1])) { string userType = ds.Tables[0].Rows[0][0].ToString(); if (userType == "Learner") { DataSet ds2 = db.GetDataSet("select FirstName,LastName from LearnerRegistration where userId='" + teachername.Value.Trim() + "'"); Session["name"] = ds2.Tables[0].Rows[0][0] + " " + ds2.Tables[0].Rows[0][1]; Session["userId"] = teachername.Value; Session["userType"] = ds.Tables[0].Rows[0][0].ToString(); Response.Redirect("Learner/AdvanceProfile.aspx"); } else { DataSet ds2 = db.GetDataSet("select FirstName,LastName from TrainerRegistration where userId='" + teachername.Value.Trim() + "'"); Session["name"] = ds2.Tables[0].Rows[0][0] + " " + ds2.Tables[0].Rows[0][1]; Session["userId"] = teachername.Value; Session["userType"] = ds.Tables[0].Rows[0][0].ToString(); Response.Redirect("Trainner/AdvanceProfileTrainer.aspx"); } } else { lblError.Text = "Your Id is Blocked !!!"; return; } } else { lblError.Text = "Invalid User Id or Password !"; } }
protected void Button2_Click(object sender, EventArgs e) { lblError.Text = ""; DbLayer db = new DbLayer(); DataSet ds = db.GetDataSet("SELECT Role from AdminLogin where userId='" + pupilname.Value.Trim() + "' and Password='******' "); if (ds.Tables[0].Rows.Count > 0) { Session["userId"] = pupilname.Value; Session["userType"] = ds.Tables[0].Rows[0][0].ToString(); Response.Redirect("Admin/ViewSuggestion.aspx"); } else { lblError.Text = "Invalid Admin Login "; } }
protected void Button1_Click(object sender, EventArgs e) { DbLayer db = new DbLayer(); DataSet ds = db.GetDataSet("select * from Login where UserId='" + Session["userId"].ToString() + "' and Password='******' "); if (ds.Tables[0].Rows.Count > 0) { int i = db.ExecuteNonQuery("Update Login set Password='******'where UserId='" + Session["userId"].ToString() + "' "); if (i > 0) { Label1.ForeColor = Color.Green; Label1.Text = "Your Password is Successfully Updated .."; } } else { Label1.ForeColor = Color.Red; Label1.Text = "Invalid Old Password plz Try again !!!"; } }