VB.NET RSS VB.NET RSS

Using Select Statement to retrieve data from SQL Server 2005 database

Please support our VB.NET advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!
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: 304
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 30minutes 2005 2008 access account arithmetic array basic beginner browser button buttons center check code component connectionstring crystalreport cuesent data database databasesearch datagrid datagridview date datetimepicker design designer dissertation dissertations dissertationthesis dissertationtopic dropdownlist excel fade file-dialog filter folder forms ftp generatetags hardcopy html image images input insert intel monitor net networking open output panel passingparameters peertopeervideostreaming picturebox picturebox1 port printing problem problemwithinstallation project reports" searchvb.net select settings shutdown sqlserver survey tcp temperature text textbox timespan toolbox transparency trim updown user vb vb.net vb.netcode vb.netformclosing()eventpictureboxmessagebox vb2008 vbnet view visual visualbasic visualbasic.net visualstudio visualstudio.net visualstudio2008 web winforms wpf wrapingcode year
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC