protected void upd_btn_Click(object sender, EventArgs e) { con.Open(); //SqlCommand cmd = new SqlCommand("admin_add_complaint_proc", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@action", "update"); //cmd.Parameters.AddWithValue("@pk_id", Label_id.Text); //cmd.Parameters.AddWithValue("@batch", Batch_dll.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@stream", streamddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@class", class_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@section", section_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@Student_name", student_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@student_rollno", roll_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@date", System.DateTime.Now.ToString()); //cmd.Parameters.AddWithValue("@complaint", Text_complaint.Text); //cmd.ExecuteNonQuery(); finance.Financeserv obj = new finance.Financeserv(); int a = obj.addcomplaintupdate(Convert.ToInt32(Label_id.Text), Batch_dll.SelectedItem.ToString(), streamddl.SelectedItem.ToString(), class_ddl.SelectedItem.ToString(), section_ddl.SelectedItem.ToString(), student_ddl.SelectedItem.ToString(), roll_ddl.SelectedItem.ToString(), System.DateTime.Now.ToString(), Text_complaint.Text); if (a > 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Updated!!!!');", true); gridshow(); blank(); con.Close(); upd_btn.Visible = false; submit_btn.Visible = true; } }
protected void submit_btn_Click(object sender, EventArgs e) { con.Open(); //SqlCommand cmd = new SqlCommand("addfee_proc", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@action", "insert"); //cmd.Parameters.AddWithValue("@pk_id", ""); //cmd.Parameters.AddWithValue("@batch", Batch_dll.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@stream", streamddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@class", class_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@section", section_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@feetype", ddl_type.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@date", (DateTime.ParseExact(deposit_txt.Text,"dd/MM/yyyy",CultureInfo.InvariantCulture)).ToShortDateString()); //cmd.Parameters.AddWithValue("@fee", fee_txt.Text); //cmd.ExecuteNonQuery(); finance.Financeserv obj = new finance.Financeserv(); int a = obj.insert(Batch_dll.SelectedItem.ToString(), streamddl.SelectedItem.ToString(), class_ddl.SelectedItem.ToString(), section_ddl.SelectedItem.ToString(), ddl_type.SelectedItem.ToString(), (DateTime.ParseExact(deposit_txt.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture)).ToShortDateString(), fee_txt.Text); if (a > 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Submitted!!!!');", true); gridshow(); blank(); } con.Close(); }
protected void upd_btn_Click(object sender, EventArgs e) { con.Open(); //SqlCommand cmd = new SqlCommand("addfee_proc", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@action", "update"); //cmd.Parameters.AddWithValue("@pk_id", Label_id.Text); //cmd.Parameters.AddWithValue("@batch", Batch_dll.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@stream", streamddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@class", class_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@section", section_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@feetype", ddl_type.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@date", deposit_txt.Text); //cmd.Parameters.AddWithValue("@fee", fee_txt.Text); //cmd.ExecuteNonQuery(); finance.Financeserv obj = new finance.Financeserv(); int a = obj.update(Convert.ToInt32(Label_id.Text), Batch_dll.SelectedItem.ToString(), streamddl.SelectedItem.ToString(), class_ddl.SelectedItem.ToString(), section_ddl.SelectedItem.ToString(), ddl_type.SelectedItem.ToString(), deposit_txt.Text, fee_txt.Text); if (a > 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Updated!!!!');", true); gridshow(); blank(); } con.Close(); upd_btn.Visible = false; submit_btn.Visible = true; batch(); stream(); classname(); section(); }
protected void submit_btn_Click(object sender, EventArgs e) { string senderusername; senderusername = Label9.Text; string senderpassword; senderpassword = Label10.Text; string senderid; senderid = Label11.Text; con.Open(); //SqlCommand cmd = new SqlCommand("admin_add_complaint_proc", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@action", "insert"); //cmd.Parameters.AddWithValue("@pk_id", ""); //cmd.Parameters.AddWithValue("@batch", Batch_dll.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@stream", streamddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@class", class_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@section", section_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@Student_name", student_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@student_rollno", roll_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@date", System.DateTime.Now.ToString()); //cmd.Parameters.AddWithValue("@complaint", Text_complaint.Text); //cmd.ExecuteNonQuery(); finance.Financeserv obj = new finance.Financeserv(); int a = obj.addcomplaintinsert(Batch_dll.SelectedItem.ToString(), streamddl.SelectedItem.ToString(), class_ddl.SelectedItem.ToString(), section_ddl.SelectedItem.ToString(), student_ddl.SelectedItem.ToString(), roll_ddl.SelectedItem.ToString(), System.DateTime.Now.ToString(), Text_complaint.Text); if (a > 0) { string sURL; string message1 = "Hello Sir " + "\n\n" + "Complaint :" + Text_complaint.Text + "\n\n"; StreamReader objReader; sURL = "http://pointsms.in/API/sms.php?username="******"&password="******"&from=" + senderid + "&to=" + father_contact.Text + "&msg=" + message1; WebRequest wrGETURL; wrGETURL = WebRequest.Create(sURL); try { Stream objStream; objStream = wrGETURL.GetResponse().GetResponseStream(); objReader = new StreamReader(objStream); objReader.Close(); } catch (Exception ex) { ex.ToString(); } ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Submitted!!!!');", true); gridshow(); blank(); } con.Close(); }
public void gridshow() { //SqlDataAdapter da = new SqlDataAdapter("admin_add_complaint_dlt_proc", con); //da.SelectCommand.CommandType = CommandType.StoredProcedure; //da.SelectCommand.Parameters.AddWithValue("@action", "show"); //da.SelectCommand.Parameters.AddWithValue("@pk_id", ""); //DataTable dt = new DataTable(); //da.Fill(dt); finance.Financeserv obj = new finance.Financeserv(); GridView1.DataSource = obj.addcomplaintshow(); GridView1.DataBind(); }
public void gridshow() { //SqlDataAdapter da = new SqlDataAdapter("studentinfo_procevent", con); //da.SelectCommand.CommandType = CommandType.StoredProcedure; //da.SelectCommand.Parameters.AddWithValue("@action", "show"); //da.SelectCommand.Parameters.AddWithValue("@student_id", ""); //DataTable dt = new DataTable(); //da.Fill(dt); finance.Financeserv obj = new finance.Financeserv(); GridView1.DataSource = obj.studentshow(); GridView1.DataBind(); }
protected void btn_delete_Click(object sender, EventArgs e) { con.Open(); LinkButton lnk = (LinkButton)sender; GridViewRow row = (GridViewRow)lnk.NamingContainer; Label l1 = (Label)row.FindControl("Lbl_id"); //SqlCommand cmd = new SqlCommand("parentinfo_procevent", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@action", "delete"); //cmd.Parameters.AddWithValue("@parent_id", l1.Text); //cmd.ExecuteNonQuery(); finance.Financeserv obj = new finance.Financeserv(); int a = obj.parentdelete(Convert.ToInt32(l1.Text)); if (a > 0) { gridshow(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Deleted!!!!');", true); } con.Close(); }
protected void upd_btn_Click(object sender, EventArgs e) { con.Open(); //SqlCommand cmd = new SqlCommand("parentinfo_proc", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@action", "update"); //cmd.Parameters.AddWithValue("@parent_id", Label_id.Text); //cmd.Parameters.AddWithValue("@firstname", Parent_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@student_name", sname_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@relation", relation_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@dob", dob_txt.Text); //cmd.Parameters.AddWithValue("@qualification", quali_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@occupation", occupation_txt.Text); //cmd.Parameters.AddWithValue("@income", income_txt.Text); //cmd.Parameters.AddWithValue("@email", email_txt.Text); //cmd.Parameters.AddWithValue("@mobilephone", mob_txt.Text); //cmd.Parameters.AddWithValue("@password", lbl_pass.Text); //cmd.Parameters.AddWithValue("@type", "parent"); //cmd.ExecuteNonQuery(); finance.Financeserv obj = new finance.Financeserv(); int a = obj.parentupdate(Convert.ToInt32(Label_id.Text), Parent_ddl.SelectedItem.ToString(), sname_ddl.SelectedItem.ToString(), relation_ddl.SelectedItem.ToString(), dob_txt.Text, quali_ddl.SelectedItem.ToString(), occupation_txt.Text, income_txt.Text, email_txt.Text, mob_txt.Text, lbl_pass.Text, "parent"); if (a > 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Updated!!!!');", true); gridshow(); blank(); clr_btn.Visible = true; upd_btn.Visible = false; submit_btn.Visible = true; } con.Close(); }
protected void submit_btn_Click(object sender, EventArgs e) { string senderusername; senderusername = Label9.Text; string senderpassword; senderpassword = Label10.Text; string senderid; senderid = Label11.Text; con.Open(); SqlCommand com = new SqlCommand("select * from parentinfo where student_name='" + sname_ddl.SelectedItem.ToString() + "' and firstname='" + Parent_ddl.SelectedItem.ToString() + "' and email='" + email_txt.Text + "'", con); SqlDataReader dr = com.ExecuteReader(); if (dr.Read()) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Record Exist Already!!!!');", true); dr.Close(); blank(); } else { dr.Close(); //SqlCommand cmd = new SqlCommand("parentinfo_proc", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@action", "insert"); //cmd.Parameters.AddWithValue("@parent_id", ""); //cmd.Parameters.AddWithValue("@firstname", Parent_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@student_name", sname_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@relation", relation_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@dob", dob_txt.Text); //cmd.Parameters.AddWithValue("@qualification", quali_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@occupation", occupation_txt.Text); //cmd.Parameters.AddWithValue("@income", income_txt.Text); //cmd.Parameters.AddWithValue("@email", email_txt.Text); //cmd.Parameters.AddWithValue("@mobilephone", mob_txt.Text); //cmd.Parameters.AddWithValue("@type", "parent"); //Random ran = new Random(); //int i = ran.Next(1, 9); //int j = i * 689; //pass = "******" + j + "ER"; //cmd.Parameters.AddWithValue("@password", pass); finance.Financeserv obj = new finance.Financeserv(); int a = obj.parentinsert(Parent_ddl.SelectedItem.ToString(), sname_ddl.SelectedItem.ToString(), relation_ddl.SelectedItem.ToString(), dob_txt.Text, quali_ddl.SelectedItem.ToString(), occupation_txt.Text, income_txt.Text, email_txt.Text, mob_txt.Text, "parent", pass); if (a > 0) { var smtp = new System.Net.Mail.SmtpClient(); { smtp.Host = "smtp.gmail.com"; smtp.Port = 587; smtp.EnableSsl = true; smtp.Credentials = new NetworkCredential("*****@*****.**".ToString(), "my1234567".ToString()); } smtp.Send("*****@*****.**".ToString(), email_txt.Text, "Message".ToString(), "Your Loginid:- " + email_txt.Text + "\r\n" + "Your Password:- " + pass); //System.Net.Mail.MailMessage mail = new MailMessage(); //mail.From = new MailAddress("*****@*****.**"); //mail.To.Add(email_txt.Text); //mail.Subject = "Login Id Details"; //mail.Body = "<html><head><title>Login Id Details:</title></head><body><div><br/><br/><p>Your Loginid:" + email_txt.Text + "<br/>Your Password:-" + pass + "<br/> </div></body></Html>"; //mail.IsBodyHtml = true; //SmtpClient smtp = new SmtpClient(); //smtp.Host = "relay-hosting.secureserver.net"; //smtp.Port = 25; //smtp.EnableSsl = false; //smtp.Send(mail); //cmd.ExecuteNonQuery(); string sURL; string message1 = "Thanks For Registration" + "\n\n" + "Email:" + email_txt.Text + "\n\n" + "Password:"******"\n"; StreamReader objReader; sURL = "http://pointsms.in/API/sms.php?username="******"&password="******"&from=" + senderid + "&to=" + mob_txt.Text + "&msg=" + message1; WebRequest wrGETURL; wrGETURL = WebRequest.Create(sURL); try { Stream objStream; objStream = wrGETURL.GetResponse().GetResponseStream(); objReader = new StreamReader(objStream); objReader.Close(); } catch (Exception ex) { ex.ToString(); } ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Thanks For Registration!!!!');", true); gridshow(); blank(); } } con.Close(); }
protected void submit_btn_Click(object sender, EventArgs e) { string senderusername; senderusername = Label9.Text; string senderpassword; senderpassword = Label10.Text; string senderid; senderid = Label11.Text; con.Open(); SqlCommand com = new SqlCommand("select * from studentinfo where student_name='" + name_txt.Text + "' and father_name='" + father_txt.Text + "' and mother_name='" + mother_txt.Text + "' and roll_no='" + rollno_txt.Text + "' and email='" + email_txt.Text + "' and batch='" + batch_ddl.SelectedItem.ToString() + "' and class='" + class_ddl.SelectedItem.ToString() + "'", con); SqlDataReader dr = com.ExecuteReader(); if (dr.Read()) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Record Exist Already!!!!');", true); } else { dr.Close(); string imgg = ""; if (student_image.HasFile) { imgg = ("~/img/" + student_image.FileName); student_image.SaveAs(Server.MapPath("~/img/") + student_image.FileName); } string imgg1 = ""; if (doc_image.HasFile) { imgg1 = ("~/img/" + doc_image.FileName); doc_image.SaveAs(Server.MapPath("~/img/") + doc_image.FileName); } //SqlCommand cmd = new SqlCommand("studentinfo_proc", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@action", "insert"); //cmd.Parameters.AddWithValue("@student_id", ""); //cmd.Parameters.AddWithValue("@admission_no", admisn_no_txt.Text); //cmd.Parameters.AddWithValue("@admissiondate", admismdate_txt.Text); //cmd.Parameters.AddWithValue("@bloodgroup", blood_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@student_name", name_txt.Text); //cmd.Parameters.AddWithValue("@father_name", father_txt.Text); //cmd.Parameters.AddWithValue("@mother_name", mother_txt.Text); //cmd.Parameters.AddWithValue("@batch", batch_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@stream", stream_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@class", class_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@section", section_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@roll_no", rollno_txt.Text); //cmd.Parameters.AddWithValue("@dob", dob_txt.Text); //cmd.Parameters.AddWithValue("@gender", gender_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@country", ddl_country.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@state", ddl_state.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@city", ddl_city.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@address1", addres1_txt.Text); //cmd.Parameters.AddWithValue("@phone", mob_txt.Text); //cmd.Parameters.AddWithValue("@email", email_txt.Text); //Random ran = new Random(); //int i = ran.Next(1, 9); //int j = i * 456; //pass = "******" + j + "Ed"; //cmd.Parameters.AddWithValue("@password", pass); //Random ran1 = new Random(); //int k = ran.Next(1, 5); //int l = k * 456; //pass1 = "ST" + l + "Ed"; //cmd.Parameters.AddWithValue("@s_id", pass1); //cmd.Parameters.AddWithValue("@image", imgg); //cmd.Parameters.AddWithValue("@document_name", docname_txt.Text); //cmd.Parameters.AddWithValue("@doc_image", imgg1); //cmd.Parameters.AddWithValue("@type", "student"); finance.Financeserv obj = new finance.Financeserv(); int a = obj.studentinsert(admisn_no_txt.Text, admismdate_txt.Text, blood_ddl.SelectedItem.ToString(), name_txt.Text, father_txt.Text, mother_txt.Text, batch_ddl.SelectedItem.ToString(), stream_ddl.SelectedItem.ToString(), class_ddl.SelectedItem.ToString(), section_ddl.SelectedItem.ToString(), rollno_txt.Text, dob_txt.Text, gender_ddl.SelectedItem.ToString(), ddl_country.SelectedItem.ToString(), ddl_state.SelectedItem.ToString(), ddl_city.SelectedItem.ToString(), addres1_txt.Text, mob_txt.Text, email_txt.Text, pass, pass1, imgg, docname_txt.Text, imgg1, "student"); if (a > 0) { var smtp = new System.Net.Mail.SmtpClient(); { smtp.Host = "smtp.gmail.com"; smtp.Port = 587; smtp.EnableSsl = true; smtp.Credentials = new NetworkCredential("*****@*****.**".ToString(), "my1234567".ToString()); } smtp.Send("*****@*****.**".ToString(), email_txt.Text, "Message".ToString(), "Your Loginid:- " + email_txt.Text + "\r\n" + "Your Password:- " + pass + "\r\n" + "student id:- " + pass1); //System.Net.Mail.MailMessage mail = new MailMessage(); //mail.From = new MailAddress("*****@*****.**"); //mail.To.Add(email_txt.Text); //mail.Subject = "Login Id Details"; //mail.Body = "<html><head><title>Login Id Details:</title></head><body><div><br/><br/><p>Your Loginid:" + email_txt.Text + "<br/>Your Password:-" + pass + "<br/>" + "Student id:-" + pass1 + "<br/> </div></body></Html>"; //mail.IsBodyHtml = true; //SmtpClient smtp = new SmtpClient(); //smtp.Host = "relay-hosting.secureserver.net"; //smtp.Port = 25; //smtp.EnableSsl = false; //smtp.Send(mail); string sURL; string message1 = "Thanks For Registration" + "\n\n" + "Email:" + email_txt.Text + "\n\n" + "Password:"******"\n\n" + "Student ID" + pass1 + "\n"; StreamReader objReader; sURL = "http://pointsms.in/API/sms.php?username="******"&password="******"&from=" + senderid + "&to=" + mob_txt.Text + "&msg=" + message1; WebRequest wrGETURL; wrGETURL = WebRequest.Create(sURL); try { Stream objStream; objStream = wrGETURL.GetResponse().GetResponseStream(); objReader = new StreamReader(objStream); objReader.Close(); } catch (Exception ex) { ex.ToString(); } gridshow(); blank(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Thanks for Registration!!!!');", true); con.Close(); admisn_no_txt.Text = GetID("select max(admission_no) from studentinfo").ToString(); } } }
protected void upd_btn_Click(object sender, EventArgs e) { con.Open(); string imgg = ""; if (student_image.HasFile) { imgg = ("~/img/" + student_image.FileName); student_image.SaveAs(Server.MapPath("~/img/") + student_image.FileName); } else { imgg = Image2.ImageUrl; } string imgg1 = ""; if (doc_image.HasFile) { imgg1 = ("~/img/" + doc_image.FileName); doc_image.SaveAs(Server.MapPath("~/img/") + doc_image.FileName); } //SqlCommand cmd = new SqlCommand("studentinfo_proc", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@action", "update"); //cmd.Parameters.AddWithValue("@student_id", Label_id.Text); //cmd.Parameters.AddWithValue("@admission_no", admisn_no_txt.Text); //cmd.Parameters.AddWithValue("@admissiondate", admismdate_txt.Text); //cmd.Parameters.AddWithValue("@bloodgroup", blood_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@student_name", name_txt.Text); //cmd.Parameters.AddWithValue("@father_name", father_txt.Text); //cmd.Parameters.AddWithValue("@mother_name", mother_txt.Text); //cmd.Parameters.AddWithValue("@batch", batch_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@stream", stream_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@class", class_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@section", section_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@roll_no", rollno_txt.Text); //cmd.Parameters.AddWithValue("@dob", dob_txt.Text); //cmd.Parameters.AddWithValue("@gender", gender_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@country", gender_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@state", gender_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@city", gender_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@address1", addres1_txt.Text); //cmd.Parameters.AddWithValue("@phone", mob_txt.Text); //cmd.Parameters.AddWithValue("@email", email_txt.Text); //cmd.Parameters.AddWithValue("@password", lbl_pass.Text); //cmd.Parameters.AddWithValue("@s_id", lbl_sid.Text); //cmd.Parameters.AddWithValue("@image", imgg); //cmd.Parameters.AddWithValue("@document_name", docname_txt.Text); //cmd.Parameters.AddWithValue("@doc_image", imgg1); //cmd.Parameters.AddWithValue("@type", "student"); //cmd.ExecuteNonQuery(); finance.Financeserv obj = new finance.Financeserv(); int a = obj.studentupdate(Convert.ToInt32(Label_id.Text), admisn_no_txt.Text, admismdate_txt.Text, blood_ddl.SelectedItem.ToString(), name_txt.Text, father_txt.Text, mother_txt.Text, batch_ddl.SelectedItem.ToString(), stream_ddl.SelectedItem.ToString(), class_ddl.SelectedItem.ToString(), section_ddl.SelectedItem.ToString(), rollno_txt.Text, dob_txt.Text, gender_ddl.SelectedItem.ToString(), ddl_country.SelectedItem.ToString(), ddl_state.SelectedItem.ToString(), ddl_city.SelectedItem.ToString(), addres1_txt.Text, mob_txt.Text, email_txt.Text, lbl_pass.Text, lbl_sid.Text, imgg, docname_txt.Text, imgg1, "student"); if (a > 0) { gridshow(); } blank(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Updated!!!!');", true); submit_btn.Visible = true; upd_btn.Visible = false; Image2.Visible = false; con.Close(); }