TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
postmatt
NA
3
0
Using Access Database for Login authentication ?!?!
May 12 2005 9:38 AM
I am attempting to use C# in ASP.NET Webmatrix to connect to an Acess database and check for a users details to check they are members. I have managed to write the following but have no idea how much of it is correct, any asssistance would be welcome. string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("magazine.mdb"); OleDbConnection connection = new OleDbConnection(connectionString); connection.Open(); OleDbDataReader dataReader; OleDbCommand cmd = new OleDbCommand("SELECT * FROM Subscribers WHERE UserId='"username"' AND UserPassword='"password"'", connection); dataReader = cmd.ExecuteReader(); The username and password strings in the OleDbCommand line have been created as reading from a text input box on an html form.
Reply
Answers (
2
)
Help! Printing on large side (horizontally) on report page (on paper)?
Changing a Database Schema Programmatically