Hi Atley,
You need to add an update method to handle this update click event.
Dim objDataSetChanges As [ApplicationName].[DatasetName] = New
[ApplicationName].[DatasetName]
Me.BindingContext(obj[DatasetName], "[TableName]").EndCurrentEdit()
objDataSetChanges = CType(obj[DatasetName].GetChanges,
[ApplicationName].[DatasetName])
If (Not (objDataSetChanges) Is Nothing) Then
Try
Me.UpdateDataSource(objDataSetChanges)
obj[DatasetName].Merge(objDataSetChanges)
obj[DatasetName].AcceptChanges()
Catch eUpdate As System.Exception
Throw eUpdate
End Try
End If
Hope this help.
Thanks,
Cynthia
DDSE QA
--------------------
From: "Atley" <at*****@homtmail.com>
Subject: DataWizard Error
Date: Fri, 4 Jun 2004 15:13:42 -0400
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <ul**************@tk2msftngp13.phx.gbl>
Newsgroups: microsoft.public.dotnet.languages.vb
NNTP-Posting-Host: mx1.cmt-canada.com 207.236.234.220
Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGP08.phx.gbl!tk2msftngp13
.phx.gblXref: cpmsftngxa10.phx.gbl microsoft.public.dotnet.languages.vb:207774
X-Tomcat-NG: microsoft.public.dotnet.languages.vb
I have made a data form using the data wizard but when i run it and change
the data on the form, then press the update button, I get "Update requires
avalid UpdateCommand when passed Data Row Collection with modified rows."
How do I get around this error? I have created a dataset from a table (in
the wizard).
Incidentally another table in the same database has a form based on it and
it works perfectly. this table has the exact fields with just different
field names in it, so I am stumped.