i try to delete record but there is this exception..

Question

Hello,,

i try to delete a record from a datagrid and DB,,i've written this code:

adapter.DeleteCommand = new SqlCommand("DELETE FROM tabName WHERE ID=@ID", connect);
adapter.DeleteCommand.Parameters.Add("@ID", SqlDbType.Int, 0).Value = stdDataGrid.SelectedItem;
    connect.Open();
       adapter.DeleteCommand.ExecuteNonQuery();
       MessageBox.Show("Row deleted !! ");
       adapter.Update(ds, "tabName");
       adapter.Fill(ds);
    connect.Close();

this exception seems to me:

The parameterized query '(@ID int)DELETE FROM tabName WHERE ID=@ID' expects the parameter '@ID', which was not supplied

plz tell me what should i do..??

Answer 1

Hi aseel,

I was able to replicate the exception that ur getting. The cause of the exception is "stdDataGrid.SelectedItem is null".

As a result of this ur getting this error. I would suggest u to check that value in stdDataGrid.SelectedItem is not null before executing the delete command.

Please mark it as an answer if it resolves ur query.

---

Regards, Parth Shah

Answer 2

Hi parth,

thank u for answer.

I actually set a record number that i want to delete and then click on the delete button to execute it..

i thought that this method to set a value in the selectedItem..

how can i put a value in the selected Item?? Is there another way?



Answer 3

i have the same problem,,

in weeks look for the solution

so plz any help??



Answer 4

Hi aseel,

I am unable to understand the statement in ur above post "I actually set a record number that i want to delete and then click on the delete button to execute it..".

Can u post a sample code so that I can get a better idea about the issue.

If u want to delete the SelectedItem in the datagrid then what ur doing so far is correct. The only check u need to apply is that the selecteditem isn't null.

A sample code will do a world of good to understand the problem and provide a solution.

---

Regards, Parth Shah

Answer 5

Hi parth,,

u said " The only check  i need to apply is that the selecteditem isn't null"..

how can i do that?

 

I think that selectedItem takes the value of the selected record number from the datagrid when i do choose't..
Or is there another way to make selecteditem not null

*****
I do not have another code only the code in above post..
Thank you very much for your response

Undo edits