Dear, Thanks you for answering. I had read many articles about this topic, my problem is that i can't retrieve the image that i saved in sql server as binary to grid view. I make DataImageUrlField for the ImageField is itemImage, but instead of the image a white box with red cross appear. What is the problem? Thanks in advance....

I’m using sqldatasource to link data from sql to gridview. Using the following SELECT itemName, itemEmail, itemPhone, itemImage, itemDate, itemPrice, itemDescription FROM Item All the data appear in the gridview except the itemimage. Itemimage should show an image from sql. I try to use imagefield in the gridview, but instead of the image a small white box with a red cross. What option should I use in the imagefield to link data from sql server.

Thanks you for being Helpful, I need your advice I want to create a web site for shopping online. The customers can upload their images to the web. What is the best solution for this: 1- To store the image inside the table in the sql server. 2- Or to store the images inside a folder in the web.

Thanks you a lot...

When I retrieve an image from sql database in the grid view I had the following (System.Byte[]) instead the image. What is the problem? Thank you

It is working, Thanks for help Bob Regards,

i'm using sqldatasource in order to search a table item with the column name. I want to search Name column for any word containing any letter found in the text box control. I tried to write the following: SELECT Name, Email FROM Item WHERE CONTAINS (Name , @Name) The following error appears: Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Item' because it is not full-text indexed. could you please help me. thanks

Thanks for this help.I'm trying apply it on the asp.net web page there was an error occur. cannot use a contains or free text predicate on table or indexed view "item" because it is not full-text indexed What should i do thanks

I wan to search sql server table to find any word contains some all the letter what should i do. I'm using Asp.net vb to create web page. I create a text box I want to search for special letters. I'm using sqldatasource to connect to sql server with the following procedure: SELECT Name, Emai FROM Item WHERE (itemName = @itemName) What should i do instead of (itemName = @itemName) Thanks

Could you explaine more what you mean. Im using the following code to upload the file is there any mistake. Dim imageBytes(FileUpload1.PostedFile.InputStream.Length) As Byte FileUpload1.PostedFile.InputStream.Read(imageBytes, 0, imageBytes.Length) myCommand.Parameters.AddWithValue("@ImageData", imageBytes) thanks

I want to upload an image to sqlserver, i use fileupload control and upload the image. But when I retrieve it to gideview it appears as a text: System.Byte[] How can i solve this problem.. thanks

nice to see this answer, this will help me. Look at the System.Net.Mail.MailMessage class.

im using vb.net 2008. where is the best location to place the code.for example the code for sql (data reader, ds,queery). Is it better to place code at the header of the page or in the pagename.vb file or in a class I need hints Thanks

how can i send an email, when a user click a button. thanks

thanks for help, the code in the web.config is providerName="System.Data.SqlClient" /> i need to host this site.so i need to change aspnetdb.mdf to other name. what is the best solution for this problem

When I change the aspnetdb.mdf to XXXYYY.mdf in the app_data and in the web.config and try to connect using a user name and pass word I can’t access. What should I do to rename the aspnetdb.mdf database and can access secure locations. Thanks thanks

I want to build a web with user and control access. i'm using aspnetdb.how could i migrate this file to sql server. Thanks

I have simple question What is the best location to store sqlstringconnection concerning security purpose. Thanks

Dear, thank you for help, But my question is related to a question before i had ask. I want to build a web site containing a forum and users. my first question, could i use sql express edition for this site my second question, could i deploy and host this site using sql express edition thanks for hlep

Could I use sql Express edition which is already installed in the vb.net 2008 to build a site.