How to delete row in gridview using rowdeleting event

Question

This is my  cs code    protected void Gridview1 RowDeleting object sender  GridViewDeleteEventArgs e     Gridview1 DeleteRow e RowIndex    Gridview1 DataBind        and this is markup    lt asp gridview ID  Gridview1  runat  server  ShowFooter  true                                                   AutoGenerateColumns  false  OnRowDeleting  Gridview1 RowDeleting  gt                       lt Columns gt                       lt asp BoundField DataField  RowNumber  HeaderText  Row Number    gt                       lt asp TemplateField HeaderText  Column Name  gt                           lt ItemTemplate gt                               lt asp TextBox ID  TextBox1  runat  server  gt  lt  asp TextBox gt                           lt  ItemTemplate gt                       lt  asp TemplateField gt                     lt  --  lt asp TemplateField HeaderText  Header 2  gt                           lt ItemTemplate gt                               lt asp TextBox ID  TextBox2  runat  server  gt  lt  asp TextBox gt                           lt  ItemTemplate gt                       lt  asp TemplateField gt --  gt                       lt asp TemplateField HeaderText  Data Type  gt                           lt ItemTemplate gt                                 lt asp DropDownList ID  ddldatatype  runat  server  gt                                 lt asp ListItem gt varchar lt  asp ListItem gt                                 lt asp ListItem gt int lt  asp ListItem gt                                 lt asp ListItem gt numeric lt  asp ListItem gt                                 lt asp ListItem gt uniqueidentifier lt  asp ListItem gt                                 lt asp ListItem gt char lt  asp ListItem gt                                 lt  asp DropDownList gt                           lt  ItemTemplate gt                           lt FooterStyle HorizontalAlign  Right    gt                           lt FooterTemplate gt                           lt asp Button ID  ButtonAdd  runat  server  Text  Add New Row  OnClick  ButtonAdd Click   gt                            lt asp Button ID  ButtonDel  runat  server  Text  Delete Row  OnClick  ButtonDel Click    gt                            lt input type  hidden  runat  server  value  0  id  hiddencount    gt                           lt  FooterTemplate gt                       lt  asp TemplateField gt                       lt asp TemplateField gt                           lt ItemTemplate gt                               lt asp LinkButton ID  lnkdelete  runat  server  CommandName  Delete   gt Delete lt  asp LinkButton gt                           lt  ItemTemplate gt                       lt  asp TemplateField gt                       lt  Columns gt               lt  asp gridview gt    Please sugegest me  I have done this much   but still not deleting row      protected void Gridview1 RowDeleting object sender  GridViewDeleteEventArgs e                              Gridview1 DeleteRow  int Gridview1 DataKeys e RowIndex  Value                  Gridview1 DeleteRow e RowIndex                  Gridview1 DataBind                 foreach DataRow dr in dt Rows                                  dt Rows Remove dr                    dt Rows e RowIndex  Delete                                 Gridview1 DeleteRow e RowIndex                  dt    DataTable Gridview1 DataSource               Gridview1 DataSource   dt               Gridview1 DataBind

User · Answer

Your delete code looks like this  Gridview1 DeleteRow e RowIndex   Gridview1 DataBind      When you call Gridview1 DataBind   you will populate your gridview with the current datasource  So  it will delete all the existent rows  and it will add all the rows from CustomersSqlDataSource   What you need to do is delete the row from the table that CustomersSqlDataSource querying   You can do this very easy by setting a delete command to CustomersSqlDataSource  add a delete parameter  and then execute the delete command   CustomersSqlDataSource DeleteCommand    DELETE FROM Customer Where CustomerID  CustomerID      Customer is the name of the table where you take your data from  Maybe you named it different  CustomersSqlDataSource DeleteParameters Add  CustomerID   Gridview1 DataKeys e RowIndex  Values  CustomerID   ToString     CustomersSqlDataSource Delete    Gridview1 DataBind      But take into account that this will delete the data from the database

User · Answer

Make sure to create a static  DataTable object and then use the following code   protected void GridView1 RowDeleting object sender  GridViewDeleteEventArgs e        dt Rows RemoveAt e RowIndex        GridView1 DataSource   dt      GridView1 DataBind

User · Answer

I think you are doing same mistake of rebinding as mentioned in this link  How to delete row from gridview

User · Answer

The easiest way is to create your GridView with some data source in ASP and call that data source in Row Deletinng Event  For example if you have SqlDataSource1 as your GridView data source  your Row Deleting event would be   protected void GridView1 RowDeleting object sender  GridViewDeleteEventArgs e          int ID   int Parse GridView1 Rows e RowIndex  FindControl  ID   toString           string delete command    DELETE FROM your table WHERE ID       ID        SqlDataSource1 DeleteCommand   delete command

User · Answer

The solution is somewhat simple  once you have deleted the row from the datagrid  Your code ONLY removes the row from the grid and NOT the datasource  then you do not need to do anything else  As you are doing a databind operation immediately after  without updating the datasource  you are re-adding all the rows from the source to the gridview control  including the row removed from the grid in the previous statement    To simply delete from the grid without a datasource then just call the delete operation on the grid and that is all you need to do    no databinding is needed after that

User · Answer

protected void GridView1 RowDeleting object sender  GridViewDeleteEventArgs e        MySqlCommand cmd      string id1   GridView1 DataKeys e RowIndex  Value ToString        con Open        cmd   new MySqlCommand  delete from tableName where refno      id1        con       cmd ExecuteNonQuery        con Close        BindView      private void BindView         GridView1 DataSource   ms dTable  select   from table name        GridView1 DataBind

User · Answer

Add the below line in Page load   ViewState  GetRecords     dt    then try this   protected void DeleteRows object sender  GridViewDeleteEventArgs e       dt   ViewState  GetRecords   as DataTable     dt Rows RemoveAt e RowIndex       dt AcceptChanges        ViewState  GetRecords     dt      BindData        If you Still have any problem  send the code in BindData   method

User · Answer

protected void GridView1 RowDeleting object sender  GridViewDeleteEventArgs e                int index   GridView1 SelectedIndex          int id   Convert ToInt32 GridView1 DataKeys index  Value           SqlConnection con   new SqlConnection str           SqlCommand com   new SqlCommand  spDelete   con           com Parameters AddWithValue   PatientId   id           con Open            com ExecuteNonQuery      Index was out of range  Must be non-negative and less than the size of the collection  Parameter name  index

User · Answer

In Grid use this code having ID as your Primary Element so to uniquely identify each ROW   lt asp TemplateField gt               lt ItemTemplate gt               lt asp HiddenField ID  Hf ID  runat  server  Value   lt    Eval  ID     gt     gt               lt  ItemTemplate gt   lt  asp TemplateField gt    and to search the uique ID use the code in C  code behind  basically this is searching hidden field and storing it in a var   protected void Grd Registration RowDeleting object sender  GridViewDeleteEventArgs e                var ID    HiddenField Grd Registration Rows e RowIndex  FindControl  ID              Your Delete Logic Goes here having ID to delete          GridBind

User · Answer

If I remember from your previous questions  you re binding to a DataTable   Try this   protected void GridView1 RowDeleting object sender  GridViewDeleteEventArgs e         DataTable sourceData    DataTable GridView1 DataSource       sourceData Rows e RowIndex  Delete         GridVie1 DataSource   sourceData      GridView1 DataBind        Essentially  as I said in my comment  grab a copy of the GridView s DataSource  remove the row from it  then set the DataSource to the updated object and call DataBind   on it again

User · Answer

message box before deletion protected void grdEmployee RowDataBound object sender  GridViewRowEventArgs e        if  e Row RowType    DataControlRowType DataRow                foreach  DataControlFieldCell cell in e Row Cells                        foreach  Control control in cell Controls                                LinkButton button   control as LinkButton                  if  button    null  amp  amp  button CommandName     Delete                       button OnClientClick    if   confirm  Are you sure                                 you want to delete this record     return false                                       deletion protected void grdEmployee RowDeleting object sender  GridViewDeleteEventArgs e        conn Open        int empid   Convert ToInt32   Label grdEmployee Rows e RowIndex  Cells 0  FindControl  lblIdBind    Text       SqlCommand cmdDelete   new SqlCommand  Delete from employee details where id     empid  conn       cmdDelete ExecuteNonQuery        conn Close        grdEmployee refreshdata

User · Answer

I know this is a late answer but still it would help someone in need of a solution  I recommend to use OnRowCommand for delete operation along with DataKeyNames  keep OnRowDeleting function to avoid exception    lt asp gridview ID  Gridview1  runat  server  ShowFooter  true        AutoGenerateColumns  false  OnRowDeleting  Gridview1 RowDeleting  OnRowCommand  Gridview1 RowCommand  DataKeyNames  ID  gt    Include DataKeyNames  ID  in the gridView and specify the same in link button    lt asp LinkButton ID  lnkdelete  runat  server  CommandName  Delete  CommandArgument   lt   Eval  ID    gt   gt Delete lt  asp LinkButton gt   protected void Gridview1 RowCommand object sender  GridViewCommandEventArgs e      if  e CommandName     Delete               int ID   Convert ToInt32 e CommandArgument           now perform the delete operation using ID value          protected void Gridview1 RowDeleting object sender  GridViewDeleteEventArgs e          Leave it blank     If this is helpful  give me

User · Answer

Try This Make sure You mention Datakeyname which is nothing but the column name  id  in your designer file    your aspx code   lt asp GridView ID  dgUsers  runat  server  AutoGenerateSelectButton  True  OnDataBound  dgUsers DataBound  OnRowDataBound  dgUsers RowDataBound  OnSelectedIndexChanged  dgUsers SelectedIndexChanged  AutoGenerateDeleteButton  True  OnRowDeleting  dgUsers RowDeleting  DataKeyNames  id  OnRowCommand  dgUsers RowCommand  gt  lt  asp GridView gt     Your aspx cs Code  protected void dgUsers RowDeleting object sender  GridViewDeleteEventArgs e                         int id   Convert ToInt32 dgUsers DataKeys e RowIndex  Value               string query    delete from users where id       id                      your remaining delete code

User · Answer

See the following code and make some changes to get the answer for your question   lt    Page Language  C     gt    lt  DOCTYPE html PUBLIC  -  W3C  DTD XHTML 1 0 Transitional  EN       http   www w3 org TR xhtml1 DTD xhtml1-transitional dtd  gt    lt script runat  server  gt       void CustomersGridView RowDeleting          Object sender  GridViewDeleteEventArgs e                TableCell cell   CustomersGridView Rows e RowIndex  Cells 2           if  cell Text     Beaver                         e Cancel   true              Message Text    You cannot delete customer Beaver                      else                       Message Text                           lt  script gt    lt html xmlns  http   www w3 org 1999 xhtml  gt   lt head id  Head1  runat  server  gt       lt title gt GridView RowDeleting Example lt  title gt   lt  head gt   lt body gt       lt form id  form1  runat  server  gt       lt h3 gt          GridView RowDeleting Example      lt  h3 gt       lt asp Label ID  Message  ForeColor  Red  runat  server    gt       lt br   gt       lt asp GridView ID  CustomersGridView  runat  server           DataSourceID  CustomersSqlDataSource           AutoGenerateColumns  False          AutoGenerateDeleteButton  True           OnRowDeleting  CustomersGridView RowDeleting          DataKeyNames  CustomerID AddressID  gt           lt Columns gt               lt asp BoundField DataField  FirstName                   HeaderText  FirstName  SortExpression  FirstName    gt               lt asp BoundField DataField  LastName  HeaderText  LastName                   SortExpression  LastName    gt               lt asp BoundField DataField  City  HeaderText  City                   SortExpression  City    gt               lt asp BoundField DataField  StateProvince  HeaderText  State                   SortExpression  StateProvince    gt           lt  Columns gt       lt  asp GridView gt       lt asp SqlDataSource ID  CustomersSqlDataSource  runat  server          SelectCommand  SELECT SalesLT CustomerAddress CustomerID               SalesLT CustomerAddress AddressID               SalesLT Customer FirstName               SalesLT Customer LastName               SalesLT Address City               SalesLT Address StateProvince              FROM SalesLT Customer              INNER JOIN SalesLT CustomerAddress              ON SalesLT Customer CustomerID                    SalesLT CustomerAddress CustomerID              INNER JOIN SalesLT Address ON SalesLT CustomerAddress AddressID                    SalesLT Address AddressID          DeleteCommand  Delete from SalesLT CustomerAddress where CustomerID                 CustomerID and AddressID    AddressID           ConnectionString   lt    ConnectionStrings AdventureWorksLTConnectionString   gt   gt           lt DeleteParameters gt               lt asp Parameter Name  AddressID    gt               lt asp Parameter Name  CustomerID    gt           lt  DeleteParameters gt       lt  asp SqlDataSource gt       lt  form gt   lt  body gt   lt  html gt

User · Answer

Here is a trick with what you want to achieve  I was also having problem like you   Its hard to get selected row and data key in RowDeleting Event But it is very easy to get selected row and datakeys in SelectedIndexChanged event  Here s an example-  protected void gv SelectedIndexChanged object sender  EventArgs e            int index   gv SelectedIndex          int vehicleId   Convert ToInt32 gv DataKeys index  Value           SqlConnection con   new SqlConnection  -----            SqlCommand com   new SqlCommand  DELETE FROM tbl WHERE vId    vId   con           com Parameters AddWithValue   vId   vehicleId           con Open            com ExecuteNonQuery

User · Answer

protected void GridView1 RowDeleting object sender  GridViewDeleteEventArgs e        GridViewRow row    GridViewRow GridView1 Rows e RowIndex       SqlCommand cmd   new SqlCommand  Delete From userTable  userName age birthPLace         GridView1 DataBind

[c#] How to delete row in gridview using rowdeleting event?

Examples related to c#

Examples related to asp.net