can anyone show me to login page code?? i did my registration code already.. now i need the login page the userid and pword read from my database access then the user can log in to another page.. i need the whole code. as simple as possible.. thankyou very much. this is my asp.net assignment.. im very weak in asp.net.. pls help.. tq.. im doing dvd rental assignment..

im using asp.net 1.1 and microsoft access 2003

Use this code
<script runat="server">
void button_click(Object s, EventArgs e)
{
if (ds_user.RecordCount == 1)
{
Response.Cookies["ckuser"].Value = txtusername.Text;
Response.Cookies["ckuser"].Expires = DateTime.Now.AddDays(1);
Response.Redirect("home.aspx");
}
}
</script>

You can fill the Dataset "ds_user" with this valid user check result. This will have 1 record if the username and password matches

Query to validate the user name and password is:

SELECT user_id, user_name, user_pwd
FROM tbl_users
WHERE user_name = @user_name AND user_pwd = @userpwd

You can also use the windows authentication by using (AuthenticatioMode = Windows) in app.config file

omg... i dun understand.. but wat i wan is the userid and pword textbox is read from my microsoft access database..let say my database name user_details.mdb
if userid and pword match wif access database redirect to home.aspx if not match error.. wait should i do?? i really dunno how to code this login page... can teach me step by step? or create the login page for me??

It does not matter what Database your are using. Even if you are using the logic will remain the same. But the only thing that would change is the Database connection string. You can use OLE_DB to connect to the Access Database and then do the rest of the task.

Connection string would be something like this for Access:
Dim strConn as string = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath "user_details.mdb") & ";"

so the code should be

urm the top should
import.xxxx
<script runat="server">
Dim strConn as string = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath "user_details.mdb") & ";"

void button_click(Object s, EventArgs e)
{
if (ds_user.RecordCount == 1)
{
Response.Cookies["ckuser"].Value = txtusername.Text;
Response.Cookies["ckuser"].Expires = DateTime.Now.AddDays(1);
Response.Redirect("home.aspx");
}
}
</script>

like this???

yes and then you need to open the Dataset also when the users clicks on submit. ie; "ds_user"
For web applications it is recommended to use Data Readers instead of Data Sets.

binoj_daniel do u have msn?? or email?? can u help me create my login page.. i wil send u my project to u.. or i can ask you question thru msn.. coz my pc is slow.. can't open too many application... :)

This article has been dead for over six months. Start a new discussion instead.