DataAdapter to Update/Insert/Delete

[thesti]

hi,

is it possible to execute stored procedure which will Insert/Update/Delete data in the database?

Thank you.

[kenobewan]

A stored procedure can perform any of the sql actions you want to use.

[thesti]

thanks for the reply,

sorry i forgot to write DataAdapter, i mean is that is it possible to execute the Insert/Update/Delete storedProcedure by using DataAdapter?

thanks

[Curtis Rutland]

I've never tried it like that before, but assuming that those SPs take the right number of parameters then it should work. You can create new SqlCommand objects like so:

SqlCommand deleteCmd = new SqlCommand("sp_Delete",yourSqlConnection);
SqlCommand.CommandType = CommandType.StoredProcedure;

You'll probably have to add the parameters to the SP name and then define them.