<%@ import namespace="System.Data" %>
<%@ import namespace="System.Data.SqlClient" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<script language="c#" runat="server">
void page_load(object src, EventArgs e)
{
SqlConnection myconn = new SqlConnection("server=localhost;uid=sa;pwd=;database=pubs"
;
//创建对象sqlconnection
string strsql="select au_id,au_lname,au_fname,phone,address,city,zip from authors";
SqlDataAdapter mycmd = new SqlDataAdapter(strsql, myconn);
//创建对象sqldataadapter
DataSet ds = new DataSet();
//创建对象dataset
mycmd.Fill(ds);
//填充数据到dataset
DataView source = new DataView(ds.Tables[0]);
mydatagrid.DataSource = source ;
mydatagrid.DataBind();
//将数据绑定到datagrid
}
</script>
<body>
<h3><font face="verdana">simple select to a datagrid control
</font></h3>
<asp:datagrid id="mydatagrid" runat="server"
width="600"
backcolor="#ccccff"
bordercolor="black"
showfooter="false"
cellpadding=3
cellspacing="0"
font-name="verdana"
font-size="8pt"
headerstyle-backcolor="#aaaadd"
maintainstate="false"
/>
</body>
</html>
