Index was out of range

[harisbscs2003]

i am deleting a row from grid view my code is as follows. I got an exception i.e.

Index was out of range. Must be non negative and less then the size of the collection. Parameter name: INDEX

Code:

private void bindingNavigatorDeleteItem_Click()
{
try
{
SqlDataAdapter da;
DataSet ds = new DataSet();
SqlConnection conn = new SqlConnection(@"Data Source=HARIS\SQLEXPRESS;Initial Catalog=Nesk;Integrated Security=True");
da = new SqlDataAdapter();
 
SqlCommand cmd = new SqlCommand("sp_Nsk_PromoCriteriaDelete");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@promoID", SqlDbType.VarChar).Value = System.Convert.ToInt32(nsk_PromoCriteriaDataGridView.SelectedRows[0].Cells[0].Value);
 
cmd.Connection = conn;
 
da.SelectCommand = cmd;
 
da.Fill(ds);
conn.Close();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
 

Stored Procedure:

ALTER PROCEDURE [dbo].[sp_Nsk_PromoCriteriaDelete]
@PromoID varchar(20)
AS BEGIN
 
SET NOCOUNT ON;
 
delete from Nsk_PromoCriteria where PromoId = @PromoID
 
END
 

this piece of Code:

System.Convert.ToInt32(nsk_PromoCriteriaDataGridView.SelectedRows[0].Cells[0].Value);
 

Selected rows gives a value which is next to what i selected actually. Lets suppose if i select PromoID= 1 they take PromoID=2 and hence delete ID =2.

when i use:

System.Convert.ToInt32(nsk_PromoCriteriaDataGridView.SelectedRows[0].Cells[0].Count);
 

it returns 4 selected rows while i select 5

[Plater]

when i use:

System.Convert.ToInt32(nsk_PromoCriteriaDataGridView.SelectedRows[0].Cells[0].Count);
 

it returns 4 selected rows while i select 5

Actually THAT code is invalid (copy/paste error I suspect). You probably ment nsk_PromoCriteriaDataGridView.SelectedRows.Count

When do you run this code? Some of the Selecting events occur "before" the selection is made. Your code example also shows you always using the "first" row in the selection. Are you checking to make sure there IS a row in the selectedrows ?