Row index

[Guest]

dir sir

I made a database contains a table named CONTACTS has the following attributes (Cont_id, Cont_Name, Address, Email, ...
In my application I have the value of the Cont_id, and I want to get the Index of the row(in the dataSet) that contains that Cont_i
(I`ve used OleDBDataAdapter and dataSet to connect to the database
How can I do that??!

thank
Mohamme

 

[Nicholas Paldino [.NET/C# MVP]]

Mohammed,

Unfortunately, there is not. You would have to cycle through the rows,
performing a comparison, and then noting the index of the row where you
found the values that matched.

Hope this helps.

--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

dir sirs

I made a database contains a table named CONTACTS has the following

attributes (Cont_id, Cont_Name, Address, Email, ...)

In my application I have the value of the Cont_id, and I want to get the

Index of the row(in the dataSet) that contains that Cont_id

 

[Bill P.]

Try this:

int contactId = 0;
DataRow dr = dataSet.Tables["Contacts"].Select(string.Format("Cont_di =
{0}", contactId))[0];

That should get you the DataRow that you are looking for, as for the index
of the actual row itself, there isn't a way to do it.

HTH,
Bill P.

Mohammed,

Unfortunately, there is not. You would have to cycle through the rows,
performing a comparison, and then noting the index of the row where you
found the values that matched.

Hope this helps.

--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

dir sirs

I made a database contains a table named CONTACTS has the following

attributes (Cont_id, Cont_Name, Address, Email, ...)

In my application I have the value of the Cont_id, and I want to get the

Index of the row(in the dataSet) that contains that Cont_id

(I`ve used OleDBDataAdapter and dataSet to connect to the database)
How can I do that??!!

thanks
Mohammed