Click here to Skip to main content
15,923,087 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionBest way to synchronize collection? Pin
carlos_rocha27-Dec-04 1:15
carlos_rocha27-Dec-04 1:15 
AnswerRe: Best way to synchronize collection? Pin
Dave Kreskowiak27-Dec-04 5:10
mveDave Kreskowiak27-Dec-04 5:10 
GeneralRe: Best way to synchronize collection? Pin
carlos_rocha27-Dec-04 5:52
carlos_rocha27-Dec-04 5:52 
GeneralRe: Best way to synchronize collection? Pin
Dave Kreskowiak27-Dec-04 9:07
mveDave Kreskowiak27-Dec-04 9:07 
GeneralRe: Best way to synchronize collection? Pin
carlos_rocha27-Dec-04 22:04
carlos_rocha27-Dec-04 22:04 
GeneralProblem with Access Pin
Briga26-Dec-04 23:30
Briga26-Dec-04 23:30 
GeneralRe: Problem with Access Pin
Dave Kreskowiak27-Dec-04 4:45
mveDave Kreskowiak27-Dec-04 4:45 
GeneralRe: Problem with Access Pin
Briga28-Dec-04 23:45
Briga28-Dec-04 23:45 
Well things are weird.
I also added an XML just for text. So I load the DB with .readxml and before using the Update methos I also save it to an XML file with WriteXML. In the beginning I got problem with XML in reading (not in saving) due to invalid values. I changed every field as nillable and now it works (XML).
The Update method doesn't generate any exception anymore but the .mdb is empty.

The new code is:

DB.AcceptChanges()
DB.WriteXml("c:\RF.XML") ' *** salvataggio XML
conn.ConnectionString = String.Concat("Provider=Microsoft.Jet.OLEDB.4.0;Data source=", cfgDBDirectory, "\rfgprii.mdb")
Try
conn.Open()
SelectCMD = New OleDb.OleDbCommand("SELECT * FROM Coordinate", conn)
SelectCMD.CommandTimeout = 30
DBAdapter.SelectCommand = SelectCMD
CustomCB = New OleDb.OleDbCommandBuilder(DBAdapter)
DBAdapter.Update(DB.Coordinate)
Catch ex As Exception
MessageBox.Show(String.Concat("Errore nell'accesso alla base dati archivio:", ex.ToString), "RFGPRII", MessageBoxButtons.OK, MessageBoxIcon.Error)
End Try


Now I also put a rem in front of the .writexml just to see if that instruction was affecting the Update. Still it generates no exception but the .mdb is empty.

So to recap the exception was due to the nillable parameter (although there were no null values) and it's gone. The problem now is that the Update method does not work. The DB is empty. Any clues?

Thanks for the reply
Briga

Questionhow to make a Modal Dialog in VB.net Pin
BSRK26-Dec-04 21:40
BSRK26-Dec-04 21:40 
AnswerRe: how to make a Modal Dialog in VB.net Pin
Jay Shankar26-Dec-04 22:20
Jay Shankar26-Dec-04 22:20 
GeneralRe: how to make a Modal Dialog in VB.net Pin
Nasir_Awan27-Dec-04 8:32
Nasir_Awan27-Dec-04 8:32 
GeneralRe: how to make a Modal Dialog in VB.net Pin
Jay Shankar27-Dec-04 13:33
Jay Shankar27-Dec-04 13:33 
Generalcreating rich text format file in vb6.0 Pin
Mohammad Daba'an26-Dec-04 20:24
Mohammad Daba'an26-Dec-04 20:24 
GeneralRe: creating rich text format file in vb6.0 Pin
Jay Shankar27-Dec-04 13:37
Jay Shankar27-Dec-04 13:37 
QuestionHow to load record to listview in vb.net Pin
Mekong River26-Dec-04 16:14
Mekong River26-Dec-04 16:14 
AnswerRe: How to load record to listview in vb.net Pin
Mekong River27-Dec-04 16:18
Mekong River27-Dec-04 16:18 
GeneralRubber-Band Focus Rectangle Pin
OICU81226-Dec-04 13:51
OICU81226-Dec-04 13:51 
GeneralPassing events between forms Pin
plukje26-Dec-04 10:53
plukje26-Dec-04 10:53 
GeneralRe: Passing events between forms Pin
carlos_rocha27-Dec-04 1:06
carlos_rocha27-Dec-04 1:06 
QuestionIs it possible to Insert Table in RTF Control???? Pin
Nasir_Awan26-Dec-04 10:43
Nasir_Awan26-Dec-04 10:43 
AnswerRe: Is it possible to Insert Table in RTF Control???? Pin
Jay Shankar27-Dec-04 14:08
Jay Shankar27-Dec-04 14:08 
QuestionReports Integrated with Setup in VB.Net??? Pin
Nasir_Awan26-Dec-04 10:39
Nasir_Awan26-Dec-04 10:39 
GeneralTransfer File to Server Pin
Nasir_Awan26-Dec-04 10:35
Nasir_Awan26-Dec-04 10:35 
GeneralTransfer File to Server Pin
Nasir_Awan26-Dec-04 10:35
Nasir_Awan26-Dec-04 10:35 
Generalto use sql as back end Pin
preet_jy26-Dec-04 6:57
preet_jy26-Dec-04 6:57 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.