In my database I represent fruit as 1 for apples, 2 for oranges, 3 for pears in a database field as an int.
My problem is when I output this using my GridView on the page it shows "1,2,3" so on when I want it to be displaying the fruits the numbers represent.
What I want is it to go if (fruit==1) display "Apple" etc.
Can I do this within the .aspx page?
You can use a TemplateField containing a Label. The steps are shown below:
Implement event (C#) as follows:
protected void gvFruits_RowDataBound(object sender, GridViewRowEventArgs e) {
if (e.Row.RowType == DataControlRowType.DataRow)
{
Label lblFruit = e.Row.FindControl("lblFruit") as Label;
switch(value_from_database)
{
default:
case 1:
lblFruit.Text = "Apple";
case 2:
lblFruit.Text = "Orange";
// ...
}
}
}
To get current record associated with row, you can use e.Row.DataItem property. A nice discussion is shown here (citronas' answer)
The best thing to do in this scenario is to create a Enum type that will assign the numbers to Fruit Names.
enum Fruit
{
Apple=1, // Assigned integer value = 1 to apple
Guava=2,
Banana=3
};
public Fruit FruitName
{
get; // Auto implemented prop. of type Enum
set;
}
In this way , you can compare database integer values with fruit name
switch(value_from_database)
{
default:
case 1:
return Fruit.Apple;
case 2:
return Fruit.Guava;
// ... so-on
}
I would recommend that your database contain a Fruit Table with ID and Name columns and you get the values from the Database.
In the table put a field with the name of the fruit.
And the Sql Consult might look like this.
Select fruit_name from fruits where id = (1 or 2 or 3)
You can create a getter property in the clas that will decide what to show based on the value.. Something like this maybe:
public string FruitName
{
get
{
switch(someOtherField)
{
default:
case 1:
return "Apple";
case 2:
return "Orange";
// ...
}
}
}
Then you can use this property instead to show it to the user.
That is of course, if your question was just an example of a mismatch between the values in the database and the values you wanted to show to the user. If that's not the case and it was an actual example of your app, you should definitely put more work into your database table design, relations etc.
