Re: Search TextBox String

Tech-Archive recommends: Fix windows errors by optimizing your registry

So you want to do a partial match?
Are you using the SQL Like clause?
Here's more info:
http://www.techonthenet.com/sql/like.php
http://www.1keydata.com/sql/sqllike.html

--
I hope this helps,
Steve C. Orr,
MCSD, MVP, CSM, ASPInsider
http://SteveOrr.net


"Mike C" <MikeC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:A83B0899-4DCD-40FC-8778-E00DE6FEDF19@xxxxxxxxxxxxxxxx
I have an asp.net web page with a drop down box that populates the datagrid
on the change event. I have text box that I'd like to use to populate the
datagrid on the change event by matching the string values in the text box.
The code below works perfectly, but the string has to exaclty match the sql
table data source:

Dim _SqlAccounts As String = "Select * FROM IMSRejects WHERE
IMSRejects.VendorName = '" & strVendorName & "' ORDER BY VendorName ASC,
ProductDescription ASC"

I tried the variations below with no luck. Any thoughts? Thanks!!!

Dim _SqlAccounts As String = "Select * FROM IMSRejects WHERE
IMSRejects.VendorName = '%" & strVendorName & "%' ORDER BY VendorName ASC,
ProductDescription ASC"

Dim _SqlAccounts As String = "Select * FROM IMSRejects WHERE
IMSRejects.VendorName = '%" + strVendorName + "%' ORDER BY VendorName ASC,
ProductDescription ASC"

.

Relevant Pages

  • Re: Problems with Delete Command
    ... The SQL could get fairly messy if you need to construct it in code, ... ContactID, and WebComID, and create your on-the-fly SQL on that saved query, ... to find the list of ContactIDs from the junction table, ... This is a style/readability thing: if you are going to use string ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Need help with Code Please!!!
    ... posted in response to my last post was some SQL, but this is not the SQL that ... the actual string that gets built at the end of the SQ1 build process. ... The message says Syntax error in query expression ... Dim rs As Recordset 'object ref to qryCompany\USFNumber ...
    (microsoft.public.access.formscoding)
  • RE: Web Part and Access database
    ... I dont know if it is possible to connect to access,but you can download SQL ... Server Error in '/Webparts' Application. ... The connection string specifies a local Sql Server Express instance ... String user, String password, Boolean trusted, String connectionString) ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: INDEXES: BTRIEVE vs EXTFH (cobol)
    ... Bill Bach wrote: ... In SQL, you can specify just about anything, but at the lower MKDE ... the engine has to pick the right Btrieve ... When COBOL needs to find this value, it knows that the key is a string. ...
    (comp.databases.btrieve)
  • Re: INDEXES: BTRIEVE vs EXTFH (cobol)
    ... In SQL, you can specify just about anything, but at the lower MKDE ... the engine has to pick the right Btrieve ... When COBOL needs to find this value, it knows that the key is a string. ...
    (comp.databases.btrieve)