Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2010-11-09
7
Medium Priority
?
351 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
  • 3
  • 3
7 Comments
 
LVL 42

Expert Comment

by:Meir Rivkin
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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses
Course of the Month6 days, 4 hours left to enroll

772 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