Sqldatasource updating cancel Online sex private chatting
From here, you should be able to simply bind the Selected Value property of the Drop Down List using two-way databinding, like this: Actually, looking at what you're trying to do a bit more closely, it looks like what you have is probably OK.From here, you should be able to simply bind the Selected Value property of the Drop Down List using two-way databinding, like this: I tried that and pretty sure I entered it exactly as you typed it (copy & paste FTW). Text = "Updating not successfull" Exit Sub End If Else lbl Status. Exception Handled = True End If End Sub End Class Update Command="UPDATE messenger SET student ID = ? Through the query builder it works great, but not outside of it. Text = "Updated Successfully" Exit Sub Else lbl Status. id)" Delete Command="DELETE FROM messenger WHERE id = ? Ok so I tested the Update Command some more and I have the same issue still. Are there any other thoughts as to what is the issue? My Sql Client Partial Public Class Trash Inherits System.
Based on their suggestions, I also added Append Data Bound Items="True" to it, but it doesn't really fix anything. As it is currently your update command could affect more records than your delete command. department" Well if you're updating and individual record and you also want to delete that record then it stands to reason you would have the same where criteria to locate the record.When I update a record, I can change the [Name] of the activity (because it's a default textbox generated by the Grid View), and the record is updated fine.
But the value of the ddl box is not inserted into the record.The if statement in my SQLData Source "says" it's updating, but that is not the case. Data Bind() thinking that maybe it needed to be rebound. Here is the aspx: " Select Command="SELECT * FROM messenger" Update Command="UPDATE messenger SET student ID = ?