ASP.NET Tutorial/ADO.net Database/OdbcConnection

Материал из .Net Framework эксперт
Перейти к: навигация, поиск

Properties of OdbcConnection

<%@ 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">
        <table>
            <tbody>
                <tr>
                    <td>
                        ConnectionString: 
                    </td>
                    <td>
                        <asp:Label id="lblOdbcConnectionString" runat="server">ConnectionString</asp:Label></td>
                </tr>
                <tr>
                    <td>
                        ConnectionTimeout: 
                    </td>
                    <td>
                        <asp:Label id="lblOdbcConnectionTimeout" runat="server">ConnectionTimeout</asp:Label></td>
                </tr>
                <tr>
                    <td>
                        Database: 
                    </td>
                    <td>
                        <asp:Label id="lblOdbcDatabase" runat="server">Database</asp:Label></td>
                </tr>
                <tr>
                    <td>
                        DataSource: 
                    </td>
                    <td>
                        <asp:Label id="lblOdbcDataSource" runat="server">DataSource</asp:Label></td>
                </tr>
                <tr>
                    <td>
                        Driver: 
                    </td>
                    <td>
                        <asp:Label id="lblOdbcDriver" runat="server">Driver</asp:Label></td>
                </tr>
                <tr>
                    <td>
                        ServerVersion: 
                    </td>
                    <td>
                        <asp:Label id="lblOdbcServerVersion" runat="server">ServerVersion</asp:Label></td>
                </tr>
                <tr>
                    <td>
                        State: 
                    </td>
                    <td>
                        <asp:Label id="lblOdbcState" runat="server">State</asp:Label></td>
                </tr>
            </tbody>
        </table>
        
        
    </form>
</body>
</html>
Источник — «http://nfex.ru/index.php?title=ASP.NET_Tutorial/ADO.net_Database/OdbcConnection&oldid=2657»