BoldSignEasily embed eSignatures in your .NET applications. Free sandbox with native SDK available.
<asp:Content runat="server" ID="BodyContent" ContentPlaceHolderID="MainContent">
<div id="commanddialog"><div id="detailGrid1">
</div></div>
<ej:Grid ID="Grid" ClientIDMode="Static" runat="server" AllowPaging="True">
<ClientSideEvents ActionComplete="complete" DataBound="dataBound" />
<Columns>
..
<Command>
<ej:Commands Type="detail">
<ButtonOptions Text="Details" Width="100" Click="onClick"></ButtonOptions>
</ej:Commands>
</Command>
</ej:Column>
</Columns>
<EditSettings AllowEditing="True" AllowAdding="True" AllowDeleting="True" EditMode="Batch"></EditSettings>
<ToolbarSettings ShowToolbar="True" ToolbarItems="add,edit,delete,update,cancel"></ToolbarSettings>
</ej:Grid>
<script type="text/template" id="template">
<b>Order Details</b>
<table cellspacing="10">
<tr>
<td style="text-align: right;">Employee ID
</td>
<td style="text-align: left">
<input id="EmployeeID" name="EmployeeID" value="{{: EmployeeID}}" disabled="disabled"
class="e-field e-ejinputtext valid e-disable" style="text-align: right; width: 116px; height: 28px" />
</td>
<td style="text-align: right;">First Name
</td>
<td style="text-align: left">
<input id="FirstName" name="FirstName" value="{{: FirstName}}" class="e-field e-ejinputtext valid"
style="width: 116px; height: 28px" />
</td>
</tr>
<tr>
<td style="text-align: right;">Last Name
</td>
<td style="text-align: left">
<input id="LastName" name="LastName" value="{{: LastName}}" class="e-field e-ejinputtext valid"
style="width: 116px; height: 28px" />
</td>
<td style="text-align: right;">Birt hDate
</td>
<td style="text-align: left">
<input id="BirthDate" name="BirthDate" class="e-field e-ejinputtext valid"
style="width: 116px; height: 28px" value="{{:BirthDate}}" />
</td>
</tr>
<tr>
<td style="text-align: right;">Country
</td>
<td style="text-align: left">
<select id="Country" name="Country">
<option value="Germany">Germany</option>
<option value="Mexico">Mexico</option>
<option value="UK">UK</option>
<option value="Sweden">Sweden</option>
<option value="Colchester">France</option>
<option value="Denmark">Italy</option>
<option value="Spain">Spain</option>
<option value="USA">USA</option>
</select>
</td>
</tr>
</table>
</script>
<script type="text/javascript">
var PopupData = [];
$("#commanddialog").ejDialog({
"width": 650,
title: "Details of employee",
showOnInit: false,
enableResize: false
});
function onClick(args) {
var grid = $("#Grid").ejGrid("instance");
var index = this.element.closest("tr").index();
var record = grid.getCurrentViewData()[index];
//filtering the data with the help of EmployeeID a primaryKey of parent Grid
var data = ej.DataManager(PopupData).executeLocal(new ej.Query().where("EmployeeID", "equal", record.EmployeeID));
$("#detailGrid1").ejGrid({
//binding filtered data to Grid
dataSource: data,
allowPaging: true,
pageSettings: { pageSize: 4 },
columns: [
{ field: "OrderID" },
{ field: "CustomerID" }
]
})
$("#commanddialog").ejDialog("open");
}
function dataBound(args) {
var elem = $("#Grid_externalEdit").detach();
this.element.prepend(elem);
var dataManager = ej.DataManager({ url: "/Default.aspx/Data", adaptor: new ej.WebMethodAdaptor() });
var query = ej.Query();
//using DataManager to collect the all data for Popup Grid
var execute = dataManager.executeQuery(query) // executing query
.done(function (e) {
PopupData = e.result.Data;
});
}
</script>
</asp:Content> |
ALTER TABLE dbo.OrderTables DROP COLUMN Amount;
GO
ALTER TABLE dbo.OrderTables ADD Amount AS (Quantity * Price ); |
<ej:Grid ID="Grid" ClientIDMode="Static" runat="server" AllowPaging="True">
<ClientSideEvents ActionComplete="complete" DataBound="dataBound" />
<Columns>
<ej:Column Field="EmployeeID" HeaderText="Employee ID" Format="Rs {0:n2}" TextAlign="Right" Width="100" />
..
</ej:Column>
</Columns>
<EditSettings AllowEditing="True" AllowAdding="True" AllowDeleting="True" EditMode="Batch" ></EditSettings>
<ToolbarSettings ShowToolbar="True" ToolbarItems="add,edit,delete,update,cancel"></ToolbarSettings>
</ej:Grid> |