TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
ccundy
NA
1
0
Update Multiple DB Tables
Nov 2 2004 10:53 AM
I am loading a DataTable in a DataSet with data from an Excel spreadsheet. This works well. Now, without questioning the design of what I am trying to do, is there an easy way of updating several database tables with this data without copying the data to a new datatable using LoadDataRow or any other technique. The problem I am having is the RowState property is set to "Unchanged". This property is ReadOnly and will not update using the DataAdapter.Update method if the RowState is set to "Unchanged". Is this possible? Or am I stuck loading new dataset tables for each database table I want to insert the records into? In general, I am reading data from one datasource and trying to insert the data into a separate datasource without copying the data to a new datatable in the dataset. All suggestions will be appreciated?
Reply
Answers (
1
)
how to get the row count of a datagrid
Performance & best practices question????