repeater.axpx Source Code

repeater.aspx Source Code

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

// 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 ds = new DataSet( );
    int n = da.Fill(ds, Groceries);

// Display data in DataGrid object.
    //repGroceries.DataSource = ds.Tables[Groceries].DefaultView;
    repGroceries.DataSource = ds;
    repGroceries.DataBind( );
}
</script>

<html>

<head>
<title>repeater.aspx Example</title>
<link rel=stylesheet class=text/css 
                       href=examples.css />
<style class=text/css>
td    { padding-left:0.15cm;
        padding-right:0.15cm;
        padding-top:0.15cm;
        padding-bottom:0.15cm; }
.pink { background-color:#FFE0E0; }
.blue { background-color:#E0E0FF; }
</style>
</head>

<body>

<h2>repeater.aspx Example</h2>

<p>Display the on sale items from the groceries.mdb database
     in a DataGrid control.<br />
     Pick a select statement for choosing which
     data to display.</p>

</body>
</html>