there are many ways to do it, one of the inefficient way is to insert it in a loop
step1) first select the data from sql server 2008 and load it in datatable
step2) now run a loop
datatable dt = new datataable();
dt = obj_getdatatable("select * from tbl")
int i = 0;
while(!(i == dt.rows.count))
{
i++;
}
Messagebox.Show("Sucessfully Inserted..")
---------- another way is using bulk insert
---------