|
-
Sep 30th, 2002, 09:33 AM
#1
Thread Starter
New Member
Trying to use ADO 2.7 in VB.NET
I am attempting to use ADO 2.7 in VB.Net to do a simple access database update. I am using all commands successfully except the addnew command. I am passing to arrays, a fieldlist and a value list as parameters to the function. I have attempted several other methods of passing variables yet to no avail. I always end up with the same error:
"Item cannot be found in the collection corresponding to the requested name or ordinal."
Any suggestions.
Oh, by the way did I mention that this is my first project in .net. I have been working in VB 6.0 for several years now.
Here's the code line :
With dbrs
.AddNew(strFieldArray, strValueArray)
end with
I can successfully open the database, delete all records from a table, open the table, but cannot insert records.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|