|
-
Mar 4th, 2004, 05:41 PM
#1
Thread Starter
New Member
Variable value not updating dataset
If I put a text value in the variable it posts, if I get it from the field it does not. It does not bomb out, it just does not pass the test
If Not mydataset.HasChanges(DataRowState.Modified) Then Exit Sub
weird?
Code:
Dim vUser As String
Dim vDist As String
Dim vCarrier As String
Dim Ret As Integer
Try
vUser = TextBox2.Text
vDist = TextBox3.Text
vCarrier = TextBox4.Text
MsgBox(vUser)
mydataset.Tables("tblcarrier").Rows(0).Item("Name") = vUser
If Not mydataset.HasChanges(DataRowState.Modified) Then Exit Sub
Dim xDataSet As DataSet
MsgBox("made it2")
' GetChanges for modified rows only.
xDataSet = mydataset.GetChanges(DataRowState.Modified)
' Check the DataSet for errors.
If xDataSet.HasErrors Then
' Insert code to resolve errors.
End If
MsgBox("made it3")
adpCarriers.Update(xDataSet, "tblcarrier")
MsgBox("Made it4")
Catch ex As Exception
System.Diagnostics.Debug.WriteLine(ex.Message & "l " & ex.StackTrace)
'Finally
conn.Close()
End Try
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|