RSS Forums RSS
Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting

Beginner: Insert, Update, Delete & Search records from/to sql database

•
•
Join Date: May 2006
Location: Malaysia
Posts: 6
Reputation: sathiya is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
sathiya sathiya is offline Offline
Newbie Poster

Re: Beginner: Insert, Update, Delete & Search records from/to sql database

  #7  
May 10th, 2006
•
•
•
•
Originally Posted by campkev
what does your sql query look like?

Dim cmd As New SqlClient.SqlCommand("Select * from Staff where NRIC = '" & txtSearch.Text & "'", New SqlClient.SqlConnection(strConn))


The query should look like this when it runs:

Select * from Staff where NRIC = '840225-145035'

and I have a record sitting on the db. Thank you
 
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 1:17 am.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC