110,538
社区成员
发帖
与我相关
我的任务
分享
select * into tab_BiaoZhuYangShi from opendatasource('microsoft.jet.oledb,4.0','data srouce=c:\MineADS.mdb;user id=admin;password=123').MineADS.mdb.tab_BiaoZhuYangShi
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\20101223-132821.mdb");
conn.Open();
OleDbDataAdapter emailAdapter = new OleDbDataAdapter(sql + "tab_BiaoZhuYangShi", conn);
OleDbCommandBuilder cb = new OleDbCommandBuilder(emailAdapter);
emailAdapter.Fill(ds, "tab_BiaoZhuYangShi");
conn.Close();
DataTable myDt = ds.Tables["tab_BiaoZhuYangShi"];
myDt.PrimaryKey = new DataColumn[] { myDt.Columns["tab_BiaoZhuYangShi"] };
//......//修改myDs数据
emailAdapter.Update(ds, "tab_BiaoZhuYangShi");