************************************************** *************
hi, i tested this Walkthrough.
http://msdn.microsoft.com/library/de...InWebForms.asp
************************************************** *************
i can run this command with SqlCommand
UPDATE Categories
SET CategoryName = @categoryname, Description = @categorydescription WHERE (CategoryID = @categoryid)
With sqlcommandUPDATE
.Parameters("@ID").Value = ListBox.selectedtext
.Parameters("@name").Value = txtName.Text
.Parameters("@description").Value = txtdescription.Text
End With
?????????????????????????????????????????????????? ?????????
But my code for OLEDB is not execute this sql command.
UPDATE Categories SET CategoryName = ?, Description = ? WHERE (CategoryID = ?)
With cmdCategoriesUpdate
.Parameters("ID").Value = ListBox.selectedtext
.Parameters("Name").Value = txtCategoryName.Text
.Parameters("Description").Value = txtDescription.Text
End With
?????????????????????????????????????????????????? ???????????
and i added this lines in my codes
cmdCategoriesUpdate.Parameters.Add(New OleDb.OleDbParameter("ID", OleDb.OleDbType.VarChar, 5, "ID"))
cmdCategoriesUpdate.Parameters.Add(New OleDb.OleDbParameter("Name", OleDb.OleDbType.VarChar, 15, "Name"))
cmdCategoriesUpdate.Parameters.Add(New OleDb.OleDbParameter("Description", OleDb.OleDbType.VarChar, 16, "Description"))
Can you tell me a little bit?