ASP.Net/ADO.net Database/ODBC

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

Use OdbcConnection

   <source lang="csharp">

<%@ Page Language="C#" %> <%@ Import Namespace="Microsoft.Data.Odbc" %> <script runat="server"> void Page_Load(Object sender, EventArgs e) {

   String connectString = "DSN=myDSN;Uid=user;Pwd=pass";
   OdbcConnection myConn = null;
   try
   {      
     myConn = new OdbcConnection( connectString );    
     myConn.Open();
       
     lblConnectInfo.Text = "Connection successful!";
   }
   catch
   {
     lblConnectInfo.Text = "Connection failed!";
   }
   finally
   {
     if (myConn != null)
       myConn.Close();
   }        

} </script> <html>

 <head>
   <title></title>
 </head>
 <body>
   <form id="form1" method="post" runat="server">
     Open an ODBC connection.
     <asp:Label id="lblConnectInfo" runat="server"></asp:Label>
   </form>
 </body>

</html>

</source>