< %@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQL" %> <html> < script language="C#" runat="server">
'声明C# public DataSet dsCustomer; protected void Page_Load(Object Src, EventArgs E ) {
'当打开页面时联结数据库 SQLConnection myConnection = new SQLConnection
("server=sql2.bitsonthewire.com;uid=joeuser;pwd=joeuser;database=northwind"); SQLDataSetCommand CustomersDSCommand = new SQLDataSetCommand("select * from customers", myConnection);
dsCustomer = new DataSet();
CustomersDSCommand.FillDataSet(dsCustomer,"Customers");
foreach (DataRow Customer in dsCustomer.Tables["Customers"].Rows) { Response.Write(Customer["CustomerId"].ToString() + "<br> " ); } } </script> <body> </body>
</html>
</td>
</tr>
</table>
</body>
|