Input string was not in a correct format.

Jyoti Jodha

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();

}

7 Replies

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

Rafnas T P9y ago
Accepted 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();
}
Jyoti Jodha9y ago
Error Show

Conversion failed when converting the varchar value '15/05/2017' to data type int.
Rafnas T P9y ago
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 Shaik9y ago
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 borsdiya9y ago
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 Keyan9y ago
Hi jodha,

try this,

   SqlCommand cmd = new SqlCommand("delete from MainBillForm where Billno=' " + Convert.ToInt16(dataGridView.Rows[e.RowIndex].Cells[1].Value) + " ', con);
Rafnas T P9y ago
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