Thread in a webservice.

I need a thread that loads the content of a database table in the cache
(System.Web.Caching.Cache)

i wrote therefore the code below:
public class Global : System.Web.HttpApplication

{

....

.....

.....
public static Thread t;


{

get { return post; }

}
public Global()

{

InitializeComponent();

}

public static String GetConnectionString

{

get { return ConfigurationSettings.AppSettings["DBConnStr"]; }

}

protected void Application_Start(Object sender, EventArgs e)

{

DataSet
ds=SqlHelper.ExecuteDataset(Global.GetConnectionSt ring,CommandType.Text,"select
* from table");
HttpContext.Current.Cache.Insert("data",ds.Table[0],null,Cache.NoAbsoluteExpiration,System.TimeSpan.F romHours(2));
t = new Thread(new ThreadStart(ThreadProc));

t.Start();

Thread.Sleep(3600);


}

....

.....

......
public void ThreadProc()

{

try

{

DataSet
ds=SqlHelper.ExecuteDataset(Global.GetConnectionSt ring,CommandType.Text,"select
* from Table");
HttpContext.Current.Cache.Insert("data",ds.Tables[0],null,Cache.NoAbsoluteExpiration,System.TimeSpan.F romHours(2));

}

catch(Exception ex)

{

string str = ex.Message; // get the exeption as a string

}

...

.....

....

But!!!

This cause the exception: "object reference not set to an instance of
anobject"

Can someone tell me what i'm doing wrong?

Many thanks in advance

JB

Hi,

What is the line that gives you that error?

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"jensen bredal" <je***********@yahoo.dk> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

I need a thread that loads the content of a database table in the cache
(System.Web.Caching.Cache)

i wrote therefore the code below:
public class Global : System.Web.HttpApplication

{

....

.....

.....
public static Thread t;


{

get { return post; }

}
public Global()

{

InitializeComponent();

}

public static String GetConnectionString

{

get { return ConfigurationSettings.AppSettings["DBConnStr"]; }

}

protected void Application_Start(Object sender, EventArgs e)

{

DataSet
ds=SqlHelper.ExecuteDataset(Global.GetConnectionSt ring,CommandType.Text,"select
* from table");
HttpContext.Current.Cache.Insert("data",ds.Table[0],null,Cache.NoAbsoluteExpiration,System.TimeSpan.F romHours(2));
t = new Thread(new ThreadStart(ThreadProc));

t.Start();

Thread.Sleep(3600);


}

....

.....

......
public void ThreadProc()

{

try

{

DataSet
ds=SqlHelper.ExecuteDataset(Global.GetConnectionSt ring,CommandType.Text,"select
* from Table");
HttpContext.Current.Cache.Insert("data",ds.Tables[0],null,Cache.NoAbsoluteExpiration,System.TimeSpan.F romHours(2));

}

catch(Exception ex)

{

string str = ex.Message; // get the exeption as a string

}

...

.....

....

But!!!

This cause the exception: "object reference not set to an instance of
anobject"

Can someone tell me what i'm doing wrong?

Many thanks in advance

JB

in "ThreadProc" the line:

HttpContext.Current.Cache.Insert("data",ds.Table[0],null,Cache.NoAbsoluteExpiration,System.TimeSpan.F romHours(2));


"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us>
wrote in message news:ON**************@TK2MSFTNGP15.phx.gbl...

Hi,

What is the line that gives you that error?

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"jensen bredal" <je***********@yahoo.dk> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

I need a thread that loads the content of a database table in the cache
(System.Web.Caching.Cache)

i wrote therefore the code below:
public class Global : System.Web.HttpApplication

{

....

.....

.....
public static Thread t;


{

get { return post; }

}
public Global()

{

InitializeComponent();

}

public static String GetConnectionString

{

get { return ConfigurationSettings.AppSettings["DBConnStr"]; }

}

protected void Application_Start(Object sender, EventArgs e)

{

DataSet
ds=SqlHelper.ExecuteDataset(Global.GetConnectionSt ring,CommandType.Text,"select
* from table");
HttpContext.Current.Cache.Insert("data",ds.Table[0],null,Cache.NoAbsoluteExpiration,System.TimeSpan.F romHours(2));
t = new Thread(new ThreadStart(ThreadProc));

t.Start();

Thread.Sleep(3600);


}

....

.....

......
public void ThreadProc()

{

try

{

DataSet
ds=SqlHelper.ExecuteDataset(Global.GetConnectionSt ring,CommandType.Text,"select
* from Table");
HttpContext.Current.Cache.Insert("data",ds.Tables[0],null,Cache.NoAbsoluteExpiration,System.TimeSpan.F romHours(2));

}

catch(Exception ex)

{

string str = ex.Message; // get the exeption as a string

}

...

.....

....

But!!!

This cause the exception: "object reference not set to an instance of
anobject"

Can someone tell me what i'm doing wrong?

Many thanks in advance

JB