Hello, I want to be able to use SQL to create lots of 'added' rows in a datatable.
e.g. to create a single row I can execute "Select 1,2,3,4" and then map it to the 'Table' in a dataset....using a dataadapter. This works but it's datarowstate is 'unchanged'....so if I write it back to the database, I expect nothing will happen. I assume I need to change it's datastate to 'added'....and then when I write it back it will be added to the database table. RowState is readonly though. hmmmmm. can you help. =================================== This list is hosted by DevelopMentorĀ® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com