We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to bind SQL table data to dropdown column?

Platform: ASP.NET MVC |
Control: Grid |
Published Date: March 29, 2017 |
Last Revised Date: March 29, 2017

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.

 

Solution

 

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.

 

Razor

 

 

Controller

 

 

Aspx

 

 

C#

 

 

 

Result

 

The following screenshot shows the Dialog EditMode with SQL Table bound to dropdown column.

 

Figure: SQL Table bound to dropdown column.

 

ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon