i need a simple login page with asp.net(c#) to connect with sql server 2005
Hi,
You can just:
1) Put two textboxes onto the WebForm, one of which is called "TextBox1", while the other is "TextBox2" for username and password.
2) Then put a button called Login.
3) In the button's click event, please use SqlCommand to check whether the username and password from the two textboxes are right or not. To decide whether you can login or not.
And another good Login Control comes from Microsoft asp.net since 2.0. For sample, you can refer this:
Why not just use the asp.net login control? Its all done for you. There is even a way (which I can't remember off the top of my head) to integrate the database tables, views and stored procs in any sql server database instead of the default database in
the data folder.
helpmee
0 Points
3 Posts
simple program using asp.net with sql server 2005
Jan 29, 2013 03:58 AM|LINK
i need a simple login page with asp.net(c#) to connect with sql server 2005
Hiren Chavda
Member
104 Points
20 Posts
Re: simple program using asp.net with sql server 2005
Jan 29, 2013 04:50 AM|LINK
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: simple program using asp.net with sql server 2005
Jan 30, 2013 11:53 PM|LINK
Hi,
You can just:
1) Put two textboxes onto the WebForm, one of which is called "TextBox1", while the other is "TextBox2" for username and password.
2) Then put a button called Login.
3) In the button's click event, please use SqlCommand to check whether the username and password from the two textboxes are right or not. To decide whether you can login or not.
And another good Login Control comes from Microsoft asp.net since 2.0. For sample, you can refer this:
http://www.asp.net/web-forms/videos/building-35-applications/login-controls
mikener
Member
534 Points
238 Posts
Re: simple program using asp.net with sql server 2005
Jan 31, 2013 12:03 AM|LINK
Why not just use the asp.net login control? Its all done for you. There is even a way (which I can't remember off the top of my head) to integrate the database tables, views and stored procs in any sql server database instead of the default database in the data folder.