Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB.NET
|
VB.NET General VB.NET discussions for issues that don't fall into other VB.NET forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 19th, 2006, 09:04 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

hi there.. if userid and password are string (or char) types shouldn't be surrounded by ' ?????

i mean...

"insert into login (UserId, Password) values ('@UserId', '@Password')"

HTH

Gonzalo
 
Old September 19th, 2006, 12:46 PM
Authorized User
 
Join Date: Aug 2006
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to amit_mande@yahoo.com Send a message via AIM to amit_mande@yahoo.com Send a message via MSN to amit_mande@yahoo.com Send a message via Yahoo to amit_mande@yahoo.com
Default

No no,Values of userid and password r taken from textboxes txtUserName.text and txtPassword.text

 
Old September 19th, 2006, 01:04 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

again..

char values should be between ' when you pass it in a query... it doesn't matter how you build the query...

HTH

Gonzalo
 
Old September 21st, 2006, 10:38 AM
Wrox Author
 
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

Quote:
quote:Originally posted by gbianchi
 again..

char values should be between ' when you pass it in a query... it doesn't matter how you build the query...

HTH

Gonzalo
yes, agreed.

--Stole this from a moderator

I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.





Similar Threads
Thread Thread Starter Forum Replies Last Post
How to insert a value into database? [email protected] VB.NET 1 September 12th, 2006 01:35 PM
Can't insert into database chrscote Classic ASP Databases 1 June 15th, 2005 04:07 AM
Insert a record into a Database ersp Classic ASP Basics 3 May 9th, 2004 08:50 PM
How to insert new redord into a Database? ersp ASP.NET 1.x and 2.0 Application Design 1 May 9th, 2004 12:59 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.