Multipage web app with multi SQL tables.
Posted on 2008-10-20
.Net experts out there, what do you guys do when you're building a multi-page web form and wiring it to a SQL database? Please help. This is my first major project and I am at a loss here. Sorry, I'm a newb. Oh and I have a table for each page. So like the first page is called demographics.aspx and it dumps to a table called Data_Demographics; the second page is called employment.aspx and dumps to a table called Data_Employment. So I'm creating what I call a "Token" like this:
Private Function CreateUserID() 'or could be called CreateToken()
Dim str As New StringBuilder(Left(tbLastName.Text, 3))
Dim currentDate As Date = Now
Dim [ReturnValue] As String
[ReturnValue] = str.ToString.ToUpper
And that's how I would like to keep track of each user in the database if possible. Can anyone out there help me out or have a better suggestion?
Very much appreciated in advance.