0

Can please anyone help me on how to develop an Auto Searching System just like in Google and Yahoo.. im using VB.NET as front end and SQL server 2000 as its back end..

this is my code but it doesnt work...


SqlCommand1.CommandText = "SELECT eol_id, firstname FROM eol_info where eol_id like '" & id.Text & "%'"
Ds_id1.Clear()
SqlDataAdapter1.Fill(Ds_id1)

thanks.... :icon_wink:

2
Contributors
1
Reply
2
Views
9 Years
Discussion Span
Last Post by Jx_Man
0

if u used data grid for viewer i have the code :
- first u have a connection module (in this code i used GetConnect to connect to sqlserver)
- in this code dgWhat is datagrid name.

Dim conn As SqlConnection
Dim cmdWhat As New SqlCommand
Dim daWhat As New SqlDataAdapter
Dim dsWhat As New DataSet
Dim dtWhat As New DataTable

conn = GetConnect()
conn.open()
cmdWhat = conn.CreateCommand
cmdWhat.CommandText = SELECT eol_id, firstname FROM eol_info where eol_id like '" & id.Text & "%'"
daWhat.SelectCommand = cmdWhat
daWhat.Fill(dsWhat, "eol_info")
dgWhat.DataSource = dsWhat
dgWhat.DataMember = "eol_info"
dgWhat.ReadOnly = True
conn.close

hope this help.OK

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.