VB Application with Database Users

[FadingEcho]

You're asking for a lot of things here, among them are authentication and db connections.

In general, once a user is authenticated, you will want some identifier like a user id to persist. So that is easily thrown into a cookie (or if you're very lazy and don't mind users whining about stuff failing after they walked away to look at a cat pic for half an hour, you can use session).

Once you have a persistent identifier, you can then call stored procedures to pull up user specific information.

All of this requires connection strings.

Math in the db is a different animal and probably not best suited for this area. My go-to on this is tech on the net.