ASP.NET Tutorial/ADO.net Database/OdbcConnection — различия между версиями
Admin (обсуждение | вклад) м (1 версия) |
|
(нет различий)
|
Версия 18:30, 26 мая 2010
Properties of OdbcConnection
<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) { OdbcConnection myOdbcConnection = new OdbcConnection("driver={SQL Server};server=(local)\\YourDatabase;database=Books;uid=YourID;pwd=letmein;"); myOdbcConnection.Open(); lblOdbcConnectionString.Text = myOdbcConnection.ConnectionString; lblOdbcConnectionTimeout.Text = Convert.ToString(myOdbcConnection.ConnectionTimeout); lblOdbcDatabase.Text = myOdbcConnection.Database; lblOdbcDataSource.Text = myOdbcConnection.DataSource; lblOdbcDriver.Text = myOdbcConnection.Driver; lblOdbcServerVersion.Text = myOdbcConnection.ServerVersion; lblOdbcState.Text = Convert.ToString(myOdbcConnection.State); myOdbcConnection.Close(); }
</script> <html> <head> </head> <body>
<form runat="server">
ConnectionString: |
<asp:Label id="lblOdbcConnectionString" runat="server">ConnectionString</asp:Label> |
ConnectionTimeout: |
<asp:Label id="lblOdbcConnectionTimeout" runat="server">ConnectionTimeout</asp:Label> |
Database: |
<asp:Label id="lblOdbcDatabase" runat="server">Database</asp:Label> |
DataSource: |
<asp:Label id="lblOdbcDataSource" runat="server">DataSource</asp:Label> |
Driver: |
<asp:Label id="lblOdbcDriver" runat="server">Driver</asp:Label> |
ServerVersion: |
<asp:Label id="lblOdbcServerVersion" runat="server">ServerVersion</asp:Label> |
State: |
<asp:Label id="lblOdbcState" runat="server">State</asp:Label> |
</form>
</body> </html></source>