Groups | Blog | Home
all groups > vb.net > december 2007 >

vb.net : vb.net 2008 problem writing to sql 2005 express database


plonk
12/30/2007 12:37:11 AM
Hi
I am trying to write to a sql database, but the Update method is not
writing the data to the database.

I can view the data coming into the dataset grid ok and no errors are
generated.

I'm really stuck now :/

Private Sub addrow_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles addrow.Click
Dim NewMeetingRow As meetinginfoDataSet.MeetingRow
NewMeetingRow = MeetinginfoDataSet.Meeting.NewMeetingRow()

newmeetingRow.Course = "new course"
MeetinginfoDataSet.Meeting.Rows.Add(NewMeetingRow)
MeetingBindingSource.EndEdit()
TableAdapterManager.UpdateAll(MeetinginfoDataSet)

End Sub

is there something missing here?
thanks ..
Cor Ligthert[MVP]
12/31/2007 11:09:19 AM
Plonk,

Are you able to fill a datatable from your database?

plonk
12/31/2007 6:22:08 PM

[quoted text, click to view]

I have made a small amount of progress on this.
If I use the northwind database the updateall method works ok, however, if I
use my own database it does not..

very strange...

AddThis Social Bookmark Button