Autocomplete TextBox in ASP.VB.Net

Question

0.00/5 (No votes)

See more:

I'd be glad if someone could help with how to write a code for autocomplete TextBox in asp.vb.net.
I'm able to do that in VB.Net Windows application, but unable to do same in the Web Application. The following is what I've tried under Page_load:

VB

Try
            cmd = New SqlCommand("Select SubjectName from ProgramDetails.Subjects", cn)
            dr1 = cmd.ExecuteReader
            While dr1.Read
                txtSearch.AutoCompleteType.GetType.Name.Trim(dr1(0))
            End While
            dr1.Close()
            dr1 = Nothing
        Catch ex As Exception
            MsgBox(ex.Message)
        Finally
        End Try

Posted 28-Mar-13 4:26am

Akaglo

Updated 21-Aug-18 9:22am

v2

Add a Solution

Comments

ZurdoDev 28-Mar-13 10:28am

It would be easier to use a jquery plugin to do it. There are lots of free ones already built that you can tie into.

Akaglo 28-Mar-13 10:30am

Can you please show me that?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Adam R Harris · Answer 1 · 2013-03-28T05:40:00

Solution 1

http://jqueryui.com/autocomplete/[^]

Posted 28-Mar-13 5:40am

Adam R Harris

Comments

Akaglo 29-Mar-13 6:33am

Thank you, Sir. I've checked the link, but that's not what I want exactly. For my problem, I want the data in the textbox to come from a table in the database.

Adam R Harris 29-Mar-13 16:19pm

Take a look at the Remote, Remote JSONP and Remote with Cache examples .
They are exactly what you need

Vincent Maverick Durano · Answer 2 · 2018-08-21T09:22:00

It seems like you are aiming for a server-side approach to implement an autocomplete feature. In ASP.NET web app, Page_Load event isn't the place to implement that. You would typically use the TextChanged event of the TextBox. But you should be careful when taking to this route as TextChange event causes the server to fire and trigger a postback and hits your database each time you change/type something in the TextBox. You could surely cache the data at once to reduce database calls but still you need to rebind your data control with the search results - which is kinda expensive.

Your closest option if you want to avoid doing some client-side scripting is using : AutoComplete Sample[^]

Here's an article that shows how to use it: AutoCompleteExtender in ASP.Net
[^]

The ideal way to implement an autocomplete feature is using a client-side approach with AJAX. You could use jQuery as already suggested by others and couple that with AJAX to communicate with your data from your database. Here's a great writeup about: Many ways to communicate with your database using jQuery AJAX and ASP.NET[^]

Once you get a good grasp on how the web works regarding communicating your data from the server to the client, then you can start working on your autocomplete feature. There are tons of examples in the net that are available. Here are a few of them:

TextBox AutoComplete with ASP.NET and jQuery UI | DotNetCurry[^]
Populate jQuery AutoComplete TextBox from Database using Web Service in ASP.Net
JQuery - Auto Complete Text Box In ASP.Net