Hi
In Product.aspx page I have repeater that bind it from Subset_Menu table from database
<li class="current">
<asp:LinkButton id="awood" class="AWoodI" runat="server" onclick="Mobile_Click"> </asp:LinkButton>
<ul>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:Repeater ID="RptMobile" runat="server" >
<ItemTemplate>
<li>
<a href='<%#"Product.aspx?subset="+Eval("subset")+"&ID="+Eval("ID")+"&ListType="+(DataList1.Visible == true ? "Product" : "Store")%>'>
<%#Eval("subset")%></a> </li>
</ItemTemplate>
</asp:Repeater>
and SP
select subset,id
from subset_menu
where H_name='computer'
order by SubsetId desc
end
and below is Subset_menu table
Id
|
Subset
|
H_name
|
SubsetId
|
1
|
Software
|
Computer
|
1
|
2
|
Null
|
Computer
|
2
|
3
|
Hardware
|
Computer
|
3
|
4
|
Sofa
|
Furniture
|
4
|
now according to Sp I want in repeater shows SoftWare and Hardware where H_name is Computer
but Here it shows Software,"Space" and Hardware I mean it shows NULL value in repeater becuse in row with id=2 isn't any data so it shows space instead of data in repeater
I want if in Subset column wasn't any data It doesn't bind any thing from this row...
How I can do it?
Best Regards
Neda