Autocomplete from database

Question

Hi.. I implement an autocomplete texttbox using following code and it works fine : [code] <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="AutoComplete2._Default" %> <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %> Untitled Page [/code] I want the autocomplete to read from database. And i tried used following code in above scriptbut it doesn't work and shows some error in SqlConnection oConn = new SqlConnection(connect); part: [code] public string[] GetCompanyName(string prefixText int count) { string sql = Select * from Table1 Where Company_Name like ' + prefixText + % + '; string connect = ConfigurationManager.AppSettings[Conn]; SqlConnection oConn = new SqlConnection(connect); SqlDataAdapter da = new SqlDataAdapter(sql oConn); da.SelectCommand.Parameters.Add(@prefixText SqlDbType.NVarChar 50).Value = prefixText + %; DataTable dt = new DataTable(); da.Fill(dt); string[] items = new string[dt.Rows.Count]; int i = 0; foreach (DataRow dr in dt.Rows) { items.SetValue(dr[Company_Name].ToString() i); i++; } return items; } [/code] could anyone tell me where's the wrong?Is my code above correct?

sam · Answer

That means my complete code looks like this : [System.Web.Services.WebMethod] [System.Web.Script.Services.ScriptMethod] public static string[] GetCompletionList(string prefixText int count) { string conString = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; SqlConnection connection = new SqlConnection(conString); connection.Open(); SqlParameter prm; string sql = Select Company_Name FROM Table1 WHERE Company_Name LIKE @prefixText; SqlDataAdapter cmd = new SqlDataAdapter(sql connection); prm = new SqlParameter(@prefixText SqlDbType.VarChar 50); prm.Value = prefixText + %; cmd.SelectCommand.Parameters.Add(prm); DataTable dt = new DataTable(); cmd.Fill(dt); string[] items = new string[dt.Rows.Count]; int i = 0; foreach (DataRow dr in dt.Rows) { items.SetValue(dr[Company_Name].ToString() i); i++; } connection.Close(); return items; } Untitled Page ServiceMethod=GetCompletionList CompletionInterval=500 ServicePath= TargetControlID=TextBox1 EnableCaching=true CompletionSetCount=20 DelimiterCharacters=; : UseContextKey=True>

sam · Answer

I have solved the problem. I added following code on aspx file: %@ Import Namespace =  System.Data % > %@ Import Namespace =  System.Data.SqlClient % > And this code on cs file: using System.Data.SqlClient; it works fineit reads and suggests from database.