Set length of container

[marcus.lecount]

Hi to anyone out there that is taking the time to read this. I'm new to
..net and any help given is appreciated.

I am displaying a datalist on a page and I want to limit the length of
the returned container.datai tem that is displayed to 39 characters. How
do i do this in asp.net? I can do this in classic asp by using the
len() function, but i'm a bit stuck on how to do it in asp.net.

Thanks for any help you can give, my code is below.

=============== =============== ==========
'code behind creating list

Dim SQLdata As String
Dim dDS As New DataSet()
SQLdata = "SELECT id, pagedata FROM tblContent WHERE level6 =
'" & sLev6 & "'"
sConn = "Provider=Micro soft.jet.OLEDB. 4.0; Data Source=" &
dbPath & ";"

Dim myConnd As New OleDbConnection (sConn)
Dim myAdapterd As New OleDbDataAdapte r(SQLdata, myConnd)
myConnd.Open()

Try
myAdapterd.Fill (dDS)
DLdata.DataSour ce = dDS.Tables(0).D efaultView
DLdata.DataBind ()
Finally
myConnd.Close()
End Try

=============== =============== ==========
'code on aspx page displaying list

<asp:DataList ID="DLdata" runat="server" cssclass="DLdat agrid">
<ItemStyle CssClass="DLdat a" />
<ItemTemplate >
<img src="images/arrow.jpg" alt=""/>&nbsp;<a
href='pagedata. aspx?id=<%#Data Binder.Eval(Con tainer.DataItem ,
"id")%>'><%#Dat aBinder.Eval(Co ntainer.DataIte m, "pagedata") %></a>

</ItemTemplate>
</asp:DataList>

[Karl Seguin [MVP]]

the easiest way to do it is:

<%# left(DataBinder .Eval(Container .DataItem, "pagedata") , 39)%>

Karl

--
http://www.openmymind.net/

<ma************ @googlemail.com > wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .

Hi to anyone out there that is taking the time to read this. I'm new to
.net and any help given is appreciated.

I am displaying a datalist on a page and I want to limit the length of
the returned container.datai tem that is displayed to 39 characters. How
do i do this in asp.net? I can do this in classic asp by using the
len() function, but i'm a bit stuck on how to do it in asp.net.

Thanks for any help you can give, my code is below.

=============== =============== ==========
'code behind creating list

Dim SQLdata As String
Dim dDS As New DataSet()
SQLdata = "SELECT id, pagedata FROM tblContent WHERE level6 =
'" & sLev6 & "'"
sConn = "Provider=Micro soft.jet.OLEDB. 4.0; Data Source=" &
dbPath & ";"

Dim myConnd As New OleDbConnection (sConn)
Dim myAdapterd As New OleDbDataAdapte r(SQLdata, myConnd)
myConnd.Open()

Try
myAdapterd.Fill (dDS)
DLdata.DataSour ce = dDS.Tables(0).D efaultView
DLdata.DataBind ()
Finally
myConnd.Close()
End Try

=============== =============== ==========
'code on aspx page displaying list

<asp:DataList ID="DLdata" runat="server" cssclass="DLdat agrid">
<ItemStyle CssClass="DLdat a" />
<ItemTemplate >
<img src="images/arrow.jpg" alt=""/>&nbsp;<a
href='pagedata. aspx?id=<%#Data Binder.Eval(Con tainer.DataItem ,
"id")%>'><%#Dat aBinder.Eval(Co ntainer.DataIte m, "pagedata") %></a>

</ItemTemplate>
</asp:DataList>

[marcus.lecount]

Thanks Karl, I can't believe i missed that. Why do i always miss the
obvious???
Thanks for taking the time to answer, I appreciate your help.
Karl Seguin [MVP] wrote:

the easiest way to do it is:

<%# left(DataBinder .Eval(Container .DataItem, "pagedata") , 39)%>

Karl

--
http://www.openmymind.net/

<ma************ @googlemail.com > wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .

Hi to anyone out there that is taking the time to read this. I'm new to
.net and any help given is appreciated.

I am displaying a datalist on a page and I want to limit the length of
the returned container.datai tem that is displayed to 39 characters. How
do i do this in asp.net? I can do this in classic asp by using the
len() function, but i'm a bit stuck on how to do it in asp.net.

Thanks for any help you can give, my code is below.

=============== =============== ==========
'code behind creating list

Dim SQLdata As String
Dim dDS As New DataSet()
SQLdata = "SELECT id, pagedata FROM tblContent WHERE level6 =
'" & sLev6 & "'"
sConn = "Provider=Micro soft.jet.OLEDB. 4.0; Data Source=" &
dbPath & ";"

Dim myConnd As New OleDbConnection (sConn)
Dim myAdapterd As New OleDbDataAdapte r(SQLdata, myConnd)
myConnd.Open()

Try
myAdapterd.Fill (dDS)
DLdata.DataSour ce = dDS.Tables(0).D efaultView
DLdata.DataBind ()
Finally
myConnd.Close()
End Try

=============== =============== ==========
'code on aspx page displaying list

<asp:DataList ID="DLdata" runat="server" cssclass="DLdat agrid">
<ItemStyle CssClass="DLdat a" />
<ItemTemplate >
<img src="images/arrow.jpg" alt=""/>&nbsp;<a
href='pagedata. aspx?id=<%#Data Binder.Eval(Con tainer.DataItem ,
"id")%>'><%#Dat aBinder.Eval(Co ntainer.DataIte m, "pagedata") %></a>

</ItemTemplate>
</asp:DataList>