protected void btnaddproduct_Click(object sender, EventArgs e) { p.procatname = DropDownList1.Text; p.proproductname = txtproname.Text; p.unitcost = txtproprice.Text; p.desc = txtprodesc.Text; p.oprice = txtOrigional.Text; p.proquantity = dpquantity.Text; if (FileUpload1.HasFile) { //string filename = Path.GetFileName(FileUpload1.PostedFile.FileName); p.filename = Path.GetFileName(FileUpload1.PostedFile.FileName); FileUpload1.SaveAs(Server.MapPath("Images/" + p.filename)); bool b = bl.bll_insertproducts(p); if (b == true) { lblresult.Text = "Insert Successfully"; Response.Redirect("Products.aspx"); } else { lblresult.Text = "not Insert Successfully"; } /* string query = "insert into Products(CategoryID,ProductName,ProductImage,UnitCost,Description,origionalPrice,productquantity) select CategoryID,'" + txtproname.Text + "','" + "Images/" + filename + "'," + txtproprice.Text + ",'" + txtprodesc.Text + "','"+txtOrigional.Text+"','"+dpquantity.Text+"' from Categories where CategoryName='" + DropDownList1.Text + "'"; * bool b = obj.UDI(query); * * if (b) * { * lblresult.Text = "Inserted"; * * Response.Redirect("Products.aspx"); * } * else * { * * lblresult.Text = "Not Inserted"; * }*/ } else { UploadStatusLabel.Text = "You did not specify a file to upload."; } }