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 Ole...
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 + "\SimpleNews.mdb";
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();
}
}
}
}
您可能感兴趣的文章:
本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。