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: 306
Reputation: timothybard is an unknown quantity at this point 
Solved Threads: 26
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



"crystal .net .net2008 2008 access add advanced application array assignment basic beginner box browser button buttons center click code combo convert cpu cuesent data database datagrid datagridview datetimepicker designer dissertation dissertations dissertationtopic dosconsolevb.net eclipse editvb.net employees excel exists firewall forms html images isnumericfuntioncall listview map math memory mobile module msaccess mssqlbackend mysql navigate net number opacity open pan pdf picturebox picturebox2 port print printpreview record regex reuse right-to-left save search serial settings socket sorting sqldatbase sqlserver storedprocedure temp textbox timer timespan transparency txttoxmlconverter upload useraccounts usercontol vb vb.net vb.nettoolboxvisualbasic2008sidebar vba vbnet vista visual visualbasic visualbasic.net visualstudio.net web wpf wrapingcode xml
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC