We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to bind the xml file with the AutoCompleteTextBox control?

Platform: ASP.NET Web Forms (Classic) |
Control: AutoCompleteTextBox |
Published Date: April 30, 2011 |
Last Revised Date: July 10, 2014

 

The following code will bind the Products.xml file with the AutoCompleteTextBox. [Applicable only in 2.0]

C#

protected void AutoCompleteTextBox1_ProvideChoiceListOnCallback(object sender, Syncfusion.Web.UI.WebControls.Tools.ACUserChoiceListEventArgs e)

{

ArrayList userChoiceList = new ArrayList();

string key = e.Key;

DataSet dataset = new DataSet();

string url = "Products.xml";

dataset.ReadXml(this.Context.Server.MapPath(url));

DataTable dataTable = new DataTable();

dataTable = dataset.Tables[0];

DataRow[] Matchrow = dataset.Tables[0].Select();

//Convert data rows to ArrayList

foreach (DataRow row in Matchrow)

{

string emailList = row[0].ToString();

userChoiceList.Add(emailList);

}

e.ChoiceList = userChoiceList;

}

VB

Protected Sub AutoCompleteTextBox1_ProvideChoiceListOnCallback(ByVal sender As Object, ByVal e As Syncfusion.Web.UI.WebControls.Tools.ACUserChoiceListEventArgs)

Dim userChoiceList As ArrayList = New ArrayList()

Dim key As String = e.Key

Dim dataset As DataSet = New DataSet()

Dim url As String = "Products.xml"

dataset.ReadXml(Me.Context.Server.MapPath(url))

Dim dataTable As DataTable = New DataTable()

dataTable = dataset.Tables(0)

Dim Matchrow As DataRow() = dataset.Tables(0).Select()

'Convert data rows to ArrayList

For Each row As DataRow In Matchrow

Dim emailList As String = row(0).ToString()

userChoiceList.Add(emailList)

Next row

e.ChoiceList = userChoiceList

End Sub

ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon