How to check entered data in SQL using ASP.NET 3.5 & VB

[premMS143]

I'm having idea in VB 6.0 & HTML. Based on this trying to build a simple web application using ASP.NET 3.5, VB as code behind & SQL 2000 for database.

Here, I got one doubt.
In the Login Form, when the user enters his username & password, Computer has to search whether both these fields matches to the filedz present in which it is stored in UserLogin table (SQL 2000 )

How to perform this...?

[manmadhan]

u need query or how to perform that query ?

[joshuab]

Hi Prem...

To check or retrieve the data from the database(ie in your User Login table)
you must know about the connectivity ie., ADO.NET.

If you know well enough then just include those coding.

Joshua

[Frinavale]

Check out the articles on how to use a database in your program part I and how to use a database in your program part II.

-Frinny

[premMS143]

ThanQ Sir.

I got idea.

Now the question is;

I've several user types, like Admin, Student, Parent, Coordinator etc.

Each user type has having certain limitations of form usage.
For ex:
Admin - user is having full rights to add, delete, modify the contents.
Student - user is having only to view report & attendance, but no control to modify.

Depending on particular user type login, I've to display web page by enabling/disabling certain features. How to do this...?

[Frinavale]

Sounds like you need to research Authentication and Authorization.
There are a number of ways to achieve this.

My preference is to use Forms Authentication. I think that you will be most interested in using this type of authentication as well because you are using your own database to store user information.

-Frinny