Go4Expert

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
 
Hi,
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…

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
cmd.Parameters.Add(param)
           
param = New Data.SqlClient.SqlParameter("@UName",Data.SqlDbType.VarChar)
param.Value = UNameString
cmd.Parameters.Add(param)

cnn.Open()
cmd.ExecuteNonQuery()
cnn.Close()

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

cmd.ExecuteNonQuery()
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 01:33.