c# 读取ACCESS 数据库

时间:2023-03-10 05:32:31
c# 读取ACCESS 数据库
using System;
using System.Collections.Generic;
using System.Data.OleDb;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks; namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{ FileStream fs = new FileStream("ak-1.csv", FileMode.Create); OleDbConnection conn = null;
OleDbDataReader reader = null;
conn = new OleDbConnection(
"Provider=Microsoft.Jet.OLEDB.4.0; " +
"Data Source=" + ("C:/Users/Ali/Documents/aaaaa.mdb"));
conn.Open();
OleDbCommand cmd =
new OleDbCommand("Select * FROM 用户信息", conn);
reader = cmd.ExecuteReader();
int count = ;
while (reader.Read())
{
count++;
if (count % == )
{
fs = new FileStream("ak-"+(count/+)+".csv", FileMode.Create);
} String x = getsss(reader, ) + "," + getsss(reader, ) + "," +
getsss(reader, ) + "," + getsss(reader, ) + "," +
getsss(reader, ) + "," + getsss(reader, ) + "," +
getsss(reader, ) + "," + getsss(reader, ) + "," +
getsss(reader, ) + "," + getsss(reader, )+"\r\n";
//Console.WriteLine(x); byte[] aaaaa = System.Text.Encoding.Default.GetBytes(x);
//reader.Read();
//Console.WriteLine(reader.GetString(2));
fs.Write(aaaaa,,aaaaa.Length);
fs.Flush(); }
fs.Close(); } private static String getsss(OleDbDataReader reader,int a) { try
{
return reader.GetString(a); }
catch (Exception e)
{
return ""; } } } }