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
peter.brooks3
NA
16
0
Error updating Access Tables
May 23 2005 6:19 AM
I am hopefully looking for confirmation here. I am writing an application that needs to update and existing Access Database. I have written the code to allow all of the fields to be passed to the database as parameters as in the example below. OleDbCommand uCmd = new OleDbCommand("UPDATE Property SET Name=? WHERE PropertyID=?", dbConnection); uCmd.Parameters.Add(new System.Data.OleDb.OleDbParameter( "Name", System.Data.OleDb.OleDbType.Char, 50); uCmd.Parameters.Add(new System.Data.OleDb.OleDbParameter( "PropertyID", System.Data.OleDb.OleDbType.Numeric, 0); My problem is when I try to update a table which has more that 35 parameters passed to it. Is this an upper limited that is not documented?
Reply
Answers (
1
)
Enumerate SQL data sources
Add parameter value that contains a single quote (C#)