default.aspx

东软内部材料（四）asp等相关的教学案例

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<Script Language="C#" runat="server">

  public void Page_Load(Object sender, EventArgs e) {
    SqlConnection connection;
    SqlCommand command;
    SqlDataReader reader;
    string sqlSelect;
    string dsn;
    
    // Name dsn and sql select
    dsn=ConfigurationSettings.AppSettings["DsnPubs"];
    sqlSelect="Select * From stores";

    // Connect to the database
    connection = new SqlConnection(dsn);
    command = new SqlCommand(sqlSelect, connection);

    // Open the connection
    connection.Open();

    // Create the reader
    reader = command.ExecuteReader();

    // Populate the datagrid
    datagrid1.DataSource = reader;
    datagrid1.DataBind();

    // Close the connection
    connection.Close();
  }

</Script>
<asp:datagrid id="datagrid1" runat="server" />