How can I connect to SQL database?
I want to connect to my Microsoft SQL Server and use a particular table as the data source.
Is it possible to connect directly to the database from Flexmonster Pivot Table without going through a CSV-file.
If yes, is there a guide somewhere I can look at?
We have such request very often but answer is still the same – no, there is no such option. Why? Because our component is client-based. This means that there is no server-side part. And you must provide database credentials directly to the component. And, yes, everyone can see them. I think, it’s extremely unsecure.
I recommend you to look at this sample http://www.flexmonster.com/doc/connecting-to-relational-database-with-net/. It’s really easy to implement.