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....

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.

It is working, Thanks for help Bob Regards,

For creating full text indexes see: CREATE FULLTEXT INDEX (Transact-SQL)[^] But as said before, if your query need is simple use LIKE. Mika The need to optimize rises from a bad design. My articles[^]

Have u Tried this... FileUpload1.FileBytes;

y_mmohd wrote: where is the best location to place the code you should have different layer (dll ) for that. In your application you should have presentation, Business and Database layer. and you should have to organaized accroding to them. cheers, Abhijit

Hope This will help you Check This[^] cheers, Abhijit

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

Change it in the connection string as krazzy said. SSK. Anyone who says sunshine brings happiness has never danced in the rain.

Krazy Programmer wrote: in web config .. encrypted how can we store it encrypted ? plz give some e.g. or link Thanx. Apurv A coward is incapable of exhibiting love; it is the prerogative of the brave. .......Mohandas Gandhi

y_mmohd wrote: my first question, could i use sql express edition for this site Yes y_mmohd wrote: my second question, could i deploy and host this site using sql express edition No :(( Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Thank you so much,

You need to create a ContentPlaceHolder and Put a Label control in it. You can modify that Label in your web Pages dynamically, thet uses this MasterPage. Regards, Jay

Hi SQL Express is configured by default to allow only local connections using windows authentication. From what that looks is that the IIS is running under an user that the SQL Server does not accept. While I'm no IIS/SQL Server expert, and thus can not really help you to configure them to work like that, what I suggest is that you setup SQL Server to allow both Windows Authentication and SQL Server. Using the SQL Server Management Studio (http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en) log in to the server and under the server's "Properties" choose Security and select "SQL Server and Windows Authentication". Then create a user and password with access to your database (in your database "Security" -> "Logins" -> Right click -> "New Login...") and adjust your connection string to use this login, for example: "server=Earthquake\\SqlExpress; user id=UserName; password=Password; database=Database" This should allow you to use both SQL Express for the final site. Bruno Sousa Software Consultant http://www.luasys.com

BillyGoatGruff wrote: I think that if you Disable "Anonymous Access" and Enable "Integrated Windows authentication"; on the IIS virtual directory, it will solve this. I had the same problem, you are right. :)

Thanks for help.

It's as easy: TextBox1.DataBindings.Add("Text", myDataSet.Table1, "myField") vonb

Its Done, Thanks for Help :-D I need a to send string and retreive string to sql table using sql command. I write: sqlcomm = new sqlcomman (insert into mytable (name) values ('string'),sqlconn) Bu How can i do this using a textbox, I miss understand the syntax. Thanks