How to delete a selected DataGridViewRow and update a connected database table

Question

I have a DataGridView control on a Windows Forms application  written with C       What I need is  when a user selects a DataGridViewRow  and then clicks on a  Delete  button  the row should be deleted and next  the database needs to be updated using table adapters   This is what I have so far   private void btnDelete Click object sender  EventArgs e        if  this dataGridView1 SelectedRows Count  gt  0                dataGridView1 Rows RemoveAt this dataGridView1 SelectedRows 0  Index                             Furthermore  this only deletes one row  I would like it where the user can select multiple rows

User · Answer

private  System  Void button9 Click System  Object   sender  System  EventArgs   e        String  constring   L datasource localhost port 3306 username root password password       MySqlConnection  conDataBase   gcnew MySqlConnection constring       conDataBase- gt Open        try                if  MessageBox  Show  Sure you wanna delete     Warning   MessageBoxButtons  YesNo     System  Windows  Forms  DialogResult  Yes                        for each DataGridViewCell  oneCell in dataGridView1- gt SelectedCells                                if  oneCell- gt Selected                        dataGridView1- gt Rows- gt RemoveAt oneCell- gt RowIndex                       MySqlCommand  cmdDataBase1   gcnew MySqlCommand  Delete from Dinslaken DB Configuration where Memory  ORG 6400H                         cmdDataBase1- gt ExecuteNonQuery                          sda- gt Update dbdataset                                                                     catch  Exception ex                MessageBox  Show ex- gt ToString

User · Answer

private void btnDelete Click object sender  EventArgs e        dataGridView1 Rows RemoveAt dataGridView1 SelectedRows 0  Index                    BindingSource EndEdit                     TableAdapter Update this  DataSet yourTableName        NOTE      - is your data from database   Exception no need     or change with your own code   CODE    DB    Example  prntscr com p3208c        DB Set   http   prntscr com p321pw

User · Answer

This code removes selected items of dataGridView1    private void btnDelete Click object sender  EventArgs e          foreach  DataGridViewRow item in this dataGridView1 SelectedRows                  dataGridView1 Rows RemoveAt item Index

User · Answer

You delete first from the database and then you update your datagridview     let s suppose delete id  is a method which will delete a row from the database and    returns true when it is done int id   0    we suppose that the first column in the datagridview is the ID of the ROW   foreach  DataGridViewRow row in this dataGridView1 SelectedRows     id   Convert ToInt32 row Cells 0  Value ToString     if delete id                                     this dataGridView1 Rows RemoveAt this dataGridView1 SelectedRows 0  Index     else show message error

User · Answer

for  int j   dataGridView1 Rows Count  j  gt  0   j--        if  dataGridView1 Rows j-1  Selected          dataGridView1 Rows RemoveAt j-1

User · Answer

private void btnDelete Click object sender  EventArgs e        if  e ColumIndex    10    10th column the button               dataGridView1 Rows Remove dataGridView1 Rows e RowIndex                              This solution can be delete a row  not selected  clicked row   via  e  param

User · Answer

if this dgvpurchase Rows Count gt 1        if this dgvpurchase CurrentRow Index lt this dgvpurchase Rows Count                this txtname Text   this dgvpurchase CurrentRow Cells 1  Value ToString            this txttype Text   this dgvpurchase CurrentRow Cells 2  Value ToString            this cbxcode Text   this dgvpurchase CurrentRow Cells 3  Value ToString            this cbxcompany Text   this dgvpurchase CurrentRow Cells 4  Value ToString            this dtppurchase Value   Convert ToDateTime this dgvpurchase CurrentRow Cells 5  Value           this txtprice Text   this dgvpurchase CurrentRow Cells 6  Value ToString            this txtqty Text   this dgvpurchase CurrentRow Cells 7  Value ToString            this txttotal Text   this dgvpurchase CurrentRow Cells 8  Value ToString            this dgvpurchase Rows RemoveAt this dgvpurchase CurrentRow Index           refreshid

User · Answer

To delete multiple rows in datagrid  c   parts of my code   private void btnDelete Click object sender  EventArgs e                foreach  DataGridViewRow row in datagrid1 SelectedRows                          get key             int rowId   Convert ToInt32 row Cells 0  Value                  avoid updating the last empty row in datagrid             if  rowId  gt  0                                  delete                  aController Delete rowId                      refresh datagrid                 datagrid1 Rows RemoveAt row Index                                         public void Delete int rowId                        var toBeDeleted   db table1 First c   gt  c Id    rowId               db table1 DeleteObject toBeDeleted               db SaveChanges

User · Answer

Try this  foreach  DataGridViewRow item in this YourGridViewName SelectedRows        string ConnectionString      quot Data Source DESKTOPQJ1JHRG SQLEXPRESS Initial Catalog smart movers Integrated Security True quot         SqlConnection conn   new SqlConnection ConnectionString       conn Open        SqlCommand cmd   new SqlCommand  quot DELETE FROM TableName WHERE ColumnName   Index quot   conn       cmd Parameters AddWithValue  quot  Index quot   item Index       int i   cmd ExecuteNonQuery         if  i    0                YourGridViewName Rows RemoveAt item Index           MessageBox Show  quot Deleted Succefull  quot    quot Great quot   MessageBoxButtons OK  MessageBoxIcon Information             else           MessageBox Show  quot Deleted Failed  quot    quot Failed quot   MessageBoxButtons OK  MessageBoxIcon Error

User · Answer

here is one very simple example   ASPX    lt asp GridView ID  gvTest  runat  server  SelectedRowStyle-BackColor   996633          SelectedRowStyle-ForeColor  Fuchsia  gt       lt Columns gt           lt asp CommandField ShowSelectButton  True    gt           lt asp TemplateField gt               lt ItemTemplate gt                   lt    Container DataItemIndex   1   gt               lt  ItemTemplate gt           lt  asp TemplateField gt       lt  Columns gt   lt  asp GridView gt   lt asp Button ID  btnUpdate  runat  server  Text  Update  OnClick  btnUpdateClick   gt    Code Behind   public partial class  Default   System Web UI Page       private readonly DataTable  dataTable       public  Default                  dataTable   new DataTable              dataTable Columns Add  Serial   typeof  int             dataTable Columns Add  Data   typeof  string             for  var i   0    i  lt   15             dataTable Rows Add new object    i   This is row     i               protected void Page Load object sender  EventArgs e                if   IsPostBack              BindData               private void BindData                 gvTest DataSource    dataTable          gvTest DataBind               protected void btnUpdateClick object sender  EventArgs e                if  gvTest SelectedIndex  lt  0  return           var r   gvTest SelectedRow           var i   r DataItemIndex             you can get primary key or anyother column vlaue by            accessing r Cells collection  but for this simple case           we will use index of selected row in database           dataTable Rows RemoveAt i              rebind with data         BindData               clear selection from grid         gvTest SelectedIndex   -1            you will have to use checkboxes or some other mechanism to allow users to select multiple rows and then you can browse the rows for ones with the checkbox checked and then remove those rows

User · Answer

maybe you can use temp list for delete  for ignore row index change   x000D   x000D   lt pre gt  x000D  private void btnDelete Click object sender  EventArgs e  x000D    x000D      List lt int gt  wantdel   new List lt int gt     x000D      foreach  DataGridViewRow row in dataGridView1 Rows  x000D        x000D          if   bool row Cells  Select   Value    true  x000D          wantdel Add row Index   x000D        x000D   x000D      wantdel OrderByDescending y   gt  y  ToList   ForEach x   gt  x000D        x000D          dataGridView1 Rows RemoveAt x   x000D                     x000D    x000D   lt  pre gt  x000D   x000D   x000D

User · Answer

private void buttonRemove Click object sender  EventArgs e        foreach  DataGridViewCell oneCell in dataGridView1 SelectedCells                if  oneCell Selected              dataGridView1 Rows RemoveAt oneCell RowIndex             Removes rows which indexes are in selected cells  So  select any cells  and their corresponding rows will be removed

User · Answer

Well  this is how I usually delete checked rows by the user from a DataGridView  if you are associating it with a DataTable from a Dataset  ex  DataGridView1 DataSource   Dataset1 Tables  x     then once you will make any updates  delete  insert update  in the Dataset  it will automatically happen in your DataGridView   if  MessageBox Show  Are you sure you want to delete this record s     confirmation   MessageBoxButtons YesNo  MessageBoxIcon Information     System Windows Forms DialogResult Yes                        try                               for  int i   dgv Championnat RowCount -1  i  gt  -1  i--                                        if  Convert ToBoolean dgv Championnat Rows i  Cells 0  Value     true                                                Program set Tables  Champ   Rows i  Delete                                                            Program command   new SqlCommandBuilder Program AdapterChampionnat                   if  Program AdapterChampionnat Update Program TableChampionnat   gt  0                                        MessageBox Show  Well Deleted                                                catch  SqlException ex                                MessageBox Show ex Message

User · Answer

ArrayList bkgrefs   new ArrayList                        foreach  GridViewRow rowd in grdOptionExtraDetails Rows                                                CheckBox cbf    CheckBox rowd Cells 1  FindControl  chkbulk                                 if  cbf Checked                                                                rowd Visible   true                                   bkgrefs Add Convert ToString grdOptionExtraDetails Data Rows rowd RowIndex   OptionID                                                                 else                                                               grdOptionExtraDetails Data Rows RemoveAt rowd DataItemIndex                                   rowd Visible   false

User · Answer

have a look this way   if  MessageBox Show  Sure you wanna delete     Warning   MessageBoxButtons YesNo     System Windows Forms DialogResult Yes      foreach  DataGridViewRow item in this dataGridView1 SelectedRows            bindingSource1 RemoveAt item Index             adapter Update ds

User · Answer

Try this   if  dgv SelectedRows Count gt 0        dgv Rows RemoveAt dgv CurrentRow Index

User · Answer

I have written the following code  please take a look   foreach  DataGridViewRow row in dataGridView1 SelectedRows      if   row IsNewRow  dataGridView1 Rows Remove row     using the Index of the selected row still could work  see if the code below will do the trick   int selectedCount   dataGridView1 SelectedRows Count             while  selectedCount  gt  0        if   dataGridView1 SelectedRows 0  IsNewRow          dataGridView1 Rows RemoveAt dataGridView1 SelectedRows 0  Index       selectedCount--      I hope this helps  regards

User · Answer

It Work for me   private  System  Void MyButton Delete Click System  Object  sender  System  EventArgs  e                           Row       MydataGridView- gt Rows- gt RemoveAt MydataGridView- gt CurrentCell- gt RowIndex

[c#] How to delete a selected DataGridViewRow and update a connected database table?

Examples related to c#

Examples related to winforms

Examples related to datagridview

Examples related to tableadapter