newbie to asp.net and problem with tutorial code

bcomtr · Apr 28, 2012

I've gone through the tutorial about paging records on the asp.net portion of this site. It displays records fine, but when I click on the next link, it gives me a javascript error saying "Object expected". Because I'm so new to .net, I don't know what to make of this. Does anyone see a problem with my code? I've copied most of it directly from the tutorial aside from my connection string and query. Thanks. <% @Import Namespace="System.Data"%> <% @Import Namespace="System.Data.SqlClient"%> <script language="vb" runat="server"> sub page_load(sender as Object, e as EventArgs) if not Page.IsPostBack then BindData() end if end sub sub BindData() '1. create a connection Dim myConnection as new SqlConnection(connStr) '2.Create command object, passing in sql string Const strSQL as String = "select carYear, Manufacturer, Model from Cars order by carYear" dim myCommand as New SqlCommand(strSQL, myConnection) '3. create the dataadapter Dim myDA as New SqlDataAdapter() myDA.SelectCommand = myCommand '4. populate the dataset Dim myDS as new DataSet() myDA.Fill(myDS) '5.set the datagrid's datasource to the dataset and databind dgPopularFAQs.DataSource = myDS dgPopularFAQs.DataBind() end sub sub dgPopularFAQs_Paged(sender as Object, e as DataGridPageChangedEventArgs) dgPopularFAQs.CurrentPageIndex = e.NewPageIndex BindData() end sub </script> <html> <body> <asp:datagrid id="dgPopularFAQs" runat="server" borderwidth="0" Cellpadding="2" width="100%" font-name="verdana" font-size="smaller" headerStyle-HorizontalAlign="Center" headerStyle-Font-Bold="True" headerStyle-BackColor="Navy" headerStyle-ForeColor="White" AlternatingItemStyle-BackColor="#dddddd" AllowPaging="True" PageSize="15" OnPageIndexChanged="dgPopularFAQs_Paged"> <PagerStyle Mode="NextPrev" NextPageText="Next" PrevPageText="Previous" Position="Bottom"> </PagerStyle> </asp:datagrid> </body> </html>Your datagrid needs to be in a server side form. <form runat="server"> </form>

newbie to asp.net and problem with tutorial code

bcomtr

New Member