Go4Expert (http://www.go4expert.com/)
-   ASP (http://www.go4expert.com/forums/asp/)
-   -   Writting to a database (http://www.go4expert.com/forums/writting-database-t4234/)

CaJack 9May2007 01:18

Writting to a database
I have a database with a table called CDTest and the fields CDName, CDPrice, DateAdded and UName. I’m having trouble with my code, I cant quite figure out whats wrong and I was hoping someone could help. Its supposed to take CDIDString and find a match in the database and allow the user to update CDPrice and UName. Here’s the code…


Dim cnn As Data.SqlClient.SqlConnection
Dim cmd As Data.SqlClient.SqlCommand
Dim param As Data.SqlClient.SqlParameter
Dim strSQL As String
strSQL = "Insert Into CDTestTBL(CDPrice, UName) Values(@CDPrice, @UName) WHERE CDID = '" & CDIDString & "'"
Dim conn As String
conn = "Data Source=.\SQLEXPRESS;AttachDbFilename=""|DataDirectory|\aspnetdb.mdf"";Integrated Security=True;User Instance=True"

cnn = New Data.SqlClient.SqlConnection(conn)
cmd = New Data.SqlClient.SqlCommand(strSQL, cnn)

param = New Data.SqlClient.SqlParameter("@CDPrice",Data.SqlDbType.VarChar)
param.Value = CDPriceString
param = New Data.SqlClient.SqlParameter("@UName",Data.SqlDbType.VarChar)
param.Value = UNameString


An error appears when I run the code saying “Incorrect syntax near the keyword 'WHERE'.” and points to…

Could anyone lend a hand?

pradeep 9May2007 10:01

Re: Writting to a database
Where have you defined CDIDString?? An empty CDIDString has caused this..

CaJack 9May2007 18:19

Re: Writting to a database
I fixed it now. You right I hadnt passed anything to CDIDString. I've also changed the SQL statement from insert to update.

All times are GMT +5.5. The time now is 00:42.