Hi
I'm baffled.
I have the following in a codebehind page:
------------------------------------------------------
' Get Connection info from web.config
strConn = ConfigurationSettings.AppSettings("ConnectionString")
sqlConn = New SqlConnection(strConn)
' Connect to XYZDatabase
sqlConn.Open()
' Execute stored proc return reports (if any)
Try
sqlCmd = New SqlCommand("spName", sqlConn)
sqlCmd.CommandType = CommandType.StoredProcedure
rpViewReports.DataSource = sqlCmd.ExecuteReader()
rpViewReports.DataBind()
--------------------------------
I then have a Repeater (also tried a DataList) that looks like this
---------------------------------
<asp:Repeater id="rpViewReports" runat="server">
<HeaderTemplate>
<tr>
<td>
</td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td><div align="center">
<a href='pageName.aspx?id=<%# DataBinder.Eval, Container.DataItem, "Item1") %>'>
<%#DataBinder.Eval(Container.DataItem, "Item2") %>
Report No.
<%#DataBinder.Eval(Container.DataItem, "Item3") %>
</a>
<br>
<asp:button id="Button1" value='<%#DataBinder.Eval(Container.DataItem, "Item1") %>' runat="server" Text="Reject">
</asp:button>
<asp:button id="Button2" value='<%#DataBinder.Eval(Container.DataItem, "Item1") %>' runat="server" Text="Assess">
</asp:button>
<asp:button id="Button3" value='<%#DataBinder.Eval(Container.DataItem, "Item1") %>' runat="server" Text="Edit Assessment">
</asp:button></div>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
<tr>
<td>
</td>
</tr>
</FooterTemplate>
</asp:Repeater>
--------------------------------
No matter what I use, I just don't get any info back whatesoever...
I have checked the SP and yes, it does return daat.
Any ideas ?
Thanks
ING
I'm baffled.
I have the following in a codebehind page:
------------------------------------------------------
' Get Connection info from web.config
strConn = ConfigurationSettings.AppSettings("ConnectionString")
sqlConn = New SqlConnection(strConn)
' Connect to XYZDatabase
sqlConn.Open()
' Execute stored proc return reports (if any)
Try
sqlCmd = New SqlCommand("spName", sqlConn)
sqlCmd.CommandType = CommandType.StoredProcedure
rpViewReports.DataSource = sqlCmd.ExecuteReader()
rpViewReports.DataBind()
--------------------------------
I then have a Repeater (also tried a DataList) that looks like this
---------------------------------
<asp:Repeater id="rpViewReports" runat="server">
<HeaderTemplate>
<tr>
<td>
</td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td><div align="center">
<a href='pageName.aspx?id=<%# DataBinder.Eval, Container.DataItem, "Item1") %>'>
<%#DataBinder.Eval(Container.DataItem, "Item2") %>
Report No.
<%#DataBinder.Eval(Container.DataItem, "Item3") %>
</a>
<br>
<asp:button id="Button1" value='<%#DataBinder.Eval(Container.DataItem, "Item1") %>' runat="server" Text="Reject">
</asp:button>
<asp:button id="Button2" value='<%#DataBinder.Eval(Container.DataItem, "Item1") %>' runat="server" Text="Assess">
</asp:button>
<asp:button id="Button3" value='<%#DataBinder.Eval(Container.DataItem, "Item1") %>' runat="server" Text="Edit Assessment">
</asp:button></div>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
<tr>
<td>
</td>
</tr>
</FooterTemplate>
</asp:Repeater>
--------------------------------
No matter what I use, I just don't get any info back whatesoever...
I have checked the SP and yes, it does return daat.
Any ideas ?
Thanks
ING