or
| using System; |
| using System.Configuration; |
| using System.Data; |
| using System.Linq; |
| using System.Web; |
| using System.Web.Security; |
| using System.Web.UI; |
| using System.Web.UI.HtmlControls; |
| using System.Web.UI.WebControls; |
| using System.Web.UI.WebControls.WebParts; |
| using System.Xml.Linq; |
| using System.Data.SqlClient; |
| using Telerik.Web.UI; |
| using System.Collections.Generic; |
| public partial class Grid : System.Web.UI.Page |
| { |
| string tbName; |
| protected void Page_Load(object sender, EventArgs e) |
| { |
| if (Session["ID"] != null) |
| { |
| tbName = Request["id"].ToString(); |
| if (!Page.IsPostBack) |
| { |
| ViewState["tbName"] = tbName; |
| } |
| else |
| { |
| } |
| } |
| else |
| { |
| Response.Redirect("login.aspx"); |
| } |
| } |
| protected void RadGrid1_NeedDataSource(object source, GridNeedDataSourceEventArgs e) |
| { |
| string sql = @"Select * from " + ViewState["tbName"].ToString() ; |
| SqlConnection oCon = new SqlConnection(DatabaseConnection.ConnectionString); |
| SqlCommand cmd = new SqlCommand(sql, oCon); |
| cmd.CommandType = CommandType.Text; |
| DataTable tblData = new DataTable(); |
| new SqlDataAdapter(cmd).Fill(tblData); |
| RadGrid1.DataSource = tblData; |
| } |
| bool isGrouping = false; |
| protected void RadGrid1_GroupsChanging(object source, GridGroupsChangingEventArgs e) |
| { |
| isGrouping = true; |
| if (e.Action == GridGroupsChangingAction.Ungroup && RadGrid1.CurrentPageIndex > 0) |
| { |
| isGrouping = false; |
| } |
| } |
| } |
| <%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Grid.aspx.cs" Inherits="Grid" Title="Untitled Page" %> |
| <%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %> |
| <asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"> |
| <style type="text/css"> |
| .RadGrid_Default |
| { |
| border:1px solid #232323; |
| } |
| .RadGrid_Default |
| { |
| font:11px/1.4 arial,sans-serif; |
| } |
| .RadGrid_Default |
| { |
| background:#d4d0c8; |
| color:#333; |
| } |
| .GroupPanel_Default |
| { |
| border-top:1px solid #383838; |
| background:url('mvwres://Telerik.Web.UI, Version=2008.2.826.35, Culture=neutral, PublicKeyToken=121fae78165ba3d4/Telerik.Web.UI.Skins.Default.Grid.sprite.gif') repeat-x 0 -400px #1f1f1f; |
| color:#8f8f8f; |
| } |
| .MasterTable_Default |
| { |
| background:#fff; |
| border-collapse:separate !important; |
| } |
| .MasterTable_Default |
| { |
| font:11px/1.4 arial,sans-serif; |
| } |
| .GridHeader_Default |
| { |
| color:#fff; |
| text-decoration:none; |
| } |
| .GridHeader_Default |
| { |
| border-bottom:1px solid #010101; |
| background:url('mvwres://Telerik.Web.UI, Version=2008.2.826.35, Culture=neutral, PublicKeyToken=121fae78165ba3d4/Telerik.Web.UI.Skins.Default.Grid.headers.gif') repeat-x #434343; |
| padding:10px 6px 10px 11px; |
| text-align:left; |
| font-size:1.3em; |
| font-weight:normal; |
| } |
| #Table3 |
| { |
| width: 681px; |
| } |
| .style2 |
| { |
| height: 28px; |
| } |
| </style> |
| </asp:Content> |
| <asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> |
| <table style="width: 100%;"> |
| <tr> |
| <td class="style2"> |
| </td> |
| </tr> |
| <tr> |
| <td> |
| </td> |
| </tr> |
| <tr> |
| <td> |
| <telerik:RadGrid ID="RadGrid1" runat="server" AllowFilteringByColumn="True" |
| AllowPaging="True" AutoGenerateDeleteColumn="True" |
| AutoGenerateEditColumn="True" GridLines="None" Skin="Vista" |
| OnNeedDataSource="RadGrid1_NeedDataSource" |
| OnGroupsChanging="RadGrid1_GroupsChanging" AllowAutomaticDeletes="True" |
| AllowAutomaticInserts="True" AllowAutomaticUpdates="True" OnItemUpdated="RadGrid1_ItemUpdated" |
| OnItemDeleted="RadGrid1_ItemDeleted" OnItemInserted="RadGrid1_ItemInserted" > |
| <HeaderContextMenu> |
| <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> |
| </HeaderContextMenu> |
| <PagerStyle Mode="NextPrevAndNumeric"></PagerStyle> |
| <MasterTableView CommandItemDisplay="Top" EditMode ="PopUp" AllowFilteringByColumn="True" > |
| <RowIndicatorColumn> |
| <HeaderStyle Width="20px"></HeaderStyle> |
| </RowIndicatorColumn> |
| <ExpandCollapseColumn> |
| <HeaderStyle Width="20px"></HeaderStyle> |
| </ExpandCollapseColumn> |
| </MasterTableView> |
| <ClientSettings AllowKeyboardNavigation="True"> |
| <Selecting AllowRowSelect="True" /> |
| </ClientSettings> |
| <FilterMenu> |
| <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> |
| </FilterMenu> |
| </telerik:RadGrid> |
| </td> |
| </tr> |
| </table> |
| </asp:Content> |
| <telerik:RadGrid ID="rgdKnowledgeOwners" runat="server" AllowSorting="true" AutoGenerateColumns="false" |
| AllowPaging="true" GridLines="None" AllowMultiRowSelection="true" PageSize="25" Width="500px" |
| OnItemDataBound="rgdKnowledgeOwners_ItemDataBound"> |
| <PagerStyle Mode="NextPrevNumericAndAdvanced" Position="TopAndBottom" /> |
| <HeaderContextMenu> |
| <CollapseAnimation Type="OutQuint" Duration="200" /> |
| </HeaderContextMenu> |
| <MasterTableView DataKeyNames="POCID" AutoGenerateColumns="false"> |
| <RowIndicatorColumn> |
| <HeaderStyle Width="20px" /> |
| </RowIndicatorColumn> |
| <ExpandCollapseColumn> |
| <HeaderStyle Width="20px" /> |
| </ExpandCollapseColumn> |
| <Columns> |
| <telerik:GridBoundColumn DataField="POCID" |
| HeaderText="POCID" UniqueName="POCID" Visible="false"> |
| </telerik:GridBoundColumn> |
| <telerik:GridTemplateColumn HeaderText="Primary Owner" SortExpression="PrimaryOwner"> |
| <ItemTemplate> |
| <asp:RadioButton id="rbPrimaryOwner" runat="server" GroupName="PrimaryOwner"> |
| </asp:RadioButton> |
| </ItemTemplate> |
| </telerik:GridTemplateColumn> |
| <telerik:GridBoundColumn DataField="Name" |
| HeaderText="Knowledge Owner Name" UniqueName="Name" SortExpression="Name"> |
| </telerik:GridBoundColumn> |
| <telerik:GridTemplateColumn HeaderText="Receive Admin Emails" SortExpression="ReceiveEmail"> |
| <ItemTemplate> |
| <asp:CheckBox id="chkReceiveEmail" runat="server"> |
| </asp:CheckBox> |
| </ItemTemplate> |
| </telerik:GridTemplateColumn> |
| <telerik:GridTemplateColumn HeaderText="Disply on CoP" SortExpression="DisplayOnCoP"> |
| <ItemTemplate> |
| <asp:CheckBox id="chkDisplayOnCoP" runat="server"> |
| </asp:CheckBox> |
| </ItemTemplate> |
| </telerik:GridTemplateColumn> |
| </Columns> |
| </MasterTableView> |
| <ClientSettings AllowRowsDragDrop="true" AllowColumnsReorder="false" |
| AllowDragToGroup="true" AllowRowHide="true" AllowColumnHide="true" |
| ReorderColumnsOnClient="true"> |
| <Selecting AllowRowSelect="true" /> |
| </ClientSettings> |
| <FilterMenu> |
| <CollapseAnimation Type="OutQuint" Duration="200" /> |
| </FilterMenu> |
| </telerik:RadGrid> |
| protected void rgdKnowledgeOwners_ItemDataBound(object sender, GridItemEventArgs e) |
| { |
| GridItemType giType = e.Item.ItemType; |
| if (giType == GridItemType.AlternatingItem || giType == GridItemType.Item) |
| { |
| DTOOwner dr = (DTOOwner)e.Item.DataItem; |
| RadioButton rb = (RadioButton) e.Item.FindControl("rbPrimaryOwner"); |
| CheckBox chk1 = (CheckBox)e.Item.FindControl("chkReceiveEmail"); |
| CheckBox chk2 = (CheckBox)e.Item.FindControl("chkDisplayOnCoP"); |
| //Set radio buttons to script so that if one is selected, others are turned false |
| string script = "SetUniqueRadioButton(" + rb.ClientID + ", " + "'rgdKnowledgeOwners')"; |
| rb.Attributes.Add("onclick", script); |
| rb.Checked = dr.PrimaryOwner; |
| chk1.Checked = dr.ReceiveEmail; |
| chk2.Checked = dr.DisplayOnCoP; |
| } |
| } |
| function SetUniqueRadioButton(objRadioButton, grdName) { |
| var i, obj; |
| for (i = 0; i < document.all.length; i++) { |
| obj = document.all(i); |
| if (obj.type == "radio") { |
| if ((objRadioButton.id.substr(0, grdName.length) == grdName)) { |
| if (objRadioButton.id == obj.id) |
| obj.checked = true; |
| else |
| obj.checked = false; |
| } |
| } |
| } |
| } |
| telerik:radtabstrip id="RadTabStrip1" runat="server" selectedindex="0" enableembeddedskins="False" |
| skin="FashionestaProductlist" multipageid="RadMultiPage1"> |
| <Tabs> |
| <telerik:RadTab runat="server" PageViewID="RadPageView1" Selected="True" /> |
| <telerik:RadTab runat="server" PageViewID="RadPageView2" /> |
| <telerik:RadTab runat="server" PageViewID="RadPageView3" /> |
| </Tabs> |
| </telerik:radtabstrip> |
| <telerik:radmultipage id="RadMultiPage1" runat="server" selectedindex="0"> |
| <telerik:RadPageView ID="tabRecently" runat="server"> |
| <div class="Content"> |
| .... |