VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,591 questions
A community member has associated this post with a similar question:
UPDATE fields
Only moderators can edit this content.
OleDbCommand Parameters
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 77%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
StewartBW
405
Reputation points
Hello
I'm going to use parameterized queries for all my Access OleDb commands and got 2 questions:
Use Parameters.Add or Parameters.AddWithValue? The documentation won't clarify the pros and cons of each one.
If I choose Parameters.Add how to map the data types? I mean Field Size in Access vs OleDbType for numbers, or Memo which is long string and has no OleDbType equivalent.
Thanks.
VB
{count} votes