dataset-direct2.axpx Source Code

dataset-direct2.aspx Source Code

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

public void Page_Load(object sender, EventArgs e)
{
    if (!Page.IsPostBack)
    {
        // Create and configure connection string.
        OleDbConnection c = new OleDbConnection( );
        c.ConnectionString = 
            Provider=Microsoft.Jet.OLEDB.4.0; +
            Data Source=e:/ectserver/sjost/Database/groceries.mdb;

// Create and configure SelectCommand object.
        OleDbCommand sc = c.CreateCommand( );
        sc.Commandclass = Commandclass.Text;
        sc.CommandText = SELECT * FROM Groceries;

// Create DataAdapter object.
        OleDbDataAdapter da = new OleDbDataAdapter( );
        da.SelectCommand = sc;

// Create and populate DataSet object.
        DataSet dataset = new DataSet( );
        int nrows = da.Fill(dataset, Groceries);

// Initialize current row to 0.
        int current = 0;

// Save DataSet object and n in Session collection.
        Session[dataset] = dataset;
        Session[nrows] = nrows;
        Session[current] = current;

// Display data in textboxes.
        DisplayData(dataset, current);
    }
}

public void btnFirst_Click(object source, EventArgs e)
{
    // Retrieve values from Session collection.
    DataSet dataset = (DataSet) Session[dataset];
    int nrows = (int) Session[nrows];
    int current = (int) Session[current];

// Move current row to first.
    current = 0;

// Display current row.
    DisplayData(dataset, current);

// Update current row in Session collection.
    Session[current] = current;
}

public void btnPrev_Click(object source, EventArgs e)
{
    // Retrieve values from Session collection.
    DataSet dataset = (DataSet) Session[dataset];
    int nrows = (int) Session[nrows];
    int current = (int) Session[current];

// Move current row to next row, unless already 
    // at last row.
    if (current > 0)
    {
        current--;
    }

// Display current row.
    DisplayData(dataset, current);

// Update current row in Session collection.
    Session[current] = current;
}

public void btnNext_Click(object source, EventArgs e)
{
    // Retrieve values from Session collection.
    DataSet dataset = (DataSet) Session[dataset];
    int nrows = (int) Session[nrows];
    int current = (int) Session[current];

// Move current row to next row, unless already 
    // at last row.
    if (current < nrows - 1)
    {
        current++;
    }

// Display current row.
    DisplayData(dataset, current);

// Update current row in Session collection.
    Session[current] = current;
}

public void btnLast_Click(object source, EventArgs e)
{
    // Retrieve values from Session collection.
    DataSet dataset = (DataSet) Session[dataset];
    int nrows = (int) Session[nrows];
    int current = (int) Session[current];

// Move current row to last.
    current = nrows - 1;

// Display current row.
    DisplayData(dataset, current);

// Update current row in Session collection.
    Session[current] = current;
}
</script>

<html>

<head>
<title>dataset-direct2.aspx Example</title>
<link rel=stylesheet class=text/css 
                       href=examples.css />
<style class=text/css>
.short { width:40px; 
         text-align:center;
         font-weight:bold; }
.long  { width:200px }
</style>
</head>

<body>

<h2>dataset-direct2.aspx Example</h2>

<p>Display the data in the groceries.mdb database
     in textboxes, which are populated from the
     DataSet object without using data binding.</p>

<table>
<tr>
    <td style=text-align:right>Item</td>
    <td><asp:TextBox runat=server Id=txtItem 
             CssClass=long /></td>             
</tr>
<tr>
    <td style=text-align:right>Code</td>
    <td><asp:TextBox runat=server Id=txtCode 
             CssClass=long /></td>             
</tr>
<tr>
    <td style=text-align:right>Quantity</td>
    <td><asp:TextBox runat=server Id=txtQuantity 
             CssClass=long /></td>             
</tr>
<tr>
    <td style=text-align:right>Price</td>
    <td><asp:TextBox runat=server Id=txtPrice 
             CssClass=long /></td>             
</tr>
<tr>
    <td style=text-align:right>OnSale</td>
    <td><asp:TextBox runat=server Id=txtOnSale 
             CssClass=long /></td>             
</tr>
<tr>
    <td> </td>
    <td style=text-align:center>
        <asp:Button runat=server Id=btnFirst 
             CssClass=short Text=<<
             OnClick=btnFirst_Click /> 
        <asp:Button runat=server Id=btnPrev 
             CssClass=short Text=<
             OnClick=btnPrev_Click /> 
        <asp:Button runat=server Id=btnNext 
             CssClass=short Text=>
             OnClick=btnNext_Click /> 
        <asp:Button runat=server Id=btnLast 
             CssClass=short Text=>>
             OnClick=btnLast_Click /></td>
</tr>
</table>

</form>

</body>
</html>