Logins

[kakas]

Greetings.......

I am working on a website in ASP.net 2.0.(using Visual Web Developer Express Edition and SQL Management Studio) I am also utilizing a SQL DB to store all my data. The website should enable students to view courses from a course list and select courses they want to register. I have created the aspx pages to enable the students to view the course list. Now the problem i am having is how to make my application distinguish which specific user is currently logged in and grab their unique Student_ID and supply it to a stored procedure to add their selected courses to the StudentCourses table that stores what student is registered to what class?

[Frinavale]

Greetings.......

I am working on a website in ASP.net 2.0.(using Visual Web Developer Express Edition and SQL Management Studio) I am also utilizing a SQL DB to store all my data. The website should enable students to view courses from a course list and select courses they want to register. I have created the aspx pages to enable the students to view the course list. Now the problem i am having is how to make my application distinguish which specific user is currently logged in and grab their unique Student_ID and supply it to a stored procedure to add their selected courses to the StudentCourses table that stores what student is registered to what class?

Look into Forms Authentication.
It's really pretty easy to do.

To get you started I recommend you watch this video found on this site.

I'd also suggest looking up forms authentication in the MSDN Library. It contains a lot of useful information and tutorials etc.

Hope this gets you pointed in the right direction :)

-Frinny

[kakas]

Finny,

Thanks for your response, i have watched the video, it was very informative but it didn't help me becuase the users and roles he creates in the video have no relationship to the users in my Students table. How can i link the user in the ASP Membership tables and the users in my student table?
I about to read the other website it looks very promising.
Thanks
kakas

Look into Forms Authentication.
It's really pretty easy to do.

To get you started I recommend you watch this video found on this site.

I'd also suggest looking up forms authentication in the MSDN Library. It contains a lot of useful information and tutorials etc.

Hope this gets you pointed in the right direction :)

-Frinny

[Frinavale]

Finny,

Thanks for your response, i have watched the video, it was very informative but it didn't help me becuase the users and roles he creates in the video have no relationship to the users in my Students table. How can i link the user in the ASP Membership tables and the users in my student table?
I about to read the other website it looks very promising.
Thanks
kakas

Somehow I knew you were going to ask this.

There is a way to create a custom MembershipProvider and MembershipUser that you can implement to utilize your own DataBase store.

All you really have to do is create the classes that Inherit the MembershipUser or MembershipProvider and build upon this.

I was able to implement a custom Provider and User in a couple of hours..from knowing nothing about membership. It's quite easy. Check out what MSDN has on Membership and these classes for more information on how to do this. They have excellent examples on how to create your own Membership classes.

Keep me updated on your progress.

-Frinny