drasbeboslip
New Member
Ok how would i add records doing the following:<BR>1.I run a stored procedure and collect data across many tables in the database<BR>2. business rules modify data<BR>3. The modified data needs to be added to a table that stores the data.<BR><BR>How should i go about doing this?you will need to put the data in a dataset... then you can manipulate it anyway way you like and write it to a new table in the dataset , then bind a control such as a datagrid or list to that dataset table and there you gook right now, the stored procedure fills a dataset. But i want to fill another table with the modified data.no problem... a dataset can hold as many tables of data as you want so just write it back to the same dataset calling the table a new namebut what are the methods, properties... like how do i loop thru the dataset? how do i read, assign values in a dataset?