Hi Amine,
We have checked your query “Auto Complete is not working”. we regret to inform that the DataTable collection is not supported for the AutoComplete operation. We have stated this limitation in our UG documentation also. Please refer the below UG link for getting information about this limitations.
So we have workaround on this query to meet your requirement by converting the DataTable collection in to the Dynamic object and then used that collection as a ItemsSource as like the below provided code sample
|
public static ObservableCollection<dynamic> ToDynamic(this DataTable dt)
{
var dynamicDt = new ObservableCollection<dynamic>();
foreach (System.Data.DataRow row in dt.Rows)
{
dynamic dyn = new ExpandoObject();
dynamicDt.Add(dyn);
//Converting the DataTable collcetion in Dynamic collection
foreach (System.Data.DataColumn column in dt.Columns)
{
var dic = (IDictionary<string, object>)dyn;
dic[column.ColumnName] = row[column];
}
}
return dynamicDt;
}
. . . .
EmployeeCollection = DataTableExtensions.ToDynamic(ds.Tables["Table1"]);
dataGrid.ItemsSource = EmployeeCollection; |
We have attached that the sample for your reference, You can able to get it from the below location.
Regards,
Balamurugan R
