VB.NET RSS VB.NET RSS

Using Select Statement to retrieve data from SQL Server 2005 database

Please support our VB.NET advertiser: Intel Parallel Studio Home
Reply

•
•
Join Date: Nov 2008
Posts: 3
Reputation: Ugochukwu is an unknown quantity at this point 
Solved Threads: 0
Ugochukwu Ugochukwu is offline Offline
Newbie Poster

Using Select Statement to retrieve data from SQL Server 2005 database

 
0
  #1
Nov 22nd, 2008
Please friends am working on a project in which am trying to make it possible that when the first letter/alphabet of a name is keyed into a textbox linked to a search button and when the search button is pressed, all the names/rows begining with that first letter will appear in the Data Gridview provided for it.
Please i need the right SQL Select command statement to achieve this.You can also email me to brunosollozo42006@yahoo.com.Thank you!
Reply With Quote Quick reply to this message  
•
•
Join Date: Mar 2007
Posts: 305
Reputation: timothybard is an unknown quantity at this point 
Solved Threads: 25
timothybard's Avatar
timothybard timothybard is offline Offline
Posting Whiz

Re: Using Select Statement to retrieve data from SQL Server 2005 database

 
0
  #2
Nov 22nd, 2008
You will need to use the LIKE operator with the % wildcard. There's more information here:
http://www.techonthenet.com/sql/like.php
http://www.timothybard.com
http://www.oliveirabard.com
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the VB.NET Forum
Thread Tools Search this Thread



.net .net2008 2008 access account advanced application array basic beginner browser button buttons center click code combo cuesent data database datagrid datagridview date datetimepicker designer dissertation dissertations dissertationtopic excel exists fade filter forms ftp generatetags html images input insert intel internet listview map mobile module monitor msaccess net number objects open panel passingparameters pdf picturebox picturebox2 port position print printing problem regex right-to-left save search searchvb.net select serial settings shutdown socket sqldatbase sqlserver survey table temperature textbox timer timespan transparency txttoxmlconverter update user usercontol vb vb.net vb.netformclosing()eventpictureboxmessagebox vba vbnet visual visualbasic visualbasic.net visualstudio.net visualstudio2008 web winforms wpf wrapingcode xml year
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC