protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { String query = "select * from Country"; ob.ExeAdapter(query, "Contry"); ob.DropList(DropDownList1, query, "Country_id", "Country_name", "---select Country---"); } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString.Count > 0) { name = Request.QueryString["Email"].ToString(); string qury = "select CandidateName from CandidateRegistration where email='" + name + "'"; ds = ob.ExeAdapter(qury, "CandidateRegistration"); candidatename = ""; if (ds.Tables["CandidateRegistration"].Rows.Count > 0) { candidatename = ds.Tables["CandidateRegistration"].Rows[0]["CandidateName"].ToString(); } } else { Response.Redirect("Candidatelogin.aspx"); } string qry = "select profile from CandidateRegistration where email='" + name + "'"; ds = ob.ExeAdapter(qry, "CandidateRegistration"); if (ds.Tables["CandidateRegistration"].Rows.Count > 0) { Image1.ImageUrl = ds.Tables["CandidateRegistration"].Rows[0]["profile"].ToString(); } else { Image1.ImageUrl = ds.Tables["CandidateRegistration"].Rows[0]["profile"].ToString(); } string query = "select * from Edit where email='" + name + "'"; ds = ob.ExeAdapter(query, "Edit"); if (ds.Tables["Edit"].Rows.Count != 0) { lbl_name.Text = candidatename; Label2.Text = ds.Tables["Edit"].Rows[0]["Skill"].ToString(); Label3.Text = ds.Tables["Edit"].Rows[0]["Study"].ToString(); Label4.Text = ds.Tables["Edit"].Rows[0]["Home"].ToString(); Label5.Text = ds.Tables["Edit"].Rows[0]["Pview"].ToString(); Label6.Text = ds.Tables["Edit"].Rows[0]["Qparty"].ToString(); Label7.Text = ds.Tables["Edit"].Rows[0]["Nparty"].ToString(); Label8.Text = ds.Tables["Edit"].Rows[0]["Aparty"].ToString(); } else { Label2.Text = ""; Label3.Text = ""; Label4.Text = ""; Label5.Text = ""; Label6.Text = ""; Label7.Text = ""; Label8.Text = ""; } }
protected void Button2_Click(object sender, EventArgs e) { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@pass", TextBox10.Text), new SqlParameter("@cpass", chgnp.Text), new SqlParameter("@cont", chgcon0.Text) }; string query = "select Password from CandidateRegistration where Password=@pass"; ds = ob.ExeAdapter(query, parameter, "CandidateRegistration"); int count = ds.Tables["CandidateRegistration"].Rows.Count; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@pass", TextBox10.Text), new SqlParameter("@cpass", chgnp.Text), new SqlParameter("@cont", chgcon0.Text) }; if (count > 0) { query = "update CandidateRegistration set Password=@cpass where Password=@pass"; ob.ExeQuery(query, parameters); Response.Redirect("Candidate.aspx?Email=" + name); } else { Response.Write("<script>alert('Your password is incorrect:')</script>"); } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString.Count > 0) { string name = Request.QueryString["no"].ToString(); // Response.Write(name); int count = Convert.ToInt32(name); img = new Image[count]; img1 = new Image[count]; brk = new Label[count]; brk1 = new Label[count]; brk2 = new Label[count]; brk3 = new Label[count]; txt = new Label[count]; string query = "select * from CandidateRegistration"; ds = ob.ExeAdapter(query, "CandidateRegistration"); int a = ds.Tables["CandidateRegistration"].Rows.Count; for (int index = 0; index < count; index++) { img[index] = new Image(); string st = ds.Tables["CandidateRegistration"].Rows[a - 1]["profile"].ToString(); img[index].ImageUrl = st; img[index].Width = 200; img[index].Height = 200; string st1 = ds.Tables["CandidateRegistration"].Rows[(a - 1)]["CandidateName"].ToString(); brk[index] = new Label(); brk[index].Text = "<br/><br/>"; txt[index] = new Label(); txt[index].Text = "Candidate Name: " + st1; txt[index].CssClass = "font"; brk2[index] = new Label(); /* img1[index] = new Image(); * string st3 = ds.Tables["CandidateRegistration"].Rows[a - 1]["ElectionSign"].ToString(); * img1[index].ImageUrl = st3; * img1[index].Width = 200; * img1[index].Height = 200; */ brk1[index] = new Label(); brk1[index].Text = "<br/><br/><hr/>"; a--; PlaceHolder1.Controls.Add(img[index]); PlaceHolder1.Controls.Add(brk[index]); PlaceHolder1.Controls.Add(txt[index]); PlaceHolder1.Controls.Add(brk1[index]); } } }
protected void Button1_Click(object sender, EventArgs e) { string Email = Cname.Text; string password = TextBox2.Text; string query = "select * from CandidateRegistration where email=@email and Password=@pass"; SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@email", Email), new SqlParameter("@pass", password) }; ds = common.ExeAdapter(query, parameter, "CandidateRegistration"); int count = ds.Tables["CandidateRegistration"].Rows.Count; if (count == 1) { // Response.Redirect("Candidate.aspx"); Response.Redirect("Candidate.aspx?Email=" + Cname.Text); } else { Response.Write("<script>alert('Your Name id or password is incorrect:')</script>"); } }
protected void Page_Load(object sender, EventArgs e) { /*Session["count"]=Convert.ToInt32(Session["count"])+1; * Response.Write("Session Count :" + Session["count"]+"<br/>");*/ if (Session["id"] != null) { uid = Session["id"].ToString(); query = "Select * from user_details where userid=@id"; SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@id", uid) }; DataSet ds = common.ExeAdapter(query, parameter, "users"); string username = ds.Tables["users"].Rows[0]["name"].ToString(); string email = ds.Tables["users"].Rows[0]["email"].ToString(); string path = ds.Tables["users"].Rows[0]["image"].ToString(); ImageButton1.ImageUrl = path; alert += "Welcome " + username + "!"; alert += "EmailID : " + email; Response.Write("<script>alert('" + alert + "')</script>"); lbl_name.Text = lbl_name2.Text = username; txt_mail.Text = ds.Tables["users"].Rows[0]["email"].ToString(); txt_mobile.Text = ds.Tables["users"].Rows[0]["mobileno"].ToString(); //Formatting address string----------------------------------------------------- string address = ds.Tables["users"].Rows[0]["address"].ToString(); string[] adr = address.Split('+'); address = ""; for (int i = 0; i < adr.Length; i++) { address += adr[i] + ","; } address = address.Replace('=', '-'); txt_address.Text = address; ///fetching voterID from UserID------------------------------------------ /// query = "select image from images where imageid=@id"; parameter = new SqlParameter[] { new SqlParameter("@id", uid) }; object vid = common.ExeScalar(query, parameter); voterid = vid.ToString(); img_voterid.ImageUrl = voterid; img_voterid.AlternateText = username + "VoterID"; } else { Response.Redirect("Userlogin.aspx"); } }