asp.net membership

Hi :wave:

I'm designing a site and the client wants to restrict access to some pdf files.
I got handed a excel sheet with members names & info [couple hundred]. These are the people who can look at the files.

Is there a way to load the worksheet, set up parameters and update the tables aspnetdb.mdf. If its possible, can someone point me to an article?

Thank in advance!:)

What version of ASP.NET are you using?

Hi eSPiYa

I'm using asp.net 2.0 and visual web developer 2005.

Thanks:)

You may upload the worksheet then immediately update your tables w/ the data from the worksheet. I did it before but I can't find my source code. ;)

About restriction of files, you may use the directory restriction.

ok, the first thing you will need to do is get that excel file open and expose the data programmatically. once you have achieved that, this article should be enough to show you what to do with the data:

http://msdn2.microsoft.com/en-us/library/ms998347.aspx

Kayos

Thank you for the article. I've got some time today to go over it.

I suggest using HttpHandlers and HttpModules. You can specify a specific file type (PDF, XLS) to be handled by the HttpHandler/HttpModule in your application's web.config. In the HttpHandler or HttpModule you write, check the session object that contains the user's information and their authentication level or any other information you may need. If they pass, give them the file. If they fail, send them a nasty picture of a llama shedding its skin.

If you have an Access Denied page to tell users, then it's not hard to verify a user's status and redirect them if they lack sufficient access rights.

vb Code:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
 
        If Not User.Identity.IsAuthenticated Then
            Response.Redirect("~/accessdenied.aspx")
        End If
 
End Sub