how to delete data from datagridview in windows application

Jyoti Jodha

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
Accepted 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();
}
0
Rafnas T P9y ago
then change

dataGridView.Rows[e.RowIndex].Cells[1].Value

to

dataGridView.Rows[e.RowIndex].Cells[2].Value
0
Jyoti Jodha9y ago
no bill no is not second cloumn

bill no is your 3rd cloumn
0
Karthi Keyan9y ago
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.
+1
Jyoti Jodha9y ago
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++;
}
}

+1
Rafnas T P9y ago
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
+1