Hi
I have a radgrid using editmode popup.
when no record in grid(data source is empty) and click Inset new records ,the grid is not visible, only a single line
even I use OnNeedDatasourse event and write the code to fill grid from SQL inside the event But not work!
Please help me
I have a radgrid using editmode popup.
when no record in grid(data source is empty) and click Inset new records ,the grid is not visible, only a single line
even I use OnNeedDatasourse event and write the code to fill grid from SQL inside the event But not work!
Please help me
<
telerik:RadGrid
ID
=
"RadGrid3"
runat
=
"server"
AutoGenerateEditColumn
=
"True"
ShowFooter
=
"true"
GridLines
=
"None"
AllowAutomaticUpdates
=
"True"
AllowAutomaticDeletes
=
"True"
AllowAutomaticInserts
=
"True"
OnItemDeleted
=
"RadGrid2_ItemDeleted"
OnItemInserted
=
"RadGrid2_ItemInserted"
OnItemUpdated
=
"RadGrid2_ItemUpdated"
AutoGenerateDeleteColumn
=
"True"
Skin
=
"Office2007"
AllowSorting
=
"True"
AutoGenerateColumns
=
"False"
ShowStatusBar
=
"True"
onitemcommand
=
"RadGrid3_ItemCommand"
oninsertcommand
=
"RadGrid3_InsertCommand"
onitemdatabound
=
"RadGrid3_ItemDataBound"
onselectedindexchanged
=
"RadGrid3_SelectedIndexChanged"
ondatabound
=
"RadGrid3_DataBound"
onupdatecommand
=
"RadGrid3_UpdateCommand"
onneeddatasource
=
"RadGrid3_NeedDataSource"
DataSourceID
=
"SqlDataSource3"
Enabled
=
"False"
ö
ndatabinding
=
"RadGrid3_DataBinding"
>
<
ClientSettings
EnablePostBackOnRowClick
=
"True"
>
<
Selecting
AllowRowSelect
=
"True"
/>
<
ClientEvents
ö
nRowDblClick
=
"RowDblClick"
></
ClientEvents
>
</
ClientSettings
>
<
MasterTableView
CommandItemDisplay
=
"Top"
EditMode
=
"PopUp"
DataKeyNames
=
"WorkID"
DataSourceID
=
"SqlDataSource3"
>
<
CommandItemSettings
AddNewRecordText
=
"Insert"
RefreshText
=
"Refresh"
/>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"MachinaryMainCode"
HeaderText
=
"MachinaryMainCode"
SortExpression
=
"MachinaryMainCode"
UniqueName
=
"MachinaryMainCode"
Visible
=
"False"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"UserDate"
DataType
=
"System.DateTime"
HeaderText
=
"UserDate"
SortExpression
=
"UserDate"
UniqueName
=
"UserDate"
Visible
=
"False"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"WorkDuration"
DataType
=
"System.Int32"
HeaderText
=
"time"
SortExpression
=
"WorkDuration"
UniqueName
=
"WorkDuration"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"WorkID"
DataType
=
"System.Int32"
HeaderText
=
"WorkID"
SortExpression
=
"WorkID"
UniqueName
=
"WorkID"
ReadOnly
=
"True"
Visible
=
"False"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"URID"
HeaderText
=
"URID"
SortExpression
=
"URID"
UniqueName
=
"URID"
DataType
=
"System.Int32"
ReadOnly
=
"True"
Visible
=
"False"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"UnUsaReason"
HeaderText
=
"UnUsaReason"
SortExpression
=
"UnUsaReason"
UniqueName
=
"UnUsaReason"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"USID"
DataType
=
"System.Int32"
HeaderText
=
"USID"
SortExpression
=
"USID"
UniqueName
=
"USID"
ReadOnly
=
"True"
Visible
=
"False"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"UsageName"
HeaderText
=
"UsageName"
SortExpression
=
"UsageName"
UniqueName
=
"UsageName"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"StatusID"
DataType
=
"System.Int32"
HeaderText
=
"StatusID"
ReadOnly
=
"True"
SortExpression
=
"StatusID"
UniqueName
=
"StatusID"
Visible
=
"False"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"StatusName"
HeaderText
=
"StatusName"
SortExpression
=
"StatusName"
UniqueName
=
"StatusName"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"EPID"
DataType
=
"System.Int32"
HeaderText
=
"EPID"
ReadOnly
=
"True"
SortExpression
=
"EPID"
UniqueName
=
"EPID"
Visible
=
"False"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"EquipmentName"
HeaderText
=
"EquipmentName"
SortExpression
=
"EquipmentName"
UniqueName
=
"EquipmentName"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"ARID"
DataType
=
"System.Int32"
HeaderText
=
"ARID"
ReadOnly
=
"True"
SortExpression
=
"ARID"
UniqueName
=
"ARID"
Visible
=
"False"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"AreaName"
HeaderText
=
"AreaName"
SortExpression
=
"AreaName"
UniqueName
=
"AreaName"
>
</
telerik:GridBoundColumn
>
</
tr
>
</
tr
>
</
table
>
<
table
style
=
"width: 100%"
>
<
tr
>
</
tr
>
<
tr
>
<
td
align
=
"right"
>
<
asp:Button
ID
=
"Button1"
Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Refresh" %>'
CommandName='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>'
runat="server" ValidationGroup="ValidationGroup" >
</
asp:Button
>
<
asp:Button
ID
=
"Button2"
Text
=
"Cancel"
runat
=
"server"
CausesValidation
=
"False"
CommandName
=
"Cancel"
>
</
asp:Button
>
</
td
>
</
tr
>
</
table
>
</
FormTemplate
>
<
PopUpSettings
Modal
=
"True"
/>
</
EditFormSettings
>
</
MasterTableView
>
<
PagerStyle
Mode
=
"NextPrevAndNumeric"
></
PagerStyle
>
</
telerik:RadGrid
>
<
asp:SqlDataSource
ID
=
"SqlDataSource3"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:CMMSConnectionString2 %>"
SelectCommand="SELECT ML.MachinaryMainCode, WI.UserDate, WI.WorkDuration, WI.WorkID, UR.ID AS URID, UR.UnUsaReason, US.ID AS USID, US.UsageName, MS.StatusID, MS.StatusName, EP.ID AS EPID, EP.EquipmentName, Ar.ID AS ARID, Ar.AreaName, WI.WorkKilometer, CN.ContractorID, CN.CompanyName, CN.Name + ' ' + CN.Family AS Name, WI.UnUsaReasonID, CN.ContractorType, WI.DisciplineID, Discipline.DisciplineName FROM Discipline RIGHT OUTER JOIN WorkInfo AS WI ON Discipline.ID = WI.DisciplineID RIGHT OUTER JOIN MachinList AS ML LEFT OUTER JOIN MachineryName AS MN ON ML.MachinaryNameID = MN.ID LEFT OUTER JOIN MachineryModel AS MM ON ML.MachinaryModelID = MM.ID LEFT OUTER JOIN MachineryType AS MT ON ML.MachinaryTypeID = MT.ID ON WI.MachinID = ML.ID LEFT OUTER JOIN UnUsaReason AS UR ON WI.UnUsaReasonID = UR.ID LEFT OUTER JOIN UsageShop AS US ON WI.UsageShopID = US.ID LEFT OUTER JOIN MachinStatus AS MS ON WI.StatusID = MS.StatusID LEFT OUTER JOIN Equipment AS EP ON WI.EquipmentID = EP.ID LEFT OUTER JOIN Area AS Ar ON WI.AreaID = Ar.ID LEFT OUTER JOIN Contractor AS CN ON WI.ContractorID = CN.ContractorID WHERE (ML.ID = @ID) AND (WI.UserDate = @UserDate or WI.UserDate is null )"
onselected="SqlDataSource3_Selected">
<
SelectParameters
>
<
asp:ControlParameter
ControlID
=
"RadGrid1"
Name
=
"ID"
PropertyName
=
"SelectedValues['ID']"
/>
<
asp:ControlParameter
ControlID
=
"DatePicker1"
Name
=
"UserDate"
PropertyName
=
"Date"
Type
=
"DateTime"
/>
</
SelectParameters
>
</
asp:SqlDataSource
>
.