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.
Unfortunately, activation email could not send to your email. Please try again.

How to bind the xml file with the AutoCompleteTextBox control?

 

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

Article ID: Published Date: Last Revised Date: Platform: Control:
1418 04/30/2011 07/10/2014 ASP.NET Web Forms (Classic) AutoCompleteTextBox
Tags:
Did you find this information helpful?
Add Comment
You must log in to leave a comment

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.