Best way to update data

S

Sorin Sandu

What is the best way to manipulate data (insert and update) in a aspx page ?
I want to inset and update some data and I can't do it in SQL Server.
I have to scan some tables and insert (or update) data in another table.
I've tried something whith datasets but it haven't something lihe a scan or
do while last record.
 
W

William Ryan eMVP

Sorin:

What do you mean by Scan? If you can't use SQL Server, what is the source
of data you are using and where are you trying to update it to? You should
be able to create one dataadapter for fill the data, make changes to it and
use another data adapter to update the data into the second source.

Does Scan mean a SELECT Statement?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best way of working with data 1
What's a best-practices way to perform an Insert/Update? 3
DataGridView / who to update tables with FKs 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
UPDATE Statement without WHERE 9
Strongly Typed DataSets and "Refresh the data table" Option 6
Edited data record to be inserted as a new data record under the same PO number in Microsoft Access 0
what's the best approach to follow for sql execute 2

Top