TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
haluk darbag
NA
1
0
OleDB Concurrency Error
Jun 5 2006 6:33 PM
Hi, I'm coding a WFA for some cheap people who want to use Access 2002 as a DB as they already have a licenced Office 2002. Everything is set in the application except updating records. I let them update from a DataGrid, but it throws a Concurrency Exception, which I am guessing is due to a type-mismatch. In VS 2005, the DBType of the primary key field shows as Object when I debug, and I can not find a matching OleDBType to add to the parameter. Here's the part of the code: string updateQuery = "UPDATE product SET [no] = @no, maincat = @maincat, name = @name, artist = @artist, cover = @cover," + " genre = @genre, sub = @sub, dub = @dub, disc = @disc, extra = @extra, amount= @amount WHERE id = @id"; tb_Adapter.UpdateCommand = new OleDbCommand(updateQuery, tb_Connection); gridParam = tb_Adapter.UpdateCommand.Parameters.Add("@id", OleDbType.Numeric); gridParam.SourceColumn = "id"; gridParam.SourceVersion = DataRowVersion.Current; id is the primary key. So far I have tried Integer, Numeric, ShortInt, Unsigned Int. None of them work. If anyone can tell me the type of AutoNumber in terms of OleDBTypes in 2005, it'd be greatly appreciated.
Reply
Answers (
0
)
About the Factory Design Pattern
Master C# Now and get your MCP