datagrid.aspx

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

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

<script language="C#" runat="server">

  void page_load(Object Sender,EventArgs E)
  {
    SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["DsnPubs"]);
    SqlCommand    cmd;
    
    con.Open();
    cmd = new SqlCommand("select * from authors", con);
    
    DataGrid1.DataSource = cmd.ExecuteReader();
    DataGrid1.DataBind();
  }
  
</script>


<asp:DataGrid id="DataGrid1" runat="server"/>