ASP.NET

public partial class _Default : System.Web.UI.Page<br />
{<br />
    OleDbConnection connect = new OleDbConnection();<br />
    OleDbDataAdapter dbadapter = new OleDbDataAdapter();<br />
    OleDbCommandBuilder dbbuilder = new OleDbCommandBuilder();<br />
    DataTable dbtable = new DataTable();<br />
    int cntr=0;<br />
-------------<br />
 protected void Page_Load(object sender, EventArgs e)<br />
    {<br />
        if (!IsPostBack)<br />
        {<br />
            ViewState["row"] = 0;<br />
        }<br />
        connect.ConnectionString =<br />
  @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp\xtreme.mdb";<br />
        connect.Open();<br />
        <br />
       <br />
    }<br />
-------------<br />
protected void Button3_Click(object sender, EventArgs e)<br />
    {<br />
          cntr=(int)ViewState["row"];<br />
          dbadapter = new OleDbDataAdapter("select * from employee", connect);<br />
          dbadapter.Fill(dbtable);<br />
       if (cntr < 15 && cntr>=0)<br />
        {<br />
         cntr++;<br />
Label5.Text = "" + (cntr+1) + ". " + dbtable.Rows[cntr]["First Name"].ToString()+ " " + dbtable.Rows[cntr]["Last name"].ToString();<br />
             ViewState["row"] = cntr;<br />
        }<br />
    }

protected void GenerateAlphabetPagingFields()<br />
    {<br />
        TableCell cell = new TableCell();<br />
        AlphabetPagingTable.Rows[0].Cells.Clear();<br />
        cell.ColumnSpan = 2;<br />
        treeviewDIV.Visible = true;<br />
        Table tab = AlphabetPagingTable;//(Table)StepCat.FindControl("AlphabetPagingTable");<br />
        if (tab != null)<br />
        {<br />
            for (int i = 65; i <= (65 + 25); i++)<br />
            {<br />
<br />
<br />
                LinkButton lb = new LinkButton();<br />
<br />
                lb.Text = Char.ConvertFromUtf32(i) + " ";<br />
<br />
                lb.CommandArgument = Char.ConvertFromUtf32(i);<br />
<br />
                lb.CommandName = "AlphaPaging";<br />
                lb.Click += new EventHandler(AlphabetPagingLink_Click);<br />
                cell.Controls.Add(lb);<br />
                tab.Rows[0].Cells.Add(cell);<br />
                Label lbl = new Label();<br />
                lbl.Text = " ";<br />
<br />
                lbl.Font.Underline = false;<br />
                TableCell td = new TableCell();<br />
                td.Controls.Add(lbl);<br />
<br />
                tab.Rows[0].Cells.Add(td);<br />
<br />
            }<br />
            //AlphabetPagingTable<br />
            <br />
        }<br />
        <br />
    }<br />