/// <summary> /// Excecute Sps /// </summary> /// <param name="spCollection"></param> /// <param name="Connection"></param> /// <returns></returns> public static bool ExecuteSps(StoredProcedureCollection spCollection, SqlConnection Connection) { try { foreach (StoredProcedure spData in spCollection) { SqlCommand cmd = new SqlCommand(); int i = 0; if (Connection.State != ConnectionState.Open) { Connection.Open(); } cmd.Connection = Connection; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = spData.ProcName; IEnumerator myEnumerator = spData.GetParams().GetEnumerator(); while (myEnumerator.MoveNext()) { ParamData pData = (ParamData)myEnumerator.Current; cmd.Parameters.Add(pData.pName, pData.pDataType); cmd.Parameters[i].Value = pData.pValue; i = i + 1; } cmd.ExecuteNonQuery(); } return(true); } catch (Exception exc) { return(false); } }
/// <summary> /// set the parameters /// </summary> /// <param name="pName"></param> /// <param name="pDataType"></param> /// <param name="pValue"></param> /// <returns></returns> /// public void SetParam(string pName, SqlDbType pDataType, string pValue) { ParamData pData = new ParamData(pName, pDataType, pValue); sParams.Add(pData); }