System.ArgumentOutOfRangeException?

Asked Feb 01 '20 at 17:42

Active Feb 01 '20 at 17:56

Viewed 156 times

I wrote the code below, but get the error

"System.ArgumentOutOfRangeException"

I don't know the source of the error , so guys can u help me , (excuse my bad english)

the code:

NpgsqlCommand cd = new NpgsqlCommand("insert into CLIENT values (@ref_client,@type_client,@nom,@adresse,@tele,@fax)", cnx);
            cd.Parameters.AddWithValue("@ref_client", dataGridView1.SelectedRows[0].Cells[0].Value.ToString());
            cd.Parameters.AddWithValue("@type_client", dataGridView1.SelectedRows[0].Cells[1].Value.ToString());
            cd.Parameters.AddWithValue("@nom", dataGridView1.SelectedRows[0].Cells[2].Value.ToString());
            cd.Parameters.AddWithValue("@tele", dataGridView1.SelectedRows[0].Cells[3].Value.ToString());
            cd.Parameters.AddWithValue("@fax", dataGridView1.SelectedRows[0].Cells[4].Value.ToString());
            cnx.Open();
            cd.ExecuteNonQuery();
            cnx.Close();

edited Feb 01 '20 at 17:56

asked Feb 01 '20 at 17:42

MOUAD MOUMENE

To help you we would need to know the number of elements in `SelectedRows` and, assuming that was more than zero, the number in `SelectedRows[0]`. – AdrianHHH Feb 01 '20 at 18:59
Looks like @adresse parameter is missing. You expect it in the insert statement, but missing when fill parameters. – Ceridan Feb 01 '20 at 20:32
You should confirm the index in datagridview is not out of range. – 大陸北方網友 Feb 03 '20 at 01:33
@KyleWang can u explain more , thanks . – MOUAD MOUMENE Feb 12 '20 at 13:50
You first need to ensure that `dataGridView1.SelectedRows` is not null. Second, please note that the indexes of SelectedRows [index] and Cells [index] start from 0. – 大陸北方網友 Feb 13 '20 at 01:42

System.ArgumentOutOfRangeException?

0 Answers0