/// <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)  评论(0)    收藏  举报