[02/03] inserting data in database
i'm trying to create new user in my application. Data would be enter in sql server 2000.
personal info of that user would be in one table while login info would be in separate table.these are present on a single web form. Also in both tables; userId is present and these are related with each other through it, if one is entered other should be automatically inserted. now i'm confused how to insert this data?
Re: [02/03] inserting data in database
Create a stored procedure which will insert the data into both tables inside a single transaction.
Then, call the stored procedure from your code passing the parameters it needs in.
Read this tutorial for how to use ADO.NET
http://samples.gotdotnet.com/quickst...teCommand.aspx