i want to insert one table data to another table using asp.net c#.

hi
i have one table so i want to insert 1st table data id and username to same id and username to another table... using asp.net c#...
trieve from one table and insert in to another... in one stored procedure..

thanks advance..