ASP.NET Tutorial/ADO.net Database/OleDbConnection
Connecting to an Access Database
<source lang="csharp">
<%@ Import namespace="System.Data" %> <%@ Import namespace="System.Data.OleDb" %> <%@ Page debug="true" %> <html>
<head> <title>Connecting to an Access Database</title> </head> <body>
Connecting to an Access Database
<asp:DataGrid id="dgSuppliers" runat="server" /> </body>
</html> <script language="VB" runat="server"> Sub Page_Load(Source As Object, E As EventArgs)
Dim strConnection As String = "Provider=Microsoft.Jet.OleDb.4.0;" & _ "data source=C:\northwind.mdb;" Dim objConnection As New OleDbConnection(strConnection) Dim strSQL As String = "SELECT SupplierID, CompanyName " & _ "FROM Suppliers;" Dim objCommand As New OleDbCommand(strSQL, objConnection) objConnection.Open() dgSuppliers.DataSource = objCommand.ExecuteReader() dgSuppliers.DataBind() objConnection.Close()
End Sub </script></source>
Properties of OleDbConnection
<source lang="csharp">
<%@ Page Language="C#" %> <%@ import Namespace="System.Data" %> <%@ import Namespace="System.Data.SqlClient" %> <%@ import Namespace="System.Data.OleDb" %> <%@ import Namespace="System.Data.Odbc" %> <script runat="server">
void Page_Load(object sender, EventArgs e) { OleDbConnection myOleDbConnection = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE="+ Server.MapPath("EmployeeDatabase.mdb;")); myOleDbConnection.Open(); lblOleDbConnectionString.Text = myOleDbConnection.ConnectionString; lblOleDbConnectionTimeout.Text = Convert.ToString(myOleDbConnection.ConnectionTimeout); lblOleDbDatabase.Text = myOleDbConnection.Database; lblOleDbDataSource.Text = myOleDbConnection.DataSource; lblOleDbProvider.Text = myOleDbConnection.Provider; lblOleDbServerVersion.Text = myOleDbConnection.ServerVersion; lblOleDbState.Text = Convert.ToString(myOleDbConnection.State); myOleDbConnection.Close(); }
</script> <html> <head> </head> <body>
<form runat="server">
ConnectionString: |
<asp:Label id="lblOleDbConnectionString" runat="server">ConnectionString</asp:Label> |
ConnectionTimeout: |
<asp:Label id="lblOleDbConnectionTimeout" runat="server">ConnectionTimeout</asp:Label> |
Database: |
<asp:Label id="lblOleDbDatabase" runat="server">Database</asp:Label> |
DataSource: |
<asp:Label id="lblOleDbDataSource" runat="server">DataSource</asp:Label> |
Provider: |
<asp:Label id="lblOleDbProvider" runat="server">Provider</asp:Label> |
ServerVersion: |
<asp:Label id="lblOleDbServerVersion" runat="server">ServerVersion</asp:Label> |
State: |
<asp:Label id="lblOleDbState" runat="server">State</asp:Label> |
</form>
</body> </html></source>