Showing posts with label previous. Show all posts
Showing posts with label previous. Show all posts

Monday, March 26, 2012

Images :: Next, Previous, First, Last Functionality

currently have my website that is functional...but would like to add some navigation to my photos which are displayed using a repeater tied to a SQL database. (live example can be viewed here)

the above link shows a gallery page that displays all the photos within a given shoot (using a querystring to display the unique ID of the photo shoot). When you click on one of the images within the shoot a page called is called displaying the selected photo by passing the shoot ID and the unique ID of the photo itself through a querystring.

I would like to add navigation to the page displaying the photo that would allow the user to go to the next photo, previous photo, first and last phot within the specific SHOOT ID.

First
Next
Previous
Last

I am using a repeater to display the photo with the following sqlDataSource:

<asp:SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString="<%$ ConnectionStrings:Connection %>"
SelectCommand="
SELECT usr_Photos.*, usr_PhotoShoot.*
FROM usr_Photos
INNER JOIN usr_PhotoShoot ON usr_Photos.Shoot_ID = usr_PhotoShoot.Shoot_ID
WHERE usr_Photos.Photo_ID = @.ID AND usr_Photos.Shoot_ID = @.Shoot">

<SelectParameters>
<asp:QueryStringParameterDefaultValue=""Name="ID"QueryStringField="ID"/>
<asp:QueryStringParameterDefaultValue=""Name="Shoot"QueryStringField="Shoot"/>
</SelectParameters>

</asp:SqlDataSource>

I am having trouble figuring out a way to add the functionality i would need to change photos within the specific photo shoot without having to go back to the gallery page. any help or ideas you could point me in would be great...thanks in advance...

You need Datalist or Repeater Control Coustom Paging.

see the live view of what we created:

http://www.friendspoint.de/UsersWidPics.aspx

You will be able to find alot of material online for that. just google for "Datalist paging"

Did it help? If still not then i will try to post some Article.

|||

Ok, the Article is just finished. you can see it here now:

http://www.dotnet-friends.com/articles/asp/artinasp0cfb304d-42ea-4f8b-b480-9c047396252e.aspx

Monday, March 12, 2012

I'm in deep s??

Got all excited all the new sql server 2005. Downloaded it, during
installation, it complained about requirement for uninstallation of previous
eval/CTP version. So, I obliged, however, the uninstallation were
incomplete. Now, The Remove Program couldn't uninstall SQL Server 2000
Reporting Service, it asked for a freaking version of .Net Framework.
Couldn't SQL Server 2005 installation package checking all previous
installation and automatically remove all of them?
WHAT TO DO? WHAT TO DO' I'm drowing!> WHAT TO DO? WHAT TO DO' I'm drowing!
I don't know what pre-release version you had installed but there is a build
uninstall wizard on the Sept. CTP media that will forcibly remove the
pre-release stuff. There is something similar for pre-release VS 2005 via
download.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"ImJoe" <ImJoe@.discussions.microsoft.com> wrote in message
news:4C7E4BB6-DFA5-4985-96B7-C71EF82EAD0D@.microsoft.com...
> Got all excited all the new sql server 2005. Downloaded it, during
> installation, it complained about requirement for uninstallation of
> previous
> eval/CTP version. So, I obliged, however, the uninstallation were
> incomplete. Now, The Remove Program couldn't uninstall SQL Server 2000
> Reporting Service, it asked for a freaking version of .Net Framework.
> Couldn't SQL Server 2005 installation package checking all previous
> installation and automatically remove all of them?
> WHAT TO DO? WHAT TO DO' I'm drowing!
>|||Dan,
Thanks for the follow-up. Problem resolved. Right after I posted the msg I
knocked myself in the head, what a fool I was. There could be others
experiencing the same problem, posted it and got answered, sure enough,
another thread has info on a patch workaround to clean up the mess. So, I've
now successfully installed sql server 2005.
Another question though, bear with me for not to post it separately,
is there a way to copy a database from Database Service to
Analysis Service?
Thanks.
"Dan Guzman" wrote:
> > WHAT TO DO? WHAT TO DO' I'm drowing!
> I don't know what pre-release version you had installed but there is a build
> uninstall wizard on the Sept. CTP media that will forcibly remove the
> e-release stuff. There is something similar for pre-release VS 2005 via
> download.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "ImJoe" <ImJoe@.discussions.microsoft.com> wrote in message
> news:4C7E4BB6-DFA5-4985-96B7-C71EF82EAD0D@.microsoft.com...
> >
> > Got all excited all the new sql server 2005. Downloaded it, during
> > installation, it complained about requirement for uninstallation of
> > previous
> > eval/CTP version. So, I obliged, however, the uninstallation were
> > incomplete. Now, The Remove Program couldn't uninstall SQL Server 2000
> > Reporting Service, it asked for a freaking version of .Net Framework.
> >
> > Couldn't SQL Server 2005 installation package checking all previous
> > installation and automatically remove all of them?
> >
> > WHAT TO DO? WHAT TO DO' I'm drowing!
> >
>
>|||> Another question though, bear with me for not to post it separately,
> is there a way to copy a database from Database Service to
> Analysis Service?
Sorry, but what I don't know about SSAS is a lot. I suggest you post this
question to the OLAP forum.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"ImJoe" <ImJoe@.discussions.microsoft.com> wrote in message
news:21CC133A-63E6-4C75-B36B-22D8A4A847AD@.microsoft.com...
> Dan,
> Thanks for the follow-up. Problem resolved. Right after I posted the msg
> I
> knocked myself in the head, what a fool I was. There could be others
> experiencing the same problem, posted it and got answered, sure enough,
> another thread has info on a patch workaround to clean up the mess. So,
> I've
> now successfully installed sql server 2005.
> Another question though, bear with me for not to post it separately,
> is there a way to copy a database from Database Service to
> Analysis Service?
> Thanks.
> "Dan Guzman" wrote:
>> > WHAT TO DO? WHAT TO DO' I'm drowing!
>> I don't know what pre-release version you had installed but there is a
>> build
>> uninstall wizard on the Sept. CTP media that will forcibly remove the
>> e-release stuff. There is something similar for pre-release VS 2005 via
>> download.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "ImJoe" <ImJoe@.discussions.microsoft.com> wrote in message
>> news:4C7E4BB6-DFA5-4985-96B7-C71EF82EAD0D@.microsoft.com...
>> >
>> > Got all excited all the new sql server 2005. Downloaded it, during
>> > installation, it complained about requirement for uninstallation of
>> > previous
>> > eval/CTP version. So, I obliged, however, the uninstallation were
>> > incomplete. Now, The Remove Program couldn't uninstall SQL Server 2000
>> > Reporting Service, it asked for a freaking version of .Net Framework.
>> >
>> > Couldn't SQL Server 2005 installation package checking all previous
>> > installation and automatically remove all of them?
>> >
>> > WHAT TO DO? WHAT TO DO' I'm drowing!
>> >
>>