Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 27, 2012 12:15 AM by oned_gk
Member
180 Points
190 Posts
Nov 26, 2012 06:38 AM|LINK
Hi Friends,
<asp:AdRotator ID="AdRotator1" runat="server" > <table> <tr> <td> <asp:Image ID="imgs" runat="server" Width="100px" Height="100px" ImageUrl="images/avatar.jpg" /> </td> </tr> <tr> <td> <%# Eval("FirstName") %> </td> </tr>
<tr> <td> <%# Eval("LastName") %> </td> </tr> </table> </asp:AdRotator>
is the above code applicable.
If it is not possible, is there any other way to do so.
My purpose is to display the details of members in a page. The user details have to change on every postback/refresh of a page
Please help
All-Star
31802 Points
6501 Posts
Nov 26, 2012 07:07 AM|LINK
Add datetime column in your sql table called dateshow.
use SELECT TOP (1) * FROM MEMBERS ORDER BY DATESHOW ASC
After dsiplaying the data get the ID then update the database by SET DATESHOW=getdate() WHERE ID=@ID
Now, without rotator every postback the member detail will changed.
Nov 26, 2012 07:19 AM|LINK
oned_gk Add datetime column in your sql table called dateshow. use SELECT TOP (1) * FROM MEMBERS ORDER BY DATESHOW ASC After dsiplaying the data get the ID then update the database by SET DATESHOW=getdate() WHERE ID=@ID Now, without rotator every postback the member detail will changed.
Could you please explain in detail
Nov 26, 2012 07:55 AM|LINK
Use Formview/detailview or wathever to display details of members
Get one record from members that DATESHOW has oldest value from the database using TOP(1) and ORDER BY
After showing the data then update DATESHOW current displayed to newest value or GETDATE()
Next postback will display another record because current DATESHOW will be newest.
Nov 26, 2012 09:08 AM|LINK
oned_gk Use Formview/detailview or wathever to display details of members Get one record from members that DATESHOW has oldest value from the database using TOP(1) and ORDER BY After showing the data then update DATESHOW current displayed to newest value or GETDATE() Next postback will display another record because current DATESHOW will be newest.
Thanks, But this is not solving my problem. I would like to dispaly all memebrs who are registered before 'n' days.
Nov 27, 2012 12:15 AM|LINK
Just add WHERE condition in SELECT command
sels2005j
Member
180 Points
190 Posts
AdRotator In ASP.Net
Nov 26, 2012 06:38 AM|LINK
Hi Friends,
<asp:AdRotator ID="AdRotator1" runat="server" >
<table>
<tr>
<td>
<asp:Image ID="imgs" runat="server" Width="100px" Height="100px" ImageUrl="images/avatar.jpg" />
</td>
</tr>
<tr>
<td>
<%# Eval("FirstName") %>
</td>
</tr>
<tr>
<td>
<%# Eval("LastName") %>
</td>
</tr>
</table>
</asp:AdRotator>
is the above code applicable.
If it is not possible, is there any other way to do so.
My purpose is to display the details of members in a page. The user details have to change on every postback/refresh of a page
Please help
oned_gk
All-Star
31802 Points
6501 Posts
Re: AdRotator In ASP.Net
Nov 26, 2012 07:07 AM|LINK
Add datetime column in your sql table called dateshow.
use SELECT TOP (1) * FROM MEMBERS ORDER BY DATESHOW ASC
After dsiplaying the data get the ID then update the database by SET DATESHOW=getdate() WHERE ID=@ID
Now, without rotator every postback the member detail will changed.
sels2005j
Member
180 Points
190 Posts
Re: AdRotator In ASP.Net
Nov 26, 2012 07:19 AM|LINK
Could you please explain in detail
oned_gk
All-Star
31802 Points
6501 Posts
Re: AdRotator In ASP.Net
Nov 26, 2012 07:55 AM|LINK
Use Formview/detailview or wathever to display details of members
Get one record from members that DATESHOW has oldest value from the database using TOP(1) and ORDER BY
After showing the data then update DATESHOW current displayed to newest value or GETDATE()
Next postback will display another record because current DATESHOW will be newest.
sels2005j
Member
180 Points
190 Posts
Re: AdRotator In ASP.Net
Nov 26, 2012 09:08 AM|LINK
Thanks, But this is not solving my problem. I would like to dispaly all memebrs who are registered before 'n' days.
oned_gk
All-Star
31802 Points
6501 Posts
Re: AdRotator In ASP.Net
Nov 27, 2012 12:15 AM|LINK
Just add WHERE condition in SELECT command