I am using SqlDatasource with GridView & DetailView to Insert,Edit & delete a table data (All commands (select,update,insert & delete) are dynamicaly generated & set in runtime ).

I am connected to authores in pubs.
Select,insert & update commands are working fine, but the Delete Command giving error "cannot find the @au_id ..."?

I am using "DELETE From Authors WHERE auid=@auid "

I think i got the problem, I have to set the DataKeyNames.

Still the issue persists, If I hardcode DataKeyNames in the HTML attribute i works , but i want to set in runtime from the code behind. This way it gives lots of errors like "Index not ...."

Any one to help!

Thanks in advance
Prashant