C#访问ACCESS文件的简单实例

	 

	using System; 

	using System.Collections.Generic; 

	using System.Linq; 

	using System.Text; 

	using System.Data.OleDb; 

	using System.Data.SqlClient; 

	 

	namespace CSharpAccess 

	{ 

	    class Program 

	    { 

	        static void Main(string[] args) 

	        { 

	            OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:/school.mdb"); 

	            conn.Open(); 

	            string sql = "select * from student"; 

	            OleDbCommand command = new OleDbCommand(sql, conn); 

	            OleDbDataReader reader = command.ExecuteReader(); 

	            try 

	            { 

	                while (reader.Read()) 

	                { 

	                    for (int i = 0; i < reader.FieldCount;i++ ) 

	                    { 

	                        Console.Write("{0} ", reader[i]); 

	                    } 

	                    Console.WriteLine();                      

	                } 

	            } 

	            finally 

	            { 

	                reader.Close(); 

	                conn.Close(); 

	            } 

	        } 

	    } 

	}   

	 

	摘自 I_code

补充：软件开发 , C# ,

上一个：C#.NET下窗体从不透明转为透明的一瞬间存在黑色闪烁的解决
下一个：深入浅出分析C#接口的作用