Search By Name

[gkpandi]

Hi friends, I have a text box and a MSFlexgrid control in the form. If I enter a character in the text box, the corresponding rows should fetch from the SQL Server table and the name starts with the character (which was entered in the text box). I need a sample code using VB6.0 & ADO.

Thanks

[makdu]

You need to use something like this

cmd = New OleDbCommand("select  xyz from tablename where  name= '" & textboxentry& "' '", cn)

give the row name at xyz and the table name at tablename