grwallace
asked on
Selecting data by code into a tableadapter
I have generated a quick sample program which works fine:-
Public Class Form1
Private Sub AdmasBindingNavigatorSaveI tem_Click( ByVal sender As System.Object, ByVal e As System.EventArgs)
Me.Validate()
Me.AdmasBindingSource.EndE dit()
Me.AdmasTableAdapter.Updat e(Me.PICom tass02Data Set.Admas)
End Sub
Private Sub AdmasBindingNavigatorSaveI tem_Click_ 1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles AdmasBindingNavigatorSaveI tem.Click
Me.Validate()
Me.AdmasBindingSource.EndE dit()
Me.AdmasTableAdapter.Updat e(Me.PICom tass02Data Set.Admas)
End Sub
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
.
Me.PlmasTableAdapter.Fill( Me.PIComta ss02DataSe t.Plmas)
Me.AdmasTableAdapter.Fill( Me.PIComta ss02DataSe t.Admas)
End Sub
End Class
This brings a complete list in which I can page through. What I need to be able to do is change the input query to select a single record by adding a " WHERE AccountNo = " condition to the select statement in the program.
Any ideas?
Public Class Form1
Private Sub AdmasBindingNavigatorSaveI
Me.Validate()
Me.AdmasBindingSource.EndE
Me.AdmasTableAdapter.Updat
End Sub
Private Sub AdmasBindingNavigatorSaveI
Me.Validate()
Me.AdmasBindingSource.EndE
Me.AdmasTableAdapter.Updat
End Sub
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
.
Me.PlmasTableAdapter.Fill(
Me.AdmasTableAdapter.Fill(
End Sub
End Class
This brings a complete list in which I can page through. What I need to be able to do is change the input query to select a single record by adding a " WHERE AccountNo = " condition to the select statement in the program.
Any ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.