By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,234 Members | 1,869 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,234 IT Pros & Developers. It's quick & easy.

importrows from table from one connection to table in other connection (same structur

P: 1
Why is importrows not working in my code: dsportalresas is a dataset with 1 row from a connection and i want to copy these rows to another table (same structure) in another connection, i have no error but the rows are not imported:


Dim HotelConn As New SqlConnection(HotelConnStr)
HotelConn.Open()
Dim HotelAdap As New SqlDataAdapter("select * from crs_reservations", HotelConn)
HotelAdap.Fill(dsHotelResas)

For Each dr As DataRow In dsPortalResas.Tables(0).Rows
dsHotelResas.Tables(0).ImportRow(dr)
Next

HotelConn.Close()
Sep 28 '12 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.