名创801
|
以下是我们用C＃来实现的，见下列实例代码 <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SQL" %> <script language="C#" runat="server"> ' 声明C# public DataSet dsCustomer; protected void Page_Load(Object Src, EventArgs E ) { ' 在打开页面时连接数据库 SQLConnection myConnection = new SQLConnection ("server=127.0.0.1;uid=dbuser;pwd=*****;database=db"); 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() + " " ); } } |
| 由中国名创www.chuang.top 整理发布。 |
