I am attempting to update a datarow in a sql database with a selected item in a ddl. I am using the following code:
Dim connectionstring As String = ("my connection")
Dim query As String = ("Update properties Set available='@available' where ID='@ID'")
Dim conn As New SqlConnection(my connection)
Dim cmd As New SqlCommand(query, conn)
Basically, I want the person to be able to update that particular record. When I run this application, this is the error I am getting:
System.ArgumentException: No mapping exists from object type System.Web.UI.WebControls.ListItem to a known managed provider native type.