i m developing website using asp.net with microsoft access 2003 i have product details along with the images now i want to add this images into database but how i add this pictures what code is use if there are 100 products with 100 images i want to show 10 records per page i need also code of that
View 17 Repliesi m developing website using asp.net with microsoft access 2003 i have product details along with the images now i want to add this images into database but how i add this pictures what code is use if there are 100 products with 100 images i want to show 10 records per page i need also code of that
View 3 Repliesi am a beginer and i want to know how to store images in the database tables like pictures of the pizzas and when the user selects one of the pizza from the dropdownlist he sees the image of the selected pizza.
View 2 RepliesI am new to ASP.NET. I have encountered a problem in navigating the database records that is displayed in the web form , the Next and Previous buttons. I have 4 imageboxes and 2 textboxes under each image box for displaying database records.
I am currently using an Access database with a table "Images" and there are 4 columns in it. "ImageID", "ImageDescription","ImageofPicture","Description".
My Code is below:
[Code]....
I currently have a datagrid bound to a table with tens of thousands of records. I display the datagrid using the existing asp.net 2.0. I show ten records at a time.
My problem is whenever I try to access the next page, I gets all the records again from the database and then displays the ones that are required. This is slowing down the app. Is there feature within .net 2.0 which will help me optimize this issue? I cant use third party controls or ajax.
UPDATE
I cant use SQL to get 10 records at a time as well. Without changing any existing business logic or data retrieval, I want to do this.
I suppose this question has been asked to death all over the web, but I can seem to find a clear cut answer. What I am trying to achieve is as follows: I have a web application that lists various products, their descriptions, names etc and also an image of that specific product. The user will type in a product code or name of the product and a page will pop up with al the previous mentioned info and image or images of that specific product. The problem I am having is: I read somewhere that storing images in a database is 'bad idea' since it effects performance, then I read somewhere else to keep it in the images / or app_data folder. But what would be the best approach and how would I call it from the database (if that's the best way)? And if App_Data / images are the way to go how many images can I put in there (??) already the product catalog has several hundred images of various products. So how would one go about sorting everthing in those folders without having a few hundred images rolling down in my solutions explorer.
View 5 RepliesI'm working in ASP.NET 4.0, and I've got a large web form which represents a single business entity. A user can upload multiple images associated with the entity. The entity is created and assigned a GUID upon submitting the form. The files will be stored to a file system.
The problem is that we have to name the files after the GUID that is assigned to the entity after it is inserted to the database. So before the submit button is clicked, we will have several image files floating around in limbo.
There are obvious answers to this question -- you save the images to the file system and then when the business entity is created, you rename those files. However, I believe that there must be very strong patterns and several key details that would make for a very robust system. What's best practice for this scenario?
Friends have quick question for you.i want to know storing videos and images into database(binary data) or local hard drive is efficent. What way general websites stores them in their websites.
View 6 RepliesI have implemented Membership and Role Provider in my web site. Membership and Role information is stored in database created from aspnet_regsql option.
I want to store the access rights given to the pages in ASP.NET Configuation option in Database inspite of web.config file and want to give page wise add, edit, view and delete rights that should also be stored in database.
Is there any inbuit class like Membership and Role to add page access rights?
I am select one mdb database from open dialog box.All records in the database (all table data value)will automatically delete. How to implement this concept.
View 2 RepliesI am trying to delete multiple records from an access databse with ASP.NET VB but I'm doing something very wrong .....
Here is my code ...
[Code]....
I would also like to know once I get this working how I would delete, additional tables linked to this table by another field not ID ??
I have a problem regarding database. I write to the database fine with this code:
[Code]....
When I close the application and view the Database with access.. the records are added ok, but when I start the application the records are deleted. This is what I have in the Form_Load:
[Code]....
I have table in database in which near about 2 lac records are available.
I am using access as database.
How can i get the particular row or records from the database in a minimal time
I want data to be retrieved faster
I am creating an insert statement in my c# code to insert records to an access database table. I am getting the error copied below using c# code. When I copy the generated insert statement from the console and run this on my access database, it succesfully appends a record in the table.Insert statement generated:
insert into [Pet Fish-log 2010] ([Specimen Type], Year, [Lab Number], [Last Name], [First Name], [Middle Initial], Gender, [Date of Birth], [Collection Date], [Date Received], Client, [Tissue Type], [Block Number],
[code]......
-7vf- I write a program by c# to check and retrieve data from database
The problrm:I have one table(1), I want to make update for that table(1) that is by compare the one column in table(2) with the right side from one column in table(1), so if there is any similarity it will retrieve the data and if there is no match just it will make the record empty(null) "the data type of retrieving columns: number 'double'", but the problems is:
I try to retrieve 11 columns, 7 of them are empty .the program run with out error ,but it will retrieve some records with full data 11 columns, but some of records has only 5 columns have data and 7 columns are empty (these records when I run the program did not retrive any columns, it give me empty records!!)
this is the code :
while (or.Read())
{ or.GetValues(field); OdbcCommand oc2=null;
[code]....
I want to retrive all data which are empty or null and all data
How can i return images from my database (Access) to RSS in form of thumbnails this is my RSS code:
Code:
[code]....
I have a issue where I am trying to pull some records from an Access 2007 DB that has linked tables from a SQL 2005 Server. When I go to do this the browser IE8 just sits there and does nothing. THe little progress bar at the bottom moves about half way then that is it. It will sit there and show no errors or do anything. I have experience with connecting and manipulating Access and SQL server DB's but not through Access with linked tables from SQL Server. Here is test code below:
[Code]....
This does not produce an error or anything. The browser just sits there and sits there. Is there something I am missing?
how to storethe image path in database and how to access image from database in asp web form
View 1 Repliesi want to store images of my employees with thier profiles in sql server database.i have following reservations.whether i should compress images or not if yes please provide me sample code or article
how should i retrieve images efficiently, i an afraid of asp.net application performance issue. i think with ten thousand employee records it will halt or slow down
I am developing questionare web site, where user has to answer around 55 questions. Its basically a check / uncheck option. So when user submit I store the value in DB.
The issue I am facing is if user selectes all the option, cookie value is lost. I see only 50 records can be stored (Request.Cookies.AllKeys)
Even the SessionID value is lost.Any solution / work around.
I need to store in the client side only. because if the user choose all options and do not submit. The values can be stored in the cookie and later point if he comes back we can read and give to him
ASP.NET / C#
I am designing an prototyping an app the needs to store images, similar to facebook. This will be a public facing site and I am not sure how many users I will end up with but what I am looking for is a way to efficiently retrieve them.
So far I am thinking of storing them in SQL Server varbinary columns. I have the upload code and the storage code for that. My concern is retrieving them. I can retireve and build the image tag on the fly but I am worried about having to hit the database for each one.
I have been thinking about getting all images for a user and caching them in the asp.net cache for 10 to 30 seconds. I have never had to do something like this so I would be interested in hearing a few different approaches. Obviously the images can vary in size and I was thinking about defining a size limit, but I haven't gotten that far yet.
I'm working on an application which will store around 50.000 images within it's first year and another 75.000 in it's second. Images can come from Galleries, news images, article images and profile images. So I want to give each image a GUID and store the GUID in the database.As for the directory structure i was thinking of something like this:
~/Upload/Images/F2/50/F2504E0-4F89-11D3-9A0C-0305E82C3301.jpg
So I'm using the first 4 characters of the GUID as my directory structure to spread images a bit more evenly between directories. Now I have some questions about this approach:Is it considered good practice to store all different kinds of images together rather then use ~/Images/Upload/Profiles, ~/Images/Upload/Articles etc.I'm also storing thumbnails and they have a different GUID obviously so the thumbs will not be in the same folder as the original and somehow that doesnt give me a good feeling but I guess it should not matter but.Same goes for Galleries, I'm used to store galleries in folders like ~/Images/Upload/Galleries/12 , and now all the images from a gallery will be scattered around in different subfolders, is this a big performance hit?Do you guys have any other ideas for directory structures?
As you can probably see I'm a bit afraid to use this approach but since there will be lots of images maybe even more then the numbers i gave i have to let the control go I think :)
I'm building a Web application that will eventually contain a lot of images. These images will need to be displayed in different formats across the site. What would be the pros/cons of the two solutions:
Storing various versions of the picture when they are uploaded (e.g. thumb, small, medium, large, verylarge)
Resizing the image through the URL - e.g. /Content/Image/1?height=300
Edit:I had a really hard time accepting one answer over the other, so for anyone reading this q/a, take your time to read both answers because the accepted answer was selected by the flip of a coin :) They're both equally good.
I was wondering if there is a built-in way (or other) to use images to act as page controls for Prev and Next records within a GridView control?
View 3 RepliesI would like to know which is better? Storing images in BLOB or in the File System ? I've got around 400 to 5000 images.
And at run time there are chances where I'll need to retirieve about 100 - 150 images.