or
If (String.IsNullOrEmpty(Me.grdShiftObservation.MasterTableView.FilterExpression)) Then Me.grdShiftObservation.MasterTableView.FilterExpression = dtFromStringElse Me.grdShiftObservation.MasterTableView.FilterExpression = Me.grdShiftObservation.MasterTableView.FilterExpression & " AND " & dtFromStringend if========================== Exception.ascx.cs=====================================================
protected void grdFatal_PreRender(object sender, EventArgs e) { if (grdFatal.Items.Count != 0) { GridColumn grdCellTower = grdFatal.MasterTableView.GetColumn("CellTowerId"); grdCellTower.HeaderStyle.Width = Unit.Pixel(80); GridColumn grdDate = grdFatal.MasterTableView.GetColumn("Date"); grdDate.HeaderStyle.Width = Unit.Pixel(80); GridColumn grdFWVer = grdFatal.MasterTableView.GetColumn("FWVer"); grdFWVer.HeaderStyle.Width = Unit.Pixel(55); GridColumn grdLastStatus = grdFatal.MasterTableView.GetColumn("LastStatus"); grdLastStatus.HeaderStyle.Width = Unit.Pixel(65); GridColumn grdMeterType = grdFatal.MasterTableView.GetColumn("MeterType"); grdMeterType.HeaderStyle.Width = Unit.Pixel(95); GridColumn grdModemFWVer = grdFatal.MasterTableView.GetColumn("ModemFWVer"); grdModemFWVer.HeaderStyle.Width = Unit.Pixel(120); GridColumn grdSerialNumber = grdFatal.MasterTableView.GetColumn("SerialNumber"); grdSerialNumber.HeaderStyle.Width = Unit.Pixel(120); GridColumn grdStatusId = grdFatal.MasterTableView.GetColumn("StatusId"); grdStatusId.HeaderStyle.Width = Unit.Pixel(55); GridColumn grdStatusName = grdFatal.MasterTableView.GetColumn("StatusName"); grdStatusName.HeaderStyle.Width = Unit.Pixel(90); GridColumn grdTxJobId = grdFatal.MasterTableView.GetColumn("TxJobId"); grdTxJobId.HeaderStyle.Width = Unit.Pixel(58); } }========================== Exception.ascx=====================================================
function ColumnResizing(sender, args) { if (args._gridColumn._data.UniqueName == "CellTowerId" && args._gridColumn._columnResizer._currentWidth < 80) { args._cancel = true; } else if (args._gridColumn._data.UniqueName == "Date" && args._gridColumn._columnResizer._currentWidth < 80) { args._cancel = true; } else if (args._gridColumn._data.UniqueName == "FWVer" && args._gridColumn._columnResizer._currentWidth < 55) { args._cancel = true; } else if (args._gridColumn._data.UniqueName == "LastStatus" && args._gridColumn._columnResizer._currentWidth < 65) { args._cancel = true; } else if (args._gridColumn._data.UniqueName == "MeterType" && args._gridColumn._columnResizer._currentWidth < 95) { args._cancel = true; } else if (args._gridColumn._data.UniqueName == "ModemFWVer" && args._gridColumn._columnResizer._currentWidth < 120) { args._cancel = true; } else if (args._gridColumn._data.UniqueName == "SerialNumber" && args._gridColumn._columnResizer._currentWidth < 120) { args._cancel = true; } else if (args._gridColumn._data.UniqueName == "StatusId" && args._gridColumn._columnResizer._currentWidth < 55) { args._cancel = true; } else if (args._gridColumn._data.UniqueName == "StatusName" && args._gridColumn._columnResizer._currentWidth < 108) { args._cancel = true; } else if (args._gridColumn._data.UniqueName == "TxJobId" && args._gridColumn._columnResizer._currentWidth < 90) { args._cancel = true; } else if (args._gridColumn._data.UniqueName == "Error" && args._gridColumn._columnResizer._currentWidth < 600) { args._cancel = true; } }</script> <div id="divGrid" style="margin-left:5px;"> <telerik:RadGrid ID="grdFatal" AllowMultiRowSelection="True" runat="server" AllowPaging="True" OnSelectedIndexChanged="grdFatal_OnSelectedIndexChanged" ShowStatusBar="True" Width="99%" onprerender="grdFatal_PreRender" onitemcreated="grdFatal_ItemCreated" onneeddatasource="grdFatal_NeedDataSource" CellSpacing="0" GridLines="Horizontal" Skin="WebBlue" AllowSorting="True" > <MasterTableView PageSize="10" TableLayout="Fixed"> <CommandItemSettings ExportToPdfText="Export to PDF" /> <RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column" /> <ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column" /> <Columns> <telerik:GridClientSelectColumn UniqueName="ClientSelectColumn" HeaderStyle-Width="30px" Resizable="False" > <HeaderStyle Width="30px"></HeaderStyle> </telerik:GridClientSelectColumn> </Columns> <EditFormSettings> <EditColumn FilterControlAltText="Filter EditCommandColumn column" /> </EditFormSettings> </MasterTableView> <HeaderStyle Wrap="false" HorizontalAlign="Left" VerticalAlign="Middle" /> <ItemStyle Wrap="true" HorizontalAlign="Left" VerticalAlign="Middle" /> <PagerStyle Mode="NumericPages" /> <ClientSettings EnableRowHoverStyle="true" EnablePostBackOnRowClick="true" > <Selecting CellSelectionMode="None" AllowRowSelect="True" /> <Selecting AllowRowSelect="True" /> <Scrolling AllowScroll="true" UseStaticHeaders="true" SaveScrollPosition="true"></Scrolling> <Resizing AllowColumnResize="true" AllowRowResize="false" ResizeGridOnColumnResize="false" ClipCellContentOnResize="true" EnableRealTimeResize="false" AllowResizeToFit="true"/> <ClientEvents OnColumnResizing="ColumnResizing"/> </ClientSettings> <FilterMenu EnableImageSprites="False"></FilterMenu> </telerik:RadGrid> </div>Protected Sub mnuLifts_ItemClick(ByVal sender As Object, ByVal e As Telerik.Web.UI.RadPanelBarEventArgs) Handles mnuLifts.ItemClick Dim intDay As Integer = Date.Today.Day - 1 Dim strURL As String = String.Empty AllParams = New clsParameters With AllParams .CustomerID = Me.cboCustomer.SelectedValue .CustomerName = Me.cboCustomer.Text Select Case Cint(e.Item.Value) Case 1 .qryBase = "uspStoredProc1" .BDate = CDate(Today.Date) .Edate = CDate(Today.Date) strURL = "xxxxxxxx.aspx" AllParams.Title = Me.cboCustomer.Text & "text here ommited" Case 2 .qryBase = "uspStoredProc2" AllParams.BDate = String.Empty AllParams.Edate = String.Empty strURL = "yyyyyyyyyy.aspx" AllParams.Title = Me.cboCustomer.Text & "text here ommited" Case "3" ' lifts per month .qryBase = "uspStoredProc3" AllParams.BDate = CDate(DateAdd(DateInterval.Day, -intDay, Today.Date)) AllParams.Edate = CDate(Today.Date) strURL = "zzzzzz.aspx" AllParams.Title = Me.cboCustomer.Text & ControlChars.CrLf & "text here ommited " & AllParams.BDate.ToString & " to " & AllParams.Edate.ToString End Select End With ScriptManager.RegisterStartupScript(Me.Page, Page.GetType(), "radWin", "MyFunction(); return false", True) End Sub<script type="text/javascript"> function OpenCommun() { var wnd = $find("<%=dlgCommun.ClientID%>"); wnd.setUrl("xxxxxxxxxxxxxx.aspx"); wnd.show(); } function GetRadWindow() { var oWindow = null; if (window.radWindow) oWindow = window.radWindow; else if (window.frameElement.radWindow) oWindow = window.frameElement.radWindow; return oWindow; } function CloseCommun() { GetRadWindow().close(); } </script>