C#-文件讀取數(shù)據(jù)至dataset以更新database

2019-11-11 05:18:12

字體：大中小

供稿：網(wǎng)友

/// <summary> /// 以dataset更新數(shù)據(jù)庫 /// </summary> /// <param name="ds_source">導(dǎo)入更新（insert，delete，update）數(shù)據(jù)</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)合并數(shù)據(jù)而導(dǎo)致列類型沖突問題 //↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓ 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> /// 修改數(shù)據(jù)表DataTable列的類型和記錄值(步驟：1.克隆表結(jié)構(gòu)，2.復(fù)制表數(shù)據(jù)，3.返回結(jié)果) /// </summary> /// <param name="sourceDataTable">克隆表結(jié)構(gòu)</param> /// <param name="targDataTable">復(fù)制表數(shù)據(jù)</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; }

上一篇：C#中Request

下一篇：intellij idea maven dependency自動補全