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.
July 22nd, 2009, 06:51 AM
Re: Search By Name
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