vb.net 2008 problem writing to sql 2005 express database

  • Thread starter Thread starter plonk
  • Start date Start date
P

plonk

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 ..
PK..
 
plonk said:
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 ..
PK
Click to expand...

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...
 
Back
Top