etc Get me started, please Code Cruiser: Your comment was helpful but not what I'm looking for. I was trying to get straight when to validate, when to update, whether I have to code to handle if user changes a key column?
If the code is not available just answer those questions and I'll go from there.
Data Source= dt cm = (me.bindingcontext(dt),cur Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
ID, membres.refere_par, bands.titre, membres_1.prenom & ' ' & membres_1AS reference_nom FROM ((bands INNER JOIN membres ON bands.
Click 'Update records using a Command Builder ' The variable i gives the number of records updated Dim cmdbuilder As New Odbc.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.
Meoshow Data Set2) ' Refresh datagrid data Grid View1. Click Refresh Data() Clear All Text Box(Me) End Sub 'reset datasource dgv BHL. when user presses a button (actually file--save) the Installation object is serialized and saved to disk. Goran Ah, I have now seen that you are saying about clickinig on menu. When clicking on the normal button, datagridview looses focus, while clicking on a menu, it doesnt. It is before the serialization that I do m Installations.productiond I cannot manifest this behaviour. To solve your problem, you need to do two things: 1) Call End Edit on datagridview 2) Call End Edit on Binding Source (or End Current Edit on Currency Manager) Goran I see what you mean with loosing focus. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site. Unfortunately when getting the Dataset (mycontrol.thedataset), the last row typed is missed UNLESS the user has pressed enter to move onto another row. One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community. Update(ds, "trial1") Msg Box("Records Updated= " & i) Catch ex As Exception Msg Box(ex. Data Member = "trial1" End Sub Private Sub Button1_Click(By Val sender As System. Odbc Command Builder(adp) Dim i As Integer Try i = adp.Just answer this: I plan to run in disconnected mode but will update the database row by row.When user leaves a row, I plan to update and disconnect What is an easy way of detecting a key change?ID = membres.[band]) INNER JOIN membres membres_1 ON membres.refere_par = membres_1. ID) ' Get member id Dim user Id As Integer user Id = Data Grid View1.