protected void btnaddproduct_Click(object sender, EventArgs e) { try { string qry1 = "Select * from Productdata where productname ='" + txtproductname.Text + "'"; if (ExecuteQuery(qry1) == false) { if (txtproductname.Text != "" && txtproductqty.Text != "") { string str; str = "Insert into Productdata values ('" + Session["dealerid"].ToString() + "','" + txtproductname.Text + "','" + txtproductqty.Text + "')"; Global_c.Runquery(str); txtproductname.Text = ""; txtproductqty.Text = ""; txtproductname.Focus(); } else { Response.Write("<script language=\"javascript\">alert(\"Please Enter Product Name!!\");</Script>"); } } else { Response.Write("<script language=\"javascript\">alert(\"Please product Quntity!\");</Script>"); } refreshdata(); } catch (Exception ex) { lblerror.Text = ex.Message; } }
protected void Button1_Click1(object sender, EventArgs e) { try { //here front end is actually getting connected with backend in background string qry; if (ddlpost.SelectedItem.ToString() == "User") { qry = "insert into regagri values ('" + txtname.Text + "','" + txtage.Text + "','" + ddlgender.Text + "','" + txtpasssword.Text + "','" + txtmailid.Text + "','" + ddlpost.Text + "','" + ddlsque.Text + "','" + txtsans.Text + "','0', '0')"; Global_c.Runquery(qry); } if (ddlpost.SelectedItem.ToString() == "Shop Owner") { qry = "insert into regagri values ('" + txtname.Text + "','" + txtage.Text + "','" + ddlgender.Text + "','" + txtpasssword.Text + "','" + txtmailid.Text + "','" + ddlpost.Text + "','" + ddlsque.Text + "','" + txtsans.Text + "','" + ddlarea.Text + "', '0')"; Global_c.Runquery(qry); } if (ddlpost.SelectedItem.ToString() == "Professional Adviser") { qry = "insert into regagri values ('" + txtname.Text + "','" + txtage.Text + "','" + ddlgender.Text + "','" + txtpasssword.Text + "','" + txtmailid.Text + "','" + ddlpost.Text + "','" + ddlsque.Text + "','" + txtsans.Text + "','0', '0')"; Global_c.Runquery(qry); } txtname.Text = ""; txtage.Text = ""; txtpasssword.Text = ""; txtmailid.Text = ""; txtsans.Text = ""; Response.Redirect("Waiting_Page.aspx"); } catch (Exception ex) { lblerror.Text = ex.Message; } }
protected void btnUpload_Click(object sender, EventArgs e) { if (FileUpload1.PostedFile != null && txtname.Text != "") { try { string FileName = txtname.Text + ".mp4"; FileUpload1.PostedFile.SaveAs(Server.MapPath("videodatabase/" + FileName)); string CS = ConfigurationManager.ConnectionStrings["cnstr1"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { string filepathvideo = "videodatabase/" + FileName; string str; str = "Insert into videodata values ('" + FileName + "','" + filepathvideo + "')"; Global_c.Runquery(str); BindGrid(); lblMessage.Text = "Your file uploaded successfully"; lblMessage.ForeColor = System.Drawing.Color.Green; txtname.Text = ""; } } catch (Exception) { lblMessage.Text = "Your file not uploaded"; lblMessage.ForeColor = System.Drawing.Color.Red; txtname.Text = ""; } } else { lblMessage.Text = "Enter Proper Name and select Proepr File"; lblMessage.ForeColor = System.Drawing.Color.Red; txtname.Focus(); } }
protected void btndelet_Click(object sender, EventArgs e) { foreach (GridViewRow gvrow in GridView1.Rows) { CheckBox chck = gvrow.FindControl("CheckBox1") as CheckBox; if (chck.Checked) { var Label = gvrow.FindControl("Label1") as Label; string qry2 = "delete from videodata where videoId= '" + Label.Text + "'"; // SqlCommand cmd = new SqlCommand(qry2, con); //cmd.Parameters.AddWithValue("Idproduct", int.Parse(Label.Text)); //con.Open(); //int id = cmd.ExecuteNonQuery(); //con.Close(); //refreshdata(); Global_c.Runquery(qry2); BindGrid(); } } }