foreach (DataRow row in newDataTable.Rows)
{
foreach (DataColumn column in newDataTable.Columns)
{
string columnName = column.ColumnName;
string columnNameValue = row[column].ToString();
foreach (var item in checkedListBox1.CheckedItems)
{
if (item.ToString().Contains(columnName))
{
string oldValue = columnNameValue;
columnNameValue = wjcAPI(columnNameValue, wjcs).Result;/
if (oldValue != columnNameValue)
{
differents++;
}
}
}
string tezheng = columnName + " = ''";
if (sqlUpdate.Contains(tezheng))
{
sqlUpdate = sqlUpdate.Replace(tezheng, columnName + " =" + "'" + columnNameValue + "'");
}
}
}