oh, i see. i'll try using a CommandBuilder then. although it might be interesting to create the InsertCommand myself.
just to make sure, the insert command would be written something like this, right?:
Dim sqlInsCommand As String = "insert into citylist
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.
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 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...
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|"...