Database Saving

[nmrpa91290]

I have a vb 2005 program that I am writing. It is just a form with a
datagridview, textbox, and import command button. The code looks like
this:

Private Sub Form1_Load(ByVa l sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load
'TODO: This line of code loads data into the
'TestDbDataSet. TestTable' table. You can move, or remove it, as
needed.
Me.TestTableTab leAdapter.Fill( Me.TestDbDataSe t.TestTable)
End Sub

Private Sub cmdImport_Click (ByVal sender As System.Object, ByVal e
As System.EventArg s) Handles cmdImport.Click
Dim col1, col2 As String
Dim NewRow As DataRow
NewRow = TestDbDataSet.T ables(0).NewRow
col1 = txtImport.Text
col2 = txtImport.Text
NewRow.Item("Da ta1") = col1
NewRow.Item("Da ta2") = col2
Try
TestDbDataSet.T ables(0).Rows.A dd(NewRow)
Catch ex As Exception
MsgBox(ex.Messa ge)
End Try
End Sub

Private Sub TestTableBindin gNavigatorSaveI tem_Click(ByVal sender
As System.Object, ByVal e As System.EventArg s) Handles
TestTableBindin gNavigatorSaveI tem.Click
Me.Validate()
Me.TestTableBin dingSource.EndE dit()
Me.TestTableTab leAdapter.Updat e(Me.TestDbData Set.TestTable)

End Sub
--------------------------------------------------------------------------------------------------------------------------------

It successfully adds rows to the datagridview control on the form.
However, it does not actually save the data into the access database
that I have created. When I open the database in Access after saving
the data in my application it is not present in the table. Nor is it
present when I close the application and then open it again. Can you
actually save the data entered in a vb 2005 independent windows
application to a previously created database? Or, does it just update
the control on the form making it look like it updated the database
table? Help would be greatly appreciated!

[Cor Ligthert[MVP]]

nmrpa,

The oposite from the Fill is the Update.
Beside that you needs the update commands which are standard in a Fill
command, therefore you can use the commandbuilder.

I think that this sample reach very much your question, be aware that this
is a very SQL intensive sample, only ment as sample, not to use it that way.

http://www.vb-tips.com/SQLServerUpdate.aspx

Cor
<nm********@gma il.comschreef in bericht
news:11******** **************@ k79g2000hse.goo glegroups.com.. .

>I have a vb 2005 program that I am writing. It is just a form with a
datagridview, textbox, and import command button. The code looks like
this:

Private Sub Form1_Load(ByVa l sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load
'TODO: This line of code loads data into the
'TestDbDataSet. TestTable' table. You can move, or remove it, as
needed.
Me.TestTableTab leAdapter.Fill( Me.TestDbDataSe t.TestTable)
End Sub

Private Sub cmdImport_Click (ByVal sender As System.Object, ByVal e
As System.EventArg s) Handles cmdImport.Click
Dim col1, col2 As String
Dim NewRow As DataRow
NewRow = TestDbDataSet.T ables(0).NewRow
col1 = txtImport.Text
col2 = txtImport.Text
NewRow.Item("Da ta1") = col1
NewRow.Item("Da ta2") = col2
Try
TestDbDataSet.T ables(0).Rows.A dd(NewRow)
Catch ex As Exception
MsgBox(ex.Messa ge)
End Try
End Sub

Private Sub TestTableBindin gNavigatorSaveI tem_Click(ByVal sender
As System.Object, ByVal e As System.EventArg s) Handles
TestTableBindin gNavigatorSaveI tem.Click
Me.Validate()
Me.TestTableBin dingSource.EndE dit()
Me.TestTableTab leAdapter.Updat e(Me.TestDbData Set.TestTable)

End Sub
--------------------------------------------------------------------------------------------------------------------------------

It successfully adds rows to the datagridview control on the form.
However, it does not actually save the data into the access database
that I have created. When I open the database in Access after saving
the data in my application it is not present in the table. Nor is it
present when I close the application and then open it again. Can you
actually save the data entered in a vb 2005 independent windows
application to a previously created database? Or, does it just update
the control on the form making it look like it updated the database
table? Help would be greatly appreciated!