how to delete data from datagridview in windows application

Question

how to delete data from datagridview delete all billno records in Database use windows application c#

ID	Billno	Product name	tax	Total Amount	delete
1`	1	Abc	800	2100	delete
2	2	Xyz	150	1097	delete
3	3	Asd	556	4556565	delete

In Gridview Records

In Database Records

Id	Billno	Product name	Amount	Tax	Total amount
1	1	Abc	500	500	1000
2	1	Abc	800	300	1100
3	1	Abc	1300	800	2100
4	2	Xyz	200	50	250
5	2	Xyz	897	100	997
6	2	xyz	1097	150	1247
7	3	Asd	5000	525	5252

Rafnas T P · Answer

do like this if bill no is your second cloumn if (e.ColumnIndex == dataGridView.Columns["Delete"].Index && e.RowIndex >= 0) { dataGridView.Rows.RemoveAt(e.RowIndex); con.Open(); SqlCommand cmd= new SqlCommand("delete from tablename where Billno=" + Convert.ToInt16(dataGridView.Rows[e.RowIndex].Cells[1].Value), con); int count=cmd.ExecuteNonQuery(); }

Karthi Keyan · Answer

hi jodha, For only removing from Gridview. foreach(DataGridViewRow row in grid.SelectedRows) { grid.Rows.RemoveAt(row.RowIndex); } For Remove all bill which have the same bill no from database. string billno = grid.Rows[0].Cells[1].FormatedValue.ToString(); string query = "Delete From Table where Billno = '"+billno+"'"; SqlCommand cmd = new SqlCommand(query,conn); cmd.Excutequery(); hope this will help you.

Jyoti Jodha · Answer

How to write this this Query right formate if (e.ColumnIndex == dataGridView.Columns["Delete"].Index && e.RowIndex >= 0) { dataGridView.Rows.RemoveAt(e.RowIndex); int i = 1; foreach (DataGridViewRow g1 in dataGridView.Rows) { g1.Cells[0].Value = i; i++; } }

Rafnas T P · Answer

try as below delete from tablname where billno=1 here instead of table name give your table name from which table you wanted to delete and billno may be you Id column instead of one you can pass bill no value from grid to this query

Rafnas T P · Answer

then change dataGridView.Rows[e.RowIndex].Cells[1].Value to dataGridView.Rows[e.RowIndex].Cells[ 2 ].Value

Jyoti Jodha · Answer

no bill no is not second cloumn bill no is your 3rd cloumn