Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Connecting to a Text File

using System; using System.Data; using System.Data.OleDb;     class Program     {         static void Main(string[] args)         {             string connectString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=;Extended Properties=\"text;HDR=yes;FMT=Delimited\";";             OleDbConnection connection = new OleDbConnection(connectString);             connection.Open(  );             Console.WriteLine("Connection.String = {0}\n",connectString);             Console.WriteLine("Connection.State = {0}",connection.State);             Console.WriteLine("Connection.Provider = {0}",connection.Provider);             Console.WriteLine("Connection.ServerVersion = {0}",connection.ServerVersion);             connection.Close(  );         }     }