绑定datagide.txt

来自「学习积累的代码段」· 文本 代码 · 共 16 行

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script language="C#" runat="server">
void Page_Load(Object sender, EventArgs e) {
	SqlConnection Conn=new SqlConnection(); 
	Conn.ConnectionString="server=localhost;database=pubs;uid=sa;pwd=''";
	Conn.Open();
	SqlCommand Comm=new SqlCommand("select * from Authors ",Conn);
	SqlDataReader dr=Comm.ExecuteReader();   
	dg.DataSource=dr;
	dg.DataBind();
	Conn.Close();
}
</script>
<asp:DataGrid id="dg" runat="server" />