Updating data (Chapter 12 p388)

SouthendSupporter · July 3rd, 2009, 09:02 AM

Hi
I am new to web design and programming. I have been asked by a client to build a website for a chamber of commerce - so I am learning very much 'on project' and have been using the chapters in the book as I progress to help me with the various elements.

I have reached the point where i want to enable the editing/creation of events for the Chamber.

I have followed the 'Using gridviewsand SQLControls' section in Chapter 12 but when I drag my Events table to the page I do not see the 'Enable Editing' and 'Enable Deleting' check boxes in the Gridview tasks as shown in fig 12-4

I don't think this is a permissions issue on the database as I can edit/create data in the tables via SQL Server management Studio and the data Explorer in VWD (but not design via data Explorer - I think because it is at a remote site I get "'This feature is not Supported by VWD Express" if I try ).

Any help gladly received.
Geoff

Imar · July 3rd, 2009, 09:09 AM

Hi there,

The main reason for these check boxes not to show up is that your data source doesn't support editing, or because the underlying table doesn't have a primary. In the latter case, check your table and make sure at least one column (like the Id column which can be an identity) is the primary key for the table. Right-click the column and choose Set Primary Key if that isn't the case.

To edit remote tables, you can download a copy of the free SQL Server Management Studio Express: http://www.microsoft.com/express/sql/default.aspx

Hope this helps,

Imar

SouthendSupporter · July 3rd, 2009, 09:34 AM

Thanks Imar - simple error! I'm learning SQL at the same time as learning ASP and VB!!

Great Book!

Imar · July 3rd, 2009, 10:03 AM

You're welcome. Good to hear you like the book....

Imar