search

ErikEJ / SqlCeToolbox

SQLite & SQL Server Compact Toolbox extension for Visual Studio, SSMS (and stand alone)
Other
838 stars 175 forks source link

Enhance SQL CE DDEX provider(s) to support Data Source Configuration Wizard #39

Closed hydrowin closed 7 years ago

hydrowin commented 8 years ago

When creating a report from scratch and I'm using C# by the way. It either gets stuck by the add connection form or it allows me to use the connection but gives an error on the part were you select which table or view to use. Am I just using it wrong or is there another area specifically for SqlCe reports? image image

ErikEJ commented 8 years ago

The DDEX provider I supply is "simple" (as is stated in the name) - so it does not support the "Data Source Configuration Wizard" - but I leave this open to consider extending its functionality.

hydrowin commented 8 years ago

Ok sounds good, thanks Erick. Would I be the first to bring up this problem with the data source wizard? Was there a suggested work around in the meantime and this is actually my first time using GitHub so is it possible to help establish a working data source?

ErikEJ commented 8 years ago

The suggested workaround is to create a DataSet in code, and bind that to the report.

ErikEJ commented 8 years ago

Have decided not to do this, but have changed the description of the DDEX providers to clarify missing support for Data Source Config Wiz

ErikEJ commented 7 years ago

How to solve this in code: https://blogs.msdn.microsoft.com/sqlforum/2011/04/27/walkthrough-assign-dataset-dynamically-created-in-code-to-your-local-report-with-reportviewer/