hi good day
    Im using stored procedure to retrieve data from MSQL
and load it to datagrid,Im trying to update record from datagrid to  the database it prompt me with this error...

"Dynamic SQL Generation for the update command is not supported against a SelectCommand that does not return any key column information"  
What is the reason for this error?and how to fix it??
                  



                                                ROy

[Edited by rtbuquia on 18-07-2005 at 06:47 PM GMT]

____________________________
rtbuquia

Most probably either you didnt define a primary key in the table, or you didnt generate UPDATE statement correctly.

____________________________
If you find the answer helpful, please mark this topic as solved.