写代码时只要写一句OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Temp\NWIND.mdb");

就得了，但是数据-添加新数据源-数据库-新建连接中的ConnectionString设置为

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Temp\NWIND.mdb

系统就提醒我从索引0处就错了，Why?

SHOW YOUR CODE。

运行已经成功了的，就是想试试VS的工具该怎么用

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;

namespace RowOperationApp
{
class Program
{
static void Main(string[] args)
{
OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Temp\NWIND.mdb");
connection.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT * FROM Employees", connection);
OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter);
DataSet dataset = new DataSet();
adapter.Fill(dataset,"Employees");
DataColumn[] keys = new DataColumn[2];
keys[0] = dataset.Tables["Employees"].Columns["FirstName"];
keys[1] = dataset.Tables["Employees"].Columns["LastName"];
dataset.Tables["Employees"].PrimaryKey = keys;
string[] name ={ "Feng", "Wang" };
DataRow findRow = dataset.Tables["Employees"].Rows.Find(name);

if (findRow == null)
{
Console.WriteLine("Row{0} {1}dont't exist,add it to Employees table", name[0], name[1]);
DataRow newRow = dataset.Tables["Employees"].NewRow();
newRow["FirstName"] = name[0];
newRow["LastName"] = name[1];
dataset.Tables["Employees"].Rows.Add(newRow);
Console.WriteLine("Row{0} {1}successfully added it into Employees table", name[0], name[1]);

}
else
{
Console.WriteLine("Row{0} {1}already exist in Wmployees table", name[0], name[1]);
}

adapter.Update(dataset, "Employees");
connection.Close();
}
}
}

怎样才规范阿？已经试过加引号也不行

connstr="Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Into=False;Data Source=c:\e.mdb;
手写的可能，有误差，但这样我做过，可行。。你用向导生成的串都有错？

可能是人品问题，还是不用那个向导了，多谢蓝冰技术

呵呵，还有这种事？


出来了吗？

恩，直接写代码就没问题了

最原始的才是最好用的呀！！