Re: Setting a Default Value

I'm a bit of an asp.net/csharp newbie so please bear with me. If I
understand you correctly, I would call: SafeSessionGet(myvariable) to get
the query string value (or assign a default value) each time I needed to
reference myvariable?



Assuming that's correct, I'm not sure if that's the best solution as I am
going to assign the default value through a database query. So for instance
I might have the following (again in pseudo code):



if myvariable == null {

run the following SQL query: select * from table where x = 1

myvariable = first result of sql query

}



So for instance if I needed to call myvariable from four different sections
of my code I would have to run the sql query four times? Isn't that fairly
inefficient performance wise? I was thinking of trying to set myvariable
once using one SQL query then reuse it throughout my application. I was
hoping to do that through some sort of global variable (I'm not sure csharp
has anything like that or not though).



Maybe I am misunderstanding you or maybe there is some other approach I'm
overlooking. Any additional guidance you could provide would be sincerely
appreciated. :)



Thanks Again,

Brad



"sloan" <sloan@xxxxxxxxx> wrote in message
news:Ocvto0kmHHA.3952@xxxxxxxxxxxxxxxxxxxxxxx
Put this in a class somewhere.



public static string SafeSessionGet(Page pageObj, string requestKey,
string defaultValue)
{
if (pageObj.Request[requestKey] == null)
{
return defaultValue;
}
else
{
return pageObj.Request[requestKey].ToString ();
}
}




public static string SafeSessionGet(Page pageObj, string requestKey)
{
return SafeSessionGet ( pageObj , requestKey , string.Empty ) ;
}





You could write a generics version of this in 2.0 if you wanted, but that
might be overkill.


private string m_empUUID = string.Empty;

public void Page_Load(object sender, EventArgs e)
{


m_empUUID = SafeSessionGet ( Page , "empkey" ) ;
//or

m_empUUID = SafeSessionGet ( Page , "empkey" ,
"00000-00000-000000000-000000000" ) ;



}







"Brad Baker" <brad@xxxxxxxxxxxxx> wrote in message
news:ubX6fskmHHA.3952@xxxxxxxxxxxxxxxxxxxxxxx
I have an asp.net/csharp application that requires a particular variable
to
work properly. This variable is usually passed via a query string in the
URL
when the application is first run but under certain circumstances the
query
string may not contain the variable. So I need some way of establishing a
default value if one isn't set.

Is there some way I can set a query string on page_load OR is there some
way
I can use a global variable which is accessible throughout my application
instead? In pseudo code something like:

public void Page_Load(object sender, EventArgs e)
{
if (querystring == null)
{
global myvariable = "somevalue";
} else {
global myvariable = querystring;
}
}

protected void dostuff(object sender, EventArgs e)
{
if (myvariable == "foo")
{
// do stuff
}
}

Hopefully this makes sense - for clarity sake I have tried to simplify my
situation as much as possible.

Thanks
Brad






.

Relevant Pages

  • Re: Problems with Delete Command
    ... The SQL could get fairly messy if you need to construct it in code, ... ContactID, and WebComID, and create your on-the-fly SQL on that saved query, ... to find the list of ContactIDs from the junction table, ... This is a style/readability thing: if you are going to use string ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Need help with Code Please!!!
    ... the actual string that gets built at the end of the SQ1 build process. ... The message says Syntax error in query expression ... Dim rs As Recordset 'object ref to qryCompany\USFNumber ...
    (microsoft.public.access.formscoding)
  • Re: Need help with Code Please!!!
    ... putting the query SQL itself in here maybe it will help you understand what I ... the actual string that gets built at the end of the SQ1 build process. ... Dim rs As Recordset 'object ref to qryCompany\USFNumber ... Dim qd As QueryDef 'object ref to query item ...
    (microsoft.public.access.formscoding)
  • Re: Need help with Code Please!!!
    ... the actual string that gets built at the end of the SQ1 build process. ... The message says Syntax error in query expression ... Dim rs As Recordset 'object ref to qryCompany\USFNumber ...
    (microsoft.public.access.formscoding)
  • Re: Error using " in .open with ADODB.Recordset
    ... recordset but I'm getting hung up on the SQL statement. ... query that has a string as a condition. ... Dim mrk As String ...
    (microsoft.public.data.ado)
Loading