如題 如何將調用web service返回的sal 的 DataSet寫入到Access數據庫?
解决方案 »
- 选中复选框,把复选框的值赋给一个文本框
- 如何将gridview的值插入到数据库另外一个表呢?
- RadioButton
- 如何将 js脚本从 .aspx里提取出来?
- SelectedIndexChanged事件,真急!
- 。。急。。。这个 sql 语句是什么意思?
- ==== 做一个数据中转程序,很迷茫.高手多帮忙 ====
- 求指导啊!~~框架页面间的值传递应该怎样传啊?就是像百度地图那样
- hashtable能存储的对象最多能多少,即它的count最大能多少?
- 急!当在asp:textbox中输入内容,再在选择下拉框时页面无法显示
- [求助]北京时间怎么转换为UK当地时间
- DataGrid点击选择按钮后变色的问题
先将获取的DataSet 合并到Access获取的DataSet中,然后调用OleDbDataAdapter.Update(DataSet)来进行更新,也可以循环DataSet的表中记录insert into Access相应表
string sqlStr = "select * from " + dataTable;
string oleDbStr = sqlStr;
SqlCommand mySqlComm = new SqlCommand(sqlStr,this.sqlConnection1); SqlDataAdapter mySqlDa = new SqlDataAdapter(mySqlComm);
DataSet ds1 = new DataSet();
mySqlDa.Fill(ds1,dataTable);
this.DataGrid1.DataSource = ds1;
this.DataGrid1.DataBind();
ds1.WriteXml(Server.MapPath(dataTable + ".xml"),XmlWriteMode.WriteSchema); OleDbCommand myOleDbComm = new OleDbCommand(oleDbStr,this.oleDbConnection1);
OleDbDataAdapter myOleDbDa = new OleDbDataAdapter(myOleDbComm);
OleDbCommandBuilder myOleDbCd = new OleDbCommandBuilder(myOleDbDa);
myOleDbCd.QuotePrefix = "[";
myOleDbCd.QuoteSuffix = "]";
DataSet ds2 = new DataSet();
myOleDbDa.Fill(ds2,dataTable);
this.DataGrid2.DataSource = ds2;
this.DataGrid2.DataBind();
ds2.Tables[dataTable].Clear();
ds2.ReadXml(Server.MapPath(dataTable + ".xml"));
myOleDbDa.Update(ds2, dataTable);
this.DataGrid3.DataSource = ds2;
this.DataGrid3.DataBind();