// Create a new Connection and SqlDataAdapter

            SqlConnection myConnection = new SqlConnection("server=(local)\\SQLExpress;Integrated Security=SSPI;database=northwind");

            // Create stored procedure with out parameter
            try
            {
                SqlCommand CreateProcCommand = new SqlCommand("CREATE PROCEDURE GetCompanyName  @CustomerId nchar(5), @CompanyName nchar(40) out as select @CompanyName = CompanyName from Customers where CustomerId = @CustomerId",myConnection);
                SqlCommand DropProcCommand = new SqlCommand("IF EXISTS (SELECT name FROM sysobjects WHERE name = 'GetCompanyName' AND type = 'P') DROP PROCEDURE GetCompanyName", myConnection);

                myConnection.Open();
                DropProcCommand.ExecuteNonQuery();   // remove procedure if it exists
                CreateProcCommand.ExecuteNonQuery(); // create procedure

                SqlCommand myCommand = new SqlCommand("GetCompanyName", myConnection);
                myCommand.CommandType = CommandType.StoredProcedure;

                // Fill the parameters collection based upon stored procedure.
                SqlParameter workParam = null;

                workParam = myCommand.Parameters.Add("@CustomerID", SqlDbType.NChar, 5);
                // ParameterDirection.Input is the default for the Direction property. Thus the following line is not
                // needed here. To set the Direction property to its default value, use the following line.
                // workParam.Direction = ParameterDirection.Input;

                workParam = myCommand.Parameters.Add("@CompanyName", SqlDbType.NChar, 40);
                workParam.Direction = ParameterDirection.Output;

                myCommand.Parameters["@CustomerID"].Value = "ALFKI";

                myCommand.ExecuteNonQuery();
                MsgString = "CompanyName = " + myCommand.Parameters["@CompanyName"].Value.ToString();
            }
            catch(Exception e)
            {
                MsgString = e.ToString();
            }
            finally
            {
                myConnection.Close();
            }

Are you looking for DotNetNuke Modules, DotNetNuke Skins or DotNetNuke Support?

public override int SaveDataAndGetNewID(int SomeInputData)
        {
            try
            {
                string SPName = "SaveDataAndReturnID";
                SqlParameter SomeInputDataParam= new SqlParameter("@SomeInputData", SqlDbType.Int);
                SomeInputDataParam.Value = SomeInputData;
                SqlParameter NewIDParam = new SqlParameter("@NewID", SqlDbType.Int);
                NewIDParam.Direction = ParameterDirection.Output;

                SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, DatabaseOwner + ObjectQualifier + SPName, formUserIDParam, iAppsUserIDParam);

                return (int)NewIDParam.Value;

            }
            catch (Exception ex)
            {

                throw ex;
            }

        }