Hi Kelly,
What you're looking to do is dependent on ADO.Net technology and isn't really recommended with ASP.Net 2.0. (at least not what you are trying to do with ADO.Net)
ASP.Net 2.0 has built in login controls (that have all the validators and other good stuff included for you) that are managed by administering the site, something that is quite easier and more secure but beyond the scope of this reply
www.asp.net has some great tutorials on ASP.Net 2.0 and login controls and a bunch of other goodies. Here are some videos:
http://www.asp.net/learn/videos/default.aspx?tabid=63
http://www.asp.net/learn/videos/view...tabid=63&id=45
Check those out and let us know how everything worked out.
Jon