<div>
Is there any here who can help?
</div>

<div>
Where is your code snippet?
</div>

<div>
I had thought I attached it but perhaps not. &nbsp;Let me try again. 

<pre><code class="code-10 nolinks" id="code-261608">&lt;html xmlns=&quot;http://www.w3.org/1999/xhtml&quot;&gt;
&lt;head runat=&quot;server&quot;&gt;
 &lt;title&gt;Untitled Page&lt;/title&gt;
&lt;/head&gt;
&lt;body&gt;
 &lt;form id=&quot;form1&quot; runat=&quot;server&quot;&gt;
 &lt;div&gt;
 &lt;h2&gt;Alphabet Paging Via DataGrid Conrol&lt;/h2&gt;
 &lt;asp:PlaceHolder ID=&quot;ph_alphabet&quot; runat=&quot;server&quot;&gt;&lt;/asp:PlaceHolder&gt;
 &lt;asp:GridView ID=&quot;AlphaGrid&quot; runat=&quot;server&quot; AllowPaging=&quot;True&quot;&gt;
 &lt;Columns&gt;
 &lt;asp:HyperLinkField DataNavigateUrlFields=&quot;CUSTOMID&quot; 
 DataNavigateUrlFormatString=&quot;clientViewDetails?cid={0}&quot; HeaderText=&quot;Details&quot; 
 Text=&quot;View&quot; /&gt;
 &lt;/Columns&gt;
 &lt;/asp:GridView&gt;
 
 &lt;/div&gt;
 &lt;/form&gt;
&lt;/body&gt;
&lt;/html&gt;
 
 
CODE BEHIND
**************************************************************************************************
Imports System.Data
Imports System.Data.SqlClient
 
Partial Class AlphaPaging
 Inherits System.Web.UI.Page
 
 Dim myConnection As New SqlConnection(ConfigurationManager.ConnectionStrings(&quot;NEWIDDConnectionString&quot;).ConnectionString)
 
 
 Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
 
 ' Add the Alphabet Link Buttons to the page
 
 For i As Integer = 65 To (65 + 25)
 Dim lb As New LinkButton()
 
 lb.ID = &quot;Letter &quot; &amp; Char.ConvertFromUtf32(i)
 lb.Text = Char.ConvertFromUtf32(i) &amp; &quot; &quot;
 lb.CommandArgument = Char.ConvertFromUtf32(i)
 lb.CommandName = &quot;AlphaPaging&quot;
 AddHandler lb.Command, AddressOf CommandButton_Click
 
 ph_alphabet.Controls.Add(lb)
 Next
 
 End Sub
 
 
 Protected Sub CommandButton_Click(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.CommandEventArgs)
 lblButtonPressed.Text = &quot;You pressed: &quot; _
 &amp; e.CommandName &amp; &quot;&lt;BR&gt;With this argument: &quot; _
 &amp; e.CommandArgument &amp; &quot;&lt;BR&gt;&quot;
 
 
 ' SQL Statement
 Dim sb As New StringBuilder()
 sb.Append(&quot;SELECT CUSTOMID, SOLDTO, MAINTEL, NAME1 &quot;)
 sb.Append(&quot;FROM CUSTOMERS &quot;)
 sb.Append(&quot;WHERE SOLDTO LIKE '[&quot; + e.CommandArgument + &quot;]%'&quot;)
 
 Dim sqlCommand As String = sb.ToString
 
 ' Create Command
 Dim cmd As New SqlCommand(sqlCommand, myConnection)
 
 ' Create Adaptor to connect to the db
 Dim da As New SqlDataAdapter(cmd)
 
 ' Create Dataset to hold results
 Dim dsAlphaPage As New DataSet
 
 ' Fill dataset and bind to Grid
 Try
 da.Fill(dsAlphaPage)
 da.Dispose()
 cmd.Dispose()
 
 AlphaGrid.DataSource = dsAlphaPage
 AlphaGrid.DataBind()
 
 Catch ex As Exception
 
 End Try
 End Sub
 
 Protected Sub AlphaGrid_PageIndexChanging1(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles AlphaGrid.PageIndexChanging
 AlphaGrid.PageIndex = e.NewPageIndex
 AlphaGrid.DataBind()
 End Sub
 
End Class
</code></pre>
</div>

<div>
You will need to set AlphaGrid.DataSource before you rebind the grid, if you don't, you get a blank Grid. 

</div>

<div>
I was talking about line 93.
</div>

<div>
Sorry. &nbsp;I'm a Newbie. &nbsp;Could you show me how to do this?
</div>

<div>
I did this... (see snippet) but I'm getting a &quot;Name 'dsAlphaPage' is not declared'. 

<pre><code class="code-1 nolinks" id="code-261647"> Protected Sub AlphaGrid_PageIndexChanging1(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles AlphaGrid.PageIndexChanging
 AlphaGrid.PageIndex = e.NewPageIndex
 AlphaGrid.DataSource = dsAlphaPage
 AlphaGrid.DataBind()
 End Sub
</code></pre>
</div>

<div>
Hey Prairedog - That did the trick! &nbsp;Only one change. &nbsp;Line (4) from above couldn't have the NEW in it, so I had to change it to... 
 
Dim dsAlphaPage As DataSet = Session(&quot;dsAlphaPage&quot;) 
 
... and it worked! &nbsp;Any idea why I couldn't used NEW? &nbsp;Regardless, it does work. &nbsp;Thanks again!
</div>

<div>
Thank you so much! &nbsp;Very big help to me. &nbsp;Good first experience with Experet Exchange!
</div>

<div>
How about this: 
Dim dsAlphaPage As New DataSet 
dsAlphaPage = Session(&quot;dsAlphaPage&quot;) 

</div>

<div>
That works too!? &nbsp;Huh. Why is that? &nbsp;How come you can have the statement on a single line?
</div>

<div>
It was my mistake. 
Dim ds As New DataSet is actually doing this: 
Dim ds As DataSet = New DataSet() 
You acutally assgned a value to ds, the value is &quot;Nothing&quot;. So you cannot assign &quot;Nothing&quot; and another value at the same line. Hope this helps. 

</div>

<div>
I copied and pasted code from your code and didn't pay much attention to it.
</div>

<div>
Hey Prairiedog. &nbsp;I just noticed something odd. &nbsp;When I click on a letter it loads the data just fine. &nbsp;When I click on a number it will page though the records. &nbsp;However, If I click on a page number and switch to another letter, it loads the data based on the page I was on. &nbsp;Let me try to explain. 
 
Lets say I click on the letter 'A'. &nbsp;It loads 10 records in the datagrid and shows me I have 8 more pages to click through. (A total of 80 records for the letter 'A') &nbsp;So I click on the page '2' to see the next page of records and it loads them just find. 
 
Now if I stay on page '2' and click the letter 'C'. &nbsp;It loads the 'C' records BUT in the page &nbsp;'2' position. &nbsp;(so records 11-20). &nbsp; This occures with any letter I click. &nbsp;Let's say I &nbsp;click on the letter 'M' and select page '5'. It'll loads page '5''s records. &nbsp;If I click back to the letter 'A' it loads the 'A' records found in the page '5' position (records 51-60) rather than jumping back to page 1. 
 
How to I set it so that when you click on a new letter, the page jumps back to page 1? 
</div>

<div>
<div class="content wysiwyg-content">
I just sign up for Experts Exchange 2 minutes ago because I just can seam to figure out how to accomplish this. &nbsp; 
 
I'm trying to create a Alphabet pager using a GridView control. 
 
Now, what I was able to do was to dynamic create the A-Z Link Buttons on page load. &nbsp;That works great! &nbsp;Then, when you click any letter it WILL load the data into the GridView Control for that letter. 
 
Here's where my problem is. &nbsp;In the Properties of the GridView I have the AllowPaging set to TRUE and the PageSize = 10. &nbsp;I only want to show 10 records at a time. 
 
When you click on any letter the GridView loads the first 10 records for that letter and then shows, in the footer, the additional pages. &nbsp;So if you click on B, it loads the first 10 record that match the B and then will show that there are 8 more pages for the B record. &nbsp;If I click on the number 2 to see the next set of records for the letter B the GridView goes blank. 
 
I've attached a code snippet so you can see what I've done thus far. &nbsp;It includes my main page and code behind page. &nbsp; 
 
Can someone please help me.
</div>
</div>

I just sign up for Experts Exchange 2 minutes ago because I just can seam to figure out how to accomplish this.  

I'm trying to create a Alphabet pager using a GridView control.

Now, what I was able to do was to dynamic create the A-Z Link Buttons on page load.  That works great!  Then, when you click any letter it WILL load the data into the GridView Control for that letter.

Here's where my problem is.  In the Properties of the GridView I have the AllowPaging set to TRUE and the PageSize = 10.  I only want to show 10 records at a time.

When you click on any letter the GridView loads the first 10 records for that letter and then shows, in the footer, the additional pages.  So if you click on B, it loads the first 10 record that match the B and then will show that there are 8 more pages for the B record.  If I click on the number 2 to see the next set of records for the letter B the GridView goes blank.

I've attached a code snippet so you can see what I've done thus far.  It includes my main page and code behind page.  

Can someone please help me.

Alphabetical Paging using a GridView

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.