Membership & Roles - The SqlTableProvider Sample

Last post 08-07-2007 7:38 AM by XiaoYong Dai – MSFT. 3 replies.

Sort Posts:

  • Membership & Roles - The SqlTableProvider Sample

    08-03-2007, 4:00 AM
    • Participant
      1,179 point Participant
    • pete_m
    • Member since 04-28-2004, 11:13 AM
    • UK
    • Posts 296

    Hi all,

     I'm new to .net 2.0 (but have a few years of 1.1 behind me)  I'm looking at Membership and Roles and am getting quite confused.

    We would like to apply .Net Roles to our existing Database. As I understand it, this will require a custom Provider - such as the SqlTableProvider/SqlStoredProcedureProvider.

    I have downloaded and installed the Table Profile Provider sample from http://www.asp.net/downloads/sandbox/table-profile-provider-samples/ but cannot work it out.

    First of all, how do I compile the project? There isn't a project file in the project directory, I tried creating a new project and adding the items in individually but it wont compile (controls don't exist in the current context) as there was no .aspx.designer.cs file (Which I then created but to no effect)

     Any help much appreciated as I feel I am really hitting a brick wall with this,

    Thanks,

    Pete
     

  • Re: Membership & Roles - The SqlTableProvider Sample

    08-06-2007, 11:52 PM
    Answer

    Hi

    I install the sample code for SQlTableProfile Provider from the same link.

    By default, you can get the sample code in forlder; C:\Program Files\Microsoft\ASP.NET 2.0 Table Profile Provider Samples

    Add all files into your web site which has a structure like this

    YourWebsite
      -App_Code
     --SqlStoredProcedureProfileProvider.cs
     --SqlTableProfileProvider.cs
      -App_Data
     --SampleSchema.sql
      -Default.aspx
       --Default.aspx.cs
      -Login.aspx
       --Login.aspx.cs
      -Web.config 

    and it should be successfully compiled without any modification.

    You can also follow the steps in white paper and make it a fully working project.

     

    Best Regards
    XiaoYong Dai
    Microsoft Online Community Support

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
  • Re: Membership & Roles - The SqlTableProvider Sample

    08-07-2007, 3:13 AM
    • Participant
      1,179 point Participant
    • pete_m
    • Member since 04-28-2004, 11:13 AM
    • UK
    • Posts 296

     Hi cheers for the reply,

     This is exactly what I did - the project would not build though because the default.aspx.designer.cs wasnt present.

    I seem to have solved my original problem but have still not managed to build the example so I guess this thread is now complete...

    Cheers,

    Pete
     

     

  • Re: Membership & Roles - The SqlTableProvider Sample

    08-07-2007, 7:38 AM

    Hi

    Hmm, There are some distinguish between WebApplication project and web site project, For this scenario, I suggest you create a web site and it should work.

    Best Regards
    XiaoYong Dai
    Microsoft Online Community Support

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
Page 1 of 1 (4 items)