开发者

C# dataset insert query issue from access database

开发者 https://www.devze.com 2022-12-17 04:36 出处:网络
I\'m using Visual Studio 2008 and an Access 2007 database. While I\'m trying to create a new insert query in my DataSet, the insert stored procedure mixes up the database field va开发者_如何学编程lues

I'm using Visual Studio 2008 and an Access 2007 database. While I'm trying to create a new insert query in my DataSet, the insert stored procedure mixes up the database field va开发者_如何学编程lues. I have a print screen of the problem here: http://netplague.eu/Capture.PNG As you can see in the attached print screen the table clients is displayed and below the InsertClient stored procedure. My problem is that the parameters are all mixed up.

Is there a solution to this problem or is it just a visual studio bug?

Thank you.


It's probably just a display order issue.

If you are inserting the parameters in alphabetical order of the field names, but Visual Studio is displaying the fields in the order they are defined in the database (for example), this would explain the difference.


I had your same problem. I have fixed it installing the service pack 1 for Microsoft visual studio 2008. I hope this help.

Simone

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号