Mapping Custom Data in Gridview

[jayesch]

I am using data sets in my project to fetch data from Access database and I bind these dataset APIs to gridview. My problem is - I have certain boolean data and numerical data that I need to map it to user presentable text. For e.g. say if I use gender as boolean data then 1(True) - should be displayed as "male" and 0 (false) should be displayed as "female". The other example is say I wish to store name of fruits as numbers in my database to save some memory. Then 0 - should be displayed as - Apple, 1 as - Oranges, 2 - Peach etc. For this I defined a hash table which would contain a mapping of the numerical values to the presentable text. Now I am not sure how to present values from hash table to the web page in grid view.

Thanks in advance
Jayesh

[jhardman]

Jayesh,

I am moving this question to the .NET forum, since this is a .NET question. In ASP classic I would either link this data to a second db table like this:

query = "SELECT * FROM users, genders WHERE users.genderNum = genders.genderNum"
 
rs.open query, conn
 
response.write rs("genders.genderName")

or I would populate an array with the possible choices like this:

dim fruits(6)
 
fruits(0) = "banana"
fruits(1) = "apple"
'etc
 
response.write fruits(rs("fruitNum"))

Let me know if this helps.

Jared

[mzmishra]

You can do like this
1.Create a DataTable like DataTable table = dataset.Tables[0]
2. add one more column to datatable which will containg the value from your HashTable.
3.you can add the values from Hashtable to this column
4.Make this table your grid datasource