protected void DesignGrid_RowUpdating(object sender, GridViewUpdateEventArgs e) { Label Did = DesignGrid.Rows[e.RowIndex].FindControl("lblDesignId") as Label; Label Dname = DesignGrid.Rows[e.RowIndex].FindControl("lblDesignName") as Label; TextBox Dstylename = DesignGrid.Rows[e.RowIndex].FindControl("txtStyleName") as TextBox; TextBox Pprice = DesignGrid.Rows[e.RowIndex].FindControl("txtPrice") as TextBox; FileUpload fuPhoto = DesignGrid.Rows[e.RowIndex].FindControl("image") as FileUpload; if (fuPhoto.FileName != "") { SqlCommand cmd = new SqlCommand("Update Design set DesignName=@Dname,StyleName=@Dstylename, Images=@img, Price=@price where DesignId=@Did", con); cmd.Parameters.AddWithValue("@Did", Did.Text); cmd.Parameters.AddWithValue("@Dname", Dname.Text); cmd.Parameters.AddWithValue("@Dstylename", Dstylename.Text); cmd.Parameters.AddWithValue("@price", Pprice.Text); fuPhoto.SaveAs(Server.MapPath("~/images/") + Path.GetFileName(fuPhoto.FileName)); String Image = "../images/" + Path.GetFileName(fuPhoto.FileName); cmd.Parameters.AddWithValue("@img", Image); con.Open(); cmd.ExecuteNonQuery(); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); DesignGrid.EditIndex = -1; DesignGrid.DataSource = dt; DesignGrid.DataBind(); con.Close(); } else { SqlCommand cmd = new SqlCommand("Update Design set DesignName=@Dname,StyleName=@Dstylename, Price=@price where DesignId=@Did", con); cmd.Parameters.AddWithValue("@Did", Did.Text); cmd.Parameters.AddWithValue("@Dname", Dname.Text); cmd.Parameters.AddWithValue("@Dstylename", Dstylename.Text); cmd.Parameters.AddWithValue("@price", Pprice.Text); con.Open(); cmd.ExecuteNonQuery(); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); DesignGrid.EditIndex = -1; DesignGrid.DataSource = dt; DesignGrid.DataBind(); con.Close(); } FillGridView(); }
protected void DesignGrid_RowDeleting(object sender, GridViewDeleteEventArgs e) { Label DesignId = DesignGrid.Rows[e.RowIndex].FindControl("lblDesignId") as Label; SqlCommand cmd = new SqlCommand("delete from Design where DesignId= @DesignId", con); cmd.Parameters.AddWithValue("@DesignId", DesignId.Text); con.Open(); cmd.ExecuteNonQuery(); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); DesignGrid.EditIndex = -1; DesignGrid.DataSource = dt; DesignGrid.DataBind(); con.Close(); FillGridView(); }
public void FillGridView() { SqlCommand cmd = new SqlCommand("SELECT Design.DesignId,Product.ProductId,Design.DesignName,Design.StyleName,Design.Price,Design.Images FROM Design LEFT JOIN Product ON Design.ProductId = Product.ProductId where Design.DesignName=@DesignName And Product.ProductId=@ProductId", con); con.Open(); cmd.Parameters.AddWithValue("@ProductId", drpModel.SelectedValue); cmd.Parameters.AddWithValue("@DesignName", drpSubModel.SelectedValue); cmd.ExecuteNonQuery(); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); DesignGrid.DataSource = dt; DesignGrid.DataBind(); con.Close(); }