This is a migrated thread and some comments may be shown as answers.

RadGrid displays integers instead of text for column values

2 Answers 33 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Alex
Top achievements
Rank 1
Alex asked on 11 Mar 2013, 05:37 PM
I am using a Ajax RadGrid to display contents, however, I want to have text show up in some columns instead of numbers. I have attached a screenshot of my grid. I may have setup my database wrong, so I'd like some help trying to correct this, please. I have a primary table called "kb" which holds the values inserted from a web form. I have about a dozen AccessDataSource tags with different select statements: one for each control on the form. So if I have a drop-down called "kbcategory" I also have an AccessDataSource which is pulling from a table called "category" for all the values. So my category table would have several rows with data like (apples, bananas, pears, etc.). My insert statement to put my form data into my "kb" table pulls the "id" values from the drop-downs in the form and enters their numeric values. So all my drop-downs in my "kb" table have number listed in them. I created a pk/fk relationship between my primary table "kb" and all the other tables.

So, now I want to display my data in a grid, but I don't want to show the numeric values of the drop-down columns. I want their respective textual values: like apples or bananas. As you can see from my screenshot I am only showing numbers in the columns named "kbcategory" and "kbsubcatid".

How can I get these columns to show text instead of numbers?

Thanks in advance.

2 Answers, 1 is accepted

Sort by
0
Alex
Top achievements
Rank 1
answered on 12 Mar 2013, 09:58 PM
See this post http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28060203.html#a38975734 for a solution.
0
Mitch
Top achievements
Rank 1
answered on 13 Nov 2014, 06:25 PM
Man. Links are unreliable enough as answers, but a link to experts exchange? I'm looking more closely at the question but I'm really not seeing where he's asking how to make a terrible website
Tags
Grid
Asked by
Alex
Top achievements
Rank 1
Answers by
Alex
Top achievements
Rank 1
Mitch
Top achievements
Rank 1
Share this question
or