VB.Net 2005 How to get a Table Adapter to display a certain record based on a parameter passed in ??
Posted on 2010-09-20
I am using VB.Net 2005..
I have on the Load Event of the form... a Table adapter that shows all the records of the tCust table
Dim sql As String
Dim da1 As SqlClient.SqlDataAdapter
Dim ds1 As DataSet = New DataSet
There are about 1000 records that are being returned.. the "ID" field of the Customer table is tCust.lID...if I wanted to get the table adapter to load based on a ID passed into it ..
For example instead of seeing all the records.. I want to see..tCust.lId = 150
What would the code look like?
Any insight would be greatly appreciated...