<%@ Page Language="C#" %>
<%@ Import Namespace ="System.Data" %>
<%@ Import Namespace ="System.Data.Common" %>
<%@ Import Namespace ="System.Data.SqlClient" %>
<script runat="server">
protected void Page_Load(object sender, EventArgs e) {
string sCnx =
"server = localhost ; uid=sa ; pwd =; database = ORGANIZATION";
string sCmd = "SELECT * FROM EMPLOYEES";
using (DbConnection cnx =new SqlConnection(sCnx)) {
using (DbCommand cmd =new SqlCommand(sCmd, cnx as SqlConnection)){
cnx.Open();
using ( DbDataReader rdr = cmd.ExecuteReader() ) {
MyList.DataSource = rdr;
MyList.DataTextField = "SurName";
DataBind();
MyList.EnableViewState = false;
} // end using rdr.
} // end using cmd.
} // end using cnx.
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<body>
<form id="Form1" runat="server">
<asp:ListBox ID="MyList" runat="server" />
</form>
</body>
</html>