Sorting a Dataview and Finding

[Charles A. Lackman]

Hello
I have created a Dataview and have sorted it on the Date and ShiftNumber
columns
this works great, but when I want to use the Find Method it gives me the
following error:
Expecting 2 value(s) for the key being indexed, but received 1 value(s).

I have tried the following:

Dim Names(1) as Object
Name(0) = TheDate
Name(1) = txtShiftNumber. text
X = ADataView.Find( Names)

and

X = ADataview.Find( TheDate)

Any assistance will be greatly appeciated.
Thank,
Chuck

[Ken Tucker [MVP]]

Hi,

You need to enclose the date in #. Try this.

Dim Names(1) as String
Name(0) = string.format(" #{0}#",TheDate)
Name(1) = txtShiftNumber. text
X = ADataView.Find( Names)

Ken
-------------------
"Charles A. Lackman" <Ch*****@Create ItSoftware.net> wrote in message
news:OE******** ********@TK2MSF TNGP12.phx.gbl. ..
Hello
I have created a Dataview and have sorted it on the Date and ShiftNumber
columns
this works great, but when I want to use the Find Method it gives me the
following error:
Expecting 2 value(s) for the key being indexed, but received 1 value(s).

I have tried the following:

Dim Names(1) as Object
Name(0) = TheDate
Name(1) = txtShiftNumber. text
X = ADataView.Find( Names)

and

X = ADataview.Find( TheDate)

Any assistance will be greatly appeciated.
Thank,
Chuck

[Charles A. Lackman]

Thank You for you assistance but it did not work, I received an invalid cast
exception.

I am sorting the Dataview on two columns, I believe this is why it is
requiring two arguments for the sort. But when I try to give the Find to
arguments it underlines it.

I am sorting as such:
ADataView = New DataView(ADatas et.Tables("Temp "))
ADataView.sort = "Date, Shift"

If I do not sort and Date and Shift It works just fine Finding the Date:

X = ADataview.Find( TheDate)

It's the 2 parameters that is giving me the problem.

Chuck
"Ken Tucker [MVP]" <vb***@bellsout h.net> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..

Hi,

You need to enclose the date in #. Try this.

Dim Names(1) as String
Name(0) = string.format(" #{0}#",TheDate)
Name(1) = txtShiftNumber. text
X = ADataView.Find( Names)

Ken
-------------------
"Charles A. Lackman" <Ch*****@Create ItSoftware.net> wrote in message
news:OE******** ********@TK2MSF TNGP12.phx.gbl. ..
Hello
I have created a Dataview and have sorted it on the Date and ShiftNumber
columns
this works great, but when I want to use the Find Method it gives me the
following error:
Expecting 2 value(s) for the key being indexed, but received 1 value(s).

I have tried the following:

Dim Names(1) as Object
Name(0) = TheDate
Name(1) = txtShiftNumber. text
X = ADataView.Find( Names)

and

X = ADataview.Find( TheDate)

Any assistance will be greatly appeciated.
Thank,
Chuck

[Sijin Joseph]

This link
http://groups.google.com/groups?hl=e...3DN%26tab%3Dwg

suggests that the solution is to make sure that the order of the sort
keys and the values you are passing in the array should be the same, but
you seem to be doing that from what i see.

Sijin Joseph
http://www.indiangeek.net
http://weblogs.asp.net/sjoseph

Charles A. Lackman wrote:

Hello
I have created a Dataview and have sorted it on the Date and ShiftNumber
columns
this works great, but when I want to use the Find Method it gives me the
following error:
Expecting 2 value(s) for the key being indexed, but received 1 value(s).

I have tried the following:

Dim Names(1) as Object
Name(0) = TheDate
Name(1) = txtShiftNumber. text
X = ADataView.Find( Names)

and

X = ADataview.Find( TheDate)

Any assistance will be greatly appeciated.
Thank,
Chuck

[Cor Ligthert]

Charles,

You have to decide which methode you use.
For the "find: you need to add or have a primary key to your datatable.

http://msdn.microsoft.com/library/de...sfindtopic.asp

You can as well use the dataview.rowfil ter and the datatable.selec t
http://msdn.microsoft.com/library/de...ilterTopic.asp

Or the datatable select
http://msdn.microsoft.com/library/de...electTopic.asp

I hope this helps?

Cor

"Charles A. Lackman" <

Hello
I have created a Dataview and have sorted it on the Date and ShiftNumber
columns
this works great, but when I want to use the Find Method it gives me the
following error:
Expecting 2 value(s) for the key being indexed, but received 1 value(s).

I have tried the following:

Dim Names(1) as Object
Name(0) = TheDate
Name(1) = txtShiftNumber. text
X = ADataView.Find( Names)

and

X = ADataview.Find( TheDate)

Any assistance will be greatly appeciated.
Thank,
Chuck