不要在帖子的内容区加入广告

/**//// <summary>

		/// 执行一个存储过程并赋值，这个方法将从数据库中获得存储过程的参数对象并根据其顺序赋值

		/// Execute a stored procedure via a SqlCommand (that returns no resultset) against the database specified in 

		/// the connection string using the provided parameter values.  This method will query the database to discover the parameters for the 

		/// stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.

		/// </summary>

		/// <remarks>

		/// This method provides no access to output parameters or the stored procedure's return value parameter.

		/// 

		/// e.g.:  

		///  int result = ExecuteNonQuery(connString, "PublishOrders", 24, 36);

		/// </remarks>

		/// <param name="connectionString">a valid connection string for a SqlConnection</param>

		/// <param name="spName">the name of the stored prcedure</param>

		/// <param name="parameterValues">an array of objects to be assigned as the input values of the stored procedure</param>

		/// <returns>an int representing the number of rows affected by the command</returns>

		public static int ExecuteNonQuery(string connectionString, string spName, params object[] parameterValues)

		{

			//if we receive parameter values, we need to figure out where they go

			if ((parameterValues != null) && (parameterValues.Length > 0)) 

			{

				//pull the parameters for this stored procedure from the parameter cache (or discover them & populate the cache)

				SqlParameter[] commandParameters = SqlHelperParameterCache.GetSpParameterSet(connectionString, spName);



				//assign the provided values to these parameters based on parameter order

				AssignParameterValues(commandParameters, parameterValues);



				//call the overload that takes an array of SqlParameters

				return ExecuteNonQuery(connectionString, CommandType.StoredProcedure, spName, commandParameters);

			}

				//otherwise we can just call the SP without params

			else 

			{

				return ExecuteNonQuery(connectionString, CommandType.StoredProcedure, spName);

			}

		}