protected void Btnupdate_Click(object sender, EventArgs e) { bool fileflag = false; if (fileuploadpicture.HasFile == true) { string photo = fileuploadpicture.FileName.ToLower(); if (photo.EndsWith("jpg") || photo.EndsWith("png") || photo.EndsWith("bnp") || photo.EndsWith("jpeg")) { fileuploadpicture.SaveAs(Server.MapPath("images/" + photo)); HiddenField1_photo.Value = "images/" + photo; } else { lblmessage.Text = "Incorrect picture format.Only add jpg,png,jpeg or bnp pictures!!"; fileflag = true; } } if (fileflag == false) { SqlDataSource2edit.Update(); lblmessage.Text = "updated!"; } }
protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) { Tbproid.Text = Request.QueryString["pid"]; DataView dv = (DataView)SqlDataSource2edit.Select(DataSourceSelectArguments.Empty); for (int i = 0; i <= dv.Table.Rows.Count - 1; i++) { if (dv.Table.Rows[i]["productid"].ToString() == Tbproid.Text) { rbmaincate.SelectedValue = dv.Table.Rows[i]["maincategory"].ToString(); rbmaincate_SelectedIndexChanged(null, null); ddlcatname.SelectedValue = dv.Table.Rows[i]["categoryname"].ToString(); ttbname.Text = dv.Table.Rows[i]["productname"].ToString(); Ddlbrand.SelectedValue = dv.Table.Rows[i]["brand"].ToString(); tbprice.Text = dv.Table.Rows[i]["price"].ToString(); ddlprimaterial.SelectedValue = dv.Table.Rows[i]["primarymaterial"].ToString(); ddldiscount.SelectedValue = dv.Table.Rows[i]["discount"].ToString(); Tbnetprice.Text = dv.Table.Rows[i]["netprice"].ToString(); ddlcatname.SelectedValue = dv.Table.Rows[i]["categoryname"].ToString(); tbdescription.Text = dv.Table.Rows[i]["description"].ToString(); Imgprod.ImageUrl = dv.Table.Rows[i]["picture"].ToString(); HiddenField1_photo.Value = dv.Table.Rows[i]["picture"].ToString(); rblstatus.SelectedValue = dv.Table.Rows[i]["status"].ToString(); break; } } } }
protected void Btndel_Click(object sender, EventArgs e) { SqlDataSource2edit.Delete(); lblmessage.Text = "Product deleted"; }