Compare sql database field to name of the current page

SouthendSupporter · July 11th, 2009, 06:39 AM

Hi,
I want users of a website to be able to update text areas of their site using the site management pages.
I have set up a database table containing the PageName and the text areas they are able to edit.
I have created the means to update the table OK.

In the page where I want to display the data I have placed a Gridview control (might be better to use a Formview? - but I'll see) in the place where I want a section of text to appear.

I can configure the control so that it only displays the appropriate field (left column, right column) etc but I cannot figure out how to get an appropriate WHERE statement

What I want is:
SELECT PageName, LeftColumn FROM TextAreas WHERE Pagename = "the name of the current page".
Obviously, I need something that is available on every page.
I found this:
[code]
public string GetCurrentPageName()
{
string sPath = System.Web.HttpContext.Current.Request.Url.Absolut ePath;
System.IO.FileInfo oInfo = new System.IO.FileInfo(sPath);
string sRet = oInfo.Name;
return sRet;
}public string GetCurrentPageName()
[\code]
which I thought I could place in the CSS page but I get an errror that 'string' is not valid
And also I was not sure how I would then use it to create an effective WHERE....

Any thoughts anyone?

chroniclemaster1 · July 11th, 2009, 10:54 PM

I think you're making it more complicated than it needs to be. Just use an appropriate Request.Url object (I think there are shorter ones than AbsolutePath, but whatever works for you.) Store that in your database, and use it in your WHERE statement just like you're doing. I haven't tried doing it, but the only bumps I can see is that if you have slashes and punctuation you might need to escape them.

SouthendSupporter · July 12th, 2009, 07:39 AM

Quote:

Originally Posted by chroniclemaster1

I think you're making it more complicated than it needs to be. Just use an appropriate Request.Url object (I think there are shorter ones than AbsolutePath, but whatever works for you.) Store that in your database, and use it in your WHERE statement just like you're doing. I haven't tried doing it, but the only bumps I can see is that if you have slashes and punctuation you might need to escape them.

Thanks for the response.
However, you assume a greater knowledge on my part than I actually possess :(
I am VERY MUCH a beginner learning 'on project'.

I have tried to look up the use of request.url. and it looks like I can use .segments??? to get the page name :

To test my theory I created a test page (aaTestingpage.aspx) with a label and put the following code in the code behind page:

Code:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim WebPage As String = Request.Url.Segments.Clone / Page.ToString
        Label1.Text = WebPage
    End Sub

When I run the page I get the error:
Operator '/' is not defined for type 'String()' and string "ASP.aatestingpage_aspx".

If I use Request.Url.Segments.Clone.Page.ToString
I get:
Public member 'Page' on type 'String()' not found

Obviously, you can see that I am 'fishing' without solid knowledge.

Assuming I can get this syntax right with someone's help(!), Where would I put it so that the variable WebPage is available on every page and contains the name of the current page. In the code behind of the Masterpage? Or do I need to create a Base page and link all my pages to it?
And do I refer to it in my SELECT statement as WHERE PageName = '" & WebPage & "' or do I need to set something else up?

Appreciate the patience of all on the forum .