I get the error below when I try using a GridViewSearchPanel with a data source that is based on a View.  I also have a data source that is based on a table that is identical to view with the exception the view has one extra nvarchar(string) column.  The crazy thing is that the search panel works great on the table based data source.  But when I switch the datasource tag name...it blows up!

 Does anyone have any ideas?

Server Error in '/Website.AJAX' Application.

Object reference not set to an instance of an object.

Line 296:                    ColumnEnumAttribute cea = EntityHelper.GetAttribute<ColumnEnumAttribute>( (Enum)c.GetValue( i ) );
Line 297:                    // only show fields that we can realistically search against
Line 298:                    switch ( cea.DbType )
Line 299:                    {
Line 300:                        case System.Data.DbType.AnsiString:

[NullReferenceException: Object reference not set to an instance of an object.]
   Web.UI.GridViewSearchPanel.CreateChildControls() in C:\Web\UI\GridViewSearchPanel.cs:298
   System.Web.UI.Control.EnsureChildControls() +87
   Web.UI.GridViewSearchPanel.set_SearchFieldName(String value) in C:\Web\UI\GridViewSearchPanel.cs:149
   Web.UI.GridViewSearchPanelState.RestoreState(GridView& gridView, GridViewSearchPanel& searchPanel) in C:\Web\UI\GridViewSearchPanelState.cs:151
   Web.UI.<>c__DisplayClass39.<HandleGridViewSearchPanelState>b__2f(Object sender, EventArgs e) in C:\Web\UI\FormUtilBase.generated.cs:1458
   System.EventHandler.Invoke(Object sender, EventArgs e) +0
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

 Here's my code:

                     <dataAms:GridViewSearchPanel ID="GridViewSearchPanel2" runat="server" GridViewControlID="GridView1" Visible="true" />
        <br />
        <dataAms:EntityGridView ID="GridView1" runat="server"           
                AutoGenerateColumns="False"                   
                DataSourceID="SiteDrugDataSource"
                DataKeyNames="SiteDrugId"
                AllowMultiColumnSorting="false"
                DefaultSortColumnName=""
                DefaultSortDirection="Ascending"   
                ExcelExportFileName="Export_SiteDrug.xls"         
            >
            <Columns>
                <asp:CommandField ShowSelectButton="True" ShowEditButton="True" />               
                <asp:BoundField DataField="Strength" HeaderText="Strength" SortExpression="Strength"  />
                <asp:BoundField DataField="Units" HeaderText="Units" SortExpression="Units"  /> SortExpression="NameOfCodingSystem"  />
                <asp:BoundField DataField="InsertedDateTime" HeaderText="Inserted Date Time" SortExpression="InsertedDateTime"  />
                <asp:BoundField DataField="ModifiedDateTime" HeaderText="Modified Date Time" SortExpression="ModifiedDateTime"  />
            </Columns>
            <EmptyDataTemplate>
                <b>No SiteDrug Found!</b>
            </EmptyDataTemplate>
        </dataAms:EntityGridView>
        <br />
        <asp:Button runat="server" ID="btnSiteDrug" OnClientClick="BLOCKED SCRIPTlocation.href='/admin/SiteDrugEdit.aspx'; return false;" Text="Add New"></asp:Button>
           
        <dataAms:SiteDrugsViewWithGroupDrugNameDataSource ID="SiteDrugDataSource" runat="server"
            SelectMethod="GetPaged"
            EnablePaging="True"
            EnableSorting="True"
        >
            <Parameters>
                <dataAms:CustomParameter Name="WhereClause" Value="" ConvertEmptyStringToNull="false" />
                <dataAms:CustomParameter Name="OrderByClause" Value="" ConvertEmptyStringToNull="false" />
                <asp:ControlParameter Name="PageIndex" ControlID="GridView1" PropertyName="PageIndex" Type="Int32" />
                <asp:ControlParameter Name="PageSize" ControlID="GridView1" PropertyName="PageSize" Type="Int32" />
                <dataAms:CustomParameter Name="RecordCount" Value="0" Type="Int32" />
            </Parameters>
        </dataAms:SiteDrugDataSource>
 

Fixed (rev. 526)

I downloaded the latest nightly build ( 20070326 ) and just regenerated my files.   I'm still getting an error on line 298, but the stack trace output is now different...

 Any help is greatly appreciated!!!

Source Error:

Line 296:                    ColumnEnumAttribute cea = EntityHelper.GetAttribute<ColumnEnumAttribute>( (Enum)c.GetValue( i ) );
Line 297:                    // only show fields that we can realistically search against
Line 298:                    switch ( cea.DbType )
Line 299:                    {
Line 300:                        case System.Data.DbType.AnsiString:
 

Source File: C:\Data\Projects\A\ATools\M.A.Site.Web\UI\GridViewSearchPanel.cs    Line: 298

Stack Trace:

[NullReferenceException: Object reference not set to an instance of an object.]
   M.A.Site.Web.UI.GridViewSearchPanel.CreateChildControls() in C:\Data\Projects\A\ATools\M.A.Site.Web\UI\GridViewSearchPanel.cs:298
   System.Web.UI.Control.EnsureChildControls() +87
   M.A.Site.Web.UI.GridViewSearchPanel.OnLoad(EventArgs e) in C:\Data\Projects\A\ATools\M.A.Site.Web\UI\GridViewSearchPanel.cs:242
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

 Thanks,

David 

David,

GridViewSearchPanel is using reflection to get entity column attribute information, so the fix was to add ColumnEnum attribute when enumerating columns. Could you verify that in your EntityBase.generated.cs class where columns enum is defined, the ColumnEnum attribute is specified?

    /// <summary>
    /// Enumerate the CustomerandSuppliersbyCity columns.
    /// </summary>
    [Serializable]
    public enum CustomerandSuppliersbyCityColumn
    {
        /// <summary>
        /// City :
        /// </summary>
        [EnumTextValue("City")]
        [ColumnEnum("City", typeof(System.String), System.Data.DbType.String, false, false, true, 15)]
        City,
        /// <summary>
        /// CompanyName :
        /// </summary>
        [EnumTextValue("CompanyName")]
        [ColumnEnum("CompanyName", typeof(System.String), System.Data.DbType.String, false, false, false, 40)]
        CompanyName,
        /// <summary>
        /// ContactName :
        /// </summary>
        [EnumTextValue("ContactName")]
        [ColumnEnum("ContactName", typeof(System.String), System.Data.DbType.String, false, false, true, 30)]
        ContactName,
        /// <summary>
        /// Relationship :
        /// </summary>
        [EnumTextValue("Relationship")]
        [ColumnEnum("Relationship", typeof(System.String), System.Data.DbType.AnsiString, false, false, false, 9)]
        Relationship
    }//End enum

I was having the same issue with view generated entities, but I downloaded the latest build and it looks like it fixed it.  Thanks for the patch!

 One quick question on the GridViewSearchPanel:

Is it possible to not have it show hidden columns in the dropdown list of columns?  I don't exactly want external users searching with an internally generated id key, but I need it in the view so that I can pass the next page the correct key.

 Any ideas?

Thanks again!

Jesse

Jesse,

Here is how to exclude fields from the column list:

<data:GridViewSearchPanel ID="GridViewSearchPanel1" runat="server" GridViewControlID="GridView1" Visible="true">
    <FieldsToExclude>
        <data:Field Value="City" />
        <data:Field Value="Country" />
    </FieldsToExclude>
</data:GridViewSearchPanel>

It's working great for me now as well!
Thanks,

David 

Thanks alot mike,

   Your solution for excluding fields from column list of GridViewSearchPanel helped me alot.

  Can u provide me the functionality of "GetPaged" ,"Get","GetAll","GetByCodeId","Find" properties of "SelectMethod" in "EntityDataSource" control.

regards,

Rajeev.P

Rajeev,

Please elaborate more on what you're trying to achieve.