使用DataTable更新access
从页面上传过来一个Datatable ，然后用这个插入到数据库里，
public void Setrcjqdde(DataTable dt0)
{
string connectionstring = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\业务操作\RationLibary.mdb;";
using (OleDbConnection conn = new OleDbConnection(connectionstring))
{
try
{
conn.Open();
string sql = "delete from jsqdde";
OleDbCommand cmd = new OleDbCommand(sql, conn);
cmd.ExecuteNonQuery();
OleDbDataAdapter da = new OleDbDataAdapter();
OleDbCommand cmd2 = new OleDbCommand("insert into jsqdde (bm,nr,dw,dj,dj1) values (?,?,?,?,?)");
OleDbDataAdapter adapt = new OleDbDataAdapter("select bm,nr,dw,dj,dj1 from jsqdde", conn);
OleDbCommandBuilder OleDbCmdBud = new OleDbCommandBuilder(adapt);
OleDbParameter bm = new OleDbParameter("@bm", OleDbType.VarChar, 50);
OleDbParameter nr = new OleDbParameter("@nr", OleDbType.VarWChar, 50);
OleDbParameter dw = new OleDbParameter("@dw", OleDbType.VarWChar, 10);
OleDbParameter dj = new OleDbParameter("@dj", OleDbType.Single);
OleDbParameter dj1 = new OleDbParameter("@dj1", OleDbType.Single);
adapt.Fill(dt0);
adapt.SelectCommand.Parameters.Add(bm);
adapt.SelectCommand.Parameters.Add(nr);
adapt.SelectCommand.Parameters.Add(dw);
adapt.SelectCommand.Parameters.Add(dj);
adapt.SelectCommand.Parameters.Add(dj1);
adapt.SelectCommand.Parameters["@bm"].SourceColumn = "bm";
adapt.SelectCommand.Parameters["@nr"].SourceColumn = "nr";
adapt.SelectCommand.Parameters["@dw"].SourceColumn = "dw";
adapt.SelectCommand.Parameters["@dj"].SourceColumn = "dj";
adapt.SelectCommand.Parameters["@dj1"].SourceColumn = "dj1";
adapt.InsertCommand = OleDbCmdBud.GetInsertCommand();
if (dt0 != null)
{
try
{
adapt.Update(dt0);
}
catch (Exception ex)
{
}
}
}
catch (Exception ex)
{
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
dt0.Clear();
}
}
}
有主键是ID
[解决办法]
批量插入的方法
http://dotnet.aspx.cc/file/Insert-DataSet-Into-Access.aspx
[解决办法]
我传过来的是DataTable，所以这个value到底要怎么写。
我是要把Datatable里的值批量插入到access中
。。。。。。。。。。。。。。
哪你就直接用datadapter.Update(Datatable)方法更新，不懂查资料库
[解决办法]
据我猜测，dt0中所有行的Row都被记录未改变，而不是新插入状态，因此update不起作用，
可能导致的原因是dt0插入记录之后，调用了dto.AcceptChenges()
