如何跳过该报错的sql语句，执行下一个sql语句

[he_tego]

循环往sql server中添加值时
方法：
/// <param name="databaseName">数据库名</param>
/// <param name="ls">sql语句的集合</param>
public bool InsertData(string databaseName, List<string> ls）
{
string strCon1 = "Data Source=HEHANG-PC;Initial Catalog=" + databaseName + ";Persist Security Info=True;User ID=sa;Password=123456";
SqlConnection sqlcon = new SqlConnection(strCon1);
try
{
sqlcon.Open();
}
catch (Exception ex)
{
throw ex;
}

SqlCommand sqlcmd = new SqlCommand();
sqlcmd.Connection = sqlcon;


try
{
foreach (string sql in ls)
{
sqlcmd.CommandText = sql;
sqlcmd.ExecuteNonQuery();
}

return true;
}
catch (Exception ex)
{
continue;
throw ex;
}
finally
{
sqlcon.Close();
}
}
当一条sql报错时，如何跳过该sql语句执行一条sql语句，并且保存报错的sql语句。

[ringobob]

/// <param name="databaseName">数据库名</param>
  /// <param name="ls">sql语句的集合</param>
public bool InsertData(string databaseName, List<string> ls）
  {
  string strCon1 = "Data Source=HEHANG-PC;Initial Catalog=" + databaseName + ";Persist Security Info=True;User ID=sa;Password=123456";
  SqlConnection sqlcon = new SqlConnection(strCon1);
  try
  {
  sqlcon.Open();
  }
  catch (Exception ex)
  {
  throw ex;
  }

  SqlCommand sqlcmd = new SqlCommand();
  sqlcmd.Connection = sqlcon;
    

  try
  {
  foreach (string sql in ls)
  {
  sqlcmd.CommandText = sql;
  sqlcmd.ExecuteNonQuery();
  }
    
  return true;
  }
  catch (Exception ex)
  {
  //continue;
  //此处添加一个function 执行另一条sql，并保存上面的sql语句
  throw ex;
  }
  finally
  {
  sqlcon.Close();
  }
  }

[threenewbee]

foreach (string sql in ls)
{
    try
    {
        sqlcmd.CommandText = sql;
        sqlcmd.ExecuteNonQuery();
    }
    catch (Exception ex)
    {
        continue;
    }
}
sqlcon.Close();
return true;

[小童]

foreach (string sql in ls)
{
try
{
sqlcmd.CommandText = sql;
sqlcmd.ExecuteNonQuery();
}
catch (Exception ex)
{
continue;
}
}
sqlcon.Close();
return true;

[xuexiaodong2009]

[Quote=引用 3 楼 ranen2010 的回复:]

foreach (string sql in ls)
{
try
{
sqlcmd.CommandText = sql;
sqlcmd.ExecuteNonQuery();
}
catch (Exception ex)
{
continue;
}
}
sqlcon.Close(……
[/Quote]同意，改变try，catch 的位置就行了

[he_tego]

[Quote=引用 2 楼 caozhy 的回复:]

C# code
foreach (string sql in ls)
{
try
{
sqlcmd.CommandText = sql;
sqlcmd.ExecuteNonQuery();
}
catch (Exception ex)
{
continue;
}
}
sqlcon.Close();
……
[/Quote]
主要就是如何将报错的SQL保存起来，

[threenewbee]

string errsql = "";
foreach (string sql in ls)
{
try
{
sqlcmd.CommandText = sql;
sqlcmd.ExecuteNonQuery();
}
catch (Exception ex)
{
errsql += sql + "\r\n";
continue;
}
}
sqlcon.Close();
//errsql 就是全部错误的。
return true;

[he_tego]

[Quote=引用 6 楼 caozhy 的回复:]

string errsql = "";
foreach (string sql in ls)
{
try
{
sqlcmd.CommandText = sql;
sqlcmd.ExecuteNonQuery();
}
catch (Exception ex)
{
errsql += sql……
[/Quote]
thanks，果然是人才