open the uploaded documents

Hi,

I have the requirements to add the attachment, so i am saving the documents in sqlserver.

now i am facing the problem with openning the document.

can any body suggest me how to open the documents which are stored in sql server

Try this:

byte[] file = table.row.fileField;

Response.AddHeader(

"Content-Disposition","inline; filename=\"nameOfTheFile");

Response.BinaryWrite(file);

Response.End

|||

Try this:

byte[] file = table.row.fileField;

Response.AddHeader(

"Content-Disposition","inline; filename=\"nameOfTheFile");

Response.BinaryWrite(file);

Response.End

|||

Try this:

byte[] file = table.row.fileField;

Response.AddHeader(

"Content-Disposition","inline; filename=\"nameOfTheFile");

Response.BinaryWrite(file);

Response.End

|||

Try this:

byte[] file = table.row.fileField;

Response.AddHeader(

"Content-Disposition","inline; filename=\"nameOfTheFile");

Response.BinaryWrite(file);

Response.End

only show days in datetime

hi
I want to search for documents created between different dates. Therefore I want to store a date in the format yyyy-mm-dd, but the databases store it as yyyy-mm-dd 00:00:00.000
how do I get rid of the hours and minutes?
Helenayou cannot get rid of them, they are part of the datatype

store your date values without a time component, and then when you search for a date range, you'll be fine

the only way people get into trouble is when they store values like getdate() which include an actual time

Online SQL Files?

Good morning,
I'm trying to make files I've placed on a SQL server publicly accessible from the WWW. I put them in a folder where other documents are located but the files are not online. I know I must publish them, but I'm not exactly sure on how to go about it.As you have posted a question in the articles section it is being moved to SQL Forum.

MODERATOR.