I have been reviewing the APOSE Grid product for a week now and in theory ( according to feature list ) should provide the solution we require. From the online examples, documentation and Forum questions I have been unable to resolve the following application of the GRID web control.
[1] Figure out the format for storing Formula’s in SQL Server 2005 and or how to effectively insert them into the actual grid control other than manually with test data which is provided in the examples ( I am hoping that this will occur when binding and storing is successful ?? )
[2] I have a normalised DB which separates the Columns and Rows into two tables, thus allowing me to store many worksheet templates and responses / data. From the examples it is easy to bind a basic sheet from a single table though in real world applications this is not likely to be the case. Can you point to appropriate documentation that explains how to combine queries / stored procedures to data binding with APOSE Grid ?
1. Can you tell me the details about the formulas stored in SQL Server? In normal databinding, the grid only get value from the dataset, and it will not convert them to formulas. If you want to use formulas, you may add some none-bound columns to the sheet.
2. Essentially the databinding gets data or updates data with a DataSet or DataTable object. So it is not related to the database. You just write SQL or SP, get the record set from the query, and fill the data to the DataSet. Then bind the dataset to the grid. After the grid has updated the dataset, use a DataAdaptor to save the dataset's change to the database.
For the detailed information about databinding, you may read the online document: