Convert asp Gridview to Telerik RadGrid

4 posts, 0 answers
  1. Aftab
    Aftab avatar
    1 posts
    Member since:
    Apr 2013

    Posted 28 Apr 2013 Link to this post

    Kindly help me
    I want to convert asp grid view to Telerik RadGrid
    This is my code
    i try my level best but i am unable to do this

    <asp:GridView ID="grdWeeks" runat="server" AutoGenerateColumns="false" ShowFooter="false"
                                    BorderColor="Transparent" ShowHeader="false" OnRowDataBound="grdWeeks_RowDataBound"
                                    Width="100%">
                                    <Columns>
                                        <asp:TemplateField>
                                            <ItemTemplate>
                                                <fieldset>
                                                    <legend>
                                                        <asp:Label ID="lblWeekTitle" runat="server" Text=""></asp:Label>
                                                    </legend>
                                                    <table id="tblSave" runat="server" width="100%" border="0" cellpadding="0" cellspacing="0">
                                                        <tr>
                                                            <td>
                                                                <table width="100%" border="0" cellpadding="0" cellspacing="0">
                                                                    <tr>
                                                                        <th style="text-align: right; background-color: #CFE2FC; height: 34px;">
                                                                            <asp:Label ID="lblHeadingTotal" runat="server" Text="TOTALS:" Style="position: relative;
                                                                                right: 84px;"></asp:Label>
                                                                            <asp:Label ID="lblWeekTotal1" runat="server" Text="9.922 €" Style="position: relative;
                                                                                right: 8px;"></asp:Label>
                                                                        </th>
                                                                    </tr>
                                                                    <tr>
                                                                        <td>
                                                                            <asp:GridView ID="grdWeekDetail1" runat="server" AutoGenerateColumns="false" RowStyle-CssClass="rowstyle"
                                                                                ShowHeader="false" ShowFooter="false" HeaderStyle-CssClass="header_row" AlternatingRowStyle-CssClass="alternate_row"
                                                                                GridLines="None" OnRowDataBound="grdWeekDetail1_RowDataBound" OnRowCommand="grdWeekDetail1_RowCommand"
                                                                                Width="100%">
                                                                                <Columns>
                                                                                    <asp:TemplateField ItemStyle-HorizontalAlign="Right" HeaderStyle-HorizontalAlign="Right"
                                                                                        ItemStyle-Width="175">
                                                                                <ItemTemplate>
                                                                                            <div id="divDays" runat="server">
                                                                                                <asp:Label ID="lblDays" runat="server" Text="Suday 14/05/2011" Style="position: relative;
                                                                                                    right: 35px;"></asp:Label>
                                                                                                <asp:LinkButton ID="lnkDays" runat="server" CommandName="order" Style="position: relative;
                                                                                                    right: 35px;"></asp:LinkButton>
                                                                                            </div>
                                                                                        </ItemTemplate>
                                                                                    </asp:TemplateField>
                                                                                    <asp:TemplateField ItemStyle-HorizontalAlign="Right" HeaderStyle-HorizontalAlign="Right">
                                                                                        <ItemTemplate>
                                                                                            <asp:Label ID="lblTotal" runat="server" Style="position: relative; right: 8px;"></asp:Label>
                                                                                        </ItemTemplate>
                                                                                    </asp:TemplateField>
                                                                                </Columns>
                                                                            </asp:GridView>
                                                                        </td>
                                                                    </tr>
                                                                </table>
                                                            </td>
                                                            <td style="width: 2px; background-color: #9c9c9c;">
                                                            </td>
                                                            <td>
                                                                <table width="100%" border="0" cellpadding="0" cellspacing="0">
                                                                    <tr>
                                                                        <th style="text-align: left; background-color: #CFE2FC; height: 34px;">
                                                                            <asp:Label ID="lblWeekTotal2" runat="server" Text="9.922 €" Style="position: relative;
                                                                                left: 8px;"></asp:Label>
                                                                            <asp:Label ID="Label1" runat="server" Text="TOTALS:" Style="display: none;"></asp:Label>
                                                                        </th>
                                                                    </tr>
                                                                    <tr>
                                                                        <td>
                                                                            <asp:GridView ID="grdWeekDetail2" runat="server" AutoGenerateColumns="false" RowStyle-CssClass="rowstyle"
                                                                                ShowHeader="false" ShowFooter="false" HeaderStyle-CssClass="header_row" AlternatingRowStyle-CssClass="alternate_row"
                                                                                GridLines="None" OnRowDataBound="grdWeekDetail2_RowDataBound" OnRowCommand="grdWeekDetail2_RowCommand"
                                                                                Width="100%">
                                                                                <Columns>
                                                                                    <asp:TemplateField ItemStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Left">
                                                                                        <ItemTemplate>
                                                                                            <div id="divDays" runat="server">
                                                                                                <asp:Label ID="lblTotal" runat="server" Style="position: relative; left: 8px;"></asp:Label>
                                                                                            </div>
                                                                                        </ItemTemplate>
                                                                                    </asp:TemplateField>
                                                                                    <asp:TemplateField ItemStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Left"
                                                                                        ItemStyle-Width="175">
                                                                                        <ItemTemplate>
                                                                                            <asp:Label ID="lblDays" runat="server" Text="Suday 14/05/2011" Style="position: relative;
                                                                                                left: 35px;"></asp:Label>
                                                                                            <asp:LinkButton ID="lnkDays" runat="server" CommandName="order" Style="position: relative;
                                                                                                left: 35px;"></asp:LinkButton>
                                                                                        </ItemTemplate>
                                                                                    </asp:TemplateField>
                                                                                </Columns>
                                                                            </asp:GridView>
                                                                        </td>
                                                                    </tr>
                                                                </table>
                                                            </td>
                                                            <td style="width: 2px; background-color: #9c9c9c;">
                                                            </td>
                                                            <td>
                                                                <table width="100%" border="0" cellpadding="0" cellspacing="0" style="height: 187px;
                                                                    width: 100%;" align="center">
                                                                    <tr>
                                                                        <th valign="top" style="position: relative; background-color: #CFE2FC;" align="center">
                                                                            <div id="divDifference" runat="server" class="textbox115" style="width: 115px;">
                                                                                <asp:Label ID="lblDifference" runat="server" Text="00,00"></asp:Label>
                                                                            </div>
                                                                        </th>
                                                                    </tr>
                                                                    <tr class="rowstyle">
                                                                        <td align="center">
                                                                            <asp:Label ID="lblSaturdayDiff" runat="server"></asp:Label>
                                                                        </td>
                                                                    </tr>
                                                                    <tr class="alternate_row">
                                                                        <td align="center">
                                                                            <asp:Label ID="lblFridayDiff" runat="server"></asp:Label>
                                                                        </td>
                                                                    </tr>
                                                                    <tr class="rowstyle">
                                                                        <td align="center">
                                                                            <asp:Label ID="lblThursdayDiff" runat="server"></asp:Label>
                                                                        </td>
                                                                    </tr>
                                                                    <tr class="alternate_row">
                                                                        <td align="center">
                                                                            <asp:Label ID="lblWednesdayDiff" runat="server"></asp:Label>
                                                                        </td>
                                                                    </tr>
                                                                    <tr class="rowstyle">
                                                                        <td align="center">
                                                                            <asp:Label ID="lblTuesdayDiff" runat="server"></asp:Label>
                                                                        </td>
                                                                    </tr>
                                                                    <tr class="alternate_row">
                                                                        <td align="center">
                                                                            <asp:Label ID="lblMondayDiff" runat="server"></asp:Label>
                                                                        </td>
                                                                    </tr>
                                                                    <tr class="rowstyle">
                                                                        <td align="center">
                                                                            <asp:Label ID="lblSundayDiff" runat="server"></asp:Label>
                                                                        </td>
                                                                    </tr>
                                                                </table>
                                                            </td>
                                                            <td style="width: 2px; background-color: #9c9c9c;">
                                                            </td>
                                                            <td>
                                                                <table width="100%" border="0" cellpadding="0" cellspacing="0" style="height: 187px;
                                                                    width: 100%;" align="center">
                                                                    <tr>
                                                                        <th valign="top" style="position: relative; background-color: #CFE2FC;" align="center">
                                                                            <div id="divPercentage" runat="server" class="textbox115" style="width: 115px;">
                                                                                <asp:Label ID="lblPercentage" runat="server" Text="00,00"></asp:Label>
                                                                            </div>
                                                                        </th>
                                                                    </tr>
                                                                    <tr class="rowstyle">
                                                                        <td align="center">
                                                                            <asp:Label ID="lblSaturdayPer" runat="server"></asp:Label>
                                                                        </td>
                                                                    </tr>
                                                                    <tr class="alternate_row">
                                                                        <td align="center">
                                                                            <asp:Label ID="lblFridayPer" runat="server"></asp:Label>
                                                                        </td>
                                                                    </tr>
                                                                    <tr class="rowstyle">
                                                                        <td align="center">
                                                                            <asp:Label ID="lblThursdayPer" runat="server"></asp:Label>
                                                                        </td>
                                                                    </tr>
                                                                    <tr class="alternate_row">
                                                                        <td align="center">
                                                                            <asp:Label ID="lblWednesdayPer" runat="server"></asp:Label>
                                                                        </td>
                                                                    </tr>
                                                                    <tr class="rowstyle">
                                                                        <td align="center">
                                                                            <asp:Label ID="lblTuesdayPer" runat="server"></asp:Label>
                                                                        </td>
                                                                    </tr>
                                                                    <tr class="alternate_row">
                                                                        <td align="center">
                                                                            <asp:Label ID="lblMondayPer" runat="server"></asp:Label>
                                                                        </td>
                                                                    </tr>
                                                                    <tr class="rowstyle">
                                                                        <td align="center">
                                                                            <asp:Label ID="lblSundayPer" runat="server"></asp:Label>
                                                                        </td>
                                                                    </tr>
                                                                </table>
                                                            </td>
                                                        </tr>
                                                    </table>
                                                    <table id="tblStaff" runat="server" visible="false" width="100%" border="0" cellpadding="0"
                                                        cellspacing="0">
                                                        <tr>
                                                            <th style="width: 274px;">
                                                                WEEK TOTALS:
                                                            </th>
                                                            <th>
                                                                <div class="textbox_small">
                                                                    <asp:Label ID="lblIncome_WeekTotal" runat="server" Text="00,00"></asp:Label>
                                                                </div>
                                                            </th>
                                                            <th>
                                                                <div class="textbox_small">
                                                                    <asp:Label ID="lblSalary_WeekTotal" runat="server" Text="00,00"></asp:Label>
                                                                </div>
                                                            </th>
                                                            <th>
                                                                <div class="textbox_small">
                                                                    <asp:Label ID="lblTips_WeekTotal" runat="server" Text="00,00"></asp:Label>
                                                                </div>
                                                            </th>
                                                            <th>
                                                                <div class="textbox_small">
                                                                    <asp:Label ID="lblBonus_WeekTotal" runat="server" Text="00,00"></asp:Label>
                                                                </div>
                                                            </th>
                                                            <th>
                                                                <div class="textbox_small">
                                                                    <asp:Label ID="lblPenalty_WeekTotal" runat="server" Text="00,00"></asp:Label>
                                                                </div>
                                                            </th>
                                                            <th>
                                                                <div class="textbox_small">
                                                                    <asp:Label ID="lblAdvance_WeekTotal" runat="server" Text="00,00"></asp:Label>
                                                                </div>
                                                            </th>
                                                            <th style="width: 12px;">
                                                            </th>
                                                            <th>
                                                                <div class="textbox_small">
                                                                    <asp:Label ID="lblLate_WeekTotal" runat="server" Text="00,00"></asp:Label>
                                                                </div>
                                                            </th>
                                                        </tr>
                                                        <tr>
                                                            <td colspan="10">
                                                                <asp:GridView ID="grdSalaries" runat="server" AutoGenerateColumns="false" GridLines="Vertical"
                                                                    RowStyle-CssClass="rowstyle" ShowFooter="false" HeaderStyle-CssClass="header_row"
                                                                    AlternatingRowStyle-CssClass="alternate_row" OnRowDataBound="grdSalaries_RowDataBound"
                                                                    Width="100%">
                                                                    <Columns>
                                                                        <asp:TemplateField HeaderText="Date" ItemStyle-Width="150">
                                                                            <ItemTemplate>
                                                                                <div id="divDaysForSalaries" runat="server">
                                                                                    <asp:Label ID="lblDays" runat="server" Style="position: relative; left: 8px;" Text="<%#Bind('DayType') %>"></asp:Label>
                                                                                </div>
                                                                            </ItemTemplate>
                                                                        </asp:TemplateField>
                                                                        <asp:TemplateField HeaderText="Position" ItemStyle-Width="110">
                                                                            <ItemTemplate>
                                                                                <div id="divDays2" runat="server">
                                                                                    <asp:Label ID="lblPosition" runat="server" Style="position: relative; left: 8px;"
                                                                                        Text="<%#Bind('position') %>"></asp:Label>
                                                                                </div>
                                                                            </ItemTemplate>
                                                                        </asp:TemplateField>
                                                                        <asp:TemplateField HeaderText="Income" ItemStyle-Width="70">
                                                                            <ItemTemplate>
                                                                                <div id="divDays3" runat="server">
                                                                                    <asp:Label ID="lblIncome" runat="server" Style="position: relative; left: 8px;" Text="<%#Bind('income') %>"></asp:Label>
                                                                                </div>
                                                                            </ItemTemplate>
                                                                        </asp:TemplateField>
                                                                        <asp:TemplateField HeaderText="Salary" ItemStyle-Width="70">
                                                                            <ItemTemplate>
                                                                                <div id="divDays4" runat="server">
                                                                                    <asp:Label ID="lblSalary" runat="server" Style="position: relative; left: 8px;" Text="<%#Bind('Salary') %>"></asp:Label>
                                                                                </div>
                                                                            </ItemTemplate>
                                                                        </asp:TemplateField>
                                                                        <asp:TemplateField HeaderText="Tips" ItemStyle-Width="70">
                                                                            <ItemTemplate>
                                                                                <div id="divDays5" runat="server">
                                                                                    <asp:Label ID="lblTips" runat="server" Style="position: relative; left: 8px;" Text="<%#Bind('Tip') %>"></asp:Label>
                                                                                </div>
                                                                            </ItemTemplate>
                                                                        </asp:TemplateField>
                                                                        <asp:TemplateField HeaderText="Bonus" ItemStyle-Width="70">
                                                                            <ItemTemplate>
                                                                                <div id="divDays6" runat="server">
                                                                                    <asp:Label ID="lblBonus" runat="server" Style="position: relative; left: 8px;" Text="<%#Bind('Bonus') %>"></asp:Label>
                                                                                </div>
                                                                            </ItemTemplate>
                                                                        </asp:TemplateField>
                                                                        <asp:TemplateField HeaderText="Penalty" ItemStyle-Width="70">
                                                                            <ItemTemplate>
                                                                                <div id="divDays7" runat="server">
                                                                                    <asp:Label ID="lblAdvance" runat="server" Style="position: relative; left: 8px;"
                                                                                        Text="<%#Bind('Advance') %>"></asp:Label>
                                                                                </div>
                                                                            </ItemTemplate>
                                                                        </asp:TemplateField>
                                                                        <asp:TemplateField HeaderText="Advance" ItemStyle-Width="70">
                                                                            <ItemTemplate>
                                                                                <div id="divDays8" runat="server">
                                                                                    <asp:Label ID="lblPenalty" runat="server" Style="position: relative; left: 8px;"
                                                                                        Text="<%#Bind('Penalty') %>"></asp:Label>
                                                                                </div>
                                                                            </ItemTemplate>
                                                                        </asp:TemplateField>
                                                                        <asp:TemplateField HeaderText="Ontime">
                                                                            <ItemTemplate>
                                                                                <div id="divDays9" runat="server">
                                                                                    <asp:CheckBox ID="chkOnTime" runat="server" Checked="<%#Bind('ontime') %>" Enabled="false" />
                                                                                </div>
                                                                            </ItemTemplate>
                                                                        </asp:TemplateField>
                                                                        <asp:TemplateField HeaderText="Late" ItemStyle-Width="70">
                                                                            <ItemTemplate>
                                                                                <div id="divDays10" runat="server">
                                                                                    <asp:Label ID="lblLate" runat="server" Style="position: relative; left: 8px;" Text="<%#Bind('latehour') %>"></asp:Label>
                                                                                </div>
                                                                            </ItemTemplate>
                                                                        </asp:TemplateField>
                                                                    </Columns>
                                                                </asp:GridView>
                                                            </td>
                                                        </tr>
                                                    </table>
                                                </fieldset>
                                            </ItemTemplate>
                                        </asp:TemplateField>
                                    </Columns>
                                </asp:GridView>
  2. Shinu
    Shinu avatar
    17764 posts
    Member since:
    Mar 2007

    Posted 28 Apr 2013 Link to this post

    Hi,

    Try the following.
    aspx:
    <telerik:RadGrid ID="RadGrid1" OnNeedDataSource="RadGrid1_NeedDataSource"  AutoGenerateColumns="false" runat="server">
       <MasterTableView>
         <Columns>
          <telerik:GridBoundColumn DataField="EmployeeID"  UniqueName="EmployeeID"></telerik:GridBoundColumn>
           <telerik:GridTemplateColumn>
               <ItemTemplate>
                   <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
               </ItemTemplate>
            </telerik:GridTemplateColumn>
      </MasterTableView>
    </telerik:RadGrid>
    c#
    protected void RadGrid1_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
        {
            SqlConnection con1 = new SqlConnection(WebConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString);
            SqlCommand cmd = new SqlCommand("SELECT top 10 * FROM [Orders]", con1);
            SqlDataAdapter ad = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            ad.Fill(ds);
           RadGrid1.DataSource = ds;
        }
    Thanks,
    Shinu
  3. Swedha
    Swedha avatar
    1 posts
    Member since:
    Sep 2011

    Posted 05 Feb in reply to Shinu Link to this post

    Hi ,

    I am converting asp grid view to rad grid for my application. I have edit, delete functionality for the rows. Here is my row editing code 

    protected void GridViewDocs_RowEditing(object sender, GridViewEditEventArgs e)
            {
                RegularExpressionValidatorVersion.Enabled = false;
                this.UpdateId = Convert.ToInt32(GridViewDocs.DataKeys[e.NewEditIndex].Value);

                int rowIndex = Convert.ToInt32(e.NewEditIndex);
                GridViewRow row = GridViewDocs.Rows[rowIndex];. . . 

    I just need to take the updateid value and row values in rad grid .

    Can you help me how to modify that in my radgrid editing functionality ?

    . . 

  4. Attila Antal
    Admin
    Attila Antal avatar
    376 posts

    Posted 08 Feb Link to this post

    Hi Swedha,

    Please check out the following Documentation articles. They will help guide you through the process.

    The Accessing Raw Field Data and Key Values will explain, how to access Field data or key values, which can serve as identifiers (or any other purpose) when needed. For inserting new records you can check out the Grid - Data Editing  section of the documentation. For instance, check out how the manual Insert operation is done:  Inserting Values Using InPlace and EditForms Modes and the update operation: Updating Values Using InPlace and EditForms Modes. Once you need to extract value, follow the instructions from the Extracting values article.

    Kind regards,
    Attila Antal
    Progress Telerik
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Back to Top