This is for the Club Web Site Starter Kit Extended  Edition that put an upload file addition on the site.

You can mark a file that you upload to the site as PUBLIC viewable or not.

When it is not PUBLIC it will not show on the docs.aspx gridveiw only PUBLIC files show-up.

I want the files to show if you are an ADMINISTRATOR.

I know if I make another page just for the ADMINISTRATOR I can get it to show all files by avoiding the IsPublic WHERE
Must be a better way.
Reason: I want all files to show if an ADMINISTRATOR, so other ADMINISTRATOR whom are not designing the web site can view and download files that have been uploaded by other Administrators.

Thanks In Advance for your help

Here is the present code that brings back the PUBLIC files.

SelectCommand="SELECT * FROM [DocumentCategories] WHERE ([IsPublic] = @IsPublic) ORDER BY [CategoryName]">
                  
                    <SelectParameters>
                        <asp:Parameter DefaultValue="true" Name="IsPublic" Type="Boolean" />
                    </SelectParameters>

This is for the Club Web Site Starter Kit Extended  Edition that put an upload file addition on the site. ???

If I'm reading this right your saying you have a CSK extended edition?  If so where did you get it from, just curious.

I have a File sharing addon I just developed, it does have the ability to set the ViewStatus to Public, Authenticated or Administrators. it is a simple Radio button selection when you add a file or edit a file.

You can do this by adding an OR to the sql query. For example:

SelectCommand="SELECT * FROM [DocumentCategories] WHERE (([IsPublic] = @IsPublic) OR (@isAdmin= TRUE)) ORDER BY [CategoryName]">
                  
                    <SelectParameters>
                        <asp:Parameter DefaultValue="true" Name="IsPublic" Type="Boolean" />

                        <asp:Parameter DefaultValue="false" Name="isAdmin" Type="Boolean" />
                    </SelectParameters>

You then need to set the value of the parameter when the datasource is bound. The code below is probably wrong as I just flattened my laptop and don't have VS installed, but should be close enough to give the right idea.

    protected void SqlDataSource1_Selecting(object sender, System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs e)
    {
        if (User.Identity.IsAuthenticated && User.IsInRole("Administrators"))
        {
            e.Command.Parameters["@isAdmin"].Value = True;
        }
    }

Sam

Your help is greatly appreciated. I'm putting here more of the code with your suggested changes included. I see where the DataBinding takes place. But I do not know where to put the Data Bound protected void code you have provided. Can you continue with your help?