Display master details in ASP.Net DataList and Repeater using SqlDataSource

Using DataList it's not possible as DataList will iterate each row as separate row. You have to add Repeater where you can get the different Fruit color based on Fruit name from same table inside the DataList. Refer the below design change for your reference and implement it as per your code logic. In parent DataList you need Fruit_Name and Description Distinct in select clause.

HTML

    <asp:DataList ID="DataList1" DataSourceID="SqlDataSource1" RepeatDirection="Vertical"
        RepeatLayout="Table" GridLines="Both" BorderWidth="0" runat="server">
        <ItemTemplate>
            <table border="1" cellpadding="0" cellspacing="0">
                <tr>
                    <td>
                        Fruit Name:
                    </td>
                    <td>
                        <asp:Label ID="FruitNameLabel" runat="server" Text='<%# Eval("Fruit_Name") %>'></asp:Label>
                    </td>
                </tr>
                <tr>
                    <td valign="top">
                        Fruit Link:
                    </td>
                    <td>
                        <asp:Repeater ID="rptFruitDetails" runat="server" DataSourceID="SqlDataSource2">
                            <ItemTemplate>
                                <table border="0" cellpadding="0" cellspacing="0">
                                    <tr>
                                        <td>
                                            <asp:Label ID="Label4" Text='<% #Eval("Fruit_Color")%> ' Visible='<%# Convert.ToInt32(Eval("MD_ONLY")) <=0 ? false :true %>'
                                                runat="server" />
                                            <asp:HyperLink runat="server" ID="h1" NavigateUrl='<%# Eval("Fruit_Link", "{0}") %> '
                                                Visible='<%# Convert.ToInt32(Eval("MD_ONLY")) <= 0 ? true :  false %>' Text='<% #Eval("Fruit_Color") + "<br>"%>'
                                                Target="_xmlwindow">
                                            </asp:HyperLink>
                                        </td>
                                    </tr>
                                </table>
                            </ItemTemplate>
                        </asp:Repeater>
                    </td>
                </tr>
                <tr>
                    <td>
                        Description:
                    </td>
                    <td>
                        <asp:Label ID="DescriptionLabel" runat="server" Text='<%# Eval("Description") %>'> </asp:Label>
                    </td>
                </tr>
            </table>
        </ItemTemplate>
    </asp:DataList>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:constr  %>"
        SelectCommand="SELECT DISTINCT Fruit_Name, Description FROM Fruits WHERE Fruit_Name=@Fruit_Name">
        <SelectParameters>
            <asp:QueryStringParameter Name="Fruit_Name" QueryStringField="Fruit_Name" DbType="String"
                Direction="Input" DefaultValue="" ConvertEmptyStringToNull="True" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:constr  %>"
        SelectCommand="SELECT DISTINCT Fruit_Name, Description, Fruit_Color, MD_ONLY, Fruit_Link FROM Fruits WHERE Fruit_Name=@Fruit_Name">
        <SelectParameters>
            <asp:QueryStringParameter Name="Fruit_Name" QueryStringField="Fruit_Name" DbType="String"
                Direction="Input" DefaultValue="" ConvertEmptyStringToNull="True" />
        </SelectParameters>
    </asp:SqlDataSource>

Screenshot