states.axpx Source Code

states.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 States;

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

// Create and populate DataSet object.
        DataSet ds = new DataSet( );
        int n = da.Fill(ds, States);

// Bind data to DropDownList control.
        ddlStates.DataSource = ds;
        ddlStates.DataTextField = State;
        ddlStates.DataValueField = Abbreviation;
        ddlStates.DataBind( );
    }
}

public void ddlStates_SelectedIndexChanged(
                               object sender, EventArgs e)
{
    litDisplay.Text = Postal abbreviation for  +
        ddlStates.SelectedItem +  is  + 
        ddlStates.SelectedValue + .;
}
</script>

<html>

<head>
<title>states.aspx Example</title>
<link rel=stylesheet class=text/css 
                       href=examples.css />
</head>

<body>

<h2>states.aspx Example</h2>

<p>Load state names and abbreviations into 
     a dropdownlist control using databinding.</p>

</body>
</html>