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.

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