📄 accessconnection.aspx
字号:
<%@ Page Debug="true" Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<html>
<head>
<title>连接Access</title>
<script language="C#" runat="server" >
public void OnConnection(object sender, EventArgs arg)
{
string provider = "Provider=" + txtProvider.Text;
string dataSource = "Data Source=" + txtDataSource.Text;
string cnnString = provider + dataSource;
ConnectionString.Text = cnnString;
OleDbConnection connection = new OleDbConnection(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>连接Access</h3>
提供者：
<asp:TextBox id="txtProvider" runat="server" />
范例: Microsoft.Jet.OleDb.4.0;<br/>
数据源：
<asp:TextBox id="txtDataSource" runat="server" />
范例: C:\DiabloCharacter.mdb;<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 + -