I have made a project on social nework in which i used Datalist1 for posting scraps and Datalist2 for commenting. but i m unable to do the paging in them ..please help coding is as given below\[code\] <asp
ataList ID="DataList1" runat="server" CellPadding="4" Font-Bold="True" Font-Italic="False" Font-Names="Verdana" Font-Overline="False" Font-Size="Medium" Font-Strikeout="False" Font-Underline="False" ForeColor="#333333" Height="1592px" RepeatLayout="Flow" DataSourceID="SqlDataSource1" OnItemCommand="DataList1_ItemCommand" OnItemDataBound="DataList1_ItemDataBound"> <AlternatingItemStyle BackColor="White" /> <EditItemTemplate> <br /> </EditItemTemplate> <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /> <FooterTemplate> <br /> <br /> </FooterTemplate> <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /> <ItemStyle BackColor="#FFFBD6" ForeColor="#333333" /> <ItemTemplate> <table class="style8"> <tr> <td bgcolor="#FFFF99" class="style12"> <asp:Label ID="Label4" runat="server" Font-Bold="True" Font-Italic="True" ForeColor="Red" Text='<%# Eval("FirstName") %>'></asp:Label> </td> <td bgcolor="#FFFF99" class="style11"> <asp:Image ID="Image3" runat="server" Height="108px" ImageUrl='<%# "~/UserImage/" +Eval("profile_pic") %>' Width="98px" /> </td> </tr> <tr> <td bgcolor="#CCFF99" colspan="2"> Posted on:<asp:Label ID="Label9" runat="server" Text='<%# Eval("posttime", "{0}") %>'></asp:Label> | <asp:Label ID="Label5" runat="server" ForeColor="#000066" Text='<%# Eval("scrap") %>'></asp:Label> </td> </tr> <tr ID="Tr1" runat="server" visible='<%# Eval("scrap") != "" %>'> <td bgcolor="#CCFF99" colspan="2"> <asp:Image ID="postedimage" runat="server" Height="202px" ImageUrl='<%# "~/Postedimages/" +Eval("scrap") %>' Visible="False" Width="262px" /> </td> </tr> <tr> <td bgcolor="#FFC1B3" class="style21" colspan="2"> <aspataList ID="DataList2" runat="server" CellPadding="4" DataKeyField="Comment" DataSourceID="SqlDataSource2" ForeColor="#333333" RepeatLayout="Flow" style="height: 331px" Width="192px"> <AlternatingItemStyle BackColor="White" /> <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /> <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /> <ItemStyle BackColor="#FFFBD6" ForeColor="#333333" /> <ItemTemplate> <table class="style16"> <tr> <td bgcolor="#FFCCFF" class="style19"> <asp:Label ID="Label6" runat="server" ForeColor="#CC0066" Text='<%# Eval("FirstName") %>'></asp:Label> </td> <td bgcolor="#FFCCFF" class="style20"> <asp:Image ID="Image4" runat="server" Height="91px" ImageUrl='<%# "~/UserImage/" +Eval("profile_pic") %>' Width="110px" /> </td> </tr> <tr> <td class="style17" colspan="2"> <asp:Label ID="Label7" runat="server" ForeColor="#003300" Text='<%# Eval("Comment") %>'></asp:Label> </td> </tr> <tr> <td bgcolor="White" class="style18"> </td> <td bgcolor="White"> Commented on- <asp:Label ID="Label10" runat="server" ForeColor="#FF0066" Text='<%# Eval("Cmnttime") %>'></asp:Label> </td> </tr> </table> <br /> <br /> <br /> <br /> <br /> <br /> </ItemTemplate> <SelectedItemStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" /> </aspataList> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:Con %>" SelectCommand="SELECT l.*, c.Cmnttime , c.Comment,c.* FROM Login l LEFT JOIN comment c ON l.email =c.CommentFrom WHERE l.email =@UserName UNION ALL SELECT l.*, c.Comment, c.Cmnttime,c.* FROM Login l LEFT JOIN comment c ON l.email = c.CommentFrom WHERE l.email IN (SELECT frnemail FROM requests WHERE email =@UserName AND frnshpStatus = 'Y') UNION ALL SELECT l.*, c.Comment, c.Cmnttime,c.* FROM Login l LEFT JOIN comment c ON l.email = c.CommentFrom WHERE l.email IN (SELECT email FROM requests WHERE frnemail = @UserName AND frnshpStatus = 'Y') UNION ALL SELECT l.*, c.Comment, c.Cmnttime,c.* FROM Login l LEFT JOIN comment c ON l.email = c.CommentFrom WHERE l.email IN (SELECT s.scrap FROM Scraps s WHERE c.Cmntonscrap=s.scrap and c.CommentTo=s.Emailscrapto)ORDER BY c.Cmnttime DESC"> <SelectParameters> <asp:SessionParameter Name="UserName" SessionField="UserName" /> </SelectParameters> </asp:SqlDataSource> </td> </tr> <tr> <td bgcolor="#FFC1B3" class="style15" colspan="2"> <asp:TextBox ID="commentbox" runat="server" Height="23px" Width="492px"></asp:TextBox> <asp:Button ID="comment" runat="server" CommandName="Cmnt" Text="Comment" /> <asp:Label ID="Label8" runat="server" Text='<%# Eval("Emailscrapto", "{0}") %>' Visible="False"></asp:Label> </td> </tr> <tr> <td bgcolor="#CABAF8" class="style13" colspan="2"> </td> </tr> </table> </ItemTemplate> <SelectedItemStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" /> <SeparatorStyle BackColor="Yellow" Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Size="Small" Font-Strikeout="False" Font-Underline="False" ForeColor="Maroon" HorizontalAlign="Center" /> </aspataList> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Con %>" SelectCommand="SELECT l.*, s.scrap, s.posttime,s.Emailscrapto,s.index1FROM Login lLEFT JOIN Scraps sON l.email = s.EmailscraptoWHERE l.email =@UserNameUNION ALLSELECT l.*, s.scrap, s.posttime,s.Emailscrapto,s.index1FROM Login lLEFT JOIN Scraps sON l.email = s.EmailscraptoWHERE l.email IN (SELECT frnemail FROM requests WHERE email = @UserName AND frnshpStatus = 'Y' AND s.index1 between 1 and 4)UNION ALLSELECT l.*, s.scrap, s.posttime,s.Emailscrapto,s.index1FROM Login lLEFT JOIN Scraps sON l.email = s.EmailscraptoWHERE l.email IN (SELECT email FROM requests WHERE frnemail = @UserName AND frnshpStatus = 'Y' AND s.index1 between 1 and 4)ORDER BY posttime DESC"> <SelectParameters> <asp:SessionParameter Name="UserName" SessionField="UserName" /> </SelectParameters> </asp:SqlDataSource>\[/code\]Now please please tell me how to make its post-comment scheme just like Facebook also solve the problem of comentingi.e a comment posted on 1 scrap is apearind or showing in all the scraps.
ataList ID="DataList1" runat="server" CellPadding="4" Font-Bold="True" Font-Italic="False" Font-Names="Verdana" Font-Overline="False" Font-Size="Medium" Font-Strikeout="False" Font-Underline="False" ForeColor="#333333" Height="1592px" RepeatLayout="Flow" DataSourceID="SqlDataSource1" OnItemCommand="DataList1_ItemCommand" OnItemDataBound="DataList1_ItemDataBound"> <AlternatingItemStyle BackColor="White" /> <EditItemTemplate> <br /> </EditItemTemplate> <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /> <FooterTemplate> <br /> <br /> </FooterTemplate> <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /> <ItemStyle BackColor="#FFFBD6" ForeColor="#333333" /> <ItemTemplate> <table class="style8"> <tr> <td bgcolor="#FFFF99" class="style12"> <asp:Label ID="Label4" runat="server" Font-Bold="True" Font-Italic="True" ForeColor="Red" Text='<%# Eval("FirstName") %>'></asp:Label> </td> <td bgcolor="#FFFF99" class="style11"> <asp:Image ID="Image3" runat="server" Height="108px" ImageUrl='<%# "~/UserImage/" +Eval("profile_pic") %>' Width="98px" /> </td> </tr> <tr> <td bgcolor="#CCFF99" colspan="2"> Posted on:<asp:Label ID="Label9" runat="server" Text='<%# Eval("posttime", "{0}") %>'></asp:Label> | <asp:Label ID="Label5" runat="server" ForeColor="#000066" Text='<%# Eval("scrap") %>'></asp:Label> </td> </tr> <tr ID="Tr1" runat="server" visible='<%# Eval("scrap") != "" %>'> <td bgcolor="#CCFF99" colspan="2"> <asp:Image ID="postedimage" runat="server" Height="202px" ImageUrl='<%# "~/Postedimages/" +Eval("scrap") %>' Visible="False" Width="262px" /> </td> </tr> <tr> <td bgcolor="#FFC1B3" class="style21" colspan="2"> <aspataList ID="DataList2" runat="server" CellPadding="4" DataKeyField="Comment" DataSourceID="SqlDataSource2" ForeColor="#333333" RepeatLayout="Flow" style="height: 331px" Width="192px"> <AlternatingItemStyle BackColor="White" /> <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /> <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /> <ItemStyle BackColor="#FFFBD6" ForeColor="#333333" /> <ItemTemplate> <table class="style16"> <tr> <td bgcolor="#FFCCFF" class="style19"> <asp:Label ID="Label6" runat="server" ForeColor="#CC0066" Text='<%# Eval("FirstName") %>'></asp:Label> </td> <td bgcolor="#FFCCFF" class="style20"> <asp:Image ID="Image4" runat="server" Height="91px" ImageUrl='<%# "~/UserImage/" +Eval("profile_pic") %>' Width="110px" /> </td> </tr> <tr> <td class="style17" colspan="2"> <asp:Label ID="Label7" runat="server" ForeColor="#003300" Text='<%# Eval("Comment") %>'></asp:Label> </td> </tr> <tr> <td bgcolor="White" class="style18"> </td> <td bgcolor="White"> Commented on- <asp:Label ID="Label10" runat="server" ForeColor="#FF0066" Text='<%# Eval("Cmnttime") %>'></asp:Label> </td> </tr> </table> <br /> <br /> <br /> <br /> <br /> <br /> </ItemTemplate> <SelectedItemStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" /> </aspataList> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:Con %>" SelectCommand="SELECT l.*, c.Cmnttime , c.Comment,c.* FROM Login l LEFT JOIN comment c ON l.email =c.CommentFrom WHERE l.email =@UserName UNION ALL SELECT l.*, c.Comment, c.Cmnttime,c.* FROM Login l LEFT JOIN comment c ON l.email = c.CommentFrom WHERE l.email IN (SELECT frnemail FROM requests WHERE email =@UserName AND frnshpStatus = 'Y') UNION ALL SELECT l.*, c.Comment, c.Cmnttime,c.* FROM Login l LEFT JOIN comment c ON l.email = c.CommentFrom WHERE l.email IN (SELECT email FROM requests WHERE frnemail = @UserName AND frnshpStatus = 'Y') UNION ALL SELECT l.*, c.Comment, c.Cmnttime,c.* FROM Login l LEFT JOIN comment c ON l.email = c.CommentFrom WHERE l.email IN (SELECT s.scrap FROM Scraps s WHERE c.Cmntonscrap=s.scrap and c.CommentTo=s.Emailscrapto)ORDER BY c.Cmnttime DESC"> <SelectParameters> <asp:SessionParameter Name="UserName" SessionField="UserName" /> </SelectParameters> </asp:SqlDataSource> </td> </tr> <tr> <td bgcolor="#FFC1B3" class="style15" colspan="2"> <asp:TextBox ID="commentbox" runat="server" Height="23px" Width="492px"></asp:TextBox> <asp:Button ID="comment" runat="server" CommandName="Cmnt" Text="Comment" /> <asp:Label ID="Label8" runat="server" Text='<%# Eval("Emailscrapto", "{0}") %>' Visible="False"></asp:Label> </td> </tr> <tr> <td bgcolor="#CABAF8" class="style13" colspan="2"> </td> </tr> </table> </ItemTemplate> <SelectedItemStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" /> <SeparatorStyle BackColor="Yellow" Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Size="Small" Font-Strikeout="False" Font-Underline="False" ForeColor="Maroon" HorizontalAlign="Center" /> </aspataList> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Con %>" SelectCommand="SELECT l.*, s.scrap, s.posttime,s.Emailscrapto,s.index1FROM Login lLEFT JOIN Scraps sON l.email = s.EmailscraptoWHERE l.email =@UserNameUNION ALLSELECT l.*, s.scrap, s.posttime,s.Emailscrapto,s.index1FROM Login lLEFT JOIN Scraps sON l.email = s.EmailscraptoWHERE l.email IN (SELECT frnemail FROM requests WHERE email = @UserName AND frnshpStatus = 'Y' AND s.index1 between 1 and 4)UNION ALLSELECT l.*, s.scrap, s.posttime,s.Emailscrapto,s.index1FROM Login lLEFT JOIN Scraps sON l.email = s.EmailscraptoWHERE l.email IN (SELECT email FROM requests WHERE frnemail = @UserName AND frnshpStatus = 'Y' AND s.index1 between 1 and 4)ORDER BY posttime DESC"> <SelectParameters> <asp:SessionParameter Name="UserName" SessionField="UserName" /> </SelectParameters> </asp:SqlDataSource>\[/code\]Now please please tell me how to make its post-comment scheme just like Facebook also solve the problem of comentingi.e a comment posted on 1 scrap is apearind or showing in all the scraps.