Author: lennyk1313 | Posted on: 11/9/2009 3:54:17 PM | Views : 404

I looked at the video sample of the Ajax Autocomplete, but it generates random characters, but I am trying to get the data from MySQL Database.
How would I go about changing the code to connect to a specific table in database and return the results from a specific column?
 
Lets say for this example we have the following:
Database name: TestDB
Connection String: SampleConnectionString (if needed)
Table name: cn.test
Table column: Country
 
Here is a sample code that automaticaly generates random name that I would like to change:
Default.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd< ...

Go to the complete details ...