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的倍數(容斥)