protected void ntnAddCategory_Click(object sender, EventArgs e) { try { ClassDate s = new ClassDate(); string datee = s.date(); //==== Get file name without its extension. string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName); string fileExtension1 = Path.GetExtension(FileUpload1.FileName); fileNameWithoutExtension1 = datee + fileNameWithoutExtension1; FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1)); strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1; con.Open(); SqlCommand cmd = new SqlCommand("insert into tblbanner(heading1,heading2,heading3,image) values(@heading1,@heading2,@heading3,@image)", con); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@heading1", txtheading1.Text); cmd.Parameters.AddWithValue("@heading2", txtheading2.Text); cmd.Parameters.AddWithValue("@heading3", txtheading3.Text); cmd.Parameters.AddWithValue("@image", strfile1); int i = cmd.ExecuteNonQuery(); if (i > 0) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Successfully Submited');location.href='banner.aspx'", true); } } catch { } finally { con.Close(); } }
public void image() { ClassDate s = new ClassDate(); string datee = s.date(); if (FileUpload1.HasFile) { //==== Get file name without its extension. string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName); string fileExtension1 = Path.GetExtension(FileUpload1.FileName); fileNameWithoutExtension1 = datee + fileNameWithoutExtension1; FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1)); strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1; } else { strfile1 = Image1.ImageUrl; } SqlCommand cmd = new SqlCommand("proc_tblallpages", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@typee", "headerlogo"); cmd.Parameters.AddWithValue("@content", strfile1); cmd.ExecuteNonQuery(); Image1.ImageUrl = all.showpagecontent("headerlogo"); }
protected void Button1x_Click(object sender, EventArgs e) { using (SqlConnection con = new SqlConnection(str)) { try { string datee = s.date(); //==== Get file name without its extension. string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName); string fileExtension1 = Path.GetExtension(FileUpload1.FileName); fileNameWithoutExtension1 = datee + fileNameWithoutExtension1; FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1)); strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1; con.Open(); SqlCommand cmd = new SqlCommand("insert into tblPortfolio(catcode,catname,plan_name,heading,image)values(@catcode,@catname,@plan_name,@heading,@image)", con); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@catcode", ddlcat.SelectedValue.ToString()); cmd.Parameters.AddWithValue("@catname", ddlcat.SelectedItem.ToString()); cmd.Parameters.AddWithValue("@plan_name", txtplanName.Text.Trim()); cmd.Parameters.AddWithValue("@heading", Textplanheading.Text); cmd.Parameters.AddWithValue("@image", strfile1); int i = cmd.ExecuteNonQuery(); if (i > 0) { ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmessage", "javascript:alert('Successfully Submitted')", true); } } catch { } finally { con.Close(); } } }
protected void btnupdate_Click(object sender, EventArgs e) { try { if (FileUpload1.HasFile) { ClassDate s = new ClassDate(); string datee = s.date(); //==== Get file name without its extension. string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName); string fileExtension1 = Path.GetExtension(FileUpload1.FileName); fileNameWithoutExtension1 = datee + fileNameWithoutExtension1; FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1)); strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1; } else { strfile1 = imgbanner.ImageUrl; } if (FileUpload2.HasFile) { ClassDate ss = new ClassDate(); string dateee = ss.date(); //==== Get file name without its extension. string fileNameWithoutExtension2 = Path.GetFileNameWithoutExtension(FileUpload2.FileName); string fileExtension2 = Path.GetExtension(FileUpload2.FileName); fileNameWithoutExtension2 = dateee + fileNameWithoutExtension2; FileUpload2.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension2 + fileExtension2)); strfile2 = "~/productimg/" + fileNameWithoutExtension2 + fileExtension2; } else { strfile2 = imgservice.ImageUrl; } con.Open(); SqlCommand cmd = new SqlCommand("update tblservice_details set service_banner=@service_banner,banner_heading1=@banner_heading1,banner_heading2=@banner_heading2,service_content=@service_content,service_image=@service_image where service_name=@service_name", con); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@service_name", ddlservice.SelectedItem.Text); cmd.Parameters.AddWithValue("@service_banner", strfile1); cmd.Parameters.AddWithValue("@banner_heading1", txtbannerheading1.Text); cmd.Parameters.AddWithValue("@banner_heading2", txtbannerheading2.Text); cmd.Parameters.AddWithValue("@service_content", Editor1.Content); cmd.Parameters.AddWithValue("@service_image", strfile2); //cmd.Parameters.AddWithValue("@var", "ins"); int i = cmd.ExecuteNonQuery(); if (i > 0) { ScriptManager.RegisterStartupScript(this, GetType(), "Message", "alert('Successfully Updated');", true); } } catch { } finally { con.Close(); } }
protected void gvDetails_RowUpdating(object sender, GridViewUpdateEventArgs e) { int userid = Convert.ToInt32(gvDetails.DataKeys[e.RowIndex].Value.ToString()); // string username = gvDetails.DataKeys[e.RowIndex].Values["UserName"].ToString(); TextBox txtheading = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txteditheading"); TextBox txtdesig = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txteditdegisnation"); TextBox txtcity = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txtcity"); Label lblimg1 = (Label)gvDetails.Rows[e.RowIndex].FindControl("lblimg"); FileUpload FileUpload1 = (FileUpload)gvDetails.Rows[e.RowIndex].FindControl("fileuploadedit"); ClassDate s = new ClassDate(); string datee = s.date(); if (FileUpload1.HasFile == true) { //==== Get file name without its extension. string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName); string fileExtension1 = Path.GetExtension(FileUpload1.FileName); fileNameWithoutExtension1 = datee + fileNameWithoutExtension1; FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1)); strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1; } else { strfile1 = lblimg1.Text; } con.Open(); SqlCommand cmd = new SqlCommand("proc_tbltesti", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@name", txtheading.Text); cmd.Parameters.AddWithValue("@degisnation", txtdesig.Text); cmd.Parameters.AddWithValue("@desc_", txtcity.Text); cmd.Parameters.AddWithValue("@img", strfile1); cmd.Parameters.AddWithValue("@id", userid); cmd.Parameters.AddWithValue("@var", "upda"); cmd.ExecuteNonQuery(); con.Close(); lblresult.ForeColor = Color.Green; lblresult.Text = userid + " Details Updated successfully"; gvDetails.EditIndex = -1; BindEmployeeDetails(); }
//public void Show_Feature(string topic) //{ // con.Open(); // SqlCommand cmd = new SqlCommand("select * from tblservice_details where service_name=@service_name", con); // cmd.CommandType = CommandType.Text; // cmd.Parameters.AddWithValue("@topic", topic); // SqlDataReader drr = cmd.ExecuteReader(); // if (drr.Read()) // { // Txticon.Text = drr["icon"].ToString(); // txtheading.Text = drr["heading"].ToString(); // Editor1.Content = drr["content"].ToString(); // } // con.Close(); //} //public void service_name() //{ // con.Open(); // SqlDataAdapter da = new SqlDataAdapter("select id,heading1 from tblhome_services", con); // DataTable dt = new DataTable(); // da.Fill(dt); // ddlservice.DataSource = dt; // ddlservice.DataTextField = "heading1"; // ddlservice.DataValueField = "id"; // ddlservice.DataBind(); // ddlservice.Items.Insert(0, "----Pls. Choose Service Here----"); //} protected void btnsubmit_Click1(object sender, EventArgs e) { try { ClassDate s = new ClassDate(); string datee = s.date(); //==== Get file name without its extension. string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName); string fileExtension1 = Path.GetExtension(FileUpload1.FileName); fileNameWithoutExtension1 = datee + fileNameWithoutExtension1; FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1)); strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1; ClassDate ss = new ClassDate(); string dateee = ss.date(); //==== Get file name without its extension. string fileNameWithoutExtension2 = Path.GetFileNameWithoutExtension(FileUpload2.FileName); string fileExtension2 = Path.GetExtension(FileUpload2.FileName); fileNameWithoutExtension2 = dateee + fileNameWithoutExtension2; FileUpload2.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension2 + fileExtension2)); strfile2 = "~/productimg/" + fileNameWithoutExtension2 + fileExtension2; con.Open(); SqlCommand cmd = new SqlCommand("insert into tblservice_details(service_banner,banner_heading1,banner_heading2,service_name,service_content,service_image)values(@service_banner,@banner_heading1,@banner_heading2,@service_name,@service_content,@service_image)", con); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@service_banner", strfile1); cmd.Parameters.AddWithValue("@banner_heading1", txtbannerheading1.Text); cmd.Parameters.AddWithValue("@banner_heading2", txtbannerheading2.Text); cmd.Parameters.AddWithValue("@service_name", txtservice.Text); cmd.Parameters.AddWithValue("@service_content", Editor1.Content); cmd.Parameters.AddWithValue("@service_image", strfile2); //cmd.Parameters.AddWithValue("@var", "ins"); int i = cmd.ExecuteNonQuery(); if (i > 0) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Service Details Submited Successfully');location.href='service-details.aspx'", true); } else { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Some Error Occurred!!!');", true); } txtbannerheading1.Text = ""; txtbannerheading2.Text = ""; txtservice.Text = ""; //ddlservice.SelectedItem.Text= ""; Editor1.Content = ""; } catch { } finally { con.Close(); } }
protected void gvDetails_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals("AddNew")) { TextBox txtUsrname = (TextBox)gvDetails.FooterRow.FindControl("txtftrusrname"); TextBox txtdesig = (TextBox)gvDetails.FooterRow.FindControl("txtftdegisnation"); TextBox txtCity = (TextBox)gvDetails.FooterRow.FindControl("txtftrcity"); FileUpload FileUpload1 = (FileUpload)gvDetails.FooterRow.FindControl("fileuploadfooter"); ClassDate s = new ClassDate(); string datee = s.date(); //==== Get file name without its extension. string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName); string fileExtension1 = Path.GetExtension(FileUpload1.FileName); fileNameWithoutExtension1 = datee + fileNameWithoutExtension1; FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1)); strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1; con.Open(); SqlCommand cmd = new SqlCommand("proc_tbltesti", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@name", txtUsrname.Text); cmd.Parameters.AddWithValue("@degisnation", txtdesig.Text); cmd.Parameters.AddWithValue("@desc_", txtCity.Text); cmd.Parameters.AddWithValue("@img", strfile1); cmd.Parameters.AddWithValue("@var", "ins"); int result = cmd.ExecuteNonQuery(); con.Close(); if (result == 1) { BindEmployeeDetails(); lblresult.ForeColor = Color.Green; lblresult.Text = txtUsrname.Text + " Details inserted successfully"; } else { lblresult.ForeColor = Color.Red; lblresult.Text = txtUsrname.Text + " Details not inserted"; } } }
protected void Button1x_Click(object sender, EventArgs e) { using (SqlConnection con = new SqlConnection(str)) { try { string datee = s.date(); if (FileUpload1.HasFile == true) { //==== Get file name without its extension. string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName); string fileExtension1 = Path.GetExtension(FileUpload1.FileName); fileNameWithoutExtension1 = datee + fileNameWithoutExtension1; FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1)); strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1; } else { strfile1 = Image1.ImageUrl; } con.Open(); SqlCommand cmd = new SqlCommand("update tblPortfolio set catcode=@catcode,catname=@catname,plan_name=@plan_name,heading=@heading,image=@image where id=@id", con); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@catcode", ddlcat.SelectedValue.ToString()); cmd.Parameters.AddWithValue("@catname", ddlcat.SelectedItem.ToString()); cmd.Parameters.AddWithValue("@plan_name", txtplan.Text.Trim()); cmd.Parameters.AddWithValue("@heading", Textheading.Text); cmd.Parameters.AddWithValue("@image", strfile1); cmd.Parameters.AddWithValue("@id", Request.QueryString["id_x"].ToString()); int i = cmd.ExecuteNonQuery(); if (i > 0) { ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmessage", "javascript:alert('Successfully Updated')", true); show(Request.QueryString["id_x"].ToString()); } } catch { } finally { con.Close(); } } }
protected void Button1x_Click(object sender, EventArgs e) { if (FileUpload1.HasFile) { ClassDate clsdat = new ClassDate(); string datee = clsdat.date(); //==== Get file name without its extension. string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName); string fileExtension1 = Path.GetExtension(FileUpload1.FileName); fileNameWithoutExtension1 = datee + fileNameWithoutExtension1; FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1)); strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1; } else { strfile1 = lblfilePath.Text; } try { con.Open(); SqlCommand cmd = new SqlCommand("proc_tblService_Plan", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@var", "Update"); cmd.Parameters.AddWithValue("@service_id", ddlChooseInsuranceCategory.SelectedValue.ToString()); cmd.Parameters.AddWithValue("@service_heading", ddlChooseInsuranceCategory.SelectedItem.ToString()); cmd.Parameters.AddWithValue("@plan_name", txtplan.Text); cmd.Parameters.AddWithValue("@plan_detail", Editor1.Content); cmd.Parameters.AddWithValue("@download_plan", strfile1); cmd.Parameters.AddWithValue("@id", Request.QueryString["id_x"].ToString()); int i = cmd.ExecuteNonQuery(); if (i > 0) { ScriptManager.RegisterStartupScript(this, GetType(), "Message", "alert('Successfully Updated');", true); } } catch { } finally { con.Close(); } }
protected void ntnAddCategory_Click(object sender, EventArgs e) { try { ClassDate s = new ClassDate(); string datee = s.date(); if (FileUpload1.HasFile) { //==== Get file name without its extension. string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName); string fileExtension1 = Path.GetExtension(FileUpload1.FileName); fileNameWithoutExtension1 = datee + fileNameWithoutExtension1; FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1)); strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1; } else { strfile1 = Image1.ImageUrl; } con.Open(); SqlCommand cmd = new SqlCommand("update tblbanner set heading1=@heading1,heading2=@heading2,heading3=@heading3,image=@image where id=@id", con); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@heading1", txtheading1.Text); cmd.Parameters.AddWithValue("@heading2", txtheading2.Text); cmd.Parameters.AddWithValue("@heading3", txtheading3.Text); cmd.Parameters.AddWithValue("@image", strfile1); cmd.Parameters.AddWithValue("@id", Request.QueryString["id_x"].ToString()); cmd.Parameters.AddWithValue("@var", 4); int i = cmd.ExecuteNonQuery(); if (i > 0) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Successfully Updated');location.href='edit-banner.aspx?id_x=" + Request.QueryString["id_x"].ToString() + "'", true); } } catch { } finally { con.Close(); } }
protected void Button1x_Click(object sender, EventArgs e) { try { con.Open(); ClassDate s = new ClassDate(); string datee = s.date(); if (FileUpload1.HasFile) { //==== Get file name without its extension. string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName); string fileExtension1 = Path.GetExtension(FileUpload1.FileName); fileNameWithoutExtension1 = datee + fileNameWithoutExtension1; FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1)); strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1; } else { strfile1 = Image1.ImageUrl; } SqlCommand cmd = new SqlCommand("proc_tblallpages", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@typee", "headerlogo"); cmd.Parameters.AddWithValue("@content", strfile1); int i = cmd.ExecuteNonQuery(); if (i > 0) { ScriptManager.RegisterStartupScript(this, GetType(), "Message", "alert('Successfully Updated');", true); } Image1.ImageUrl = all.showpagecontent("headerlogo"); } catch { } finally { con.Close(); } }
protected void Button1x_Click(object sender, EventArgs e) { try { ClassDate s = new ClassDate(); string datee = s.date(); if (FileUpload1.HasFile) { //==== Get file name without its extension. string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName); string fileExtension1 = Path.GetExtension(FileUpload1.FileName); fileNameWithoutExtension1 = datee + fileNameWithoutExtension1; FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1)); strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1; } else { strfile1 = Image1.ImageUrl; } con.Open(); SqlCommand cmd = new SqlCommand("proc_tblservices", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@var", "Update"); cmd.Parameters.AddWithValue("@content", Editor1.Content); cmd.Parameters.AddWithValue("@img", strfile1); cmd.Parameters.AddWithValue("@heading", ddlChooseInsuranceCategory.SelectedItem.ToString()); int i = cmd.ExecuteNonQuery(); if (i > 0) { ScriptManager.RegisterStartupScript(this, GetType(), "Message", "alert('Successfully Updated');", true); } } catch { } finally { con.Close(); } }
protected void gvDetails_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals("AddNew")) { FileUpload FileUpload1 = (FileUpload)gvDetails.FooterRow.FindControl("fileuploadfooter"); ClassDate s = new ClassDate(); string datee = s.date(); //==== Get file name without its extension. string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName); string fileExtension1 = Path.GetExtension(FileUpload1.FileName); fileNameWithoutExtension1 = datee + fileNameWithoutExtension1; FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1)); strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1; con.Open(); SqlCommand cmd = new SqlCommand("proc_tblclientlogos", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@img", strfile1); cmd.Parameters.AddWithValue("@var", "ins"); int result = cmd.ExecuteNonQuery(); con.Close(); if (result == 1) { BindEmployeeDetails(); lblresult.ForeColor = Color.Green; lblresult.Text = "Client Logo Inserted Successfully"; } else { lblresult.ForeColor = Color.Red; lblresult.Text = "Some Error Occurred!!!"; } } }
protected void btnsubmit_Click1(object sender, EventArgs e) { try { if (FileUpload1.HasFile) { ClassDate s = new ClassDate(); string datee = s.date(); //==== Get file name without its extension. string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName); string fileExtension1 = Path.GetExtension(FileUpload1.FileName); fileNameWithoutExtension1 = datee + fileNameWithoutExtension1; FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1)); strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1; } else { strfile1 = imgplanbanner.ImageUrl; } if (FileUpload2.HasFile) { ClassDate ss = new ClassDate(); string dateee = ss.date(); //==== Get file name without its extension. string fileNameWithoutExtension2 = Path.GetFileNameWithoutExtension(FileUpload2.FileName); string fileExtension2 = Path.GetExtension(FileUpload2.FileName); fileNameWithoutExtension2 = dateee + fileNameWithoutExtension2; FileUpload2.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension2 + fileExtension2)); strfile2 = "~/productimg/" + fileNameWithoutExtension2 + fileExtension2; } else { strfile2 = imgplan.ImageUrl; } if (FileUpload3.HasFile) { ClassDate sss = new ClassDate(); string dateeee = sss.date(); //==== Get file name without its extension. string fileNameWithoutExtension3 = Path.GetFileNameWithoutExtension(FileUpload3.FileName); string fileExtension3 = Path.GetExtension(FileUpload3.FileName); fileNameWithoutExtension3 = dateeee + fileNameWithoutExtension3; FileUpload3.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension3 + fileExtension3)); strfile3 = "~/productimg/" + fileNameWithoutExtension3 + fileExtension3; } else { strfile3 = imageshortimg.ImageUrl; } con.Open(); SqlCommand cmd = new SqlCommand("update tblplan_details set banner_heading1=@banner_heading1,banner_heading2=@banner_heading2,service_name=@service_name,plan_name=@plan_name,plan_content=@plan_content,plan_image=@plan_image,short_content=@short_content,short_image=@short_image,banner_image=@banner_image where plan_name=@plan_name", con); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@banner_image", strfile1); cmd.Parameters.AddWithValue("@banner_heading1", txtbannerheading1.Text); cmd.Parameters.AddWithValue("@banner_heading2", txtbannerheading2.Text); cmd.Parameters.AddWithValue("@plan_name", ddlplanname.SelectedItem.Text); cmd.Parameters.AddWithValue("@service_name", ddlservice.SelectedItem.Text); cmd.Parameters.AddWithValue("@plan_content", Editor1.Content); cmd.Parameters.AddWithValue("@short_content", Editor2.Content); cmd.Parameters.AddWithValue("@plan_image", strfile2); cmd.Parameters.AddWithValue("@short_image", strfile3); //cmd.Parameters.AddWithValue("@var", "ins"); int i = cmd.ExecuteNonQuery(); if (i > 0) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Plan Details Updated Successfully');location.href='edit-plan-details.aspx'", true); } else { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Some Error Occurred!!!');", true); } txtbannerheading1.Text = ""; txtbannerheading2.Text = ""; //ddlservice.SelectedItem.Text= ""; Editor1.Content = ""; Editor2.Content = ""; } catch { } finally { con.Close(); } }