Error with EntityDataSource

TeaDrinkingGeek · March 20th, 2011, 12:26 PM

Hi Imar,

I'm getting another error on Try It Out pg 505.

I finished typing in the code, and I ran NewPhotoAlbum.aspx. I entered in a name for the photo album and click insert. I then get an error.

Here is the error:

Code:

Server Error in '/Site' Application.
--------------------------------------------------------------------------------

For the EntityDataSource, either Type or DbType (but not both) must be specified for each Parameter. 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.InvalidOperationException: For the EntityDataSource, either Type or DbType (but not both) must be specified for each Parameter.

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  

Stack Trace: 


[InvalidOperationException: For the EntityDataSource, either Type or DbType (but not both) must be specified for each Parameter.]
   System.Web.UI.WebControls.EntityDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +738
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +21
   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +143
   System.Web.UI.WebControls.ListView.PerformSelect() +113
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +74
   System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +66
   System.Web.UI.WebControls.ListView.CreateChildControls() +55
   System.Web.UI.Control.EnsureChildControls() +102
   System.Web.UI.Control.PreRenderRecursiveInternal() +42
   System.Web.UI.Control.PreRenderRecursiveInternal() +175
   System.Web.UI.Control.PreRenderRecursiveInternal() +175
   System.Web.UI.Control.PreRenderRecursiveInternal() +175
   System.Web.UI.Control.PreRenderRecursiveInternal() +175
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2496

I check back over my code but cannot see anything missing. any idea?

Regards

Imar · March 20th, 2011, 12:57 PM

It sounds as if your SelectParamater is missing the Type attribute as the error message suggests.

Can you please post your code when you create threads like these? Makes it easier to supply you with an answer on the first reply, rather than asking for the source code first ;-)

Cheers,

Imar

TeaDrinkingGeek · March 20th, 2011, 01:25 PM

Hi Imar,

I've cheated and copied the code from Chapter 14 and compiled that.

It mean I missed a few exercises in the books, but it save on trying to work out what was happening.

I'm now going to read to the end of chapter 14 so I understand how it all ties together.

Thanks
Lee

Imar · March 20th, 2011, 01:54 PM

Quote:

but it save on trying to work out what was happening.

I think what you missed was the second half of step 4 on page 506, directly below Figure 14-13. The instructions read:

Quote:

Make sure you enter

it.PhotoAlbum.Id = @photoAlbumId in the Where Expression box at the top of the dialog. Next, click the Show Advanced Properties link and change the Type property of the parameter to Int32. When you’re done, click OK to dismiss the dialog box.

This adds the Type attribute to the SelectParameter.

Cheers,

Imar