DbDataReader dr = DbHelper.ExecuteReader(CommandType.Text, "select * from Test1");
DataTable dt = new DataTable();
dt.Load(dr);
dr.Close();
SqlBulkCopy sbc = new SqlBulkCopy(AppSetting.GetInntoConfig().SqlConntring.ToString(), SqlBulkCopyOptions.UseInternalTransaction);
sbc.DestinationTableName = "Test1";
sbc.WriteToServer(dt);