Select the product you need help with

�� OleDbConnection � Visual C#.NET

��

� �� OLE DB �� (.udl) �� , ADO.NET OleDbConnection �� .

�� OLE DB �� (.udl) �� ActiveX (ADO), �� OLE DB. �� .udl. �� UDL-�� ConnectionString �� ADO.NET OleDbConnection ��, �� . �� ��  �� UDL, �� .

�� OleDbConnection.ConnectionString �� .�� NET Framework (��. �� ):

�� Microsoft Data Link (UDL), �� UDL, �� ConnectionString � �� "�� = myfile.udl". �� UDL, �� . �� UDL � �� OleDbConnection �� ConnectionString, ConnectionString �� UDL, � �� . �� , �� UDL, �� OleDbConnection �� . �� , ConnectionString �� UDL.

��

�� Visual C#.NET �� , �� UDL-��, �� ADO.NET OleDbConnection ��:

�� SQL Server �� OLE DB �� Microsoft SQL Server � �� UDL-�� Test.udl � �� C.

�� Microsoft OLE DB �� Jet 4.0 �� UDL �� Microsoft Access 97 �� 2000 �� , �� SQL Server.�� UDL �� :
189680
(http://support.microsoft.com/kb/189680/EN-US/ )
�� ADO
�� Visual C#.NET �� .

�� Class1 �� :

using System;
using System.Data;
using System.Data.OleDb;

namespace DataLink
{
    class Class1
    {
        static void Main(string[] args)
        {
            OleDbConnection myConnection = new OleDbConnection("File Name = d:\\test.udl");

            try
            {
                myConnection.Open();
                if (myConnection.State == ConnectionState.Open)
                    Console.WriteLine("Connection opened successfully!");
                else
                    Console.WriteLine("Connection could not be established");
            }
            catch(Exception ex)
            {
                Console.WriteLine(ex.Message.ToString());
            }
            finally
            {
                myConnection.Close();
            }
            Console.ReadLine();
 
            return;
        }
    }
}