Click here to Skip to main content
15,921,028 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
i have Two table for rating:
Table 1:

Table 2 for rating:
This is my code:
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" PageSize="4" AutoGenerateColumns="False"
        BackColor="White" BorderColor="#CCCCCC" BorderStyle="Ridge" BorderWidth="2px"
        CellPadding="3" DataKeyNames="ReplyDoubtID" DataSourceID="SqlDataSource1" OnRowCommand="GridView1_RowCommand"
        CssClass="roundedbox" CellSpacing="1" GridLines="None">
            <asp:BoundField DataField="Name" HeaderText="Sender Name" SortExpression="Name" />
            <asp:BoundField DataField="Subject" HeaderText="Subject" SortExpression="Subject" />
            <asp:BoundField DataField="Date" HeaderText="Date" SortExpression="Date" />
            <asp:TemplateField HeaderText="Topic">
                    <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Topic") %>' TextMode="MultiLine"
                        Height="54px" Width="202px" CssClass="roundedbox"></asp:TextBox>
            <asp:TemplateField HeaderText="Solved Doubts">
                    <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("ReplyDoubt") %>' TextMode="MultiLine"
                        Height="84px" Width="239px" CssClass="roundedbox"></asp:TextBox>
            <asp:TemplateField HeaderText="Download">
                    <asp:LinkButton ID="LinkButton1" runat="server" CommandArgument='<%# Eval("Files") %>'
                        Text='<%# Eval("Files") %>' CommandName="Download" OnClick="LinkButton1_Click"></asp:LinkButton>
            <asp:TemplateField HeaderText="Rate">
                    <cc1:Rating ID="Rating1" runat="server" StarCssClass="Star" WaitingStarCssClass="WaitingStar"
                        EmptyStarCssClass="Star" FilledStarCssClass="FilledStar" Height="22px" Width="107px"
                        AutoPostBack="True" OnChanged="OnRatingChanged" BehaviorID="Rating1_RatingExtender">
        <FooterStyle BackColor="White" ForeColor="#000066" />
        <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
        <RowStyle ForeColor="#000066" />
        <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
        <SortedAscendingCellStyle BackColor="#F1F1F1" />
        <SortedAscendingHeaderStyle BackColor="#007DBB" />
        <SortedDescendingCellStyle BackColor="#CAC9C9" />
        <SortedDescendingHeaderStyle BackColor="#00547E" />
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:VCRConnectionString %>"
        SelectCommand="SELECT * FROM [ReplyDoubt]" FilterExpression="Topic LIKE '%{0}%'">
            <asp:ControlParameter Name="Topic" ControlID="TextBox3" PropertyName="Text" />

So i want to show the rating,but i have one sqldatasource connection please help me
is it possible......
Updated 29-Mar-15 6:28am
Arkadeep De 29-Mar-15 13:16pm    
I will with Abinav's solution. Its look like that id is the foreign key between two tables. So its better to have join those table. If so then use joining.
Select Table1.Id, Table1.Name,, Table1.Files, Table1.Topic,Table1.Subject, Table1.article, Table2.Rate from Table1 inner join Table2 on Table1.Id = Table2.Id
Manoj K Bhoir 30-Mar-15 1:12am    
Create New View in your database in which join those two tables and then bind that view to your Grid View.
Hanss1492 3-Jun-15 13:30pm    
is not clear to me, is this a master detail? I mean the second table have detail from the first one?
Or maybe is like Abhinav S. create a new view or procedure in SQL and bind into gridview

1 solution

Can you join the content of table 1 to table 2? If not, it may not make sense to show data for these two tables together.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900