Update link doesn't update in FormsView
I hope I get the answer to this problem. Any clue would be greatly appreciated.
I have "Update" and "Cancel" links in my FormView. Just to test the Update link button, I have written a simple query wich is -
UPDATE Domains SET DNS = @txtDNS WHERE (Id = @Id)
in my browser, when I update the DNS field and click the Update link - nothinh happens. The page just reloads with the same information. I click the update link again and it throws me an error -
Cannot insert the value NULL into column 'DNS', table 'MSInteractive.dbo.Domains'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
Looks like the text field in the form which is named correctly as "txtDNS" is not getting its value. But I have no clue here onwards. I have bben spent quite a few hours on this but no luck.
Please Please help... Thanks a million