Solved

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

Posted on 2010-11-09
7
311 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: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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

930 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now