Editable dynamic table in ASP.net MVC
I could implement an editable table with knowledge of the number of columns, for example in: How to edit a table in ASP.net?
In my case, we have over 100 tables and I am looking for a one-stop solution. Where we can pass any table name and the Web should display the database in tabular format. Some things like edit in sqlserver edit data rows.
I came across datatable , jqgrid, web grid , but they only support tables where we have the column names before they are manually passed. In my case, columns and tables will only be defined during runtime.
source to share
JQGrid you need to specify the column names, but they are not fixed. This means you can define the column names at runtime and generate the column according to the column name you give.
In this case, you can do two things: either you specify the column model, and the column names on the server, and push it as a string or json array. Or build client side based on the data you receive.
I use the first option to do almost the same thing. Please let me know if more information is required. The same is true for any library available out there.
source to share