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

DataGridControl and Excel Binding

Thread ID:





98698 Mar 20,2011 04:31 PM UTC Apr 1,2011 02:43 PM UTC WPF 1
Tags: GridControl
Administrator [Syncfusion]
Asked On March 20, 2011 04:31 PM UTC


WPF DataGridControl -

I'm using a DataGridControl that is bound to a DataTable. Is there a way for me to use the IDataErrorInfo interface to show custom error messages? how do I pass the DataGridControl columns to the interface?

and even more importantly, is there a way to use the ObservableCollection to bind to an OleDbConnection connection that uses Excel file as it's data provider? My company works almost exclusively with Excel files and it will be great if I can create a two way binding between the DataGridControl and an Excel file.


Karthick Ravichandran [Syncfusion]
Replied On April 1, 2011 02:43 PM UTC

Hi Assaf,

Sorry for the delay caused.

1. Regarding IDataErrorInfo Interface:

Currently we don’t have the support for the error validation in the data table. We have logged this as a feature request in our database; we will implement this feature in any of our upcoming releases. We usually have an interval of at least three months between releases. The feature implementation would also greatly depend on the factors such as product design, code compatibility and complexity. So we request you to check with the product page in our website regarding this feature in the upcoming releases. We will update you once this feature is implemented.

2. Regarding Excel File as Data Provider Using OleDbConnection:

We have prepared the sample based on your requirement; please check the sample for this in the following location

Sample: http://www.syncfusion.com/uploads/redirect.aspx?&team=support&file=GDC_Excel_OleDbConnection369360711.zip

Note: Already we have provided this information in the incident 78560 itself,for a record we give this information here.

Please let us know if you need more information.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

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