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; } }