Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

vb.net ado.net know first value of table rows

Posted on 2010-11-09
7
Medium Priority
?
347 Views
Last Modified: 2012-05-10
I have a table but i need modify/delete some times each row value, how can know the value originally in each row.
0
Comment
Question by:rflorencio
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 42

Expert Comment

by:sedgwick
ID: 34092682
can u elaborate the question?what do u mean by "how can know the value originally in each row"?
0
 
LVL 53

Expert Comment

by:Dhaest
ID: 34092797
For a datatable in .net: Getting Specific Versions of a Row
http://msdn.microsoft.com/en-us/library/7kd9zhee(vs.71).aspx
0
 

Author Comment

by:rflorencio
ID: 34093243
for ex i load a row from sql table:
credit=500
after credit row can have many values like 200/, 39, ....
and last i need to know the first value in row, in this case 500
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 53

Expert Comment

by:Dhaest
ID: 34093354
So you want the first row of the data you retrieve ?

DataTable.Rows(0)
0
 

Author Comment

by:rflorencio
ID: 34093450
no, my example consider is ever the same row. if same row change value, i need know original value in this ex. 500
0
 
LVL 53

Accepted Solution

by:
Dhaest earned 2000 total points
ID: 34093615
See the link I provided earlier ...

For a datatable in .net: Getting Specific Versions of a Row
http://msdn.microsoft.com/en-us/library/7kd9zhee(vs.71).aspx
0
 

Author Comment

by:rflorencio
ID: 34093882
I can get the DataRowVersion.Original at any time, even after is changed.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to create and use a custom WaterMark textbox class.  The custom WaterMark textbox class allows you to set the WaterMark Background Color and WaterMark text at design time.   IMAGE OF WATERMARKS STEPS Create VB …
If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question