Autocomplete text box bind from database.. in asp.net using C#

keshu keshvala

16y8.2kLearn iOS Programming

I want autocomplete text box and want value in it from my database using C# in asp.net...

Thanks in advanced...

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

keshu keshvala16y ago
Hey thanks for help... i got your logic but when i run it show s error like..
The following operations are supported. For a formal definition, please review the Service Description.

GetInfo
This web service is using http://tempuri.org/ as its default namespace.

Recommendation: Change the default namespace before the XML Web service is made public.

Each XML Web service needs a unique namespace in order for client applications to distinguish it from other services on the Web. http://tempuri.org/ is available for XML Web services that are under development, but published XML Web services should use a more permanent namespace.

Your XML Web service should be identified by a namespace that you control. For example, you can use your company's Internet domain name as part of the namespace. Although many XML Web service namespaces look like URLs, they need not point to actual resources on the Web. (XML Web service namespaces are URIs.)

For XML Web services creating using ASP.NET, the default namespace can be changed using the WebService attribute's Namespace property. The WebService attribute is an attribute applied to the class that contains the XML Web service methods. Below is a code example that sets the namespace to "http://microsoft.com/webservices/":

C#

[WebService(Namespace="http://microsoft.com/webservices/")]
public class MyWebService {
// implementation
}

as i am new to asp so cant get what it says...
thanks ...

Shankey16y ago

hi,

Following is your code, But dont forget to mark my answer as accepted if it helped you :)

Drag and drop a Textbox from your Toolbox. Then drag and drop a ScriptManager and AutoCompleteExtender to your Default.aspx page. Then add a webservice to your project as WebService.asmx. First thing you have to do is to add the ScriptService reference to the webserive as follows.

[System.Web.Script.Services.ScriptService]

Now, write a webmethod 'GetData' to fetch the data from your table as follows

[WebMethod]
public string[] GetInfo(string prefixText)
{
int count = 10;
string sql = "Select * from tbl Where Name like @prefixText";
SqlDataAdapter da = new SqlDataAdapter(sql,"Your Connection String Comes Here"));
da.SelectCommand.Parameters.Add("@prefixText", SqlDbType.VarChar, 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["Name"].ToString(),i);
i++;
}
return items;
}

The above webmethod takes prefixText as argument, sends it to the query to fetch only the related words that starts with the prefixText values. Then it returns the result as an array of strings.

Next, in the Default.aspx page, set the AutoCompleteExtender's TargetControlID property to the TextBox Id. Now you can see a new Extenders Tab is added in the Textbox's Property window. Set ServicePath as WebService.asmx, ServiceMethod as GetInfo and MinimimPrefixLength as 1.

Autocomplete text box bind from database.. in asp.net using C#

This web service is using http://tempuri.org/ as its default namespace.

Recommendation: Change the default namespace before the XML Web service is made public.