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";
}
