public static SqlConnection DEV
    {
        get
        {
            return new SqlConnection(ConfigurationManager.ConnectionStrings["DEV"].ConnectionString);
        }
    }

public static DataTable ExecuteDataTable(string storedProcedureName, SqlConnection connection, params SqlParameter[] sqlParams)
    {
        SqlCommand command = new SqlCommand(storedProcedureName, connection);
        DataSet returnSet = new DataSet();
        if (sqlParams != null)
            command.Parameters.AddRange(sqlParams);
        command.CommandType = CommandType.StoredProcedure;
        SqlDataAdapter adapter = new SqlDataAdapter();
        adapter.SelectCommand = command;
        adapter.Fill(returnSet);
        connection.Close();
        if (returnSet.Tables.Count > 0)
        {
            return returnSet.Tables[0];
        }
        return null;
    }

DataTable dt = new DataTable();
                dt = dataAccess.ExecuteDataTable
                (
                    "spInsert", dataAccess.DEV, new SqlParameter[2]
                    {
                        new SqlParameter ("@vRecID", hidIDs.Value),
                        new SqlParameter ("@vTransDate", txtTransDate.Text)
                    }
                );

                Response.Write(dt.Rows[0]["requestDate"].ToString());

<asp:HiddenField runat = "server" ID = "hidIDs" />
<asp:TextBox ID="txtTransDate" runat="server"></asp:TextBox>

Insert Into Requests
    (
        transDate,
        requestDate
    )

    Values
    (
        @vTransDate,
        getDate()
    )
    Select recID = SCOPE_IDENTITY()

    Select requestDate from Requests
    Where recID = @vRecID