DataRowCollection.Find

[Scott Adams]

When calling the Find function of a DataRowCollection, one has two options:

Overloads Public Function Find(ByVal key As Object) As DataRow
or
Overloads Public Function Find(ByVal keys() As Object) As DataRow

This function is easy to use if the primary key of your DataTable consists
of only one field. How can you use the Find functions if the primary key
consists of two database fields (composite key)?

Thanks in advance,

Scott Adams

[Jonathan Mast]

Scott,

You want to use the second implementation of this method.

A code sample can be found in the MSDN library:
http://msdn.microsoft.com/library/de...findtopic2.asp

Basically you pass in an array of objects that contain values that you want
to find in the DataTable's primary key columns.

You may also have to set the Primary Key property of your DataTable from
which the DataRowCollection is coming.

A code sample for this can also be found in MSDN library:
http://msdn.microsoft.com/library/de...rykeytopic.asp

Hope it helps.

--
Cheers,

Jonathan

"Scott Adams" wrote:

When calling the Find function of a DataRowCollection, one has two options:

Overloads Public Function Find(ByVal key As Object) As DataRow
or
Overloads Public Function Find(ByVal keys() As Object) As DataRow

This function is easy to use if the primary key of your DataTable consists
of only one field. How can you use the Find functions if the primary key
consists of two database fields (composite key)?

Thanks in advance,

Scott Adams

[Scott Adams]

Great. That was the key <no pun intended>. Thanks!

Scott
"Jonathan Mast" <jm***@lucruminc.com.dontspammeplease> wrote in message
news:4B**********************************@microsof t.com...

Scott,

You want to use the second implementation of this method.

A code sample can be found in the MSDN library:
http://msdn.microsoft.com/library/de...findtopic2.asp

Basically you pass in an array of objects that contain values that you
want
to find in the DataTable's primary key columns.

You may also have to set the Primary Key property of your DataTable from
which the DataRowCollection is coming.

A code sample for this can also be found in MSDN library:
http://msdn.microsoft.com/library/de...rykeytopic.asp

Hope it helps.

--
Cheers,

Jonathan

"Scott Adams" wrote:

When calling the Find function of a DataRowCollection, one has two
options:

Overloads Public Function Find(ByVal key As Object) As DataRow
or
Overloads Public Function Find(ByVal keys() As Object) As DataRow

This function is easy to use if the primary key of your DataTable
consists
of only one field. How can you use the Find functions if the primary key
consists of two database fields (composite key)?

Thanks in advance,

Scott Adams