Web App, SQL Server, files

[grzybek]

Hi,
I have question about techniques of using files
in SQL Server in Web Application.
Assuming that I send files from my Web App ( client )
to server and located these files on hard disk ( on server ),
I'd like to view these files and I want to have possibilities
to open it.
How can I do it ?

My only one idea is :
In table in database I should put path to specific file ?
And then I know reference to specific file connecting to
display name.
( Unless I can put files directly indatabase, not disk? I'm not good at
SQL yet ,
but I doubt it )

Any others idea ? Any example in C#.

Thanks in advance.

[ ASP .NET, C#, SQL Server 2000 )

Best Regards,
grzybek

[Nicholas Paldino [.NET/C# MVP]]

grzybek,

You can store files in the database in SQL server. However, if you are
processing a large number of files, and they are located on the local
machine, and your SQL server is on another machine, moving the content to
SQL server is going to worsen the performance of your application.

Your original suggestion of placing the path to the file in the database
sounds like the best idea.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"grzybek" <no************@gze.pl> wrote in message
news:bs***********@news2.ipartners.pl...

Hi,
I have question about techniques of using files
in SQL Server in Web Application.
Assuming that I send files from my Web App ( client )
to server and located these files on hard disk ( on server ),
I'd like to view these files and I want to have possibilities
to open it.
How can I do it ?

My only one idea is :
In table in database I should put path to specific file ?
And then I know reference to specific file connecting to
display name.
( Unless I can put files directly indatabase, not disk? I'm not good at
SQL yet ,
but I doubt it )

Any others idea ? Any example in C#.

Thanks in advance.

[ ASP .NET, C#, SQL Server 2000 )

Best Regards,
grzybek