473,394 Members | 1,750 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

How to get RowID from DataRowChangeEventArgs?

I see it as private in e.Row._rowID. is there a way to get this from
DataRowChangeEventArgs?

Thanks,
Brett

Jul 17 '06 #1
1 4239
Hi Brett,

DataRowChangeEventArgs does not provide a strong-Typed Row reference. If
you have a strong-typed DataSet with a column named "_rowID" then you can
either cast e.Row to the Type of your DataRow and access the column as a
property:

MyDataRow row = (MyDataRow) e.Row;
int id = row._rowID;

// TODO: work with id
or use the DataRow indexer:

DataRow row = e.Row;
object id = row["_rowID"];

// TODO: work with id
- Dave Sexton

"Brett Romero" <ac*****@cygen.comwrote in message
news:11**********************@75g2000cwc.googlegro ups.com...
>I see it as private in e.Row._rowID. is there a way to get this from
DataRowChangeEventArgs?

Thanks,
Brett

Jul 18 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: droope | last post by:
I am trying to retrieve the rowid from a datatable without any success. When in the immediate window I can look at the rowid value, ex: ?DataSetName.Tables(0).Rows.Find(SearchValues).RowId ...
4
by: Corrine | last post by:
Hi, I am creating a global temporary table that is session-specific. I insert a BLOB into this table, and then select the BLOB from this table into a ResultSet. The ResultSet sees this BLOB...
2
by: tracy | last post by:
when i run the statement: SQL> select rowid from student_semester; ERROR at line 1: ORA-01445: cannot select ROWID from a join view without a key-preserved table student_semester is a view...
2
by: captain | last post by:
hi, Want to count rowid. One row by one row and on each do a calculation and than go to next or previous row. In oracle it is Rowid, wonder how to do in SAS for going by row. e.g. in Oracle...
2
by: Scott Holland | last post by:
OK. I have a problem and need some help from DB2 Gurus. In ORACLE, I have a trigger which fires on an update event, sending the ROWID and TRANSACTION_ID via a pipe to my application. The...
3
by: TP | last post by:
Can someone please explain or provide examples of how to use ROWID in DB2 on Z/OS. I am using v7.1.1. Here is the table I created with the ROWID column. CREATE TABLE XXX.EMP_PHOTO_RESUME1 ...
0
by: UJ | last post by:
I have a datatable that I want to display the first 10 records, then display the next 10 records, and so forth. I'm storing the dataset in a session variable because as the user makes changes, they...
2
by: arivudai2 | last post by:
Hello, I am doing a migration of db from informix to db2.In informix there is a query with rowid.The same query with rowid is not working for DB2.Can anyone help me in this regard. for Ex. ...
0
by: kaapie | last post by:
Oracle does not know which table's rowid to return from this view and thus it gives an error. What this means is that one of the underlying tables in the view has to have either a primary key or...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.