thanks
oh, i see. i'll try using a CommandBuilder then. although it might be interesting to create the InsertCommand myself.
thanks.
Edit:
just to make sure, the insert command would be written something like this, right?:
Dim sqlInsCommand As String = "insert into citylist
(name, state...
Exception: "Update requires a valid InsertCommand when passed DataRow collection with new rows"
This is the error message i got when i tried to update my database.
The way i'm trying to update is by creating 2 DataRow objects and adding each to a DataTable that i filled with DataAdapters, then i...
yea, i guess so. i'll see if i can get a copy from a friend...
it's probably a stupid question, but if you create a project so that it compiles for .Net 2.0, can you open it in vb 2005? or is there some way to make a project backward compatible with 2005?
in any case, thank you.
hey Robert_Zenz,
thanks for your reply.
the reason i need 2005 is that it's the version that my class at school uses... they're too lazy to update to 2008...
i've looked all over xanadu, but i can't find a copy of visual basic .net 2005 express edition... my computer died (not a metaphor or personification; it literally died (it was alive)), so i need to download it again... does anyone know of a site that still offers this program?
thanks :)
hi jmcilhinney,
thanks for your reply.
I just have a few questions, though, if you don't mind answering them:
- do you have any more info on DataRelations? maybe some code samples?
- since i need 2 DataAdapters, will i need 2 CommandBuilder objects (1 for each DataAdapter)...
ok, so i have a database with 2 related tables (one-to-many). What i'm trying to do is to connect to the database, fill 2 DataTable objects, and add them to a DataSet object. Then I would need to bind each column in the DataTables to a text box on the form, and allow the user to update the...
hi,
I have an MS Access database and i'm trying to connect to it in vb .net.
My question: Is there a way to provide a relative path to a database in the connection string?
the problem is that when I move the db and app, the path is no longer valid.
I read something about using "|DataDirectory|"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.