
March 27th, 2003, 09:20 PM
|
|
Registered User
|
|
Join Date: Mar 2003
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Input string was not in a correct format.
Im trying to bind data to a repeater control. Its a press room type of application where each headline, and story will be displayed on the page. Here's what I have in the html:<br><br><div class="msgQuoteWrap"><div class="msgCode"><br><asp:Repeater id="storiesRepeater" runat="server"><br> <HeaderTemplate><br> <table><br> </HeaderTemplate><br><ItemTemplate><br> <tr><br> <td><%#storiesRepeater.Items("strTimeStamp").ToString%><br></td><br> </tr><br> <tr><br> <td><hr noshade></td><br> </tr><br> <tr><br> <td><%#storiesRepeater.Items("strHeadline").ToString%><br></td><br> </tr><br> <tr><br> <td><%#storiesRepeater.Items("strStoryText").ToString%></td><br> </tr><br></ItemTemplate><br> <FooterTemplate><br> </table><br> </FooterTemplate> <br></asp:Repeater><br></div></div><br>This is what I have in my code-behind:<br><br><div class="msgQuoteWrap"><div class="msgCode"><br>Dim dbConn As String = ConfigurationSettings.AppSettings("dbConn")<br>Dim sqlConn As New SqlConnection(dbConn)<br>Dim bolError As Boolean = False<br><br> Try<br> sqlConn.Open()<br> Catch connError As Exception<br> bolError = True<br> lblDBError.Visible = True<br> End Try<br><br> If bolError = False Then<br><br> Dim cmdGetStories As New SqlCommand("getStories", sqlConn)<br><br> With cmdGetStories<br> .CommandType = CommandType.StoredProcedure<br> End With<br><br> Dim drGetStories As SqlDataReader = cmdGetStories.ExecuteReader() <br> storiesRepeater.DataSource = drGetStories<br> storiesRepeater.DataBind()<br> <br> Dim strTimeStamp = drGetStories(CStr("time_stamp"))<br> Dim strHeadline = drGetStories(CStr("story_title"))<br> Dim strStoryText = drGetStories(CStr("story_text"))<br><br> drGetStories.Close()<br> sqlConn.Close() <br></div></div><br><br>When I build and browse I get this error:<br><br>Input string was not in a correct format. <br><br><div class="msgQuoteWrap"><div class="msgCode"><tr><br> <td><%#storiesRepeater.Items("strTimeStamp").ToString%><br></td><br> </tr></div></div><br><br>Any input would be appreciated. Thanks -E
|