Using vb.net 2003 my command works as under
mySearchString = "Select * from tblEmployee" & " where Lastname = ' " & txtLastname.text & " '; "

but i want to use like operator instead of equals and it doesnt work with * (wildcard character)
mySearchString = "Select * from tblEmployee" & " where Lastname like ' " & txtLastname.text & " ' & * & ; "

I have tried to put * with various delimeters but none works. Greatly appreciate some help


Yasho

yvk




yvk

__________________
yvk

I have finally solved the problem
Here is the solution

Select command shall look like this
"Select * from tblEmolyee " & " where lastname like '" & searchname & "%' "

I am just a beginner so the following statemnts shall be accepted with a grain of salt by other my kind of programmers.

I invite and would greatly appreciate if GURU'S make a statement so other poeple with my kind of limitations dont get a erroneous suggestion from me
The problem I was having with was placement of % (wild character) and spaces.
spaces in the statement text are accepted by VB.net as actual spaces in commandtext
therefore program was reading my statement as "SearchName(space)then %
or it was not finding a match

Yasho


yvk

String concatenation the way you are doing it is not recommended (I'm not sure why more samples or instructional material don't provide the better way of doing it). Instead of chains of strings, use the String.Format() method. It makes for much more readable (and supposedly more efficient) string construction code. You can break it up any way you like depending on the complexity.

In your example:

mySearchString = "Select * from tblEmployee where Lastname like '{0}%';"
string.Format(mySearchString, txtLastname.text);

The {0} is a replacement token. First argument to Format() is the "formatting string" containing the token. The subsequent argument(s) are the replacement values corresponding to the indexed tokens ({0} {1} {2} ...). The method also supports formatting the values you pass in.

myString = string.Format("Tax: {0:C}", dblTax);

This will place the value from the double 'dblTax' into the string, formatting it as a currency.

Visit MSDN for more:
http://msdn2.microsoft.com/en-us/lib...ng.format.aspx

-Peter