Re: How to create a file folder using ASP.NET 2.0 ?

I think the article Alexey sent you was excellent, it covers it all.
But to answer about my case: Yes I have a user login with username and
password. I keep the username (not the passord - this may be cahanging)
along with customerno and various credibilities in a session var, so each
form can set the appropriate properties for each user. And finally, the
username is stored in a column (LastChangedBy or OwnerID or AddedByID ...)
in various tables. On uploading files, my users have to specify a cathegory
and a description of the file. All this information along with current
datetime and the file itself is stored in a table.

Retrieving is very easy: SELECT * from FileTable WHERE OwnerID=LoginID

Bjørn

"kai" <kailiang@xxxxxxxxxxxxx> wrote in message
news:gmW5i.1995$%T3.1342@xxxxxxxxxxxxxxxxxxxxxxxxx
Bjorn ,
Thank for sharing your experiences.
After I insert a file for the user, how do you retrive the file for the
user? do you insert username and password into the files_Table?


Thanks

Kai

"Bjorn Sagbakken" <bjo-sag@xxxxxxxxx> wrote in message
news:Q96dnVy9-orBxsrbRVnzvAA@xxxxxxxxxxxxxx
Of course, the user can download the files from the SQL server. The user
will not know the difference, not knowing exactly where the files have
been stored. After all, the user experience only basic HTML at his end.
At the server end there may be all sorts of magic...

Bjorn

"kai" <kailiang@xxxxxxxxxxxxx> wrote in message
news:VPI5i.9768$JQ3.1064@xxxxxxxxxxxxxxxxxxxxxxxxx
Bjorn,
Thank you very much for your help.
After storing files in the SQL Server, can them be organized in the
folders? Can user download the files from SQL Server?


Thanks

Kai

"Bjorn Sagbakken" <bjo-sag@xxxxxxxxx> wrote in message
news:gr6dnUwgz9dP1srbRVnzvQA@xxxxxxxxxxxxxx
This can surely be done, but I would like to share my experience on
files on the web-server:
I designed an upload function for user files, but after some time the
administrator of the web-server was less happy about the volume of
these files (CD images and other large files). After some pondering I
have decided for another option; storing the user files in blob-fields
on an SQL-server. The administrator said this server had unlimited
space, they only add more HDD's far into TB. Well, in that way it is
easy to store userid along with the file and everything else you want
to control access.

Bjorn

"kai" <kailiang@xxxxxxxxxxxxx> wrote in message
news:soG5i.9089$JQ3.3525@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi, All
I am trying to create a file folder for any login user, and create
sub folders for the user on a web page. After the user login again, he
can only sees his own folder on the Web page. I am planning to use
VB2005 or C#.

I look the help files and searched on the web, I cannot find the
answer. Is this possble in ASP.NET 2.0?


Thanks

kai











.

Relevant Pages

  • Re: logon failure
    ... MSSQLServer service after you change the username of administrator account. ... username for the SQL Server startup service account or the SQL Server Agent ... Microsoft SQL Server service account on the SQL Server host computer. ...
    (microsoft.public.windows.server.sbs)
  • Interdev not creating project (authenticate failure)
    ... SQL Server Enterprise SP2 ... Username: Administrator ... Password: pwd ...
    (microsoft.public.inetserver.iis.security)
  • Interdev not creating project (authenticate failure)
    ... SQL Server Enterprise SP2 ... Username: Administrator ... Password: pwd ...
    (microsoft.public.win2000.security)
  • Re: Index for username/password
    ... say that users want to be able to define customer ... A username in a login table is a little different. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • authentication varies based on web address
    ... - if i type in the dns name, i get the user login ... (username, pwd, domain), it's the 2 text box login screen. ...
    (microsoft.public.inetserver.iis.security)