http://nfex.ru/index.php?action=history&feed=atom&title=ASP.NET_Tutorial%2FADO.net_Database%2FOleDbConnection
ASP.NET Tutorial/ADO.net Database/OleDbConnection - История изменений
2026-04-29T16:28:49Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://nfex.ru/index.php?title=ASP.NET_Tutorial/ADO.net_Database/OleDbConnection&diff=2733&oldid=prev
в 15:30, 26 мая 2010
2010-05-26T15:30:57Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 15:30, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://nfex.ru/index.php?title=ASP.NET_Tutorial/ADO.net_Database/OleDbConnection&diff=2734&oldid=prev
Admin: 1 версия
2010-05-26T11:56:56Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== Connecting to an Access Database==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Import namespace="System.Data" %><br />
<%@ Import namespace="System.Data.OleDb" %><br />
<%@ Page debug="true" %><br />
<html><br />
<head><br />
<title>Connecting to an Access Database</title><br />
</head><br />
<body><br />
<H3>Connecting to an Access Database</H3><br />
<asp:DataGrid id="dgSuppliers" runat="server" /><br />
</body><br />
</html><br />
<script language="VB" runat="server"><br />
Sub Page_Load(Source As Object, E As EventArgs)<br />
Dim strConnection As String = "Provider=Microsoft.Jet.OleDb.4.0;" & _<br />
"data source=C:\northwind.mdb;"<br />
Dim objConnection As New OleDbConnection(strConnection)<br />
Dim strSQL As String = "SELECT SupplierID, CompanyName " & _<br />
"FROM Suppliers;"<br />
Dim objCommand As New OleDbCommand(strSQL, objConnection)<br />
objConnection.Open()<br />
dgSuppliers.DataSource = objCommand.ExecuteReader()<br />
dgSuppliers.DataBind()<br />
objConnection.Close()<br />
End Sub<br />
</script></source><br />
<br />
<br />
<br />
== Properties of OleDbConnection==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="C#" %><br />
<%@ import Namespace="System.Data" %><br />
<%@ import Namespace="System.Data.SqlClient" %><br />
<%@ import Namespace="System.Data.OleDb" %><br />
<%@ import Namespace="System.Data.Odbc" %><br />
<script runat="server"><br />
void Page_Load(object sender, EventArgs e) {<br />
OleDbConnection myOleDbConnection = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE="+ Server.MapPath("EmployeeDatabase.mdb;"));<br />
myOleDbConnection.Open();<br />
<br />
lblOleDbConnectionString.Text = myOleDbConnection.ConnectionString;<br />
lblOleDbConnectionTimeout.Text = Convert.ToString(myOleDbConnection.ConnectionTimeout);<br />
lblOleDbDatabase.Text = myOleDbConnection.Database;<br />
lblOleDbDataSource.Text = myOleDbConnection.DataSource;<br />
lblOleDbProvider.Text = myOleDbConnection.Provider;<br />
lblOleDbServerVersion.Text = myOleDbConnection.ServerVersion;<br />
lblOleDbState.Text = Convert.ToString(myOleDbConnection.State);<br />
<br />
myOleDbConnection.Close();<br />
}<br />
</script><br />
<html><br />
<head><br />
</head><br />
<body><br />
<form runat="server"><br />
<table><br />
<tbody><br />
<tr><br />
<td><br />
ConnectionString: <br />
</td><br />
<td><br />
<asp:Label id="lblOleDbConnectionString" runat="server">ConnectionString</asp:Label></td><br />
</tr><br />
<tr><br />
<td><br />
ConnectionTimeout: <br />
</td><br />
<td><br />
<asp:Label id="lblOleDbConnectionTimeout" runat="server">ConnectionTimeout</asp:Label></td><br />
</tr><br />
<tr><br />
<td><br />
Database: <br />
</td><br />
<td><br />
<asp:Label id="lblOleDbDatabase" runat="server">Database</asp:Label></td><br />
</tr><br />
<tr><br />
<td><br />
DataSource: <br />
</td><br />
<td><br />
<asp:Label id="lblOleDbDataSource" runat="server">DataSource</asp:Label></td><br />
</tr><br />
<tr><br />
<td><br />
Provider: <br />
</td><br />
<td><br />
<asp:Label id="lblOleDbProvider" runat="server">Provider</asp:Label></td><br />
</tr><br />
<tr><br />
<td><br />
ServerVersion: <br />
</td><br />
<td><br />
<asp:Label id="lblOleDbServerVersion" runat="server">ServerVersion</asp:Label></td><br />
</tr><br />
<tr><br />
<td><br />
State: <br />
</td><br />
<td><br />
<asp:Label id="lblOleDbState" runat="server">State</asp:Label></td><br />
</tr><br />
</tbody><br />
</table><br />
</form><br />
</body><br />
</html></source></div>
Admin