In some cases, there is a need for the user to bind SQL table data to a dropdown in the grid. But the column will accept only text/value pair as input.
We suggest to convert the SQL Table result to the list of text/value pair. Then this result is set to be assigned to the corresponding dropdown column.
The following screenshot shows the Dialog EditMode with SQL Table bound to dropdown column.
Figure: SQL Table bound to dropdown column.
|Article ID:||Published Date:||Last Revised Date:||Platform:||Control:|
|7617||03/29/2017||03/29/2017||ASP.NET Web Forms||Grid|