Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
| Search | Today's Posts | Mark Forums Read
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old December 6th, 2006, 04:33 PM
Registered User
 
Join Date: Dec 2006
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Update link doesn't update in FormsView

Hi folks,

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





Similar Threads
Thread Thread Starter Forum Replies Last Post
update multiple columns in an update statement debbiecoates SQL Server 2000 1 August 17th, 2008 04:01 AM
How does Update Link in FormView work? URGENT shaly ASP.NET 2.0 Professional 0 December 7th, 2006 04:10 PM
DropDownBox inside FormsView - Urgent shaly ASP.NET 2.0 Basics 1 December 6th, 2006 05:52 PM
reference textbox values in FORMSVIEW templates alexdcosta ASP.NET 2.0 Basics 0 June 22nd, 2006 05:49 AM
Datagrid.update() and DataAdapter.Update aarunlal ASP.NET 2.0 Professional 2 February 23rd, 2006 11:41 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.