<%@ Import Namespace="System.Data"%> <%@ Import Namespace="System.Data.SqlClient"%> <mce:script Language="c#" runat="server"><!-- //连接到SQL Server 2000中 void Page_Load() { string strConnection = "user id=sa;password=;"; strConnection += "initial catalog=northwind;server=YourSQLServer;"; strConnection += "Connect Timeout=30"; data_src.Text = strConnection; SqlConnection objConnection = new SqlConnection(strConnection); try { objConnection.Open(); con_open.Text="Connection opened successfully.<br />"; objConnection.Close(); con_close.Text="Connection closed.<br />"; } catch(Exception e) { con_open.Text="Connection failed to open.<br />"; con_close.Text=e.ToString(); } } // --></mce:script> <html> <body> <asp:label id="data_src" runat="server" /> <asp:label id="con_open" runat="server" /> <asp:label id="con_close" runat="server" /> </body> </html>