
<telerik:RadWindowManager ID="RadWindowManager1" runat="server" EnableShadow="true"> </telerik:RadWindowManager> <telerik:RadWindow ID="radwindowPopup" runat="server" Animation="FlyIn" CssClass="modalPopup" DestroyOnClose="true" EnableShadow="true" KeepInScreenBounds="true" Width="420px" Height="150px" MaxHeight="150px" MaxWidth="420px" MinHeight="150px" MinWidth="420px" Modal="true" RenderMode="Classic" VisibleTitlebar="true" VisibleStatusbar="false" Behaviors="Close" Title="Manifest-BI" Skin="Outlook"> <ContentTemplate> <center> <div style="padding: 20px"> <asp:Label ID="lblMsg" runat="server"></asp:Label> <br /> <br /> <telerik:RadButton ID="btnOk" runat="server" Text="Yes" Width="70px" Skin="Outlook" /> <telerik:RadButton ID="btnCancel" runat="server" Text="No" Width="70px" Skin="Outlook" /> </div> </center> </ContentTemplate> </telerik:RadWindow> <fieldset id="fs1" runat="server" style="height: auto; width: 650PX; border-style: outset; border-width: 1.5px; border-color: Blue; z-index: 1" class="loginField"> <legend style="border-style: outset; border-width: 1.5px; border-color: Blue; font-weight: bold; z-index: 1">COMPANY LIST</legend> <center> <table> <tr> <td> <telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" ClientEvents-OnRequestStart="onRequestStart"> <%-- EnableViewState="False" --%> <telerik:RadGrid ID="RadGrid1" runat="server" Width="530px" OnNeedDataSource="RadGrid1_NeedDataSource" AllowPaging="true" PageSize="10" AllowSorting="true" ShowGroupPanel="True" Skin="WebBlue" OnDeleteCommand="RadGrid1_DeleteCommand" HeaderStyle-Font-Bold="true" OnPreRender="RadGrid1_PreRender" OnUpdateCommand="RadGrid1_UpdateCommand" OnItemCreated="RadGrid1_ItemCreated" OnInsertCommand="RadGrid1_InsertCommand" OnItemCommand="RadGrid1_ItemCommand"> <ExportSettings ExportOnlyData="true" OpenInNewWindow="true" IgnorePaging="true"> <Pdf AllowAdd="true" AllowCopy="true" AllowModify="true" AllowPrinting="true" BorderColor="Black" BorderStyle="Medium" BorderType="AllBorders" PageBottomMargin="20px" PageFooter-LeftCell-TextAlign="Center" PageFooterMargin="20px" PageHeader-LeftCell-TextAlign="Center" PageHeaderMargin="20px" PageLeftMargin="35px" PageRightMargin="35px" PageTitle="List Of Companies and Details" PageTopMargin="35px" PaperSize="A4" UserPassword="ss"> </Pdf> </ExportSettings> <PagerStyle Mode="NextPrevAndNumeric" AlwaysVisible="true"></PagerStyle> <ClientSettings Selecting-AllowRowSelect="true" AllowDragToGroup="True" EnablePostBackOnRowClick="true"> <Selecting AllowRowSelect="True" UseClientSelectColumnOnly="True"></Selecting> </ClientSettings> <MasterTableView EditMode="EditForms" AutoGenerateColumns="true" DataKeyNames="CompId" CommandItemDisplay="Top" CommandItemSettings-ShowAddNewRecordButton="true"> <CommandItemSettings ShowExportToPdfButton="true" /> <CommandItemSettings ShowExportToExcelButton="true" /> <CommandItemSettings ShowExportToWordButton="true" /> <CommandItemSettings ShowExportToCsvButton="true" /> <EditFormSettings FormMainTableStyle-HorizontalAlign="Center" EditColumn-ButtonType="ImageButton" FormTableStyle-Width="350px" FormTableButtonRowStyle-HorizontalAlign="Center" FormTableStyle-CellPadding="3" FormMainTableStyle-Font-Bold="true" FormMainTableStyle-ForeColor="Purple" FormStyle-CssClass="" FormTableStyle-CellSpacing="5" InsertCaption="Add New Record" FormCaptionStyle-Font-Bold="true" FormCaptionStyle-Font-Underline="true" FormCaptionStyle-ForeColor="Black" FormCaptionStyle-Font-Size="Large" FormCaptionStyle-HorizontalAlign="Center" FormCaptionStyle-Width="100%"> <FormStyle Width="100%" BackColor="LightCyan"></FormStyle> </EditFormSettings> <Columns> <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditColumn"> </telerik:GridEditCommandColumn> </Columns> </MasterTableView> <MasterTableView> <Columns> <telerik:GridButtonColumn CommandName="Delete" Text="Delete" UniqueName="DeleteColumn" ButtonType="ImageButton" /> </Columns> </MasterTableView> </telerik:RadGrid> </telerik:RadAjaxPanel> </td> </tr> </table> </center> </fieldset>

<telerik:RadGrid ID="RadGrid_Details" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource_Details" GridLines="None" AllowAutomaticInserts="True" AllowAutomaticDeletes="True" AllowAutomaticUpdates="True" AllowSorting="True" onitemcommand="RadGrid_Details_ItemCommand" OnItemDeleted="RadGrid_Details_ItemDeleted" OnItemInserted="RadGrid_Details_ItemInserted" OnItemUpdated="RadGrid_Details_ItemUpdated" Width="925px" onitemdatabound="RadGrid_Details_ItemDataBound" onprerender="RadGrid_Details_PreRender" > <ClientSettings AllowDragToGroup="True"> </ClientSettings> <MasterTableView DataSourceID="SqlDataSource_Details" autogeneratecolumns="False" commanditemdisplay="Bottom" editmode="InPlace" ShowFooter="true" horizontalalign="NotSet" AllowPaging="True" DataKeyNames="Detail_GUID" > <Columns>(column telerik:control definitions) </Columns> <EditFormSettings> <EditColumn UniqueName="EditCommandColumn1"> </EditColumn> </EditFormSettings> </MasterTableView> </telerik:RadGrid><telerik:RadScriptManager ID="RadScriptManager1" runat="server"></telerik:RadScriptManager><telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="RadGridSmears"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadGridSmears"></telerik:AjaxUpdatedControl> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings></telerik:RadAjaxManager><telerik:RadGrid ID="RadGridSmears" runat="server" CellSpacing="0" DataSourceID="SqlDataSourceSmears" ShowStatusBar="True" AutoGenerateColumns="False" PageSize="3" AllowSorting="True" AllowPaging="True" GridLines="None" AllowAutomaticDeletes="True" AllowAutomaticUpdates="True" OnItemUpdated="RadGridSmears_ItemUpdated" OnItemDeleted="RadGridSmears_ItemDeleted"> <PagerStyle Mode="NumericPages"></PagerStyle> <MasterTableView DataSourceID="SqlDataSourceSmears" DataKeyNames="SampleNo" AllowMultiColumnSorting="True" Width="100%" CommandItemDisplay="Top" Name="Smears"> <DetailTables> <telerik:GridTableView DataKeyNames="AnalysisNo" DataSourceID="SqlDataSourceAnalysis" Width="100%" runat="server" CommandItemDisplay="Top" Name="Analysis"> <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="SampleNo" MasterKeyField="SampleNo"> </telerik:GridRelationFields> </ParentTableRelation>
...blah...blah<asp:SqlDataSource ID="SqlDataSourceAnalysis" runat="server" ConnectionString="<%$ ConnectionStrings:XConnectionString %>" DeleteCommand="DELETE FROM [Analysis] WHERE [AnalysisNo] = @AnalysisNo AND [AnalysisDateTime]=@AnalysisDateTime" SelectCommand="SELECT * FROM [Analysis] WHERE [SampleNo] = @SampleNo" UpdateCommand="UPDATE [Analysis] SET [AnalysisDateTime] = @AnalysisDateTime, [AlphaCPM] = @AlphaCPM, [BetaCPM] = @BetaCPM, [InstrumentIDAlpha] = @InstrumentIDAlpha WHERE [AnalysisNo] = @AnalysisNo"> <SelectParameters> <asp:Parameter Name="SampleNo" Type="String"></asp:Parameter> </SelectParameters> <DeleteParameters> <asp:Parameter Name="AnalysisNo" Type="Int32"></asp:Parameter> <asp:Parameter Name="AnalysisDateTime" Type="DateTime"></asp:Parameter> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="AnalysisDateTime" Type="DateTime"></asp:Parameter> <asp:Parameter Name="AlphaCPM" Type="Int32"></asp:Parameter> <asp:Parameter Name="BetaCPM" Type="Int32"></asp:Parameter> <asp:Parameter Name="InstrumentIDAlpha" Type="String"></asp:Parameter> <asp:Parameter Name="AnalysisNo" Type="Int32"></asp:Parameter> </UpdateParameters></asp:SqlDataSource><asp:SqlDataSource ID="SqlDataSourceSmears" runat="server" ConnectionString="<%$ ConnectionStrings:XConnectionString %>" DeleteCommand="DELETE FROM [Smears] WHERE [SampleNo] = @SampleNo" SelectCommand="SELECT * FROM [Smears] WHERE [SampleNo] = @SampleNo" UpdateCommand="UPDATE [Smears] SET [Station] = @Station, [SampleDate] = @SampleDate, [BagNo] = @BagNo WHERE [SampleNo] = @SampleNo"> <SelectParameters> <asp:Parameter Name="SampleNo" Type="String"></asp:Parameter> </SelectParameters> <DeleteParameters> <asp:Parameter Name="SampleNo" Type="String"></asp:Parameter> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="Station" Type="String"></asp:Parameter> <asp:Parameter Name="SampleDate" Type="DateTime"></asp:Parameter> <asp:Parameter Name="BagNo" Type="Int32"></asp:Parameter> <asp:Parameter Name="SampleNo" Type="String"></asp:Parameter> </UpdateParameters></asp:SqlDataSource> var imagePath = Server.MapPath("myPath"); System.Drawing.Image image = System.Drawing.Image.FromFile(imagePath); using (var stream = new System.IO.MemoryStream()) { image.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
MyRadBinaryImage.Width = 525
MyRadBinaryImage.Height = 613; MyRadBinaryImage.DataValue = stream.ToArray(); }<telerik:radbinaryimage id="MyRadBinaryImage" runat="server" alternatetext="BinaryImage" width="525" height="613" resizemode="Fit" ClientIDMode="Static"></telerik:radbinaryimage>

Hi Arumugam,
Post the below issue in telerik.
I am using a radgrid with paging. In that next and last page is working but previous and first page buttons are not working.
<telerik:RadGrid ID="rgRole3" runat="server" Skin="Office2007"
CssClass="rgrole1" onneeddatasource="rgRole3_NeedDataSource"
AllowPaging="True" PagerStyle-AlwaysVisible="true" CellSpacing="0"
GridLines="None" AllowSorting="True" AutoGenerateColumns="False" onupdatecommand="rgRole3_UpdateCommand">
<PagerStyle AlwaysVisible="True" PageSizeControlType="RadComboBox" Mode="NextPrevAndNumeric" ></PagerStyle>
<ClientSettings>
<Scrolling AllowScroll="True" UseStaticHeaders="true" />
</ClientSettings>
<MasterTableView>
<CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>
<RowIndicatorColumn FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn>
<ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column"
Created="True"></ExpandCollapseColumn>
<Columns>
<telerik:GridEditCommandColumn Display="true" HeaderStyle-Width="60px"
CancelImageUrl="Cancel.gif" InsertImageUrl="Update.gif"
UpdateImageUrl="Update.gif">
<HeaderStyle Width="60px"></HeaderStyle>
</telerik:GridEditCommandColumn>
<EditFormSettings>
<EditColumn UniqueName="EditCommandColumn1"
FilterControlAltText="Filter EditCommandColumn1 column"
CancelImageUrl="Cancel.gif" InsertImageUrl="Update.gif"
UpdateImageUrl="Update.gif"></EditColumn>
</EditFormSettings>
<PagerStyle AlwaysVisible="True" PageSizeControlType="RadComboBox"></PagerStyle>
</MasterTableView>
<clientsettings>
<Selecting AllowRowSelect="True" />
<scrolling allowscroll="True" UseStaticHeaders="true" ScrollHeight="350px" /></clientsettings>
<FilterMenu EnableImageSprites="False"></FilterMenu>
</telerik:RadGrid>
I have searched all your demos and forums but I am not able to find the correct solution. Please let us know the correct solution
Thanks
Public Function GetDataTable(ByVal query As String) As DataTable Dim ConnString As [String] = ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString Dim adapter As New SqlDataAdapter() Dim myDataTable As New DataTable() Using conn As New SqlConnection(ConnString) adapter.SelectCommand = New SqlCommand(query, conn) adapter.Fill(myDataTable) End Using Return myDataTableEnd FunctionRadGrid1.DataSource = GetDataTable(q.ToString)RadGrid1.DataBind()Protected Sub RadGrid1_PreRender(sender As Object, e As System.EventArgs) Handles RadGrid1.PreRender Dim expression As GridSortExpression = New GridSortExpression() expression.FieldName = "Column1" expression.SortOrder = GridSortOrder.Descending RadGrid1.MasterTableView.SortExpressions.AddSortExpression(expression) Dim dt As GridBoundColumn = RadGrid1.MasterTableView.GetColumnSafe("Column1") If dt IsNot Nothing Then 'dt.DataType = TypeOf(DateTime.Now.ToString) << -- NOT WORKING End If RadGrid1.MasterTableView.Rebind()End Sub