DataTable _dtColumnValue = QianBianWanHua_Common.DBHelper.getTable( " SELECT * FROM QB_ProductColumnValue " );Hashtable _htColumnValue = new Hashtable();DataRow[] _drColumnValue = _dtColumnValue.Select( " ColumnsValue=' " + _strColumnValue + " ' " ); if (_drColumnValue.Length > 0 ) ... { continue; } _htColumnValue.Add( " ColumnsValue " , _strColumnValue); QianBianWanHua_Common.DBHelper.DataTableNewRow( ref _dtColumnValue, _htColumnValue); _htColumnValue.Clear(); if (BatchInsertColumnValue( ref _dtColumnValue)) ... { QianBianWanHua_Common.MessageBox.Show(this, "操作成功"); } else ... { QianBianWanHua_Common.MessageBox.Show(this, "操作失败"); } /**/ /// <summary> /// 批量添加 /// </summary> /// <param name="dt">DataTable</param> /// <returns>bool</returns> private bool BatchInsertColumnValue( ref DataTable dt) ... { SqlCommand _cmdInsert = new SqlCommand("INSERT INTO QB_ProductColumnValue(ColumnsValue) VALUES (@ColumnsValue)"); Hashtable _htColumnValue = new Hashtable(); _htColumnValue.Add("@ColumnsValue", "ColumnsValue"); if (QianBianWanHua_Common.DBHelper.BuildBatchUpdateCommand(ref dt, ref _cmdInsert, _htColumnValue)) ...{ return QianBianWanHua_Common.DBHelper.BatchUpdateDataTable(ref dt, _cmdInsert, null, null); } else ...{ return false; } }