I am developing a project in ASP.Net using C#. I don’t know how to take data from other table (SQL database) in the same project and save the data into another table using C#. Let say that I have two table that is registration and user. In the registration table, there have metric_number and in the user table, there have user_id. I want to take the data from metric_number in registration table and copy it into user_id in user table. When user click the Save button from the interface after fill other user data, it will copy and save the metric_number into the user_id for that current user. So, user no need to fill the user_id. Before using the application, user must register as a user and the data will be saved in registration table. After register, they must login to use the application. How to do it using C# ? Please help me... thanks.