c#多表联合更新access报错
public void filesToDJBH()
{
OleDbConnection mycon = null;
try
{
string strcon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\1.mdb;";
mycon = new OleDbConnection(strcon);
mycon.Open();
string sql = "updata djbh2 set djbh2.文件名 = files.文件名 where djbh2.ID = files.ID";
OleDbDataAdapter ad = new OleDbDataAdapter(sql, strcon);
DataTable dt = new DataTable();
ad.Fill(dt);
}
finally
{
mycon.Close();
}
}
