Edit data in a dataset datatable column automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my datatable I have a column of decimal values. I would like to edit any values in this column so that all values < 0 are set to 0, prior to updating my sql database. Any ideas on how I can achieve this

Many thank

Homer
 
Hi,
i hope you mean check column data in your datatable (dataset) beforu you
update sql database.
So you can handle event of datadapter (updating) where you can finally set
(and/or check) all values in your colums...

--

Pavel KOHOUT
Advantage Solutions, Ltd.
www.advantages.cz




Homer said:
In my datatable I have a column of decimal values. I would like to edit
Click to expand...
any values in this column so that all values < 0 are set to 0, prior to
updating my sql database. Any ideas on how I can achieve this?
 
You must log in or register to reply here.

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

Edited datatable values in dataset not persisted? 1
How to set DataTable columns value automatically when saving? 3
Combining and relating DataTables from different typed DataSets in 1
DataTable Load Issue 6
strongly typed dataset update with identity column 6
Designing a Dataset 1
Existing algorithm for merging DataSets after GetChanges() and withidentity column? 1
Clear a datatable before inserting new records 7

Back
Top