C#-文件读取数据至dataset以更新database

2019-11-11 05:16:42

字体：大中小

来源：转载

供稿：网友

/// <summary> /// 以dataset更新数据库 /// </summary> /// <param name="ds_source">导入更新（insert，delete，update）数据</param> public bool UseDataSetUpdateDataBase(DataSet ds_source) { bool _return = false; try { for (int i = 0; i < ds_source.Tables.Count; i++) { //* MySQLDataAdapter sda = new MySqlDataAdapter("select * from " + ds_source.Tables[i].TableName, this.connectionString); DataTable datatable = new DataTable(); sda.Fill(datatable); datatable.PRimaryKey = new DataColumn[] { datatable.Columns[datatable.Columns[0].ColumnName.ToString()] }; //解决DataTable.Merge(DataTable)合并数据而导致列类型冲突问题 //↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓ DataTable targertDatatable = UpdateDataTableDataType(datatable, ds_source.Tables[i]); datatable.Merge(targertDatatable); MySqlCommandBuilder cmdBuilder = new MySqlCommandBuilder(sda); MySqlCommand cmd = cmdBuilder.GetUpdateCommand(); cmd.CommandTimeout = 0; sda.UpdateCommand = cmd; sda.Update(datatable); } } catch (Exception ex) { throw ex; } return _return; } /// <summary> /// 修改数据表DataTable列的类型和记录值(步骤：1.克隆表结构，2.复制表数据，3.返回结果) /// </summary> /// <param name="sourceDataTable">克隆表结构</param> /// <param name="targDataTable">复制表数据</param> /// <returns></returns> private DataTable UpdateDataTableDataType(DataTable sourceDataTable,DataTable targetDataTable) { DataTable datatableResult = new DataTable(); datatableResult = sourceDataTable.Clone(); foreach (DataRow row in targetDataTable.Rows) { DataRow rowNew = datatableResult.NewRow(); foreach (DataColumn column in targetDataTable.Columns) { rowNew[column.ColumnName.ToString()] = row[column.ColumnName.ToString()]; } datatableResult.Rows.Add(rowNew); } return datatableResult; }

上一篇：spring mvc 单独接收数组参数

下一篇：51nod - 1284 2 3 5 7的倍数(容斥)

学习交流

索泰发布一款GTX 1070 Mini迷你版本:小机

索泰发布一款GTX 1070 Mini迷你版本:小机箱大爱...

热门图片

猜你喜欢的新闻

猜你喜欢的关注