Sample for Datatable with dynamic columns. Join the table to another table with editor

Sample for Datatable with dynamic columns. Join the table to another table with editor

ShipraShipra Posts: 7Questions: 2Answers: 1

Hi ,

I need to implement Datatable with dynamic columns. The table will join to another editable table.
Please let me know if there is any sample/ tutorial for the same.

Thanks,
Shipra

Answers

  • allanallan Posts: 63,471Questions: 1Answers: 10,467 Site admin

    I'm not sure what you mean by dynamic columns. Could you clarify that please?

    Allan

  • ShipraShipra Posts: 7Questions: 2Answers: 1

    I need to have a DataTable for a SQL table. Columns added to the SQL table should be reflected automatically. This Table is joined to a second table by a Id. The Second table columns are editable.

  • allanallan Posts: 63,471Questions: 1Answers: 10,467 Site admin

    Thanks for the clarification. That isn't something that DataTables or Editor will do automatically, but it is perfectly possible to implement with the APIs. You just need to use SHOW COLUMNS (or similar) to get the columns from the database and then built the Editor instance based on that information.

    Allan

  • ShipraShipra Posts: 7Questions: 2Answers: 1

    Thanks, I will try that

This discussion has been closed.