📄 sqlserverconnection.aspx
字号:
<%@ Page Debug="true" Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<head>
<title>连接SQL Server</title>
<script language="C#" runat="server" >
public void OnConnection(object sender, EventArgs arg)
{
string dataSource = "Data Source=" + txtDataSource.Text + ";";
string security = "user id=" + txtUser.Text + "; password=" + txtPassword.Text + ";";
string database = "initial catalog=" + txtDatabase.Text + ";";
string cnnString = dataSource + security + database;
ConnectionString.Text = cnnString;
Trace.Warn("app", cnnString);
SqlConnection connection = new SqlConnection(cnnString);
try
{
connection.Open();
ConnectionResult.Text = "Connection successful!<br/>";
ConnectionResult.Text += "Server Version: " + connection.ServerVersion + "<br/>";
ConnectionResult.Text += "Database: " + connection.Database + "<br/>";
ConnectionResult.Text += "Status: " + connection.State.ToString() + "<br/>";
ConnectionResult.Text += "Timeout: " + connection.ConnectionTimeout.ToString();
}
catch(Exception e)
{
ConnectionResult.Text = "Connection failed!<br/>";
ConnectionResult.Text += e.ToString();
}
finally
{
connection.Close();
}
}
</script>
</head>
<body>
<form id="form1" runat="server">
<h3>连接SQL Server</h3>
数据源：
<asp:TextBox id="txtDataSource" runat="server" />
范例: localhost;<br/>
用 户：
<asp:TextBox id="txtUser" runat="server" />
范例: sa;<br/>
密 码：
<asp:TextBox id="txtPassword" runat="server" />
范例: password;<br/>
数据库：
<asp:TextBox id="txtDatabase" runat="server" />
范例: northwind;<br/>
<asp:Button id="Button1" runat="server"
Text="连接数据库" OnClick="OnConnection" />
<hr/>
ConnectionString:<br/>
<asp:Label id="ConnectionString" runat="server" />
Result:<br/>
<asp:Label id="ConnectionResult" runat="server" />
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -