Wednesday, February 15, 2012

Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that

Hey,

I changed the database name in the initial cataloge in the web.config conncetion string so that it now connects to other databas that contains same tables as the old one,but now i am getting that error at the update stmt !

thank u in advance

Hiba

Do you have the primary key and/or unique fields defined in the new database table? The Update command only knows how to update if it has access to a unique field...

This could explain why it worked in the first database but not the new one.

No comments:

Post a Comment