Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 13, 2012 01:04 AM by oned_gk
0 Points
7 Posts
Dec 12, 2012 09:47 PM|LINK
I am trying to use an update query with parameters to update data in the database but it isnt working. This is the code i am using for it:
sqlString = "UPDATE table SET field1 = @value1, field2 = @value2, field3 = @value3 WHERE field1 = @currentValue" dbCommand.CommandText = sqlString dbCommand.Parameters.AddWithValue("@value1", txtOne.Text) dbCommand.Parameters.AddWithValue("@field2 ", txtTwo.Text) dbCommand.Parameters.AddWithValue("@field3 ", txtThree.Text) dbCommand.Parameters.AddWithValue("@currentValue", lstListBox.SelectedValue) dbCommand.ExecuteNonQuery()
Can someone see any reason why that wont work? I can connect to and display data from the database and the sqlstring works when i hard code the values in for it, but it doesnt seem to work with the parameterized query.
Member
498 Points
118 Posts
Dec 12, 2012 10:15 PM|LINK
sqlString = "UPDATE table SET field1 = @value1, field2 = @value2, field3 = @value3 WHERE field1 = @currentValue"
dbCommand.CommandText = sqlString dbCommand.Parameters.AddWithValue("@value1", txtOne.Text) dbCommand.Parameters.AddWithValue("@value2 ", txtTwo.Text)
dbCommand.Parameters.AddWithValue("@value3", txtThree.Text)
dbCommand.Parameters.AddWithValue("@currentValue", lstListBox.SelectedValue)
dbCommand.ExecuteNonQuery()
Dec 12, 2012 10:22 PM|LINK
Uhh isnt that the exact same thing i have there already? I dont see anything different.
Contributor
3840 Points
749 Posts
Dec 13, 2012 12:42 AM|LINK
@ symbol is your BIND symbol and should not be part of the parameter name
dbCommand.CommandText = sqlString dbCommand.Parameters.AddWithValue("value1", txtOne.Text)
dbCommand.Parameters.AddWithValue("field2 ", txtTwo.Text)
dbCommand.Parameters.AddWithValue("field3 ", txtThree.Text)
dbCommand.Parameters.AddWithValue("currentValue", lstListBox.SelectedValue)
Dec 13, 2012 12:45 AM|LINK
Unfortunately that didnt solve the problem, it still didnt update the data.
All-Star
35808 Points
7313 Posts
Dec 13, 2012 01:04 AM|LINK
It seem you have not set proper lstListBox value
try this
sqlString = "UPDATE table SET field1 = @value1, field2 = @value2, field3 = @value3 WHERE field1 = @currentValue" dbCommand.CommandText = sqlString dbCommand.Parameters.AddWithValue("@value1", txtOne.Text) dbCommand.Parameters.AddWithValue("@field2 ", txtTwo.Text) dbCommand.Parameters.AddWithValue("@field3 ", txtThree.Text) dbCommand.Parameters.AddWithValue("@currentValue", lstListBox.SelectedIndex.text) dbCommand.ExecuteNonQuery()
robgw3
0 Points
7 Posts
Problem with parameterized update query
Dec 12, 2012 09:47 PM|LINK
I am trying to use an update query with parameters to update data in the database but it isnt working. This is the code i am using for it:
sqlString = "UPDATE table SET field1 = @value1, field2 = @value2, field3 = @value3 WHERE field1 = @currentValue" dbCommand.CommandText = sqlString dbCommand.Parameters.AddWithValue("@value1", txtOne.Text) dbCommand.Parameters.AddWithValue("@field2 ", txtTwo.Text) dbCommand.Parameters.AddWithValue("@field3 ", txtThree.Text) dbCommand.Parameters.AddWithValue("@currentValue", lstListBox.SelectedValue) dbCommand.ExecuteNonQuery()Can someone see any reason why that wont work? I can connect to and display data from the database and the sqlstring works when i hard code the values in for it, but it doesnt seem to work with the parameterized query.
sen338
Member
498 Points
118 Posts
Re: Problem with parameterized update query
Dec 12, 2012 10:15 PM|LINK
sqlString = "UPDATE table SET field1 = @value1, field2 = @value2, field3 = @value3 WHERE field1 = @currentValue"
dbCommand.CommandText = sqlString dbCommand.Parameters.AddWithValue("@value1", txtOne.Text) dbCommand.Parameters.AddWithValue("@value2 ", txtTwo.Text)
dbCommand.Parameters.AddWithValue("@value3", txtThree.Text)
dbCommand.Parameters.AddWithValue("@currentValue", lstListBox.SelectedValue)
dbCommand.ExecuteNonQuery()
robgw3
0 Points
7 Posts
Re: Problem with parameterized update query
Dec 12, 2012 10:22 PM|LINK
Uhh isnt that the exact same thing i have there already? I dont see anything different.
Lannie
Contributor
3840 Points
749 Posts
Re: Problem with parameterized update query
Dec 13, 2012 12:42 AM|LINK
@ symbol is your BIND symbol and should not be part of the parameter name
sqlString = "UPDATE table SET field1 = @value1, field2 = @value2, field3 = @value3 WHERE field1 = @currentValue"
dbCommand.CommandText = sqlString dbCommand.Parameters.AddWithValue("value1", txtOne.Text)
dbCommand.Parameters.AddWithValue("field2 ", txtTwo.Text)
dbCommand.Parameters.AddWithValue("field3 ", txtThree.Text)
dbCommand.Parameters.AddWithValue("currentValue", lstListBox.SelectedValue)
dbCommand.ExecuteNonQuery()
robgw3
0 Points
7 Posts
Re: Problem with parameterized update query
Dec 13, 2012 12:45 AM|LINK
Unfortunately that didnt solve the problem, it still didnt update the data.
oned_gk
All-Star
35808 Points
7313 Posts
Re: Problem with parameterized update query
Dec 13, 2012 01:04 AM|LINK
It seem you have not set proper lstListBox value
try this
sqlString = "UPDATE table SET field1 = @value1, field2 = @value2, field3 = @value3 WHERE field1 = @currentValue" dbCommand.CommandText = sqlString dbCommand.Parameters.AddWithValue("@value1", txtOne.Text) dbCommand.Parameters.AddWithValue("@field2 ", txtTwo.Text) dbCommand.Parameters.AddWithValue("@field3 ", txtThree.Text) dbCommand.Parameters.AddWithValue("@currentValue", lstListBox.SelectedIndex.text) dbCommand.ExecuteNonQuery()Suwandi - Non Graduate Programmer