acquire data from tables

Question

hello!
i want i create a link button when user click on that button it should do the following works.
1. get the user name and email id from one database table and save it in another table. the data base is same for both of the tables. please tell me how is it possible

Krishna Garad · Accepted Answer

Execute the query in linkbutton_click event to do this task. you can write sql query like this
Insert into Table2(Username,EmailId)select UserName,EmailId From Table1.