i`m totally new to vb actually.now using vb express 2008.i`m currently trying to create log in function.basically, i`m already create database (database in vb 2008 itself) for login,which the login table contain 3 columns, Username, Password and Designation.example : Username -- Password -- Designation
jack -- 123abc -- consultant
jane -- lovely -- project manager
matt -- mummy -- consultant
anna -- pass12 -- system admin
At the form design, i put textbox control for username and password, and combobox for designation.
1. The thing is, how can i make validation from user input when login, to the data that stored in the login table?
2. How can i display only certain list in the designation combobox?because, i did set the"DataSource" at the property as connected to the column designation,but its display consultant 2 times.what i need is,to display - consultant,project manager,system admin and client.
I do need designation in login because different personnel will go to different page.
Sorry for the wordy questions.I hope you guys can help me. Thanks.