| 标题 | 使用oledb连接access数据库 |
| 范文 | 使用oledb连接access数据库，具体看下面的代码： using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.OleDb; namespace ConsoleApplication1 { class Program { static void Main(string[] args) { OleDbConnection conn = new OleDbConnection(); OleDbCommand comm = new OleDbCommand(); OleDbDataReader dr=null; conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Environment.CurrentDirectory + ""; comm.Connection = conn; comm.CommandText = "select * from [login]"; try { conn.Open(); dr = comm.ExecuteReader(); while (dr.Read()) { for (int i = 0; i < dr.FieldCount; i++) Console.Write(dr.GetValue(i) + " "); Console.WriteLine(""); //dr.Close(); } dr.Close(); } catch (Exception err) { Console.WriteLine(err.Message); } finally { comm = null; conn.Close(); comm = null; Console.ReadKey(); } } } } |
| 随便看 |
|
在线学习网范文大全提供好词好句、学习总结、工作总结、演讲稿等写作素材及范文模板，是学习及工作的有利工具。