Applying ASP.NET 2.0 To Custom Pages

Ok I already have a
database layed out with several tables and relationships set up, and i
went ahead and built a bunch of pages that I was planning on using.
While i was doing this I ran into 2 problems, the first was i wrote
some SQL statements to insert data from input boxes into some tables i
have in my database, i used a catch exception statement as well as a
if/else statement to handle the transfer to diffirent pages like a
signup succeded or failed, the problem im having is that the data isnt
saving into the database. (I was modeling my code after the Video 8 in the
Learning SQL server 2005 Express Edition for Beginners Video Series....
I actually got them to work......sorta....) When i test it no
exceptions are thrown and it continues on like nothing went wrong. The
other Problem i ran into was i realized i wanted to use the memberships
and roles provided by ASP.NET 2.0, and since i already created the pages for the site, i was
wondering if there was a way to add them in. This site isnt anything
fancy at all, i wanted to try and create a app where users sign up and
create an account on the site, but i also wanted to have the
flexability to insert and retrieve data from the database with out
having to be stuck in the templates. Sorry for the long story im
trying to give all the info possible. Any help on this would be
great! Thanks!