Wednesday, 18 April 2012

How to create delete confirmation POPUP in Grid view?

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class Default2 : System.Web.UI.Page
{
    SqlConnection con;
    protected void Page_Load(object sender, EventArgs e)
    {
        con = new SqlConnection("give connection name");


        if (!IsPostBack)
        {

            Bindtablename();

        }


    }
    protected void Bindtablename()
    {

      

        con.Open();

      

        SqlCommand cmd = new SqlCommand("Select * from tablename", con);

        cmd.ExecuteNonQuery();

        SqlDataAdapter da = new SqlDataAdapter(cmd);

        DataSet ds = new DataSet();

        da.Fill(ds);

        //Binding data to gridview

        gv1.DataSource = ds;

        gv1.DataBind();

        con.Close();

    }
    protected void gv1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {

          

            string (give field name for example uname empname) = Convert.ToString(DataBinder.Eval(e.Row.DataItem, "(give field name for example uname empname)"));

          

            LinkButton delete = (LinkButton)e.Row.FindControl("delete");

            

            deletebtnresult.Attributes.Add("onclick", "javascript:return rahi('" + (give field name for example uname empname) + "')");
           
        }
    }
    protected void delete_Click(object sender, EventArgs e)
    {




        LinkButton btnlink = sender as LinkButton;

      

        GridViewRow gvrow = btnlink.NamingContainer as GridViewRow;

     

        int uid = Convert.ToInt32(gv1.DataKeys[gvrow.RowIndex].Value.ToString());

        string uname = gvrow.Cells[0].Text;

        con.Open();

        SqlCommand cmd = new SqlCommand("delete from table name where (give field name for example uid )=" + (give field name for example uname empname), con);

        int result = cmd.ExecuteNonQuery();

        con.Close();

        if (result == 1)
        {

            Bindtablename();

         

            ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmessage", "javascript:alert('" + uname + "  Deleted successfully')", true);

        }
    }


    public string linkdele { get; set; }
}

Default.aspx* page=========

<script language="javascript"  type="text/javascript" >
   

        function rahi((give field name for example uname ))
         {

        
            var result = confirm('Are you sure you want to delete ' + (give field name for example uname ) + ' tablename');

            if (result)
             {
                 return true;

            }

            else {

                return false;

            }

        }

</script>

<div>
    <asp:GridView ID="gv1" runat="server" DataKeyNames="uid"
            AutoGenerateColumns="false" OnRowDataBound="gv1_RowDataBound" 
             >
   
    <Columns>
    <asp:TemplateField  HeaderText=" udetails Delete ">
  
   <ItemTemplate>
   <asp:LinkButton ID="delete" runat="server" OnClick="delete_Click"  >
   Delete User
   </asp:LinkButton>
   </ItemTemplate>
  
   </asp:TemplateField>
    <asp:BoundField DataField="uname" HeaderText="uname" />
    <asp:BoundField DataField="FName" HeaderText="FName" />
    <asp:BoundField DataField="LName" HeaderText="LName" />
  
    </Columns>
   
   
    </asp:GridView>
    </div>


No comments:

Post a Comment

What is ASP.NET? Components of ASP.NET

ASP.Net Definition -It is used for creating web-based applications.ASP.Net is a web development platform provided by Microsoft. ASP.NET i...