I have a MDI App. connected to SQL Server 2005 database via ODBC, and there are two forms in MDI Parent form, called form1 & form2, both of the forms are contain a datagrid.

The problem that I have when try to save data from datagrid, enven thus, it says the data saved, but there are no data have been saved,and this is an intermittent problem.

Thank you,

BVN

Problem Solved, thank you

Hi BVN2002,

Would you please post the code on how you update the DataGridView? Did you try to capture the exception which Database Operation might throw?

Best regards,
Bruce Zhou

---

Please mark the replies as answers if they help and unmark if they don't.

Private

Sub Form4_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'DataSet1.PatientInfo' table. You can move, or remove it, as needed.
Me.PatientInfoTableAdapter.Fill(Me.DataSet1.PatientInfo)
End Sub

Private

Sub SaveDataToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SaveDataToolStripMenuItem.Click

Me.Validate()
Me.PatientInfoBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.DataSet1)

End Sub

The code above are in my form,

Thank you Bruce,

BVN

Hi BVN2002,

There is no problem with this code as they are generated by the designer. As I can see from your initial post, the application prompts you data is saved. Can you tell me where you get this information?

Best regards,
Bruce Zhou

---

Please mark the replies as answers if they help and unmark if they don't.

We are changing the issue type to “Comment�because you have not followed up with the necessary information. If you have more time to look at the issue and provide more information, please feel free to change the issue type back to “Question�by editing your initial post and changing the radio button at the top of the post editor window. If the issue is resolved, we will appreciate it if you can share the solution so that the answer can be found and used by other community members having similar questions.

---

Please mark the replies as answers if they help and unmark if they don't.

Problem Solved, thank you

Thank you for letting me know your problem got solved.

Best regards,
Bruce Zhou

---

Please mark the replies as answers if they help and unmark if they don't.