///
/// 执行SQL语句,返回影响的记录数
///
/// SQL语句
/// 影响的记录数
public static int ExecuteSql(string SQLString,params SqlParameter[] cmdParms)
{
using (SqlConnection connection = new SqlConnection(ConnectionString1))
{
using (SqlCommand cmd = new SqlCommand())
{
try
{
PrepareCommand(cmd, connection, null,SQLString, cmdParms);
int r

/**//// <summary>
/// 执行SQL语句,返回影响的记录数
/// </summary>
/// <param name="SQLString">SQL语句</param>
/// <returns>影响的记录数</returns>
public static int ExecuteSql(string SQLString,params SqlParameter[] cmdParms)

{
using (SqlConnection connection = new SqlConnection(ConnectionString1))

{
using (SqlCommand cmd = new SqlCommand())

{
try

{
PrepareCommand(cmd, connection, null,SQLString, cmdParms);
int rows=cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return rows;
}
catch(System.Data.SqlClient.SqlException E)

{
throw new Exception(E.Message);
}
}
}
}
posted on
2007-09-26 09:25
小角色
阅读(
251)
评论()
收藏
举报