how to delete a row on gridview with a JavaScript button and remain on the same page

Question

I am displaying a set of records through gridview, and edit and delete buttons next to them. I am having a problem in the record deletion section. The behavior I want is the following: the user clicks the button, a JavaScript validation function is called and after the button click the records are deleted, but the user remains on the same page with the rest of the records. How can I do this while remaining on the same page?

<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
    <div>

        &nbsp;&nbsp;&nbsp;
        <br />
&nbsp;

        <asp:HyperLink NavigateUrl="~/Entry.aspx" runat="server" text="Add New Record" />
    </div>

    <div>
        <asp:GridView runat="server" ID="grdView" AutoGenerateColumns="false" Height="100%"
            Width="100%" onselectedindexchanged="grdView_SelectedIndexChanged" >
            <Columns>

                <asp:BoundField DataField="Prod_Id" HeaderText="product id " HeaderStyle-BackColor="Azure"  />
                 <asp:BoundField DataField="Prod_Name" HeaderText="Product Name" HeaderStyle-BackColor="Azure" />
                <asp:BoundField DataField="Unit_Price" HeaderText="Unit Price " HeaderStyle-BackColor="Azure" />
                <asp:BoundField DataField="In_Hand" HeaderText="In Hand" HeaderStyle-BackColor="Azure" />
                <asp:BoundField DataField="Fixed" HeaderText="Fixed" HeaderStyle-BackColor="Azure" />
                <asp:BoundField DataField="Status" HeaderText="Status" HeaderStyle-BackColor="Azure" />
                 <asp:HyperLinkField DataNavigateUrlFields="Prod_Id" DataNavigateUrlFormatString="edit.aspx?Prod_Id={0}" Text="Edit" />
                <asp:ButtonField   ButtonType="Link"  Text="Delete" />        

            </Columns>
        </asp:GridView>
    </div>
</asp:Content>

code behind part

public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            binddata();
        }

        SqlConnection con;
        SqlDataAdapter da;
        DataSet ds;

        void binddata()
        {
            con = new SqlConnection("Data Source=.\\sqlexpress; initial catalog=PracticeDb; user id=sa; pwd=manager;");
            con.Open();
            da = new SqlDataAdapter("Select * from Products", con);
            DataSet ds = new DataSet();
            da.Fill(ds);
            con.Close();
            grdView.DataSource = ds;
            grdView.DataBind();
        }

        protected void grdView_SelectedIndexChanged(object sender, EventArgs e)
        {


            var P_id = ds.Tables[0].Rows[0]["Prod_Id"].ToString();

            SqlConnection con = new SqlConnection();
            con.ConnectionString = ("Data Source=.\\sqlexpress; initial catalog=PracticeDb; user id=sa; pwd=manager;");
            con.Open();
            string qry = "DELETE FROM PRODUCTS WHERE Prod_Id='" +P_id+ "'";
            SqlCommand cmd = new SqlCommand(qry, con);
            cmd.ExecuteNonQuery();
            con.Close();


        }



    }
}

Thanks

stackoverflow.com/questions/4793955/…

rahularyansharma
– rahularyansharma

2013-06-07 06:07:30 +00:00
Commented Jun 7, 2013 at 6:07 — rahularyansharma
– rahularyansharma, Commented Jun 7, 2013 at 6:07
codeproject.com/Articles/19347/…

rahularyansharma
– rahularyansharma

2013-06-07 06:08:44 +00:00
Commented Jun 7, 2013 at 6:08 — rahularyansharma
– rahularyansharma, Commented Jun 7, 2013 at 6:08

Shahid Manzoor Bhat · Accepted Answer · 2013-06-07 06:25:22Z

10

You can use row databound event to accomplish this task.

  <asp:LinkButton ID="lnkBtnDel" runat="server" CommandName="DeleteRow" OnClientClick="return confirm('Are you sure you want to Delete this Record?');""CommandArgument='<%#Eval("Prod_Id") %>'>Delete</asp:LinkButton>

and in the rowdatabound event you can have

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
 if (e.CommandName == "DeleteRow")
    {
        //incase you need the row index 
        int rowIndex = ((GridViewRow)((LinkButton)e.CommandSource).NamingContainer).RowIndex;
        int Prod_Id= Convert.ToInt32(e.CommandArgument);
        //followed by your code 
    }
}

answered Jun 7, 2013 at 6:25

Shahid Manzoor Bhat

1,3331 gold badge15 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

SearchForKnowledge Over a year ago

Do I add the linkbutton inside an itemtemplate? Thanks. Trying to accomplish here: stackoverflow.com/questions/29372431/…

Shahid Manzoor Bhat Over a year ago

@SearchForKnowledge Wow it has been a while since i answered this. Yes its obligatory that you put the linkbutton inside of an item template.

SearchForKnowledge Over a year ago

I was able to figure it out. Thanks for your response regardless :)

Prashant16 · Accepted Answer · 2013-06-07 06:11:23Z

0

You can use LinkButton in GridView

<asp:LinkButton ID="lbtnDelete"  runat="server" CommandName="delete" title="Delete"
OnClientClick="return confirm('Do you Want to Delete this Record?');"
CommandArgument='<%#Eval("Prod_Id") %>'></asp:LinkButton>

Code Behind

 protected void grdView_RowCommand(object sender, GridViewCommandEventArgs e)
 {
     int P_Id = e.CommandArgument;   \\ This will get the Product id in P_Id variable
     \\ do your delete code
 }

answered Jun 7, 2013 at 6:11

Prashant16

1,5264 gold badges18 silver badges40 bronze badges

1 Comment

user2431114 Over a year ago

there is no linkButton option in Gridview

Hitesh · Accepted Answer · 2013-06-07 06:25:49Z

0

Hi you can get linkbutton using following code:

<asp:TemplateField HeaderText=Quantity>
  <ItemTemplate>
   <asp:LinkButton ID="lbtnDelete"  runat="server" CommandName="delete" title="Delete"
    OnClientClick="return confirm('Do you Want to Delete this Record?');"
    CommandArgument='<%#Eval("Prod_Id") %>'></asp:LinkButton>
 </ItemTemplate>
</asp:TemplateField>

And code behind use below code:

protected void grdView_RowCommand(object sender, GridViewCommandEventArgs e)
{
if(e.CommandName == "delete")
 {

 int P_Id = e.CommandArgument;   \\ This will get the Product id in P_Id variable
 \\ do your delete code
  }
 }

answered Jun 7, 2013 at 6:25

Hitesh

1,2366 gold badges32 silver badges53 bronze badges

Collectives™ on Stack Overflow

how to delete a row on gridview with a JavaScript button and remain on the same page

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related