How can I alter the datatype of the data quiry from a database and store it into a gridview?

khoaha · Oct 5, 2006

Thank you in advance.
This is my problem.
Assume I have a select statement SELECT Name, Gender FROM 'Database'
Name is a (varchar) and Gender is an (int)
The Gender column stored value of '1' and '0'
Now when I use the select statement to bind the value to the gridview
I wanted it to store "Male" for '1' and "Female" for '0'

Database This should be what to be store in the
gridview
abc 1 abc Male
def 0 def Female

I have tried to use the CASE statement in the select query to alter the
data. However I can only alter it to the same type 1->100 (int to int)
but cannot
alter it to a different type 1->Male (int to varchar)

Does anybody know if there is a why to do this? Alter the value type as
well as the value.

Thanks

Ken Cox [Microsoft MVP] · Oct 6, 2006

Hi,

If you're only concerned about the display, you can insert a function into
the GridView to handle that. In this case, I'd use an IIF() as a helper
function:

<asp:label id="Label1" runat="server" text='<%#
iif(Eval("Gender"),"Male","Female") %>'></asp:label>

See the full code below.

Let us know if this helps?

Ken
Microsoft MVP [ASP.NET]

<%@ Page Language="VB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

Function CreateDataSource() As Data.DataTable
Dim dt As New Data.DataTable
Dim dr As Data.DataRow
dt.Columns.Add(New Data.DataColumn _
("Gender", GetType(Int32)))
dt.Columns.Add(New Data.DataColumn _
("Name", GetType(String)))
Dim i As Integer
For i = 0 To 5
dr = dt.NewRow()
dr(0) = i
dr(1) = "Item " + i.ToString()
dt.Rows.Add(dr)
Next i
Return dt
End Function

Protected Sub Page_Load _
(ByVal sender As Object, _
ByVal e As System.EventArgs)
If Not IsPostBack Then
GridView1.DataSource = CreateDataSource()
GridView1.DataBind()
End If
End Sub
</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Gridview Helper function</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:gridview id="GridView1" runat="server"
autogeneratecolumns="False">
<columns>
<asp:templatefield headertext="Name" sortexpression="Name">
<itemtemplate>
<asp:label id="Label2" runat="server" text='<%#
Bind("Name") %>'></asp:label>
</itemtemplate>
</asp:templatefield>
<asp:templatefield headertext="Gender"
sortexpression="Gender">
<itemtemplate>
<asp:label id="Label1" runat="server" text='<%#
iif(Eval("Gender"),"Male","Female") %>'></asp:label>
</itemtemplate>
</asp:templatefield>
</columns>
</asp:gridview>

</div>
</form>
</body>
</html>

How to store data from a sign up form on a website into an sql databse	1	Sep 9, 2022
How to create a JSON array with values from DOM(HTML TABLE) when I click a button using JQuery/Javascript?	0	May 1, 2023
How to create a JSON array with values from DOM(HTML TABLE) when I click a button using JQuery/Javascript?	0	May 1, 2023
How can I calculate the last payment of the year to be the sum of all previous payments for that year and subtracting it from Research Costs value?	7	Aug 22, 2023
"input-group-text" help	7	Aug 10, 2023
Hey can anyone tell me why input data wont save in my database?	0	Jun 16, 2024
Accessing array index addresses with custom datatype in a function	0	Jun 2, 2022
How can I find occurrences of a column name FPPaymentID in the entire database (e.g table, stored procedure etc) in SSMS?	2	Jun 20, 2023

How can I alter the datatype of the data quiry from a database and store it into a gridview?

khoaha

Ken Cox [Microsoft MVP]

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads