How to bind data in datalist

J

Jay Villa

I have a aspx webform which has executes a query
"Select * from userslist"

I have a datalist for which i have to bind this query
Dim oDataAdapter As OracleDataAdapter = New OracleDataAdapter(sSQL,
ClientConnection)

Dim ds As New DataSet

oDataAdapter.Fill(ds, "LoginInformation")

dataListQueue.DataSource = ds '.Tables("LoginInformation").DefaultView

dataListQueue.DataBind()

In the item template I've
<b>Model Number: </b> <%# DataBinder.Eval(Container.DataItem, "lastname")%>

But I dont see anything on the form ....

Any help ....

-Jay
 
D

Daniel Walzenbach

Jay,

can you verify that "Select * from userslist" returns any rows?

when get's your code executed?

Regards

Daniel Walzenbach
 
D

Daniel Walzenbach

Jay,

when get's your code executed? Did you place it in any eventhandler or how
is the structure of your application?

Regards

Daniel Walzenbach
 
J

Jay Villa

I am doing in page_load of a webform ....

It is so funny it is printing
<b>Model Number: </b> <%# DataBinder.Eval(Container.DataItem, "lastname")%>
8 times which is equal to number of records
 
S

Steven Cheng[MSFT]

Hi Jay,

If the ASP.NET page output directly display the databinding expression like:

<b>Model Number: </b> <%# DataBinder.Eval(Container.DataItem, "lastname")%>

I think the problem maybe caused by the datalist's aspx template, would you
provide the complete template in aspx page of the datalist to us? Also, you
can try binding with some other datasource to verify that the problem is
with the datalist's template. If there're any other finding, or anything
unclear, please feel free to post here.

Thanks & Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
--------------------
| From: "Jay Villa" <[email protected]>
| References: <[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
| Subject: Re: How to bind data in datalist
| Date: Sun, 4 Sep 2005 19:32:48 -0400
| Lines: 73
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Response
| Message-ID: <[email protected]>
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: adsl-68-250-49-156.dsl.bcvloh.ameritech.net
68.250.49.156
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.dotnet.framework.aspnet:122338
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| I am doing in page_load of a webform ....
|
| It is so funny it is printing
| <b>Model Number: </b> <%# DataBinder.Eval(Container.DataItem,
"lastname")%>
| 8 times which is equal to number of records
|
|
| | > Jay,
| >
| > when get's your code executed? Did you place it in any eventhandler or
how
| > is the structure of your application?
| >
| > Regards
| >
| > Daniel Walzenbach
| >
| >
| > | >>i can see it has records .... in the dataset ...
| >>
| >>
message
| >> | >>> Jay,
| >>>
| >>> can you verify that "Select * from userslist" returns any rows?
| >>>
| >>> when get's your code executed?
| >>>
| >>> Regards
| >>>
| >>> Daniel Walzenbach
| >>>
| >>>
| >>> | >>>>I have a aspx webform which has executes a query
| >>>> "Select * from userslist"
| >>>>
| >>>> I have a datalist for which i have to bind this query
| >>>> Dim oDataAdapter As OracleDataAdapter = New OracleDataAdapter(sSQL,
| >>>> ClientConnection)
| >>>>
| >>>> Dim ds As New DataSet
| >>>>
| >>>> oDataAdapter.Fill(ds, "LoginInformation")
| >>>>
| >>>> dataListQueue.DataSource = ds
'.Tables("LoginInformation").DefaultView
| >>>>
| >>>> dataListQueue.DataBind()
| >>>>
| >>>> In the item template I've
| >>>> <b>Model Number: </b> <%# DataBinder.Eval(Container.DataItem,
| >>>> "lastname")%>
| >>>>
| >>>> But I dont see anything on the form ....
| >>>>
| >>>> Any help ....
| >>>>
| >>>> -Jay
| >>>>
| >>>>
| >>>
| >>>
| >>
| >>
| >
| >
|
|
|
 
J

Jay Villa

Here is the complete template in aspx page of datalist
<asp:datalist id="dataListQueue" style="Z-INDEX: 101; LEFT: 8px;
POSITION: absolute; TOP: 8px"
runat="server" RepeatColumns="1" BorderColor="Black"
GridLines="Both">
<HeaderTemplate>
Sheriff Queue
</HeaderTemplate>
<ItemTemplate><B>Model Number:</b><%# DataBinder.Eval
(Container.DataItem,"userid")%>
</ItemTemplate>
<FooterTemplate>
@Allegheny County(R)
</FooterTemplate>
</asp:datalist>
 
J

Jay Villa

Never mind .... I deleted the Datalist and created again .... it is working
fine .... Thanks for your help

-Jay
 
S

Steven Cheng[MSFT]

Well, glad that everything work well again.
If there're any further things we can help later, please always feel free
to post here.
Good Luck!

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
--------------------
| From: "Jay Villa" <[email protected]>
| References: <[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<#[email protected]>
| Subject: Re: How to bind data in datalist
| Date: Mon, 5 Sep 2005 12:28:21 -0400
| Lines: 161
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-RFC2646: Format=Flowed; Response
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| Message-ID: <[email protected]>
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: adsl-68-250-49-156.dsl.bcvloh.ameritech.net
68.250.49.156
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.dotnet.framework.aspnet:122469
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| Never mind .... I deleted the Datalist and created again .... it is
working
| fine .... Thanks for your help
|
| -Jay
|
| | > Here is the complete template in aspx page of datalist
| > <asp:datalist id="dataListQueue" style="Z-INDEX: 101; LEFT: 8px;
| > POSITION: absolute; TOP: 8px"
| > runat="server" RepeatColumns="1" BorderColor="Black"
| > GridLines="Both">
| > <HeaderTemplate>
| > Sheriff Queue
| > </HeaderTemplate>
| > <ItemTemplate><B>Model Number:</b><%# DataBinder.Eval
| > (Container.DataItem,"userid")%>
| > </ItemTemplate>
| > <FooterTemplate>
| > @Allegheny County(R)
| > </FooterTemplate>
| > </asp:datalist>
| >
| >
| >
| >
| > | >> Hi Jay,
| >>
| >> If the ASP.NET page output directly display the databinding expression
| >> like:
| >>
| >> <b>Model Number: </b> <%# DataBinder.Eval(Container.DataItem,
| >> "lastname")%>
| >>
| >> I think the problem maybe caused by the datalist's aspx template,
would
| >> you
| >> provide the complete template in aspx page of the datalist to us?
Also,
| >> you
| >> can try binding with some other datasource to verify that the problem
is
| >> with the datalist's template. If there're any other finding, or
anything
| >> unclear, please feel free to post here.
| >>
| >> Thanks & Regards,
| >>
| >> Steven Cheng
| >> Microsoft Online Support
| >>
| >> Get Secure! www.microsoft.com/security
| >> (This posting is provided "AS IS", with no warranties, and confers no
| >> rights.)
| >> --------------------
| >> | From: "Jay Villa" <[email protected]>
| >> | References: <[email protected]>
| >> <[email protected]>
| >> <[email protected]>
| >> <[email protected]>
| >> | Subject: Re: How to bind data in datalist
| >> | Date: Sun, 4 Sep 2005 19:32:48 -0400
| >> | Lines: 73
| >> | X-Priority: 3
| >> | X-MSMail-Priority: Normal
| >> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| >> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| >> | X-RFC2646: Format=Flowed; Response
| >> | Message-ID: <[email protected]>
| >> | Newsgroups: microsoft.public.dotnet.framework.aspnet
| >> | NNTP-Posting-Host: adsl-68-250-49-156.dsl.bcvloh.ameritech.net
| >> 68.250.49.156
| >> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
| >> | Xref: TK2MSFTNGXA01.phx.gbl
| >> microsoft.public.dotnet.framework.aspnet:122338
| >> | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
| >> |
| >> | I am doing in page_load of a webform ....
| >> |
| >> | It is so funny it is printing
| >> | <b>Model Number: </b> <%# DataBinder.Eval(Container.DataItem,
| >> "lastname")%>
| >> | 8 times which is equal to number of records
| >> |
| >> |
| >> message
| >> | | >> | > Jay,
| >> | >
| >> | > when get's your code executed? Did you place it in any
eventhandler
| >> or
| >> how
| >> | > is the structure of your application?
| >> | >
| >> | > Regards
| >> | >
| >> | > Daniel Walzenbach
| >> | >
| >> | >
| >> | > | >> | >>i can see it has records .... in the dataset ...
| >> | >>
| >> | >>
| >> message
| >> | >> | >> | >>> Jay,
| >> | >>>
| >> | >>> can you verify that "Select * from userslist" returns any rows?
| >> | >>>
| >> | >>> when get's your code executed?
| >> | >>>
| >> | >>> Regards
| >> | >>>
| >> | >>> Daniel Walzenbach
| >> | >>>
| >> | >>>
| >> | >>> | >> | >>>>I have a aspx webform which has executes a query
| >> | >>>> "Select * from userslist"
| >> | >>>>
| >> | >>>> I have a datalist for which i have to bind this query
| >> | >>>> Dim oDataAdapter As OracleDataAdapter = New
| >> OracleDataAdapter(sSQL,
| >> | >>>> ClientConnection)
| >> | >>>>
| >> | >>>> Dim ds As New DataSet
| >> | >>>>
| >> | >>>> oDataAdapter.Fill(ds, "LoginInformation")
| >> | >>>>
| >> | >>>> dataListQueue.DataSource = ds
| >> '.Tables("LoginInformation").DefaultView
| >> | >>>>
| >> | >>>> dataListQueue.DataBind()
| >> | >>>>
| >> | >>>> In the item template I've
| >> | >>>> <b>Model Number: </b> <%# DataBinder.Eval(Container.DataItem,
| >> | >>>> "lastname")%>
| >> | >>>>
| >> | >>>> But I dont see anything on the form ....
| >> | >>>>
| >> | >>>> Any help ....
| >> | >>>>
| >> | >>>> -Jay
| >> | >>>>
| >> | >>>>
| >> | >>>
| >> | >>>
| >> | >>
| >> | >>
| >> | >
| >> | >
| >> |
| >> |
| >> |
| >>
| >
| >
|
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,482
Members
44,901
Latest member
Noble71S45

Latest Threads

Top