Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Select statement in VB.NET for SQL Mobile not working... works in Query Analyzer

Posted on 2009-07-14
2
445 Views
Last Modified: 2013-12-05
I can run the following statement in Query Analyzer and get the result I am looking for.  However, when I run it in VB.NET, I get no results.  Why?

SELECT STR_NAM From LocID Where STR_NAM like '%ROAD%'
Public Shared Function GetLocs() As DataSet
 
        ' Return set of locations based on search criterion entered on LocInqScreen
 
        ' Create a connection to the Mobile SQL database
        Dim PAConnection As New SqlCeConnection
        PAConnection.ConnectionString = "Data Source =""Program Files\HTE_Apps\CT Database.sdf"""
 
        ' Define a Query and Adapter to select this screen's controls from the database
 
        'Define select string
        Dim SelectLocs As String = "SELECT STR_DIR as DIR, STR_NUM as NUM, STR_NAM as STREET, STR_SFX as SFX, CITY, STATE, ZIP, LOC_ID From LocID Where"
 
        'Define select string for each search criteria entered
 
        'Street Name
        If LocInqScreen.gSTR_NAM > "" Then
            SelectLocs = Trim(SelectLocs) + " STR_NAM like '%" + Trim(LocInqScreen.gSTR_NAM.ToString) + "%' "
        End If
 
        Dim adapter As SqlCeDataAdapter = New SqlCeDataAdapter(SelectLocs, PAConnection)
 
        ' Initiate a Dataset to contain the table returned
        Dim result As New DataSet
 
        'Fill the dataset
        PAConnection.Open()
        adapter.Fill(result, "LocID")
        PAConnection.Close()
 
        ' Return the dataset
        Return result
 
    End Function

Open in new window

0
Comment
Question by:gregdoyon
2 Comments
 
LVL 15

Accepted Solution

by:
JackOfPH earned 500 total points
ID: 24855636
Try this one...

Trim(SelectLocs) & " STR_NAM like '%" & Trim(LocInqScreen.gSTR_NAM.ToString) & "%'"
0
 

Author Closing Comment

by:gregdoyon
ID: 31603519
Solved the problem
0

Featured Post

Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I will show you HOW TO: Perform a Physical to Virtual (P2V) Conversion the easy way from a computer backup (image).
Learn how to PXE Boot both BIOS & UEFI machines with DHCP Policies and Custom Vendor Classes
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question