AJAX :: Slideshow Using Access Or Sql Database To Obtain Image Names?
Oct 27, 2010
I've watched the Slideshow videos and created a number of examples that run fine. The code I've attached at the bottom is the smallest one, but instead of hard coding the image locations, I would like to select the slides from either of the following statements, which return the top 5 images selected randomly from our floorplans database.
<asp:AccessDataSource id="AccessDataSource1" runat="server" DataFile="../fpdb/J3_2005.mdb" SelectCommand="SELECT TOP 5 [Elev_Pimage] FROM [PLANS_Active] ORDER BY RND(INT(NOW*[SF_Total])-NOW*[SF_Total])" />
or,
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:J3_2005Slideshow %>" ProviderName="<%$ ConnectionStrings:J3_2005Slideshow.ProviderName %>" SelectCommand="SELECT TOP 5 [Elev_Pimage] FROM [PLANS_Active] ORDER
BY RND(INT(NOW*[SF_Total])-NOW*[SF_Total])" />
<title>SlideShow</title>
I would like to use the ajax slideshow extender and getting the Image Url stored in a databaseso far my webserivice look like this..but I think im making a mistake somewhere..its not working
<WebMethod()> _ Public Function GetSlides() As AjaxControlToolkit.Slide() Dim Connection As SqlConnection
I have this slideshow extender that works perfectly with hard coded images in the page method. However as soon as I try to make the page method get its images from the database it stops working; no images are returned.
I have tried to declare the datatable that the pagemethod uses both inside the pagemethod and in the on_load event. When in the last case I test the datatable contents by hooking it up to a gridview, it shows that it does get its proper data.
Declaring this dataTable as a private static dataTable, outside the page_load, to make it accessible in the page method (like in this --- post http://forums.asp.net/p/1115257/1726736.aspx---) also does not work.
So the page method with hard coded images works and also the query to the database works!
I want a piece of code for asp.net 3.5 using visual basic. and i am using MS access database.
I have two three text boxes and 2 image upload controls and a submit button.
I want a piece of code in which a user can upload images and store it in our database . i want an asp.net visual basic working code. also i need query behind the submit button.
I am trying to develop a image slideshow for the front of my website.I have an idea of how I would like it to look like .... http://www.reef.com/guys/But I have not been able to find any similar pre-built slideshows.I would like to be able to have a loading gif and buttons down the bottom allowing to scroll through the images at your own pace but still letting the images slide without clicking.I am unsure how I would go about making a slideshow like this one, would I use AJAX, jQuery or Silverlight?If you know of any pre built solutions that are similar to what I am looking for provide the link for me or if you have any knowlege
i find this code for slideshow but i want change it this way that change image dynamicaly that i get list of image by jquery and jquery change image automatically
So I could create different folders according to the page unique id. I have also created a thumbnail image from the image I have upload (cropped ones).
The problem I am trying to figure out is to display these images as a slide show from these dynamically created folder (display thumbnail in the page and clicking the thumbnail need to see the full size image just like slideshow).
I was trying to see examples in jQuery but its just client side. So is there any way to load these images and display as a slide show from the directory. Should I deal with DirectoryInfo in C#? Expecting a simple one.
I am using ajax html editor to write a text. I can view it without having problem but I am incapeble of storing it in a Ms Access database. which type do I need to use for this? I tried memo and OleObject type and both didn't work. I used the blow code for that.
I want to know some codes on how can i resize the selected image in fileupload control and then Upload it in MS Access Database. I am using VB in coding. The only thing I know is that I can save it as an ole object in the database and it will be saved like a string. But I don't know some codes for this one.
i have uploaded an image in database using file upload control in visual studio 2005 using c# i want to show this image saved in database to the web form. how can i do so?
I am very new to asp.net and SQL server. I am helping out my team by researching the possibility for any user to download reports into Word and Excel from the SQL database by simply clicking a button.
I was wondering if anyone knows a jQuery library that can suit my needs:
I want a slideshow of album covers which are retrieved dynamically from the database. I want to display 4 album covers at a time. I want there to be a next button so the the slideshow can continue. Here is what I cant find any librarys for. When I click the next button, I dont want to show another 4 different covers, i want it to move along by 1 album cover,
So say I had covers 1 , 2 , 3 , 4
When i click next i want to display 2 , 3 , 4 , 5.
Finally, I want the show to be able to repeat so at the end it starts at one again.
So say I only had 5 covers 1 , 2 , 3 , 4 , 5
when I click next while showing 2 , 3 , 4 , 5 I want 3 , 4 , 5 , 1 displayed.
I have done website using Ms access database and VS2005. actually i store image in system.byte[] format in MS access database..so i want to set that image in rdlc background or image tag. Actually I did the following way. [Code].... But I got following Exception ex = {"Value does not fall within the expected range."} and ex = {Function evaluation disabled because a previous function evaluation timed out. You must continue execution to reenable function evaluation.}
But when I upload image with Fileupload and click on btnupload button below error happen..
Server Error in '/' Application.
Access to the path 'C:Inetpubvhostsbehtop.comhttpdocsimageHouseservices8.jpg' is denied. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.UnauthorizedAccessException: Access to the path
