or
<telerik:RadAutoCompleteBox ID="acpstudents" Runat="server" DataSourceID="st" DataTextField="name" DataValueField="id" InputType="Text" MaxResultCount="10"> </telerik:RadAutoCompleteBox> <asp:SqlDataSource ID="st" runat="server" ConnectionString="<%$ ConnectionStrings:dbconnection %>" EnableCaching="true" SelectCommand="SELECT [name]+' '+[lname] as name,[lname],[scode],[codemelli],[id] FROM [students] WHERE ([schoolid] = @schoolid)" SelectCommandType="Text"> <SelectParameters> <asp:CookieParameter CookieName="schoolmanager" Name="schoolid" Type="Int32" /> </SelectParameters> </asp:SqlDataSource>
<telerik:RadGrid ID="grdView" runat="server" AutoGenerateColumns="false" EnableAJAXLoadingTemplate="True" AllowSorting="true" GroupingEnabled="false"AllowPaging="true" PageSize="10" OnNeedDataSource="grdView_NeedDataSource" OnDetailTableDataBind="grdView_DetailTableDataBind" OnItemCommand="grdView_ItemCommand"> <ExportSettings ExportOnlyData="true" OpenInNewWindow="true" HideStructureColumns="true" FileName="ExportExcel" IgnorePaging="true"> </ExportSettings> <MasterTableView ShowHeader="False" CommandItemDisplay="Top" PageSize="10" DataKeyNames="GroupName" AllowFilteringByColumn="true"><CommandItemSettings ShowRefreshButton="false" RefreshText="" ShowAddNewRecordButton="true" AddNewRecordText="AddNew" AddNewRecordImageUrl="../Images/RadGrid/Duplicate.gif" ShowExportToExcelButton="true" ExportToExcelText="Export to Excel" ExportToExcelImageUrl="../Images/RadGrid/ExportToExcel.gif" ShowExportToCsvButton="true" ExportToCsvText="Collapse All" ExportToCsvImageUrl="../Images/RadGrid/CollapseAll.gif" ShowExportToPdfButton="true" ExportToPdfText="Expand All" ExportToPdfImageUrl="../Images/RadGrid/ExpandAll.gif" /> <Columns> <telerik:GridTemplateColumn UniqueName="GroupName" DataField="GroupName"> <ItemTemplate> <asp:Label runat="server" ID="lblGroupName" Text='<%#Bind("GroupName") %>'> </asp:Label> <asp:Label runat="server" ForeColor="Blue" ID="lblDisplayName" Text='<%#Bind("DisplayName") %>'> </asp:Label> </ItemTemplate> <HeaderStyle Wrap="true" /> <ItemStyle Width="100%" /> </telerik:GridTemplateColumn> </Columns> <DetailTables> <telerik:GridTableView AllowSorting="True" Width="100%" runat="server" ClientDataKeyNames="Id" AllowFilteringByColumn="true"> <ParentTableRelation> <telerik:GridRelationFields /> </ParentTableRelation> <Columns><telerik:GridHyperLinkColumn DataTextField="RequestNo" Target="_blank" DataNavigateUrlFormatString="~/FormController.aspx? Id={0}" DataType="System.String" DataNavigateUrlFields="Id" HeaderText="Request#" UniqueName="RequestNo" SortExpression="RequestNo" ShowFilterIcon="false" FilterControlWidth="100%" CurrentFilterFunction="Contains" AutoPostBackOnFilter="true"> <HeaderStyle Width="100px" /> <ItemStyle HorizontalAlign="Left" CssClass="hyperlink" /> </telerik:GridHyperLinkColumn> </Columns> <PagerStyle AlwaysVisible="true" Mode="NextPrevAndNumeric" Wrap="false" Position="Bottom" PageButtonCount="5" /> <ExpandCollapseColumn ButtonType="ImageButton" UniqueName="ExpandColumn" Visible="False"> <HeaderStyle Width="19px" /> </ExpandCollapseColumn> </telerik:GridTableView> </DetailTables> <ExpandCollapseColumn ButtonType="ImageButton" UniqueName="ExpandColumn"> <HeaderStyle Width="19px" /> </ExpandCollapseColumn> <NoRecordsTemplate> There is no document to display </NoRecordsTemplate> <ExpandCollapseColumn ButtonType="ImageButton" UniqueName="ExpandColumn"> <HeaderStyle Width="19px" /> </ExpandCollapseColumn> </MasterTableView> <GroupingSettings CaseSensitive="false" /> <PagerStyle Mode="NextPrevAndNumeric" AlwaysVisible="true" PageButtonCount="10" /> <ClientSettings> <Selecting AllowRowSelect="true" /> <ClientEvents OnRowDblClick="RowDblClick"/> </ClientSettings> </telerik:RadGrid>
<!DOCTYPE html> <html> <head id="Head1" runat="server"> <title>GDBID - Invoice Notes</title> <script type="text/javascript"> function SetLabels(sender, args) { //var RowID = args.get_id(); //get Row //var masterTable = document.getElementById("RadGrid1").get_masterTableView(); //get Grid //var ControlX = masterTable.get_dataItems()[RowID].findElement('lblLastUpdateInsert').id; //get Control ID if (args.get_columnUniqueName() == "last_update") { var cardStatusCell = sender.get_masterTableView()._getCellByColumnUniqueNameFromTableRowElement(args.get_row(), "last_update"); //alert(sender.get_batchEditingManager().getCellValue(cardStatusCell)); //sender.get_batchEditingManager().changeCellValue(cardStatusCell, "10/28/2014"); var txtBox = document.getElementById("RadGrid1_RadGrid1_ctl00_last_update_TB_last_update"); if (txtBox != null) { txtBox.value = "Hello World"; txtBox.disabled = true; } } </script> </head> <body> <form id="form1" runat="server"> <telerik:RadScriptManager runat="server" ID="RadScriptManager1" EnablePartialRendering="true" EnablePageMethods="true" LoadScriptsBeforeUI="true" AsyncPostBackTimeout="600" EnableScriptCombine="false" ScriptMode="Release"> <Groups> <telerik:ScriptReferenceGroup> <Scripts> <asp:ScriptReference Path="~/Scripts/jquery-1.4.1.js" /> <asp:ScriptReference Path="~/Scripts/json2.js" /> <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" /> <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" /> <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js" /> <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryPlugins.js" /> </Scripts> </telerik:ScriptReferenceGroup> </Groups> </telerik:RadScriptManager> <telerik:RadAjaxPanel runat="server" ID="RadAjaxPanel1"> <asp:Table ID="tblInvoiceNotes" runat="server" CssClass=""> <asp:TableRow> <asp:TableCell> <telerik:RadGrid ID="RadGrid1" GridLines="None" runat="server" PageSize="10" Skin="Telerik" AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowPaging="True" AutoGenerateColumns="False" Width="750px" DataSourceID="objDataSourceIN" OnBatchEditCommand="RadGrid1_BatchEditCommand" OnUpdateCommand="RadGrid1_UpdateCommand" OnInsertCommand="RadGrid1_InsertCommand" OnDeleteCommand="RadGrid1_DeleteCommand"> <ValidationSettings EnableModelValidation="true" EnableValidation="true" CommandsToValidate="Update,InitInsert,Insert" /> <MasterTableView CommandItemDisplay="Top" DataKeyNames="InvNum,InvDbId,InvNotesNum" AutoGenerateColumns="False" DataSourceID="objDataSourceIN" HorizontalAlign="NotSet" EditMode="Batch"> <BatchEditingSettings EditType="Cell" OpenEditingEvent="Click" /> <%-- <SortExpressions><telerik:GridSortExpression FieldName="last_update" SortOrder="Descending" /></SortExpressions>--%> <Columns> <%--<telerik:GridTemplateColumn HeaderText="Date" UniqueName="last_update" HeaderStyle-Width="150px" DataField="last_update"> <ItemTemplate><%# Eval("last_update") %></ItemTemplate> <EditItemTemplate> <asp:Label runat="server" ID="lblLastUpdateEdit" Text='<%#Eval("last_update")%>' Visible="true"></asp:Label> </EditItemTemplate> <InsertItemTemplate> <asp:Label runat="server" ID="lblLastUpdateInsert" Text="<%= DateTime.Now.ToShortDateString() %>" Visible="true"></asp:Label> </InsertItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Who" UniqueName="who" HeaderStyle-Width="200px" DataField="who"> <ItemTemplate><%# Eval("who") %></ItemTemplate> <EditItemTemplate> <asp:Label runat="server" ID="lblWhoEdit" Text='<%#Eval("who")%>'></asp:Label> </EditItemTemplate> <InsertItemTemplate> <asp:Label runat="server" ID="lblWhoInsert" Text="" Visible="true"></asp:Label> </InsertItemTemplate> </telerik:GridTemplateColumn>--%> <telerik:GridBoundColumn DataField="last_update" HeaderStyle-Width="150px" HeaderText="Date" SortExpression="last_update" UniqueName="last_update"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="who" HeaderStyle-Width="200px" HeaderText="Who" SortExpression="who" UniqueName="who"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Notes" HeaderStyle-Width="410px" HeaderText="Notes" SortExpression="Notes" UniqueName="Notes"> <ColumnValidationSettings EnableRequiredFieldValidation="true"> <RequiredFieldValidator ForeColor="Red" Text="*This field is required" Display="Dynamic"> </RequiredFieldValidator> </ColumnValidationSettings> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="InvNum" DataType="System.Int32" HeaderText="InvNum" UniqueName="InvNum" Display="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="InvDbId" DataType="System.Int32" HeaderText="InvDbId" UniqueName="InvDbId" Display="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="InvNotesNum" DataType="System.Int32" HeaderText="InvNotesNum" UniqueName="InvNotesNum" Display="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="AllowEdit" DataType="System.String" HeaderText="AllowEdit" UniqueName="AllowEdit" Display="false"> </telerik:GridBoundColumn> <telerik:GridButtonColumn ConfirmText="Delete this Note?" ConfirmDialogType="RadWindow" ConfirmTitle="Delete" HeaderText="Delete" HeaderStyle-Width="50px" ButtonType="ImageButton" CommandName="Delete" Text="Delete" UniqueName="DeleteColumn" ImageUrl="Images\GridRowDelete.gif"> </telerik:GridButtonColumn> </Columns> </MasterTableView> <ClientSettings AllowKeyboardNavigation="true"> <ClientEvents OnBatchEditOpening="SetLabels" /> </ClientSettings> </telerik:RadGrid> <asp:Label ID="SavedChangesList" runat="server" Text="" ForeColor="Red" Font-Names="Calibri"></asp:Label> </asp:TableCell> </asp:TableRow> </asp:Table> </telerik:RadAjaxPanel> <asp:ObjectDataSource ID="objDataSourceIN" runat="server" TypeName="Notes" SelectMethod="GetData" InsertMethod="Insert" UpdateMethod="Update" DeleteMethod="Delete" EnablePaging="false" EnableCaching="true"> <SelectParameters> <asp:SessionParameter Name="user" SessionField="UserName" Type="String" /> <asp:SessionParameter Name="location" SessionField="Location" Type="String" /> <asp:QueryStringParameter Name="searchinvnuminvdbid" QueryStringField="InvNumInvDbId" Type="String" /> <asp:Parameter Name="searchdetailnum" Type="String" DefaultValue="" /> </SelectParameters> <InsertParameters> <asp:SessionParameter Name="user" SessionField="UserName" Type="String" /> <asp:SessionParameter Name="location" SessionField="Location" Type="String" /> <asp:QueryStringParameter Name="searchinvnuminvdbid" QueryStringField="InvNumInvDbId" Type="String" /> </InsertParameters> <UpdateParameters> <asp:SessionParameter Name="user" SessionField="UserName" Type="String" /> <asp:SessionParameter Name="location" SessionField="Location" Type="String" /> </UpdateParameters> <DeleteParameters> <asp:SessionParameter Name="user" SessionField="UserName" Type="String" /> <asp:SessionParameter Name="location" SessionField="Location" Type="String" /> </DeleteParameters> </asp:ObjectDataSource> </form> </body> </html>