insert data in two tables from form
I have two tables one for usernames and second for userdetails,
Users
_________________________
|ID (PK)| Usrname | PSW |
---------------------
|1 | User | P@sw|
-------------------------
Details
__________________________
|ID (FK)| firsn | Last_n |
--------------------------
| 1 | Test | Users |
--------------------------
Tables are related.
How can I write ASP.net stored procedure to insert data to both tables. So when new user registers and gives his username, password, first name and last name the data would insert into right tables.
|
