<telerik:RadGrid ID="grdAllGraphics" runat="server" AutoGenerateColumns="False"
GridLines="None" Skin="Web20" Width="300px" AllowMultiRowSelection="True"
AllowCustomPaging="True" AllowPaging="True" PageSize="2" ShowFooter="True"
ShowGroupPanel="True" ShowStatusBar="True">
<PagerStyle AlwaysVisible="True" NextPageToolTip="Where is this" BorderStyle="Solid" PageButtonCount="2" />
<MasterTableView>
<RowIndicatorColumn>
<HeaderStyle Width="20px" />
</RowIndicatorColumn>
<ExpandCollapseColumn>
<HeaderStyle Width="20px" />
</ExpandCollapseColumn>
<Columns>
<telerik:GridTemplateColumn
UniqueName="CheckBoxTemplateColumn">
<ItemTemplate>
<asp:CheckBox
ID="CheckBox1" runat="server"
OnCheckedChanged="ToggleRowSelection"
AutoPostBack="True"
/>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn DataField="PartNo" HeaderText="Part #"
UniqueName="column">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Description" HeaderText="Description"
UniqueName="column1">
</telerik:GridBoundColumn>
<telerik:GridTemplateColumn HeaderText="Graphic" UniqueName="TemplateColumn">
<ItemTemplate>
<asp:HyperLink ID="HyperLink1" Target="_blank" NavigateUrl ='<%# Eval("ImagePath") %>' runat="server"> <img ALT='' src='<%# Eval("ImagePath") %>' width='75'/> </asp:HyperLink>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn DataField="GraphicInventoryID" UniqueName="GraphicInventoryID" >
</telerik:GridBoundColumn>
</Columns>
</MasterTableView>
<ClientSettings AllowRowsDragDrop="False">
<Selecting AllowRowSelect="True" />
</ClientSettings>
</telerik:RadGrid>
| <telerik:RadGrid ID="InstancesGrid" runat="server" GridLines="Horizontal" |
| OnNeedDataSource="InstancesGrid_OnNeedDataSource" Height="50%"> |
| <MasterTableView AutoGenerateColumns="False" CellSpacing="-1" DataKeyNames="instance_id"> |
| <RowIndicatorColumn> |
| <HeaderStyle Width="20px" /> |
| </RowIndicatorColumn> |
| <ExpandCollapseColumn> |
| <HeaderStyle Width="20px" /> |
| </ExpandCollapseColumn> |
| <Columns> |
| <telerik:GridBoundColumn DataField="application_id" DataType="System.Int32" |
| HeaderText="application_id" SortExpression="application_id" |
| UniqueName="application_id" Visible="false"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="instance_id" DataType="System.Int32" |
| HeaderText="Instance ID" ReadOnly="True" SortExpression="instance_id" |
| UniqueName="instance_id" Visible="true"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="instance_name" HeaderText="Instance Name" |
| SortExpression="instance_name" UniqueName="instance_name"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="testing_environment_id" |
| DataType="System.Int32" HeaderText="Testing Environment" |
| SortExpression="testing_environment_id" UniqueName="testing_environment_id"> |
| </telerik:GridBoundColumn> |
| </Columns> |
| <ItemTemplate> |
| <asp:Image ID="IconImage" runat="server" style="float: left;" width="50px" Height="54px" ImageUrl="Images/InstancesGrid/icon.gif" /> |
| <table> |
| <tr> |
| <td><span>Name:</span></td> |
| <td><%#Eval("instance_name")%></td> |
| </tr> |
| <tr> |
| <td><span>Testing Environment:</span></td> |
| <td><%#Eval("testing_environment_id")%></td> |
| </tr> |
| </table> |
| </ItemTemplate> |
| </MasterTableView> |
| <ClientSettings Selecting-AllowRowSelect="true" EnableRowHoverStyle="true" ClientEvents-OnRowClick="InstancesGrid_OnRowClick" /> |
| </telerik:RadGrid> |
| function InstancesGrid_OnRowClick(sender, args) { |
| var index = args.get_itemIndexHierarchical(); |
| var MasterTable = sender.get_masterTableView(); |
| MasterTable.selectItem(MasterTable.get_dataItems()[index].get_element(), true); |
| var selectedRows = MasterTable.get_selectedItems(); |
| var row = selectedRows[0]; |
| alert(row); |
| var cell = MasterTable.getCellByColumnUniqueName(row, "instance_id"); |
| alert(cell); |
| var instance_id = cell.innerHTML; |
| alert(instance_id); |
| } |
| protected void RadMenu1_ItemClick(object sender, RadMenuEventArgs e) |
| { |
| switch (e.Item.Value)//parentroot |
| { |
| case "2"://Excel |
| RadMenuItem Excel = e.Item; |
| foreach (GridDataItem item in RdGridMainpage.Items) |
| { |
| if (item.Selected == false) |
| { |
| item.Visible = false; |
| } |
| } |
| RdGridMainpage.Rebind(); |
| RdGridMainpage.ExportSettings.ExportOnlyData = true; |
| RdGridMainpage.ExportSettings.IgnorePaging = true; |
| RdGridMainpage.ExportSettings.OpenInNewWindow = true; |
| RdGridMainpage.ExportSettings.FileName = "Request Data"; |
| RdGridMainpage.MasterTableView.ExportToExcel(); |
| break; |
| ===================================================== |
| and my need_Datasource |
| protected void RdGridMainpage_NeedDataSource(object source, GridNeedDataSourceEventArgs e) |
| { |
| AppGlobalDeclarations gConn = new AppGlobalDeclarations(); |
| DataSet ds; |
| ds = SqlHelper.ExecuteDataset(gConn.SQLConnection, CommandType.StoredProcedure, "spu_Chs_tblRequestTicket_Mainpage_SelectExport1"); |
| try |
| { |
| this.RdGridMainpage.DataSource = ds; |
| this.RdGridMainpage.Columns[3].Visible = false; |
| this.RdGridMainpage.Columns[4].Visible = true; |
| } |
| catch (Exception ex) |
| { throw ex; } |
| } |
| Protected Sub RadGrid1_ItemDataBound(ByVal sender As Object, ByVal e As GridItemEventArgs) Handles RadGrid1.ItemDataBound |
| If (TypeOf e.Item Is GridEditFormInsertItem) AndAlso (e.Item.OwnerTableView.IsItemInserted) Then |
| Dim insertItem As GridEditFormInsertItem = DirectCast(e.Item, GridEditFormInsertItem) |
| Dim txtbx1 As TextBox = DirectCast(insertItem("RUYear").Controls(0), TextBox) |
| txtbx1.Text = Year(Now) |
| Dim txtbx2 As TextBox = DirectCast(insertItem("RUMonth").Controls(0), TextBox) |
| txtbx2.Text = Month(Now) |
| txtbx1.Enabled = False |
| txtbx2.Enabled = False |
| End If |
| End Sub |
<
EditItemTemplate> <telerik:RadDateTimePicker ID="RadDateTimePicker4" Runat="server" Culture="English (United States)"
SelectedDate='<%# Bind("Trip_Detail_Begin_Time_Stamp") %>'>
<TimePopupButton HoverImageUrl="" ImageUrl="" />
<TimeView runat="server" CellSpacing="-1"> </TimeView>
<Calendar runat="server" UseColumnHeadersAsSelectors="False" UseRowHeadersAsSelectors="False"
ViewSelectorText="x"> </Calendar> <DatePopupButton HoverImageUrl="" ImageUrl="" />
</telerik:RadDateTimePicker>
</EditItemTemplate>