62,046
社区成员
发帖
与我相关
我的任务
分享
/// <summary>
/// 执行SQL语句,返回影响的记录数
/// </summary>
/// <param name="SQLString">sql语句</param>
/// <param name="cmdParms">参数化内容</param>
/// <returns></returns>
public static int SQLExecuteNonQuery(string SQLString, params MySqlParameter[] cmdParms)
{
MySqlConnection connection = new MySqlConnection(OA_myconnstr);
MySqlCommand cmd = new MySqlCommand(SQLString, connection);
try
{
connection.Open();
foreach (MySqlParameter parameter in cmdParms)
{
if ((parameter.Direction == ParameterDirection.InputOutput || parameter.Direction == ParameterDirection.Input) && (parameter.Value == null))
{
parameter.Value = DBNull.Value;
}
cmd.Parameters.Add(parameter);
}
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (MySqlException e)
{
throw e;
}
finally
{
connection.Close();
connection.Dispose();
cmd.Dispose();
}
}