or
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta http-equiv="x-ua-compatible" content="IE=9" />
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Upcoming.aspx.cs" Inherits="Website.Upcoming" %><%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %><!DOCTYPE html><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <meta http-equiv="X-UA-Compatible" content="IE=edge" /> <title></title> <link rel="stylesheet" href="css/style.css"></head><body> <form id="form1" runat="server"> <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager> <div > <telerik:RadGrid ID="grid1" runat="server" ShowStatusBar="false" GridLines="Both" Skin="WebBlue" AutoGenerateColumns="False" AllowMultiRowSelection="False" AllowPaging="false" ShowHeader="true" OnNeedDataSource="grid1_NeedDataSource" Height="350px" ClientSettings-Scrolling-UseStaticHeaders="true" ClientSettings-Scrolling-AllowScroll="true" > <MasterTableView> <Columns> <telerik:GridHyperLinkColumn DataTextField="Name" DataNavigateUrlFields="Id" DataNavigateUrlFormatString="Test.html?id={0}" Target="_parent" HeaderText="Class"> </telerik:GridHyperLinkColumn> <telerik:GridBoundColumn DataField="MyClassDate" DataType="System.String" HeaderText="Starts On"> </telerik:GridBoundColumn> </Columns> </MasterTableView> </telerik:RadGrid> </div> </form></body></html>
head runat="server"> <title></title> <script type="text/javascript" src="jquery-1.8.2.js"></script> <script type="text/javascript"> $(document).ready(function () { $('#lbtnGo').click(function () { SaveGridValues(); }); }); </script> <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server"> <script type="text/javascript"> function SaveGridValues() { var tableView = $find("<%= RadGrid1.ClientID %>").get_masterTableView(); var Updates = new Array(); for (var i = 0; i <= tableView._dataItems.length - 1; i++) { var dataItem = tableView._dataItems[i]; var row = dataItem.get_element(); var label = row.children[0].children[0]; var Appx = label.innerText; var checkBox = row.children[1].children[0]; var ZeroCostAppx = checkBox.checked; var rtb0102InstHoursPer = tableView._dataItems[i].findControl("rtb0102InstHoursPer"); var current_rtb0102InstHoursPer = rtb0102InstHoursPer._value var rtb0102InstAmountPer = tableView._dataItems[i].findControl("rtb0102InstAmountPer"); var current_rtb0102InstAmountPer = rtb0102InstAmountPer._value var rtb0111TravelHoursPer = tableView._dataItems[i].findControl("rtb0111TravelHoursPer"); var current_rtb0111TravelHoursPer = rtb0111TravelHoursPer._value var rtb0111TravelAmountPer = tableView._dataItems[i].findControl("rtb0111TravelAmountPer"); var current_rtb0111TravelAmountPer = rtb0111TravelAmountPer._value var bd = new Object(); bd.appx = Appx; bd.a01_02InstAmountPer = current_rtb0102InstAmountPer; bd.a01_02InstHoursPer = current_rtb0102InstHoursPer; bd.a01_11TravelAmountPer = current_rtb0111TravelAmountPer; bd.a01_11TravelHoursPer = current_rtb0111TravelHoursPer; bd.ZeroCostAppx = ZeroCostAppx; Updates.push(bd); } PageMethods.UpdateBD("ACCS110155", Updates, GetData); } </script> <script type="text/javascript"> function pageLoad(sender, eventArgs) { var tableView = $find("<%= RadGrid1.ClientID %>").get_masterTableView(); GetData(); } function GetData() { PageMethods.GetData("ACCS110155", updateGrid); } function RadGrid1_Command(sender, args) { //left blank } function updateGrid(result) { var tableView = $find("<%= RadGrid1.ClientID %>").get_masterTableView(); tableView.set_dataSource(result); tableView.dataBind(); } function RadGrid1_RowDataBound(sender, args) { var chkZeroCost = args.get_item().findControl("chkZeroCostAppx"); if (chkZeroCost != null) { chkZeroCost.checked = args.get_dataItem()["ZeroCostAppx"]; } var radTextBox1 = args.get_item().findControl("rtb0102InstHoursPer"); // find control radTextBox1.set_value(args.get_dataItem()["_01_02InstHoursPer"]); var radTextBox2 = args.get_item().findControl("rtb0102InstAmountPer"); // find control radTextBox2.set_value(args.get_dataItem()["_01_02InstAmountPer"]); var rtb0111TravelHoursPer = args.get_item().findControl("rtb0111TravelHoursPer"); // find control rtb0111TravelHoursPer.set_value(args.get_dataItem()["_01_11TravelHoursPer"]); var rtb0111TravelAmountPer = args.get_item().findControl("rtb0111TravelAmountPer"); // find control rtb0111TravelAmountPer.set_value(args.get_dataItem()["_01_11TravelAmountPer"]); } </script> </telerik:RadCodeBlock></head><body> <form id="form1" runat="server"> <telerik:RadScriptManager runat="server" ID="RadScriptManager1" /> <div> <telerik:RadGrid ID="RadGrid1" EnableViewState="false" runat="server" AllowPaging="false" AllowSorting="True" AllowFilteringByColumn="false" GridLines="None"> <ItemStyle Wrap="false"></ItemStyle> <MasterTableView AllowMultiColumnSorting="true" TableLayout="Fixed" BackColor="#f2f2f2" ShowFooter="true"> <Columns> <telerik:GridTemplateColumn DataField="Appx" HeaderText="Appx"> <ItemTemplate> <asp:Label ID="lblAppx" runat="server"></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="ZeroCostAppx" HeaderText="No cost"> <ItemTemplate> <asp:CheckBox ID="chkZeroCostAppx" runat="server" /> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="_01_02InstHoursPer" HeaderText="_01_02InstHoursPer" Aggregate="Sum" DataType="System.Decimal"> <ItemTemplate> <telerik:RadNumericTextBox ID="rtb0102InstHoursPer" runat="server" Width="70px" BorderColor="Transparent"> </telerik:RadNumericTextBox> </ItemTemplate> <FooterTemplate> <telerik:RadNumericTextBox ID="rtb0102InstHoursPerFOOTER" runat="server"> <ClientEvents OnLoad="Load" /> </telerik:RadNumericTextBox> </FooterTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="_01_02InstAmountPer" HeaderText="_01_02InstAmountPer" Aggregate="Sum" DataType="System.Decimal" UniqueName="_01_02InstAmountPer"> <ItemTemplate> <telerik:RadNumericTextBox ID="rtb0102InstAmountPer" runat="server" Width="70px" BorderColor="Transparent" Type="Currency"> </telerik:RadNumericTextBox> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="_01_11TravelHoursPer" HeaderText="_01_11TravelHoursPer"> <ItemTemplate> <telerik:RadNumericTextBox ID="rtb0111TravelHoursPer" runat="server" Width="70px" BorderColor="Transparent"> </telerik:RadNumericTextBox> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="_01_11TravelAmountPer" HeaderText="_01_11TravelAmountPer"> <ItemTemplate> <telerik:RadNumericTextBox ID="rtb0111TravelAmountPer" runat="server" Width="70px" BorderColor="Transparent" Type="Currency"> </telerik:RadNumericTextBox> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> </MasterTableView> <ClientSettings> <ClientEvents OnCommand="RadGrid1_Command" OnRowDataBound="RadGrid1_RowDataBound"> </ClientEvents> </ClientSettings> </telerik:RadGrid> </div> <div> <asp:LinkButton ID="lbtnGo" runat="server" Text="Go" OnClientClick="return false;"></asp:LinkButton> </div> <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server"> </telerik:RadAjaxLoadingPanel> </form></body>public partial class _Default : System.Web.UI.Page{ protected override void OnInit(System.EventArgs e) { base.OnInit(e); RadScriptManager.GetCurrent(this).EnablePageMethods = true; } [WebMethod] [ScriptMethod(ResponseFormat = ResponseFormat.Json)] public static List<BudgetedDollar> GetData(string JobNumber) { DataClassesDataContext db = new DataClassesDataContext(ConfigurationManager.ConnectionStrings["JM_ConnStringUser"].ToString()); var resultItems = (from BudgetedDollar dr in db.BudgetedDollars.Where(x => x.JobNumber.Equals(JobNumber)).AsEnumerable() select dr).ToList<BudgetedDollar>(); return resultItems; } [WebMethod] [ScriptMethod(ResponseFormat = ResponseFormat.Json)] public static void UpdateBD(string JobNumber, Object o) { DataClassesDataContext db = new DataClassesDataContext(ConfigurationManager.ConnectionStrings["JM_ConnStringUser"].ToString()); try { for (int i = 0; i < ((object[])(o)).Length; i++) { db.sp_Update_BudgetedDollars( JobNumber, Int16.Parse(((System.Collections.Generic.Dictionary<string, object>)((object[])(o))[i])["appx"].ToString()), Boolean.Parse(((System.Collections.Generic.Dictionary<string, object>)((object[])(o))[i])["ZeroCostAppx"].ToString()), Decimal.Parse(((System.Collections.Generic.Dictionary<string, object>)((object[])(o))[i])["a01_02InstHoursPer"].ToString()), Decimal.Parse(((System.Collections.Generic.Dictionary<string, object>)((object[])(o))[i])["a01_02InstAmountPer"].ToString()), Decimal.Parse(((System.Collections.Generic.Dictionary<string, object>)((object[])(o))[i])["a01_11TravelHoursPer"].ToString()), Decimal.Parse(((System.Collections.Generic.Dictionary<string, object>)((object[])(o))[i])["a01_11TravelAmountPer"].ToString()), ); } } catch (Exception ex) { } }}I have a radgrid in a dotnetnuke module and I want in the sql of the grid to have the current logged in DNN user mapped to a parameter in my where clause of the datasource.
Can you suggest how to do it? I am unsure how secure is to store it in the session..
protected void RadGrid1_ItemCreated(object sender, GridItemEventArgs e) { if (e.Item is GridDataItem) { if (e.Item.OwnerTableView.Name == "Parent") { Button editLink = (Button)e.Item.FindControl("EditLink"); editLink.Attributes["href"] = "javascript:void(0);"; editLink.Attributes["onclick"] = String.Format("return ShowEditForm('{0}','{1}','{2}','{3}');", e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["EID"], e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["RID"], e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["VID"], e.Item.ItemIndex); } else if (e.Item.OwnerTableView.Name == "Child") { // nothing } } if (e.Item is GridCommandItem) { if (e.Item.OwnerTableView.Name == "Parent") { Button addLink = (Button)e.Item.FindControl("AddNewRecordLink"); addLink.Attributes["href"] = "javascript:void(0);"; addLink.Attributes["onclick"] = String.Format("return ShowInsertForm('{0}','{1}');", e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["EID"], e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["VID"]); } } }An exception of type 'System.ArgumentOutOfRangeException' occurredprotected void RadGridHierarchy_PreRender(object sender, EventArgs e){ if (_expandedItem != null && _expandedItem.Expanded) { if (_expandedItem.HasChildItems) { foreach (GridTableView view in _expandedItem.ChildItem.NestedTableViews) { foreach (GridDataItem item in view.Items) { item.Edit = true; } view.Rebind(); } } } //Edit on all Items in Level 1 for (int i = 0; i < RadGridHierarchy.MasterTableView.Items.Count; i++) { RadGridHierarchy.EditIndexes.Add(i); RadGridHierarchy.EditIndexes.Add(RadGridHierarchy.MasterTableView.Items[i].ItemIndex); }}protected void RadGridHierarchy_ItemCommand(object sender, GridCommandEventArgs e){ if (e.CommandName == RadGrid.ExpandCollapseCommandName) { _expandedItem = (GridDataItem)e.Item; SaveGridValues(); if (_expandedItem.Expanded) { _expandedItem = null; } }}
var g=$find("some grid id")var b=g.get_batchEditingManager()var v=g.MasterTableViewg.add_command(function (sender, args) { if(args.get_commandName() == "BatchEdit" && args.get_tableView() == v) alert("save"); });saveAllChangessaveAllChanges(), the event is not fired. Why this happens?
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %><telerik:RadDatePicker runat="server" EnableEmbeddedSkins="false" CssClass="RadPicker_Laurens" SkinID="Laurens"> <DateInput CssClass="RadInput_Laurens" DisabledStyle-CssClass="RadInput_Disabled_Laurens" EmptyMessageStyle-CssClass="RadInput_Empty_Laurens" EnabledStyle-CssClass="RadInput_Enabled_Laurens" FocusedStyle-CssClass="RadInput_Focused_Laurens" HoveredStyle-CssClass="RadInput_Hover_Laurens" InvalidStyle-CssClass="RadInput_Error_Laurens" ReadOnlyStyle-CssClass="RadInput_Read_Laurens"> </DateInput> <Calendar CssClass="RadCalendar_Laurens"> </Calendar></telerik:RadDatePicker>