Re: Setting a Default Value

if your default value needs to come out of the database but it does not change,
the make the Sql call from within Application_Start in Global.asax. You can
then either store it in Application state or in a static field in the Global
class.
Peter

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net




"Brad Baker" wrote:

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: return multiple rows from sql statement
    ... Concatening SQL ... strings from input values is almost certainly a safe path to SQL ... All characters that are entered in the fields make their way into the database unaltered. ... The insert of what surprisinlgly was NOT a syntax error, but a string called "mysql_insert_id" into an integer field resulted in the value zero being put in. ...
    (comp.lang.php)
  • Re: Establish connection with and transferring data to Access
    ... If you Google for SQL +"Insert into" you'll a dozen tutorials. ... The specific problem with your code is that you need to quote string ... Dim vConnection As New ADODB.Connection ... Doug's code opens and writes to an existing database. ...
    (microsoft.public.word.vba.general)
  • Re: Random Access Files in databases
    ... I am not a Database design guru either, but it might be wise to break ... location and read in in the string, and then you want to get an integer, so ... I'm pretty sure the SQL language does have ways to seek around in BLOB ... some SQL purist are quick to point out that MySQL doesn't implement the SQL ...
    (comp.lang.java.programmer)
  • Problems Setting Up Database
    ... I seem to be having errors creating and accessing an SQL database. ... New SQL Server Database'. ... System.Web.Management.SqlServices.ExecuteFile(String file, String server, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ADO exception with character combination inside string...
    ... quoted identifier not a string literal. ... The string being sent as SQL is composed like this: ... into stored procedures inside the MSSQL database. ... use calls to the stored procedures in order to update data or retrieve ...
    (borland.public.delphi.database.ado)