how to retieve images which are stored in database one by one and put them in webpage's table.
My project is shopping cart type project in asp.net and server is sql2003
I saved the image urls in database.
i have a web page in asp.net.vb code and sql database.
the persons number is called PNUMB and i have stored all photos of persons in a folder with the persons number (PNUMB) as their file name. when i search for a PNUMB i want to display the photo of the persons whose dtata is displayed. how i sit possible
i have a table that containt two fields.
1. ProjectID
2.ImageAddress.
in ImageAddress field i have stored physically address of my images and each project has more than one image. how could i show all images that belongs to a project in a GridView?
I have a folder at my server as Images consists of 200 images. My aim is to show those images in my webpage. What ever my be the control no problem like(gridview,.....) How to retrieve those images. *It should be dynamically generated. In future the count of images may increase. Better to have paging. If possible when i click on single image it should give a popup to show that image in large size.
View 2 RepliesWould like enquire how to retrieve images from database.I have a table call "Image" with 3 attributes.. ImageID, AlbumID and ImagePath.I want to retrieve the photo and display out at my index page inside a gridview which will display the photos that recent users uploaded.My friend suggested the Eval way, but i have no idea how to do it.
View 3 Repliesi have made a webpage for user registration where i have to save image of user in data base which i have done successfully but i am unable to retrieve that image
View 4 RepliesI have an image table which stores images in binary format and an image_ id is associated with every image
My Question is i want to retrieve these images and bind then to the image button. How can we do this?????
I am using asp.net 3.5 with vb ....
i got a Food table and a Notification table. each Food has an expiry date. I wish to put all foods which are going to expired into the notification table. since user can create new food anytime, how can i update the Notifcation table once got any new food (but with near expiry date) added? and how to make sure the Notification table retrieve the nearly-expired food everytime (mayb update once everyday??)
View 1 Repliesi took a Table Name as Gallery Like The Above Pic
Now refer for Below Link & Image..
[URL]
From The Above Link i took the code of JavaScript For MultiUpload...
Now I Want The Code For Button Click When I Click Upload and only images(jpeg/gif/png/bmp..etc) should only be accepted
[Code]....
I am creating a kind of feedback website which has a feedback form on it. Each question is answered choosing from a radio button group. the answers to each question are (very good, good, bad, failed). I need to be able to create a table on the webform that will display the number of answers to each questions. for example, if the question is "Rate the use of this software" i need to be able to put in table format say 20 people said "very good", 30 said "good" etc. at the moment i only have one table to display the questions and answers and a date that will be used to select the date's report. so all the information i need is coming from this table. all i need to do is how to say like "SELECT Count* Question where Review date = "user entered date" and answer = "very good" etc.
View 4 Repliesi can view the images from the database (datatype = binary) but the problem is the .doc and pdf is not appearing at the page...
[Code]....
Basically i deal with two tables.i have a table T1 of the following format:id company_name i need to read this data and create a table T2 as followsi wrote the following code. it worked fine for retrieving data and modification but fails to insert the modified data into the 2nd table.the error is, it does not recognise the value for @token
ArrayList dynarr=new ArrayList(); // global variable
protected void Button2_Click(object sender, EventArgs e)
{
int row = 1; int i;
string strcmd = null;
string Connection = "Data Source=....";
SqlConnection conn = new SqlConnection(Connection);
string str = "select company_name from T1 where ID=@ID";
[code]...
I need a place to store images. My first thought was to use the database, but many seems to recommend using the filesystem. This seems to fit my case, but how do I implement it?
The filenames need to be unique, how to do that. Should I use a guid?
How to retrieve the files, should I go directly to the database using the filename, make a aspx page and passing either filename or primary key as a querystring and then read the file.
What about client side caching, is that enabled when using a page like image.aspx?id=123 ?
How do I delete the files, when the associated record is deleted?
how to upload images to server(application/images folder) and retrive(display) from and on client PC for asp.net. its just for uplaoding logo directly to server folder and retriving from server to client. i am not getting server path on client pc for image.
View 5 RepliesIf I use SqlDataSource control in my asp page to retrive data in viewgrid and some dropdownlist control then what is advantage and disadvantage?
View 1 RepliesI'm making a simple homes classifieds section and when a home ad is created, a HomeID is automatically created for it in the db. I need the images to upload and enter the associated HomeID with each image automatically. What I tried isn't working, because it looks like it's looking for the HomeID in the codebehind before it gets entered into the db.
ASPX CODE
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
InsertCommand="INSERT INTO [Homes] ([UserName], [Street], [Details], [Contact], [Phone], [Email], [Thumb], [Price], [Approved], [Posted]) VALUES (@UserName, @Street, @Details, @Contact, @Phone, @Email, @Thumb, @Price, @Approved, @Posted)"
[Code]....
I want to retrieve sqldatasource row from database and if = 1/0 set checkbox to checked or not
I am using the sqldatasource and formview. The sqldatasource is bringing in 1 database item via querystring id
I want to read the row entitled 'IsCharacter' which is either 1 or 0 value. If it is 1 I want the checkbox in my formview to be checked. If it is 0, I want it to not be checked.
I could do this with a dropdownlist with value of 1 or 0 which would be easier for me, however, I don't think it would be as user friendly as a checkbox.
Perhaps a radiobuttonlist would be better?
I want to be able to retrieve a record from the database and change it than update the record in the database with changes.
what's I am doing
1- select the record for the data base
2- on loading the form set the content of each component woth data (eg: textbox1.text = "content")
when I edit the value and submit the form
3- I get the changed text (changed = textbox1.text )
but it get the old text not the changed one
How to Retrieve image from database into gridview
View 1 RepliesHere's my situation. I have a table called Inspections, and another table called Images. The Images table takes the ID of the Inspections table as a foreign key, so the Images tables contains multiple images with the same foreign key value.I'd like to be able to enter an integer of the ID number from the Inspections table and have it return all the records from the Images table with the foreign key that matches this ID, and then load them into a gridview. When I tried using the .ashx Handler approach that I found at this link
View 1 Replieshow to display images from a database cant cant seem to find quite what im looking for.
I have a site that allows users to upload their own photos, i would like to be able to display these images, with the discription of the photo underneath or on top of the photo, on the website and allow other users to comment on the photos.
The display can be every photo in the database, later ill impliment a search to narrow it by user later.
Right now I have my database table set up to take the img path, username that uploaded the picture, time it was uploaded, and a description of the photo.
I want to get data from the database and display it in gridview. The gridview should be editable. Meaning the user can add, edit and delete items/rows in the gridview. Everytime the user adds/updates/deletes an item, the gridview is also updated. However, these changes will only be saved to the database once the Save button is clicked.
View 3 RepliesI have a page where I will insert all the data into the database. The page where I'm having problems is when I select an item from the checkboxlist it only displays one item. The data which is displayed is only the one that was inserted with one selected item from the checkboxlist. The following code is the page I'm using to try to retrieve the data from the database. I am trying to do is when a user selects the first, second, or third, or fourth item. The corresponding data appears in the gridview. In my current code, the record which has one item selected appears. If the user has more than one selected it does not appear. It comes up as empty. Is there a way I can do it?
[Code]....
Recently i am develop a tuition center management systemNow i want to show a timetable which admin can view and know what time the class room is emptyMy timetable is : On the top of x-axis is time (8am, 9am, ...)On the left of y-axis is date (monday, tuesday, ...)In database i will define the start time and end time for each class
View 6 RepliesI have data in mydatabase. My AnswerText in the database is test1,test2,test3 While retrieving it is displaying as test3,test1,test2. I am using the below code to display the data.
Dictionary<string, string> dicKeyValues = new Dictionary<string, string>();
for (int i = 0; i < cnstsData.Answer.Count; i++)
{
dicKeyValues.Add(AnswerText, AnswerImage);
}
DataList.DataSource = dicKeyValues;
DataList.DataBind();
I want to display the AnswetText as test1,test2,test3. Basically i want the same order which i added to the database while retrieving also.