or
Private Sub RadGrid1_ItemDataBound(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs) Handles RadGrid1.ItemDataBound If TypeOf e.Item Is GridDataItem Then Dim item As GridDataItem = DirectCast(e.Item, GridDataItem) Dim row As DataRowView = DirectCast(e.Item.DataItem, DataRowView) item("Band").Text = row("Band").ToString() item("capoptioname").Text = row("capoptioname").ToString() End If If (TypeOf e.Item Is GridEditableItem AndAlso CType(e.Item, GridEditableItem).IsInEditMode) Then Dim editedItem As GridEditableItem = CType(e.Item, GridEditableItem) Dim editMan As GridEditManager = editedItem.EditManager Dim editor As GridDropDownListColumnEditor = CType(editMan.GetColumnEditor("Band"), GridDropDownListColumnEditor) Dim ddlBand As DropDownList = editor.DropDownListControl Dim ProductBus As New Product Dim bands As Entities.Product.callbandsDataTable bands = ProductBus.GetCallBandsList ddlBand.DataSource = bands ddlBand.DataTextField = "description" ddlBand.DataValueField = "value" ddlBand.DataBind() End IfEnd Sub<telerik:RadGrid ID="RadGrid1" runat="server" PagerStyle-AlwaysVisible="true" AllowPaging="True" AllowSorting="True" pagesize="25" pagerposition="bottom" GridLines="None" Width="99.9%" EnableEmbeddedSkins="False" AllowMultiRowEdit="True" OnSortCommand="RadGrid1_SortCommand" ShowStatusBar="True" Skin="p3" OnNeedDataSource="RadGrid1_NeedDataSource" AllowFilteringByColumn="True" AutoGenerateColumns="False" CellSpacing="0" Culture="en-GB" ><MasterTableView EditMode="inplace" AllowMultiColumnSorting="true" DataKeyNames="id" GridLines="Both" CommandItemDisplay="Top" > <CommandItemSettings ExportToPdfText="Export to PDF" /> <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column" Visible="True"> </RowIndicatorColumn> <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column" Visible="True"> </ExpandCollapseColumn> <CommandItemTemplate> </CommandItemTemplate> <Columns> <telerik:GridEditCommandColumn HeaderStyle-Width="4%" ButtonType="ImageButton" EditImageUrl="/images/edit.png" /> <telerik:GridBoundColumn UniqueName="id" DataField="id" HeaderText="id" ReadOnly="True" HeaderStyle-Width="1%" Display="False"> </telerik:GridBoundColumn> <telerik:GridDropDownColumn DataField="Band" HeaderText="Band" UniqueName="Band" ColumnEditorID="GridDropDownListColumnEditor1" HeaderStyle-Width="10%" ListTextField="description" ListValueField="value" EnableEmptyListItem="true" EmptyListItemValue="0" EmptyListItemText="please select" FilterControlAltText="Filter callband column" DropDownControlType="RadComboBox" > </telerik:GridDropDownColumn> </Columns> <PagerStyle AlwaysVisible="True" /> </MasterTableView> <ClientSettings> <Scrolling AllowScroll="True" ScrollHeight="" SaveScrollPosition="True"></Scrolling> </ClientSettings> <SortingSettings EnableSkinSortStyles="false"></SortingSettings> <PagerStyle Mode="NumericPages" /></telerik:RadGrid><telerik:GridDropDownListColumnEditor ID="GridDropDownListColumnEditor1" runat="server" DropDownStyle-Width="200px" > </telerik:GridDropDownListColumnEditor>
function onGridCreated(sender, eventArgs) { if (rowIsSelected()) { .....function rowIsSelected() { var getSeletecteRow=getSelectedRow(); ......function getSelectedRow() { var employeeSummaryGrid = $find('<%=EmployeeSummaryGrid.ClientID%>'); if (employeeSummaryGrid != null) { var MasterTable = employeeSummaryGrid.get_masterTableView(); //this is returning null in some cases return MasterTable.get_selectedItems()[0]; } return null; }
function RadListBox1Deleting(sender, arg) { var callBackFunction = Function.createDelegate(sender, function (shouldSubmit) { if (shouldSubmit) { // call server side RadListBox1Deleted } }); var text = "Are you sure you want to delete?"; radconfirm(text, callBackFunction, 300, 100, null, "Deleting"); arg.set_cancel(true); }
} protected void LoadYear() { SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["HolidayTrackerConnectionString"].ConnectionString); SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM HtVacationDay", connection); DataTable dt = new DataTable(); adapter.Fill(dt); rcbYear.DataTextField = "FromDate"; rcbYear.DataValueField = "VacationDayId"; rcbYear.DataSource = dt; rcbYear.DataBind(); rcbYear.Items.Insert(0, new RadComboBoxItem("-Select a Year-")); }Hi all member
I have a grid in asp and add GridColumnGroup and column in code behind.
i add in page load event before i set value for colums but when page post back to server raise error
Invalid column name:
this my code
plase help to me
thanks
protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) { txtDate.Text = clsMain.GetPersianDate(); CreateStructureTable(); fillZoneData(); fillAreaData(); fillPlacetype(); if (objZone.dtblZone.Rows.Count == 0 || objArea.dtblZone.Rows.Count==0) { string script = "Error('شما به منطقه ای مشخص دسترسی ندارید')"; // ScriptManager.RegisterStartupScript(this, GetType(), "MyKey", script, true); } else { FillPlaceInTable(); FillDataInTable(); } } } private void CreateStructureTable() { int i = 0; string s = ""; #region "GridClear" dgdZone.MasterTableView.Columns.Clear(); // dgdZone0.MasterTableView.Columns.Clear(); dgdZone.MasterTableView.ColumnGroups.Clear(); #endregion #region "GridColumnGroup" objContractItem.dtblContractItem = clsMain.SelectByCondition("Select * from vContractItem where iNumber In(Select iParentNumber from vContractItem) Order by ContractItemLevel asc"); for (i = 0; i <= objContractItem.dtblContractItem.Rows.Count - 1; i++) { if (!dgdZone.MasterTableView.ColumnGroups.Contains(objContractItem.dtblContractItem.Rows[i]["iNumber"])) { GridColumnGroup grp = new GridColumnGroup(); grp.HeaderText = objContractItem.dtblContractItem.Rows[i]["strName"].ToStr().Replace(" ", "").Replace(":", ""); grp.Name = "grp" + objContractItem.dtblContractItem.Rows[i]["iNumber"].ToStr().Replace(" ", "").Replace(":", ""); grp.HeaderStyle.VerticalAlign = VerticalAlign.Middle; grp.HeaderStyle.HorizontalAlign = HorizontalAlign.Center; if (objContractItem.dtblContractItem.Rows[i]["iParentNumber"].ToInt() != 0) { grp.ParentGroupName = "grp" + objContractItem.dtblContractItem.Rows[i]["iParentNumber"].ToStr().Replace(" ", "").Replace(":", ""); } dgdZone.MasterTableView.ColumnGroups.Add(grp); } } #endregion //------------------------------ردیف Telerik.Web.UI.GridBoundColumn iRowNumber = new Telerik.Web.UI.GridBoundColumn(); dgdZone.MasterTableView.Columns.Add(iRowNumber); //dgdZone0.MasterTableView.Columns.Add(iRowNumber); iRowNumber.HeaderText = "ردیف"; iRowNumber.UniqueName = "iRowNumber"; iRowNumber.DataField = "iRowNumber"; iRowNumber.Visible = true; iRowNumber.HeaderStyle.Width = Unit.Pixel(40); iRowNumber.ItemStyle.Width = Unit.Pixel(20); iRowNumber.ForceExtractValue = GridForceExtractValues.Always; iRowNumber.AllowFiltering = false; iRowNumber.HeaderStyle.VerticalAlign = VerticalAlign.Middle; iRowNumber.HeaderStyle.HorizontalAlign = HorizontalAlign.Center; iRowNumber.ItemStyle.VerticalAlign = VerticalAlign.Middle; iRowNumber.ItemStyle.HorizontalAlign = HorizontalAlign.Center; dt.Columns.Add("iRowNumber", i.GetType()); dt2.Columns.Add("iRowNumber", s.GetType()); //------------------------------------------ //------------------------شناسه محل Telerik.Web.UI.GridBoundColumn iZonePlaceNumberCol = new Telerik.Web.UI.GridBoundColumn(); dgdZone.MasterTableView.Columns.Add(iZonePlaceNumberCol); // dgdZone0.MasterTableView.Columns.Add(iZonePlaceNumberCol); iZonePlaceNumberCol.HeaderText = "iZonePlaceNumber"; iZonePlaceNumberCol.UniqueName = "iZonePlaceNumber"; iZonePlaceNumberCol.DataField = "iZonePlaceNumber"; iZonePlaceNumberCol.Visible = false; iZonePlaceNumberCol.ForceExtractValue = GridForceExtractValues.Always; dt.Columns.Add("iZonePlaceNumber", i.GetType()); dt.Columns.Add("strPlaceName", s.GetType()); //------------------------------ //--------------------------------نام محل Telerik.Web.UI.GridBoundColumn strPlaceNameCol = new Telerik.Web.UI.GridBoundColumn(); dgdZone.MasterTableView.Columns.Add(strPlaceNameCol); // dgdZone0.MasterTableView.Columns.Add(strPlaceNameCol); strPlaceNameCol.HeaderText = "نام محل"; strPlaceNameCol.UniqueName = "strPlaceName"; strPlaceNameCol.DataField = "strPlaceName"; strPlaceNameCol.Visible = true; strPlaceNameCol.HeaderStyle.Width = Unit.Pixel(180); strPlaceNameCol.ItemStyle.Width = Unit.Pixel(180); strPlaceNameCol.ForceExtractValue = GridForceExtractValues.Always; strPlaceNameCol.AllowFiltering = false; strPlaceNameCol.HeaderStyle.VerticalAlign = VerticalAlign.Middle; strPlaceNameCol.HeaderStyle.HorizontalAlign = HorizontalAlign.Center; strPlaceNameCol.ItemStyle.VerticalAlign = VerticalAlign.Middle; strPlaceNameCol.ItemStyle.HorizontalAlign = HorizontalAlign.Right; strPlaceNameCol.AllowSorting = false; strPlaceNameCol.AllowFiltering = false; dt2.Columns.Add("iZonePlaceNumber", i.GetType()); dt2.Columns.Add("strPlaceName", s.GetType()); //------------------------------ objContractItem.dtblContractItem = clsMain.SelectByCondition("Select * from vContractItem where bShowDailyReport=1" + " Order by iParentNumber asc"); for (i = 0; i <= objContractItem.dtblContractItem.Rows.Count - 1; i++) { Telerik.Web.UI.GridBoundColumn col = new Telerik.Web.UI.GridBoundColumn(); if (objContractItem.dtblContractItem.Rows[i]["bIncomplete"].ToBool() == true) { // dgdZone0.MasterTableView.Columns.Add(col); dt2.Columns.Add(objContractItem.dtblContractItem.Rows[i]["iNumber"].ToString(), i.GetType()); } else { dgdZone.MasterTableView.Columns.Add(col); dt.Columns.Add(objContractItem.dtblContractItem.Rows[i]["iNumber"].ToString(), i.GetType()); } if (objContractItem.dtblContractItem.Rows[i]["iParentNumber"].ToStr().Length > 0) { //col.ColumnGroupName = "grp" + objContractItem.dtblContractItem.Rows[i]["iParentNumber"].ToStr(); } col.UniqueName =objContractItem.dtblContractItem.Rows[i]["iNumber"].ToString(); col.DataField = objContractItem.dtblContractItem.Rows[i]["iNumber"].ToString(); col.ForceExtractValue = GridForceExtractValues.Always; col.HeaderText = objContractItem.dtblContractItem.Rows[i]["strName"].ToString(); col.HeaderStyle.VerticalAlign = VerticalAlign.Middle; col.HeaderStyle.HorizontalAlign = HorizontalAlign.Center; col.ItemStyle.VerticalAlign = VerticalAlign.Middle; col.ItemStyle.HorizontalAlign = HorizontalAlign.Center; col.HeaderStyle.Width = Unit.Pixel(100); col.AllowSorting = false; col.AllowFiltering = false; col.Groupable = false; } // } GlobalMActivity.dt = dt; GlobalMActivity.dt2 = dt2; dgdZone.DataSource = dt; //dgdZone0.DataSource = dt2; dgdZone.DataBind(); // dgdZone0.DataBind(); }
...<script> function pbBtn1() { __doPostBack("button1", "") } </script></asp:Content><asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server" ><telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="button1"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="rts" LoadingPanelID="RadAjaxLoadingPanel3" /> <telerik:AjaxUpdatedControl ControlID="rmp" LoadingPanelID="RadAjaxLoadingPanel3" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings></telerik:RadAjaxManager> <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel3" runat="server" /> <div class="mainContent_bg" > <div class="mainContentContainerContent"> <div class="spessore10"></div> <br /> <br /> <div id="xls"> <telerik:RadTabStrip ID="rts" runat="server" MultiPageID="rmp" OnClientTabSelected="pbBtn1"> <Tabs> <telerik:RadTab Text="page1" selected="true" PageViewID="page1"></telerik:RadTab> <telerik:RadTab Text="page2" selected="false" PageViewID="page2"></telerik:RadTab> </Tabs> </telerik:RadTabStrip> <telerik:RadMultiPage ID="rmp" runat="server"> <telerik:RadPageView runat=server ID="page1" Selected=true BorderColor="Black" Height=500 BackColor="Gray"> <asp:Label ID=lb1 runat=server Text="Label1 base"></asp:Label> <br /> </telerik:RadPageView> <telerik:RadPageView runat=server ID="page2" BorderColor="Black" Height=500 BackColor="Gray"> <asp:Label ID=lb2 runat=server Text="Label2 base"></asp:Label> <br /> <br /> </telerik:RadPageView> </telerik:RadMultiPage> </div> <telerik:radButton ID="button1" runat="server" Text=button1 /> <asp:Button ID="button2" runat="server" OnClientClick="pbBtn1()" Text=button2 />