grocery-display4.axpx Source Code

grocery-display4.aspx Source Code

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

// Construct SQL statement from item name in textbox
    // Show resulting SQL statement in txtSql.
    string sql = SELECT * FROM Groceries  + 
        WHERE Item = ' + txtItem.Text + ';;
    txtSql.Text = sql;

// Create and configure SelectCommand object.
    OleDbCommand sc = c.CreateCommand( );
    sc.Commandclass = Commandclass.Text;
    sc.CommandText = sql;
    // 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.
    dgGroceries.DataSource = ds;
    dgGroceries.DataBind( );
}
</script>

<html>

<head>
<title>grocery-display4.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; }
</style>
</head>

<body>

<h2>grocery-display4.aspx Example</h2>

<p>Display item for which the SQL statement is
constructed dynamically from the item name.</p>

<p>Enter name of item:<br />
<asp:TextBox Id=txtItem Width=200px runat=server />
</p>

<p>SQL statement:<br />
<asp:TextBox Id=txtSql Width=600px  runat=server />
</p>

<asp:DataGrid ID=dgGroceries runat=server 
     style=font-size:90% />
</pre>
</form>

</body>
</html>