Hi ,
I am trying to insert records into database. I am trying
to write the following code.
On button1 click event i am inserting five records and
after that i am calling the update method of dataadapter
to update the records in database.
Records are inserting but all the five records have the
same value and that too of that last ones..
More over i tried to use the acceptchanges methods for
datatable and dataset but of no use
ihave used the following code

Dim da As New OleDb.OleDbDataAdapter("select * from
test", "Provider=SQLOLEDB;Data Source=192.168.16.4;Initial
Catalog=Northwind;user id=sa;password=;")
Dim myConnection As New OleDb.OleDbConnection
("Provider=SQLOLEDB;Data Source=192.168.16.4;Initial
Catalog=Northwind;user id=sa;password=;")
Dim dt As DataTable
Dim dr As DataRow
Dim ds As New DataSet()

Private Sub Form1_Load(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles MyBase.Load
da.Fill(ds, "test")


End Sub

Private Sub Button1_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Button1.Click
dt = ds.Tables("test")
da.InsertCommand = New OleDb.OleDbCommand("insert
test values('" + TextBox1.Text + "','" + TextBox2.Text
+ "')", myConnection)


Dim i As Integer
dr = dt.NewRow()
dr("name") = TextBox1.Text
dr("address") = TextBox2.Text

dt.Rows.Add(dr)
MsgBox(dt.Rows.Count())
End Sub

Private Sub Button2_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Button2.Click
Try

da.Update(ds, "test")
MsgBox("Record saved")
Catch er As Exception
MsgBox(er.ToString)
End Try
End Sub

"Hi Pushpendra Vats

I deleted some things and added some things, that commandbuilder is not the
nicest however that insert command you was using also not.

Give it a try?

It is just changed in the text so watch typos or other errors.

Cor


"> Dim da As New OleDb.OleDbDataAdapter("select * from
> test", "Provider=SQLOLEDB;Data Source=192.168.16.4;Initial
> Catalog=Northwind;user id=sa;password=;")
> Dim myConnection As New OleDb.OleDbConnection
> ("Provider=SQLOLEDB;Data Source=192.168.16.4;Initial
> Catalog=Northwind;user id=sa;password=;")
Dim ds As New DataSet()
> Private Sub Form1_Load(ByVal sender As System.Object,
> ByVal e As System.EventArgs) Handles MyBase.Load
> da.Fill(ds, "test")
> End Sub
> Private Sub Button1_Click(ByVal sender As
> System.Object, ByVal e As System.EventArgs) Handles
> Button1.Click
> dt = ds.Tables("test")
> dim dr as datarow = dt.NewRow()
> dr("name") = TextBox1.Text
> dr("address") = TextBox2.Text
> dt.Rows.Add(dr)
> MsgBox(dt.Rows.Count())
> End Sub
> Private Sub Button2_Click(ByVal sender As
> System.Object, ByVal e As System.EventArgs) Handles
> Button2.Click
> Try
dim cmb as new OleDb.OleDbcommandbuilder(da)
> da.Update(ds, "test")
> MsgBox("Record saved")
> Catch er As Exception
> MsgBox(er.ToString)
> End Try
> End Sub

Dear Cor,
Thanks a lot fro the solution but i really could not
understand why the same is not working with the
insertcommand.

One more thing if i use the acceptchanges method with
datatablenad dataset still it was not working....

Thanks a lot....again....

pushpendra
>-----Original Message-----
>"Hi Pushpendra Vats
>
>I deleted some things and added some things, that
commandbuilder is not the
>nicest however that insert command you was using also not.
>
>Give it a try?
>
>It is just changed in the text so watch typos or other
errors.
>
>Cor
>
>
>"> Dim da As New OleDb.OleDbDataAdapter("select * from
>> test", "Provider=SQLOLEDB;Data
Source=192.168.16.4;Initial
>> Catalog=Northwind;user id=sa;password=;")
>> Dim myConnection As New OleDb.OleDbConnection
>> ("Provider=SQLOLEDB;Data Source=192.168.16.4;Initial
>> Catalog=Northwind;user id=sa;password=;")
> Dim ds As New DataSet()
>> Private Sub Form1_Load(ByVal sender As System.Object,
>> ByVal e As System.EventArgs) Handles MyBase.Load
>> da.Fill(ds, "test")
>> End Sub
>> Private Sub Button1_Click(ByVal sender As
>> System.Object, ByVal e As System.EventArgs) Handles
>> Button1.Click
>> dt = ds.Tables("test")
>> dim dr as datarow = dt.NewRow()
>> dr("name") = TextBox1.Text
>> dr("address") = TextBox2.Text
>> dt.Rows.Add(dr)
>> MsgBox(dt.Rows.Count())
>> End Sub
>> Private Sub Button2_Click(ByVal sender As
>> System.Object, ByVal e As System.EventArgs) Handles
>> Button2.Click
>> Try
> dim cmb as new OleDb.OleDbcommandbuilder(da)
>> da.Update(ds, "test")
>> MsgBox("Record saved")
>> Catch er As Exception
>> MsgBox(er.ToString)
>> End Try
>> End Sub
>
>
>.
>

Hi Pushpendra,

Maybe the insert does work also, however why do more work than needed.

The acceptchanges is to prevent updating.

It stands for Accept the changes as if you did the updating.

Cor