ASP.NET

<br />
<br />
public partial class sample : System.Web.UI.Page<br />
{<br />
    OleDbConnection cn;<br />
    OleDbCommand cd;<br />
    OleDbDataReader rd;<br />
    OleDbDataAdapter da;<br />
    int rowIndex;<br />
    protected void Page_Load(object sender, EventArgs e)<br />
    {<br />
        if (!Page.IsPostBack)<br />
        {<br />
            DataTable dt = GetData();<br />
            if (dt.Rows.Count > 0)<br />
            {<br />
                // Populate the TextBox with the first entry on page load                <br />
                TextBox1.Text = dt.Rows[0]["Employee_Name"].ToString();<br />
                //Then we store the DataTable in Session so that we will NOT                <br />
                //query the DB on every postbacks                <br />
                Session["dt"] = dt;<br />
            }<br />
        }<br />
        <br />
    }<br />
<br />
    private DataTable GetData() <br />
    { <br />
        DataTable dt = new DataTable(); <br />
        cn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath("App_Data/employeedb.mdb")); <br />
        try { <br />
             cn.Open();<br />
             cd = new OleDbCommand("Select * from emptbl", cn);<br />
             //SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd); sqlDa.Fill(dt); <br />
             OleDbDataAdapter da = new OleDbDataAdapter(cd);<br />
             da.Fill(dt);<br />
            } <br />
        <br />
        catch (System.Data.OleDb.OleDbException ex) <br />
               { <br />
                  string msg = "Fetch Error:"; msg += ex.Message; <br />
                  throw new Exception(msg); <br />
               } <br />
                 finally <br />
                       { <br />
                           cn.Close();<br />
                            <br />
                       }<br />
        return dt;<br />
     }<br />
    protected void Button1_Click(object sender, EventArgs e)<br />
    {<br />
      //int rowIndex = 0; <br />
        rowIndex = +6;<br />
        TextBox1.Text = rowIndex.ToString();<br />
             <br />
        /*if (Session["dt"] != null)        <br />
          {            <br />
            DataTable dt = (DataTable)Session["dt"];            <br />
            if (rowIndex <= dt.Rows.Count)<br />
            {<br />
                          <br />
                //get the next row entry on Button Click by setting the Row Index                <br />
                TextBox1.Text = dt.Rows[rowIndex]["Employee_Name"].ToString();             <br />
            }        <br />
        }*/<br />
    }<br />
}<br />
<br />
<br />