TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Mohamed Mahmoud
NA
1
0
how to display images on the datgrid??
Jul 19 2008 7:30 PM
I'm working on a website development using C# and asp.net, the main idea of website is online shopping using smart cards, one user post an item, store all it's information on the database (title, category, photo, price, user ID who post it, and the delivery point). Everything is going alright until I came to the point where I've to store the photo in the database, well at the beginning I made photo column in the database of varchar data type, so i can store the image URL in the server. But then stuff got more complicated, so i've decided to change the column data type to image, well the process went a lot better, i've stored the image successfully, using the following code:
int len = File1.PostedFile.ContentLength;
byte[] pic = new byte[len];
File1.PostedFile.InputStream.Read (pic, 0, len);
con=new SqlConnection();
con.ConnectionString = "Data Source=(local);Initial Catalog=sudasmart;Integrated Security=SSPI";
cmd=new SqlCommand("INSERT INTO Products(Name,Descriptions,photo,details,category,price,Drop_Point,Contact_check)Values('"+ptitle.Text+"','"+pdescript.Text+"',@pic,'"+pdetails.Text+"','"+pcat.SelectedValue+"',"+iprice+",'"+dropoint.SelectedValue+"','"+cntmthd.SelectedValue+"')",con);
cmd.Parameters.Add("@pic", pic);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
where "File1" is the file input ID.
he problems all started when i want to, retrieve the information from the database, and display them on the datagrid.
So can you provide me with the need help?? thank you for taking time reading this
Reply
Answers (
1
)
hi khan, downloaded paypal sdk,how to proceed furhter???? can u plz guide me!!!!
Accessing a VSS database at the Remote machine