or
<
asp:EntityDataSource
ID
=
"EntityDataSource1"
runat
=
"server"
ConnectionString
=
"name=Clarity2011Entities"
OrderBy
=
"it.[DisplayName]"
DefaultContainerName
=
"Clarity2011Entities"
EnableFlattening
=
"False"
EntitySetName
=
"tblMassMaintenanceFields"
Select
=
"it.[FieldId], it.[DisplayName], it.[FieldName], it.[TableName], it.[NetDataType]"
EntityTypeFilter
=
"tblMassMaintenanceField"
>
</
asp:EntityDataSource
>
<
div
class
=
"filterDiv"
>
<
telerik:RadFilter
runat
=
"server"
ID
=
"RadFilter1"
OnPreRender
=
"RadFilter1_PreRender"
DataSourceControlID
=
"EntityDataSource1"
FilterContainerID
=
"RadGrid1"
ShowApplyButton
=
"false"
/>
<
asp:SqlDataSource
ID
=
"dtcRadGrid1"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:BRINVConnectionString %>" CancelSelectOnNullParameter="False" SelectCommand="Select DisplayName FROM tblMassMaintenanceFields">
</
asp:SqlDataSource
>
</
div
>
<
telerik:RadGrid
runat
=
"server"
ID
=
"RadGrid1"
AutoGenerateColumns
=
"False"
AllowPaging
=
"True"
AllowSorting
=
"True"
AllowFilteringByColumn
=
"True"
OnItemCommand
=
"RadGrid1_ItemCommand"
CellSpacing
=
"0"
GridLines
=
"None"
>
<
MasterTableView
IsFilterItemExpanded
=
"false"
CommandItemDisplay
=
"Top"
>
<
CommandItemSettings
ExportToPdfText
=
"Export to PDF"
></
CommandItemSettings
>
<
RowIndicatorColumn
FilterControlAltText
=
"Filter RowIndicator column"
></
RowIndicatorColumn
>
<
ExpandCollapseColumn
FilterControlAltText
=
"Filter ExpandColumn column"
></
ExpandCollapseColumn
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"FieldId"
DataType
=
"System.Int32"
FilterControlAltText
=
"Filter FieldId column"
HeaderText
=
"FieldId"
ReadOnly
=
"True"
SortExpression
=
"FieldId"
UniqueName
=
"FieldId"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"DisplayName"
FilterControlAltText
=
"Filter DisplayName column"
HeaderText
=
"DisplayName"
ReadOnly
=
"True"
SortExpression
=
"DisplayName"
UniqueName
=
"DisplayName"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"FieldName"
FilterControlAltText
=
"Filter FieldName column"
HeaderText
=
"FieldName"
ReadOnly
=
"True"
SortExpression
=
"FieldName"
UniqueName
=
"FieldName"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"TableName"
FilterControlAltText
=
"Filter TableName column"
HeaderText
=
"TableName"
ReadOnly
=
"True"
SortExpression
=
"TableName"
UniqueName
=
"TableName"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"NetDataType"
FilterControlAltText
=
"Filter NetDataType column"
HeaderText
=
"NetDataType"
ReadOnly
=
"True"
SortExpression
=
"NetDataType"
UniqueName
=
"NetDataType"
>
</
telerik:GridBoundColumn
>
</
Columns
>
<
EditFormSettings
>
<
EditColumn
FilterControlAltText
=
"Filter EditCommandColumn column"
></
EditColumn
>
</
EditFormSettings
>
<
CommandItemTemplate
>
<
telerik:RadToolBar
runat
=
"server"
ID
=
"RadToolBar1"
OnButtonClick
=
"RadToolBar1_ButtonClick"
>
<
Items
>
<
telerik:RadToolBarButton
Text
=
"Apply filter"
CommandName
=
"FilterRadGrid"
ImageUrl="<%#GetFilterIcon() %>"
ImagePosition="Right" />
</
Items
>
</
telerik:RadToolBar
>
</
CommandItemTemplate
>
</
MasterTableView
>
<
FilterMenu
EnableImageSprites
=
"False"
></
FilterMenu
>
<
HeaderContextMenu
CssClass
=
"GridContextMenu GridContextMenu_Default"
></
HeaderContextMenu
>
</
telerik:RadGrid
>
But when I write code to create the entitydatasource I get object not set to instance of an object when the page displays..
Here is the code:
EntityDataSource ClarityEntities = new EntityDataSource();
var conEntitiesString = ConfigurationManager.ConnectionStrings["Clarity2011Entities"];
string strConnEntitiesString = conEntitiesString.ConnectionString;
ClarityEntities.ConnectionString = strConnEntitiesString;
ClarityEntities.OrderBy = "it.[DisplayName]";
ClarityEntities.EnableFlattening = false;
ClarityEntities.DefaultContainerName = "Clarity2011Entities";
//ClarityEntities.ContextTypeName =
ClarityEntities.EntitySetName = "tblMassMaintenanceFields";
ClarityEntities.Select = "it.[FieldId], it.[DisplayName], it.[FieldName], it.[TableName], it.[NetDataType]";
ClarityEntities.EntityTypeFilter = "tblMassMaintenanceField";
RadGrid1.DataSource = ClarityEntities;
RadGrid1.MasterTableView.DataSource = ClarityEntities;
<
telerik:RadGrid
ID
=
"gridDpSummary"
runat
=
"server"
CellSpacing
=
"0"
GridLines
=
"None"
EnableEmbeddedSkins
=
"False"
Skin
=
"dpgrid"
AllowSorting
=
"True"
AllowPaging
=
"True"
PageSize
=
"20"
onneeddatasource
=
"gridDpSummary_NeedDataSource"
>
<
PagerStyle
Mode
=
"NextPrevNumericAndAdvanced"
></
PagerStyle
>
<
MasterTableView
>
<
Columns
>
<
telerik:GridBoundColumn
FilterControlAltText
=
"Filter columnVoyage column"
HeaderText
=
"Voyage"
UniqueName
=
"columnVoyage"
DataField
=
"voyageID"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
FilterControlAltText
=
"Filter columnStartDate column"
HeaderText
=
"Start Date"
UniqueName
=
"columnStartDate"
DataField
=
"date"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
FilterControlAltText
=
"Filter columnEndDate column"
HeaderText
=
"End Date"
UniqueName
=
"columnEndDate"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
FilterControlAltText
=
"Filter columnVessel column"
HeaderText
=
"Vessel"
UniqueName
=
"columnVessel"
DataField
=
"vesselName"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
FilterControlAltText
=
"Filter columnFacility column"
HeaderText
=
"Facility"
UniqueName
=
"columnFacility"
DataField
=
"facilityName"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
FilterControlAltText
=
"Filter columnDPType column"
HeaderText
=
"DP Type"
UniqueName
=
"columnDPType"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
FilterControlAltText
=
"Filter columnTotalHours column"
HeaderText
=
"Total Hours"
UniqueName
=
"columnTotalHours"
>
</
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
<
PagerStyle
Mode
=
"NextPrevAndNumeric"
/>
<
FilterMenu
EnableTheming
=
"true"
>
<
CollapseAnimation
Duration
=
"200"
Type
=
"OutQuint"
/>
</
FilterMenu
>
</
telerik:RadGrid
>
My NeedDataSource Event
protected
void
gridDpSummary_NeedDataSource(
object
sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e) {
int
companyID = Convert.ToInt32(parameters.companyID);
DateTime startDate = Convert.ToDateTime(parameters.startDate);
DateTime endDate = Convert.ToDateTime(parameters.endDate);
endDate = endDate.AddDays(1);
var voyIDQuery = from vl
in
dc.lkpVoyageLegs
join vc
in
dc.lkpVoyageCompanies on vl.voyageID equals vc.voyageID
where vc.companyID == companyID
&& vl.aDateTime >= startDate
&& vl.aDateTime < endDate
&& vl.isEnd ==
true
select vl.voyageID;
var dpQuery = from vl2
in
dc.lkpVoyageLegs
join dpt
in
dc.utlDPTypes on vl2.dpTypeID equals dpt.dpTypeID
join voy
in
dc.dtaVoyages on vl2.voyageID equals voy.ID
join ves
in
dc.dtaVessels on voy.vesselID equals ves.vesselID
join fac
in
dc.dtaFacilities on vl2.facilityID equals fac.facilityID
where voyIDQuery.Contains(vl2.voyageID)
select
new
{ voyageID = vl2.voyageID, vesselName = ves.name, facilityName = fac.name, date = vl2.aDateTime };
gridDpSummary.DataSource = dpQuery;
}