<%@ Page Language="C#" %>
<%@ Import Namespace="System" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection connection = new SqlConnection();
SqlCommand command;
SqlDataReader datareader;
connection.ConnectionString = "Server=mypc;Database=asteras;Trusted_Connection=true";
connection.Open();
command = connection.CreateCommand();
command.CommandText = "select name from ast_users";
datareader = command.ExecuteReader();
while (datareader.Read())
{
DropDownList1.Items.Add( datareader.GetValue(0).ToString() );
}
datareader.Close();
connection.Close();
}
</script>
<html>
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:DropDownList ID="DropDownList1" runat="server">
</asp:DropDownList> </div>
</form>
</body>
</html>
|