RadGrid displays integers instead of text for column values

3 posts, 0 answers
  1. Alex
    Alex avatar
    23 posts
    Member since:
    Dec 2012

    Posted 11 Mar 2013 Link to this post

    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. Alex
    Alex avatar
    23 posts
    Member since:
    Dec 2012

    Posted 12 Mar 2013 Link to this post

    See this post http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28060203.html#a38975734 for a solution.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Mitch
    Mitch avatar
    9 posts
    Member since:
    Nov 2014

    Posted 13 Nov 2014 Link to this post

    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
Back to Top