ASP+联结数据库 -- 纯粹空间 - 韩国欧美酷站教程设计素材美女壁纸下载论坛免费博客

类别: ASP.NET教程

< %@ 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>

-= 资源教程 =-

文章搜索