Datalist does not display data
I am trying to display data from a database using a datalist. I don't get and error messages. The data just does not get displayed. Could you tell me what's wrong with my code?
---------------------------------------------------------------------------------------
This is my data connection:
<Script runat="server">
Sub Page_Load
'Establish Connection
Dim myDS As New DataSet()
Dim myConnection As New SqlConnection
Dim SQLServer As String = "server=localhost;database=AIA;Trusted_Connection= yes"
Dim DataConn as SQLConnection
Dim dbCommand As SQLCommand
DataConn = new SQLConnection(SQLServer)
'Call store procedure to poulate datalist
Dim mySqlDA As New SqlDataAdapter("sp_DisplayCommiteeInfornation",Dat aConn)
mySqlDA.Fill(myDS)
CommiteeList.DataSource = myDS
CommiteeList.Databind()
End Sub
</Script>
-----------------------------------------------------------------------------
This is the datalis displaying the data:
<asp:datalist ID="CommiteeList" RepeatColumns="3"
gridlines="Both" CellPadding="5" Runat="server">
<ItemTemplate>
<b>Title</b>
<%# DataBinder.Eval(Container.DataItem, "Title")%>
<br>
<b>Name</b>
<%# DataBinder.Eval(Container.DataItem, "Name")%>
<br>
<b>Email</b>
<%# DataBinder.Eval(Container.DataItem, "Email")%>
<br>
<b>Phone</b>
<%# DataBinder.Eval(Container.DataItem, "Phone")%>
</ItemTemplate>
</asp:datalist>
Sanjeet
__________________
Sanjeet
|