I m using asp.net 3.5(visual studio 2008) and sql server 2005/2000.

I want code for validation of Account number and password. i.e. when user enter the Accountno and password and click submit button it should check the data with that enter in database. If it is correct it should go to next page otherwise show error message..

Also the account no should be of 12 charcters and password of 8 charecters.