something comparable???

[Kristi3]

Hi, I'm writing a web-based application. It is sort of a conversion from VB 6.0. I had some functionality in that app that I would like to sort of duplicate but don't know if it is possible. In the windows application I had a text box, that when you begin typing it narrows down the results in the datagrid. Here is the code for it:
Private Sub txtcompany_Change()
Dim mname As String
mname = Trim(txtCompany.Text)
If mname <> "" Then
On Error Resume Next
Adodc1.Recordset.Filter = "company like '" & mname & "%'"
Else
Adodc1.Recordset.Filter = "company <> '123'"
End If
End Sub

This works great. I'm wondering if there is any way to do this same thing in a webform?

thanks !!!!

 

[jmcilhinney]

You would use a DataView to do something like this in VB.NET. A DataView is a customised view of a DataTable that can be filtered and sorted without affecting the underlying table. Every DataTable has a DataView associated with it through its DefaultView property, or you can create a new DataView.