#region 执行可变带参数的SQL语句
/// <summary>
/// 执行可变带参数的SQL语句
/// </summary>
/// <param name="Sqlstr">SQL语句</param>
/// <param name="param">可变参数对象数组</param>
/// <returns></returns>
public static int ExecuteNonQuery(String Sqlstr, params IDataParameter[] parameters)
{
String ConnStr = "Server=localhost;USER ID=SYSDBA;PASSWORD=SYSDBA";
try
{
Dm.DmConnection conn = new Dm.DmConnection(ConnStr);
conn.Open();
DmCommand cmd = conn.CreateCommand(); cmd.CommandText = Sqlstr;
cmd.Parameters.AddRange(parameters);
return cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
return 0;
}
#endregion
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货