topic Re: Search (VB.NET) in ArcGIS Explorer Desktop Questions

Search (VB.NET)

BrianLeroux — Wed, 30 Mar 2011 15:05:24 GMT

I am having an issue searching using VB.NET. I am using the following to search a file number but it needs to be entered exactly as in the table.

Dim SrchStr As String = "File_Numbe = " & SrchTxt

I want to be able to enter a patial number and give me the matching results. I have tried the following with no success. Any ideas?

Dim SrchStr As String = "File_Numbe LIKE % " & SrchTxt & "%"
Dim SrchStr As String = "File_Numbe LIKE '% " & SrchTxt & "%'"

Re: Search (VB.NET)

MargoBlosser — Wed, 30 Mar 2011 18:39:23 GMT

This has worked for me:
Dim whereClause As String = ("Situsall LIKE" + Space(1) + "'" + Tboxsearch.Text + "%" + "'")

Best Regards,

Margo

Re: Search (VB.NET)

BrianLeroux — Wed, 30 Mar 2011 18:55:14 GMT

Thanks Margo. Unfortunately it did not work.

Re: Search (VB.NET)

DonnaBest — Thu, 31 Mar 2011 13:58:33 GMT

Hi Brian -

Did you find a way to do this? I have a similar situation and thought Type Ahead functionality might do the trick.. so I'm investigating how to do that?

I know your post was a while ago, thanks for your time

Donna

Re: Search (VB.NET)

BrianLeroux — Thu, 31 Mar 2011 14:39:52 GMT

Donna- Actually this thread started yesterday. I think you were looking at my "joined date". Anyhow, I have still not found a solution and am still investigating.

Re: Search (VB.NET)

DonnaBest — Wed, 06 Apr 2011 11:40:39 GMT

Brian -

Hope this helps..it worked for me. Not much different from Margo's so I'm curious to see if it works for you as well..

             Dim StreetString As String = UCase(StreetSearch.Text)
             Dim BuildTable As Table = Table.OpenShapefile("C:\Maps\ArcGISExplorer\Intersections.shp")
            searchFilter.WhereClause = "STREET like'" + StreetString + "%'"

(I Was at your 'join' date - but I see where to find the post date now - thanks!)

Donna

Re: Search (VB.NET)

BrianLeroux — Wed, 06 Apr 2011 12:01:37 GMT

Donna-

That did not work for me. It allows me to search for an exact match put does not work for a partila match. ie- I can search for 1234 and find the file but if i try 12 it does not find 1234.

Thanks.
Brian

Re: Search (VB.NET)

BrianLeroux — Wed, 06 Apr 2011 15:46:32 GMT

Donna -

Good news. It did actually work. I had the old add-in stuck in cache and my updated code didn't go through. Thanks for your help..

searchCriteria.WhereClause = "File_Numbe LIKE'%" & SrchTxt & "%'"

Try
Dim rows As RowCollection = layer.Table.Search(searchCriteria)

Re: Search (VB.NET)

DonnaBest — Thu, 07 Apr 2011 11:27:02 GMT

Oh that's great! Reminds me to go read up a little on cache - so win-win!

Donna

Re: Search (VB.NET)

BrianLeroux — Fri, 08 Apr 2011 13:42:17 GMT

So my next problems with my Search Add-in..
1) The search is case sensitive and I would like it not to be. I was going to use UCase on the search string and the column data. However, since I am using table.search there is no select statement to use UCase on the column I am searching.

2) I would like to use LIKE in the where clause for my columns formatted as numbers. That would mean i need to CAST them as a string. As in the case of the issue abouve, since there is no select statement I can't perform a CAST on the field I am searching.

Any ideas are appreciated.

Re: Search (VB.NET)

DonnaBest — Mon, 11 Apr 2011 14:51:23 GMT

Hi Brian -

Sorry not to respond sooner - I was gonna test a little but haven't gotten there. I'll tell you about the next item I'm struggling with in a sec (smile).

A few random thoughts on your issue - I may be missing what you're saying -

1) So is the File number a text field? I used the UCase in a variable to set the case for the textbox input string, then referenced the variable in the search criteria. - we may be doing this a little differently. I'm using Table.OpenShapefile("path") which may be causing me more troubles.
2) If you have to convert (CAST is convert yes?), can you use the same method - converting in a string to a variable?
3) If the file number is numeric, would >+ or <= in the search string help?

My current headache: I need to sort on multiple columns in my datagridview. I'd like the datagridview to only have a few fields from the table and try to sort them that way, but I can't seem to get there from here.

Not sure I'm any help, but misery loves company, yes?

Happy Monday
Donna

Re: Search (VB.NET)

BrianLeroux — Mon, 11 Apr 2011 15:24:46 GMT

Donna,
The file number is text as it may contain letters. We just call it a number internally as it has always been called that. I am using a variable in the search and can do a UCase there no problem. My issue is that i need to convert the data i am searching through to UCase also and can not find a way to do that. The reason i need to convert is because this tool I am devoloping will not just search my file numbers but any field from any feature I have selected and that may include different cases for text fields.

looking at datagridview.fill I do not see any way to specify the columns. I would actually like to do this as well and was planning on looking into it further. I will let you know what i find.

Re: Search (VB.NET)

DonnaBest — Mon, 11 Apr 2011 19:46:58 GMT

Brian -

I've found that in order to sort multiple columns I have to use IComparer and found a function. But it only works with String fields, so I have to figure out how to Cast or convert the value of the two numeric fields I want to sort to strings - you've had the same problem yes?

Meanwhile, I had a hard time finding how to specify the fields with the datagridview autogenerated. Haven't looked into setting autogenerate = False. Will let you know what I find as well.

Thanks
Donna