Using a datafield value as a function argument

Dave · Dec 1, 2004

I'm one baffled newbie. I know this is trivial, but I can't figure it out.

Using inline aspx code, I have a function called dbIntegerToString(i as
Integer, s as String) as String

Down in the html code, I have a datagrid, a stub of which follows:

<asp:TemplateColumn>
<ItemTemplate>
<%# Container.DataItem("Lessons") %>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText = "Recommendation">
<ItemTemplate>
<%# Container.DataItem("Recommendation") %>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText = "DOT">
<ItemTemplate>
<%= dbIntegerToString(3, "Category") %>
</ItemTemplate>
</asp:TemplateColumn>

All this works fine.

But my issue is in the last ItemTemplate. What I want to do, instead of
passing '3', is to pass a data value I read in when all the other data
values were read (in another vb procedure). The field is called "DOT", and
is in the same SELECT statement as the other fields you see.

Replacing '3' with 'Container.DataItem("DOT")' doesn't work (Compiler Error
Message: BC30451: Name 'Container' is not declared.), and other feeble
attempts also result in errors.

Is there anybody out there that can set me straight on this?

Thanks in advance,

Dave

Ken Cox [Microsoft MVP] · Dec 2, 2004

Hi Dave,

It may just be a syntax issue. I took your code and played with it. The code
below *seems* to do something like what you might need.

Let us know if this helps?

Ken
Microsoft MVP [ASP.NET]
Toronto

<%@ Page Language="vb" AutoEventWireup="true" %>
<%@ Import Namespace="System.Data" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>dgcontainer</title>
<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" content="Visual Basic .NET 7.1">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema"
content="http://schemas.microsoft.com/intellisense/ie5">
<script language="visualbasic" runat="server">
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
If Not IsPostBack Then
DataGrid1.DataSource = CreateDataSource()
DataGrid1.DataBind()
End If
End Sub
Function dbIntegerToString(ByVal i As Integer, ByVal s As String) As
String
Return "Test" & i.ToString
End Function
Function CreateDataSource() As system.data.DataTable
Dim dt As New DataTable
Dim dr As DataRow
dt.Columns.Add(New DataColumn _
("Lessons", GetType(Int32)))
dt.Columns.Add(New DataColumn _
("Recommendation", GetType(String)))
dt.Columns.Add(New DataColumn _
("Category", GetType(Double)))
dt.Columns.Add(New DataColumn _
("DOT", GetType(Boolean)))
Dim i As Integer
For i = 0 To 8
dr = dt.NewRow()
dr(0) = i
dr(1) = "Item " + i.ToString()
dr(2) = 1.23 * (i + 1)
dr(3) = (i = 4)
dt.Rows.Add(dr)
Next i
Return dt
End Function 'CreateDataSource
</script>
</head>
<body MS_POSITIONING="FlowLayout">
<form id="Form1" method="post" runat="server">
<asp:datagrid id="DataGrid1" runat="server"
AutoGenerateColumns="False">
<columns>
<asp:templatecolumn>
<itemtemplate>
<%# Container.DataItem("Lessons") %>
</itemtemplate>
</asp:templatecolumn>
<asp:templatecolumn HeaderText="Recommendation">
<itemtemplate>
<%# Container.DataItem("Recommendation") %>
</itemtemplate>
</asp:templatecolumn>
<asp:templatecolumn HeaderText="DOT">
<itemtemplate>
<%#
dbIntegerToString(Container.DataItem("Lessons"),Container.DataItem("Category")
) %>
</itemtemplate>
</asp:templatecolumn>
</columns>
</asp:datagrid>
</form>
</body>
</html>

Dave · Dec 2, 2004

Ken,

Beeyootiful. Just changing
'<%=dbIntegerToString(Container.DataItem("DOT")...' to
'<%#dbIntegerToString(Container.DataItem("DOT")...' fixed it.

If I may explore this a little bit, what does the '#' signify? I read in a
tutorial somewhere that you use a '=' when calling a function. And I just
inferred that the '#' referred to a database value. Perhaps I'm reading the
wrong tutorials?

Dave

Ken Cox said:
Hi Dave,

It may just be a syntax issue. I took your code and played with it. The code
below *seems* to do something like what you might need.

Let us know if this helps?

Ken
Microsoft MVP [ASP.NET]
Toronto
[snip]

<itemtemplate>
<%#

Click to expand...

dbIntegerToString(Container.DataItem("Lessons"),Container.DataItem("Category
")
) %>
</itemtemplate>
</asp:templatecolumn>
</columns>
</asp:datagrid>
</form>
</body>
</html>

Dave said:

I'm one baffled newbie. I know this is trivial, but I can't figure it out.

Click to expand...

[snip]

How do I output a function with a parameter argument?	6	Dec 18, 2022
ItemTemplate Problem	0	Jul 7, 2012
How to print prefix and suffix without giving a String as an argument between them	2	May 9, 2022
Value error: Argument Z must be 2-dimensional	0	May 7, 2022
Char array as a function returned value	2	Nov 23, 2019
Problem with editing datagrid <EditItemTemplate>	1	Mar 24, 2006
Databinder.Eval passed as argument is choking	3	Oct 10, 2005
NEED HELP please! retrieving checked items to a textbox	0	Jun 22, 2004

Using a datafield value as a function argument

Dave

Ken Cox [Microsoft MVP]

Dave

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads