database problem

i have 2 database tables and want the primary key from table 1 to appear in table 2. The tables are connected to two web forms, so in other words, the user enters personal details into form1 which is sent to table1..then the user enters company details into form 2 which is sent to table 2, the trouble is, is that at the moment there is no way of telling which personal details relate to which company details...

any ideas?

When you direct users to form 2, send a parameter: Response.Redirect("Form2.aspx?ID=" + ID.ToString())

Alternately, if users login, then you have some way to identify which user is logged in (User.Identity.Name will likely have some useful information on who the user is). Another alternative is to use a session variable.

|||

ok, how would that ...Response.Redirect("Form2.aspx?ID=" + ID.ToString())...store it in database table 2?

i dont understand how this works

Database otpion @ Client - Smart Client

Hello,

We are trying to develop a smart client application which is occasionaly connected. The issue here is we are unable to decide on the database which needs to be used in the client. We will not able to use MSSQL express or MSDE becuase of the size limitation. The size of the DB is actually a couple of gigs(SQL server backup). The user need not do any transaction which needs to be re recorded in server. The user will connect only to donwload data and get the application updates.

The other important factor the user should have high performance of the applciation

Please suggest

I'm not an expert on all of the SQL Express specifications, but according to this, the limit is actually 4GB, so maybe this would work for you:

Comparing SQL Server Express with MSDE

http://msdn2.microsoft.com/zh-cn/library/ms165672(SQL.90).aspx

Thanks,

Sararh

|||

Sorry. I must have told you...I will also have incremental update to the database..so everytime you update the database size is going to grow ...So it will easily cross 4 GB of data over a period of time ...