VS 2010 - Modifying Default Template

I'm playing around and created a new Web Form project and trying to make way with the default template. I've created the pages I need but trying to leverage the existing membership pages and ASPNETDB. I'm having trouble grasping how the asp pages are connecting to the database(and thus make my own changes). I cannot see any SQL syntax in the aspx pages or the code behind? I can tell the project is making use of the stored procedures but where is the actual connection configured or the command that is being run, for example when the "create" button is pressed on the CreateUserWizard control. Looking at the createUserWizrd I cannot see any adapters it might be using?

Perhaps my mindset is trying to apply, tableadapter and datasets way of working to asp controls. All the information and tutorials I'm looking at, seem to bypass the connection to the database and somehow there controls are 'taking care' of the I/O to the database. So if I wanted to add an additional field to the createwizard process, what do I need to do? Alter the db and the stored procedure, then?