protected void btnsubmit_Click(object sender, EventArgs e) { if (sliderimage.HasFile) { string sliderpic = sliderimage.FileName; imagename = "PH" + "_" + Common.GenerateClassCode2() + "_" + sliderpic; string filePath2 = MapPath("../uploadimage/" + imagename); Stream Buffer2 = sliderimage.PostedFile.InputStream; System.Drawing.Image Image2 = System.Drawing.Image.FromStream(Buffer2); Bitmap bmp2 = GetImage.ResizeImage(Image2, Image2.Height, Image2.Width); bmp2.Save(filePath2, System.Drawing.Imaging.ImageFormat.Jpeg); } else { imagename = img; } if (Request.QueryString["id"] != null) { objsql.ExecuteNonQuery("update tblproduct set name='" + txtname.Text + "',Mrp='" + txtmrp.Text + "',image='" + imagename + "',bv='" + txtbv.Text + "',serial='" + txtserial.Text + "' where id='" + Request.QueryString["id"] + "'"); } else { objsql.ExecuteNonQuery("insert into tblproduct(name,code,mrp,image,bv,serial) values('" + txtname.Text + "','" + txtcode.Text + "','" + txtmrp.Text + "','" + imagename + "','" + txtbv.Text + "','" + txtserial.Text + "')"); } img = ""; Response.Redirect("view-products.aspx"); }
protected void btnsubmit_Click(object sender, EventArgs e) { //if (Request.QueryString["id"] != null) //{ // objsql.ExecuteNonQuery("update tblproducts set name='" + txtname.Text + "',dp='" + txtdp.Text + "',pv='"+txtpv.Text+"' where id='" + Request.QueryString["id"] + "'"); //} //else //{ // objsql.ExecuteNonQuery("insert into tblproducts(name,dp,pv) values('" + txtname.Text + "','" + txtdp.Text + "','"+txtpv.Text+"')"); //} if (sliderimage.HasFile) { string sliderpic = sliderimage.FileName; imagename = sliderpic; string filePath2 = MapPath("../uploadimage/" + imagename); Stream Buffer2 = sliderimage.PostedFile.InputStream; System.Drawing.Image Image2 = System.Drawing.Image.FromStream(Buffer2); Bitmap bmp2 = GetImage.ResizeImage(Image2, Image2.Height, Image2.Width); bmp2.Save(filePath2, System.Drawing.Imaging.ImageFormat.Jpeg); } else { imagename = img; } if (Request.QueryString["id"] != null) { objsql.ExecuteNonQuery("update tblproducts set name='" + txtname.Text + "',dp='" + txtdp.Text + "',pv='" + txtpv.Text + "',image='" + imagename + "' where id='" + Request.QueryString["id"] + "'"); } else { objsql.ExecuteNonQuery("insert into tblproducts(name,code,dp,pv,image) values('" + txtname.Text + "','" + Common.GenProductCode() + "','" + txtdp.Text + "','" + txtpv.Text + "','" + imagename + "')"); } img = ""; Response.Redirect("view-Products.aspx"); }