Hello,
I have to design and develop web application (ASP.NET 2.0). The main point
of it will be managing documents stored into database (SQL Server 2005).
Advice me please how can I do it.
What is the best field type to store documents (Word, Excel, PDF). Maybe new
varbinary(max)? -maybe other.
How can I perform inserting, deleting, editing etc. documents in database
via ASP.NET 2.0 page.
What web control should be used (maybe upload file?). And what code behind
could be invoked to perform these tasks.
Best Regards
Darek T.
2  3244 
On 4 Kwi, 23:14, "Dariusz Tomon" <d.to...@mazars.plwrote:
Hello,
I have to design and develop web application (ASP.NET 2.0). The main point
of it will be managing documents stored into database (SQL Server 2005).
Advice me please how can I do it.
What is the best field type to store documents (Word, Excel, PDF). Maybe new
varbinary(max)? -maybe other.
How can I perform inserting, deleting, editing etc. documents in database
via ASP.NET 2.0 page.
What web control should be used (maybe upload file?). And what code behind
could be invoked to perform these tasks.
Best Regards
Darek T.
Hi
You can use BLOB fields for storing data. But if you have to modify
data you should get it from database to something like MemoryStream
then change and put it to database. I thing uploading files to
directories (and editing etc) should be simplier.
Regards
Dariusz Tarczynski
I've detailed the answers to all your questions in this free article: http://SteveOrr.net/articles/EasyUploads.aspx
--
I hope this helps,
Steve C. Orr,
MCSD, MVP, CSM, ASPInsider http://SteveOrr.net
"Dariusz Tomon" <d.*****@mazars.plwrote in message
news:em**************@TK2MSFTNGP04.phx.gbl...
Hello,
I have to design and develop web application (ASP.NET 2.0). The main point
of it will be managing documents stored into database (SQL Server 2005).
Advice me please how can I do it.
What is the best field type to store documents (Word, Excel, PDF). Maybe
new varbinary(max)? -maybe other.
How can I perform inserting, deleting, editing etc. documents in database
via ASP.NET 2.0 page.
What web control should be used (maybe upload file?). And what code behind
could be invoked to perform these tasks.
Best Regards
Darek T.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Dave Smithz |
last post by:
Hi There,
Being quite new to MS-SQL I would like to ask if there is a general opinion
of what approach should be taken to storing things like external documents
and images in databases.
...
|
by: clintonG |
last post by:
Membership is broken and who knows what else. Does anybody have any
referrals to current documents that explain what was changed and how one
might respond?
<%= Clinton Gallagher...
|
by: Jordan Richard |
last post by:
I'm designing a new .NET 2.0 Windows Forms application to support users who,
amongst other things, need to print letters and envelopes. They currently do
such printing by manually managing a...
|
by: batman |
last post by:
we have a group of developers which have created and asked us (DBAs) to
create many objects in the databases including tables / stored
procedures / functions / etc.
since our company is growing,...
|
by: (PeteCresswell) |
last post by:
User wants to go this route instead of storing pointers in the DB and the
documents outside.
Only time I tried it was with only MS Word docs - and that was a loooong time
ago - and it seemed to...
|
by: sameer |
last post by:
i am in the process of designing an application that uploads documents to the
webserver from my ASP.net \ winforms application and saved them in the
database. Now i have another page which show...
|
by: istruttorenuoto |
last post by:
hi to everybody!!
i wrote i script from Unix's Bourne shell that connects to an Oracle DataBase and calls a Stored Procedure. Now i'd like to insert some more commands for error managing.
here's my...
|
by: shantanu |
last post by:
Hi All,
I have a requirement to develop a search engine based on
some search criteria that will search for the string or statement in
all the documents uploaded in the website. The search result...
|
by: RAZZ |
last post by:
Hello, Can anyone suggest me solution?
I Need to manage different types of documents (doc,xls,ppt etc) in
server. I have folder structure to maintain these documents in server.
Say folder1 is...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |
