Hi,
I'm currently converting a big range of old MS Access databases based on SQL 97 to a web based interface. As upgrading/changing the SQL 97 server is out of the question, Linq (as well as entity framework etc) seems to be out of the question (unless you know any way to get this working?).
As we will need a large range of reuse, like simple editable tables, we wanted to make generic configurable controls. However it seems to me that the editable columns are a bit tedious and error prone to parse.
As for parsing the values of the editable column, the best (and only) example I found in your demos was this : http://demos.telerik.com/aspnet-ajax/grid/examples/dataediting/editmodes/defaultcs.aspx
What I ideally would have wished for, was an easy way to access SQL rowtype, rowname and the new and old values as objects, such that I could easily insert everything chosen as old and new values in parametrized SQL, and leave the rest up to the SQL server.
However, it doesnt seem that I can find the SQL datatype, and parsing and ensuring no failure for all possible datatypes, will end up prooving quite tedious for a generic web control.
Do you have any experience, guides or ideas on how to best create generic dataupdating without the use of Linq?
I'm currently converting a big range of old MS Access databases based on SQL 97 to a web based interface. As upgrading/changing the SQL 97 server is out of the question, Linq (as well as entity framework etc) seems to be out of the question (unless you know any way to get this working?).
As we will need a large range of reuse, like simple editable tables, we wanted to make generic configurable controls. However it seems to me that the editable columns are a bit tedious and error prone to parse.
As for parsing the values of the editable column, the best (and only) example I found in your demos was this : http://demos.telerik.com/aspnet-ajax/grid/examples/dataediting/editmodes/defaultcs.aspx
What I ideally would have wished for, was an easy way to access SQL rowtype, rowname and the new and old values as objects, such that I could easily insert everything chosen as old and new values in parametrized SQL, and leave the rest up to the SQL server.
However, it doesnt seem that I can find the SQL datatype, and parsing and ensuring no failure for all possible datatypes, will end up prooving quite tedious for a generic web control.
Do you have any experience, guides or ideas on how to best create generic dataupdating without the use of Linq?
1 Answer, 1 is accepted
0
Morten
Top achievements
Rank 1
Rank 1
answered on 30 Aug 2011, 03:51 PM
I've solved this fairly well by extension of the example in http://demos.telerik.com/aspnet-ajax/grid/examples/dataediting/extractvalues/defaultcs.aspx - I no longer have need of help on this issue.