tem.Data和System.Data.
<%@ Import
namespace="System.Data" %>
<%@ Import N
amespace="System.Data.SqlClient" %>
<ht
ML>
<script language="C
#" runat="server">
PRotected void Page_Load(Object Src, Event
args E )
{
SqlConnection myConn = new SqlConnection("server=localhost;uid=sa;pwd=;database=p
ubs");
//创建对象SqlConnection
string strSQL="SELECT au_id,au_lname,au_fname,phone,address,c
ITy,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="#ccc
CFf"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font
-size="8pt"
HeaderStyle-BackColor="#aaaadd"
M
aintain
state="false"
/>
</body>
</html>