Chapter 13

pgrant · April 11th, 2012, 04:52 AM

I have replayed this try out twice and have a couple of issues.

1. If I open the Smart Tasks Panel on the DetailsView Control, there is no facility to Enable Inserting.
2. If I look through the DetailsView object's properties I cannot find a facility to Enable Inserting

So what this means is I have to add this expression to the Markup:

Code:

 <asp:CommandField ShowInsertButton="True>

Am I missing something here?

Imar · April 11th, 2012, 05:19 AM

Hi there,

This usually means that you haven't made the Id column a primary key. The controls need a primary key in order to enable Insert behavior. To fix it:

1. Open the database, locate your table, click the Id column and then click the lock icon on the toolbar to make it a primary key. Also check that you made this an Identity column.
2. Redo the steps that generate the SQL statements.

Hope this helps,

Imar

pgrant · April 11th, 2012, 05:34 AM

Imar
Thanks for the suggestion. The primary key for both tables is set to the ID column. Both fields are int and Identity columns.

There is another related problem which is the DataGrid will not allow an Insert.

Is there another reason for this behaviour? Perhaps the way SQL Server Express is configured?

I thought I would try to generate the SQL to create the table to prove it had a primary key and was an Identity column.

So I tried to access the PlanetWrox database using SSMS from a Developer version of SQL Server 2008. The PlanetWrox database did not show under the SQLExpress Server, so I attempted to make an attachment to PlanetWrox.mdf. This resulted in this error:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Attach database failed for Server 'PGDT\SQLEXPRESS'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Unable to open the physical file "C:\BegASPNET\DatabaseTest\App_Data\PlanetWrox.mdf ". Operating system error 5: "5(failed to retrieve text for this error. Reason: 15105)". (Microsoft SQL Server, Error: 5120)

For help, click: http://go.microsoft.com/fwlink?ProdN...0&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Imar · April 11th, 2012, 05:49 AM

Maybe the SqlDataSource doesn't support inserting? To check, open its Smart Tasks panel and choose Configure DataSource. Then click Next and then Advanced. Make sure the option for Generate INSERT, UPDATE and DELETE statements is checked.

If that doesn't help can you a) describe which page / TIO exercise you're working on and b) post the full code for the page you're working on?

Cheers,

Imar

pgrant · April 11th, 2012, 06:51 AM

Imar
Thanks - that fixed it.

I went back to the previous exercise to try to find out why this happened. I have tried to recreate the DataGrid via drag and drop onto the design surface and in markup. Doing it either way resulted in the Generate Insert, Update and Delete being correctly selected.

I think I must have somehow gone sausage fingered on the previous exercise.

Many thanks.

PG