Input string was not in a correct format.

Question

if (e.ColumnIndex == dataGridView.Columns["Delete"].Index && e.RowIndex >= 0) { //dataGridView.Rows.RemoveAt(e.RowIndex); int i = 1; con.Open(); SqlCommand cmd = new SqlCommand("delete from MainBillForm where Billno=" + Convert.ToInt16(dataGridView.Rows[e.RowIndex].Cells[1].Value), con); int count = cmd.ExecuteNonQuery(); if (count > 0) { MessageBox.Show("Record Deleted Successfully!"); } dataGridView.DataSource = null; displayDataGridView(); }

Rafnas T P · Answer

change your cell index and try if (e.ColumnIndex == dataGridView.Columns["Delete"].Index && e.RowIndex >= 0) { //dataGridView.Rows.RemoveAt(e.RowIndex); int i = 1; con.Open(); SqlCommand cmd = new SqlCommand("delete from MainBillForm where Billno=" + Convert.ToInt16(dataGridView.Rows[e.RowIndex].Cells[ 2 ].Value), con); int count = cmd.ExecuteNonQuery(); if (count > 0) { MessageBox.Show("Record Deleted Successfully!"); } dataGridView.DataSource = null; displayDataGridView(); }

Rafnas T P · Answer

I think it is a conversion issue, may be your input grid column is not able to convert to integer, please check column properly which one you wanted to convert, it must have numeric values dataGridView.Rows[e.RowIndex].Cells[1].Value

Jyoti Jodha · Answer

Error Show Conversion failed when converting the varchar value '15/05/2017' to data type int.

Rafnas T P · Answer

I think may be you have selected a wrong column, please check that also , and remember that, grid cells are 0 based that means, if your column is 1 then dataGridView.Rows[e.RowIndex].Cells[0].Value if your column is 2 then dataGridView.Rows[e.RowIndex].Cells[1].Value like it will go just add one

Sameer Shaik · Answer

i would like to suggest keep your code as clean as possible. you can store your value in variable first, then you can add sql command parameter, which will be much better to pass parameter of your data type and easy for debugging. you are trying to join string and Int "delete from MainBillForm where Billno=" is a string, Convert.ToInt16(dataGridView.Rows[e.RowIndex].Cells[1].Value), is INT,

ketan borsdiya · Answer

Hi Jyoti, Try below code snippet, if (e.ColumnIndex == dataGridView.Columns["Delete"].Index && e.RowIndex >= 0) { //dataGridView.Rows.RemoveAt(e.RowIndex); int i = 1; con.Open(); SqlCommand cmd = new SqlCommand("delete from MainBillForm where Billno='" + dataGridView.Rows[e.RowIndex].Cells[1].Value +"'", con); int count = cmd.ExecuteNonQuery(); if (count > 0) { MessageBox.Show("Record Deleted Successfully!"); } dataGridView.DataSource = null; displayDataGridView(); }

Karthi Keyan · Answer

Hi jodha, try this, SqlCommand cmd = new SqlCommand("delete from MainBillForm where Billno= ' " + Convert.ToInt16(dataGridView.Rows[e.RowIndex].Cells[1].Value) + " ' , con);