Problem with source table update
I'm having trouble updating the source table with dataset records that have been added (in VB.NET)
I have two databases that I want to merge one table at a time. I'm struggling with table number one.
I manage to get all rows into the "ds" dataset and the rowstate of each is "added".
When I run the update statement I get an error and no update.
I added the command builder because I read somewhere it would automatically generate the necessary SQL statements.
This is the code:
Dim cn As OleDbConnection = New OleDbConnection(strConnection)
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _
dscmd = New OleDbDataAdapter("SELECT * FROM firsttable", cn)
Dim cb As OleDbCommandBuilder = New OleDbCommandBuilder(dscmd)
cn = New OleDbConnection(strConnection)
cb.QuotePrefix = ("[")
cb.QuoteSuffix = ("]")
ds = New DataSet
Dim workrow As DataRow
For iCtr = 1 To SourceRecordCount
workrow = ds.Tables("firsttable").NewRow
'set column values
In the dbs I have a table called "session". Strangely it can't be called that.
If I change the name to "session1" ,for example, no error occurs.
Anyone who knows why?
I would be very happy if someone could help with this.
session is a reserved keyword in some languages and I am not sure about in databases but it could be a reason. a few years ago, I had a table named Order and it never worked and after a whole month of investigation I found out that it was just the name of the table which is why I would never get an error nor it would work. Try Sessions if Session1 is not suitable.
new to programming but getting ther
If this is MS-SQL Server, you can bracket the table name, like this:
For instance, in a SELECT command it would be:
Select * from [session]
Select * from MyDB.dbo.[session]
This also works if you have problems with table names that have spaces, punctuation, etc.
Hope this helps...
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center