[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Auto generated gridview paging index out of range

Posted on 2007-12-06
3
Medium Priority
?
1,790 Views
Last Modified: 2013-11-26
I have an auto generated gridview that requires paging (and it must be auto generated since my original sql is dynamic). I need to hide a column, which is successfully done, but when I include AllowPaging="True" in the gridview, I receive the error:

Specified argument was out of the range of valid values. Parameter name: index

I know it's because the gridview is reading the first page returned and can't the second page, but how do I go about fixing this? The snippit was done with Northwind.

Thanks
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
		<br />
		<asp:GridView ID="GridView1" OnRowDataBound="GridView1_RowDataBound" runat="server" 
		DataSourceID="SqlDataSource1" AllowPaging="True">
		</asp:GridView>
		
		<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
			SelectCommand="SELECT [ProductID], [ProductName] FROM [Alphabetical list of products] ORDER BY [ProductName]">
		</asp:SqlDataSource>
    
    </div>
    </form>
</body>
</html>
 
 
AND
 
Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs)
		e.Row.Cells(1).Visible = False
End Sub

Open in new window

0
Comment
Question by:barnesco
  • 2
3 Comments
 
LVL 12

Expert Comment

by:madhevan_pillai
ID: 20425569
Try this

    Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound
       
        If e.Row.RowType = DataControlRowType.DataRow Or e.Row.RowType = DataControlRowType.Header Then

            e.Row.Cells(1).Visible = False
        End If

    End Sub
0
 
LVL 12

Accepted Solution

by:
madhevan_pillai earned 2000 total points
ID: 20425570
Hi try this
    Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound
       
        If e.Row.RowType = DataControlRowType.DataRow Or e.Row.RowType = DataControlRowType.Header Then
 
            e.Row.Cells(1).Visible = False
        End If
 
    End Sub

Open in new window

0
 

Author Closing Comment

by:barnesco
ID: 31413312
Works beautifully. Thank you!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question