hi im new to vb.net and i was wondering if anyone can help me. i have a backend database in sqlserver2000, and a windows form developed in vb.net to access the data. i need a login script so only a selective few users can access the application.

 I have a table in my database called 'login' which has username and password fields.

thanks

Hello,

Just have a user ID/password form that loads up first. User types userid/password in, you verify against the database, and then open up the application form and close the login form.

Brian

yeah but i cant do the coding any ideas anyone?

What do you mean you can't do the coding? What are you looking for us to help with? Please be more specific.


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

i understand that i have to verify the userid's and the passwords against the database, but i dont understand how to do this. if i can see some code then i will grasp the idea and take it further

I truly suggest you go to google.com and search for something like "Database Authentication .NET". It will come up with many examples of what your talking about.

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

ive looked on google for examples all tht i can find is examples implemented in asp.net, im doing a vb.net standalone application its not web related

The functionality is the same- you just need to change the login page from a webform to a winform.

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

if i am to use asp.net code to do this login function, when starting up studio.net do i need to open a new asp.net application or windows application. by the way users are required to enter information via a winform

Obviously, you need a Windows application if you need Windows Forms. What Hal is referring to is the code behind the logic and forms. For a task like this, you need some ADO.NET code that passes the username and password to a database and performs the validation. That part is identical in Windows Forms and Web Forms, so you should be able to reuse most of the code. Also the way you retrieve the username and password from the forms could be identical (e.g. string name = txtUserName.Text)

I think you need to look a little harder. Searching Google for "windows forms" login brought back a very useful list of links.

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Eurochild by Massive Attack (Track 7 from the album: Protection) What's This?