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
Fred Tededmondson
NA
12
68k
Alter parameter type
Dec 9 2010 2:22 PM
Hi, all,
How does one go about setting the value type of a parameter built into a datatable/tableadapter query? I usually create these by typing a ? (which it converts to :PARAM1, eg) into the query. However, it tries to guess what type of value I mean to send, and it's guessing wrong. It's using the field type it's getting from the database (Decimal), and while I guess I could convert the values to decimals, I would prefer string matching. I don't like to convert integers to floating point numbers; I have lost a lot of time in the past to rounding errors.
So I'm wondering how you tell QueryBuilder what type of value you're passing. I have gone into the Designer codebehind for the dataset and manually edited the code that builds in the parameter to match one that's a legitimate string, and this does work (as long as you close the design view first), but it seems like the sort of thing that the designer should let you control somehow (eg, type ?D or ?S)
Reply
Answers (
0
)
Cannot open database "GADatabase" requested by the login. The login failed. HELP!
Changing location of my ms access 2007 db means can't update records