Using Session.add() with ado

[Spencer H. Prue]

Hello!,

I have a using system.web.sess ionstate directive one the top of each of two
web pages. On the first page I have the dataadapter, dataconnection, and
dataset (also in the component tray). I have used Session.Add().

Session.Add("da dapter", sqlDataAdapter1 );
Session.Add("ds et", ds);

On the other page I have used a cast to get at the Session objects that I
supposedly stored on the other page.

SqlDataAdapter da2 =
(System.Data.Sq lClient.SqlData Adapter)Session["dadapter"]);

Dataset ds2 = (System.Data.Da taSet)Session["dset"]);

My code on the page where I want to use the data from the database(The other
page has the ADO in the component tray) says

Session("dadapt er")=null
Session("dset") =null

I looked through the MSDN to see if I could get some error messages out of
the session object, but no go. As far as the ASP.NET I get the error "object
reference not set to an instance of an object." What could be wrong?
--
Spencer

[Tampa.NET Koder]

Basically,

You just held the variable names in session state not the objects itselves.
So, to create the objects after you cast each variable reference out you
should do a
da2 = new SqlDataAdapter( );
ds2 = new Dataset():

This should allow you to use these objects.
"Spencer H. Prue" <Sp**********@d iscussions.micr osoft.com> wrote in message
news:BE******** *************** ***********@mic rosoft.com...

Hello!,

I have a using system.web.sess ionstate directive one the top of each of
two
web pages. On the first page I have the dataadapter, dataconnection, and
dataset (also in the component tray). I have used Session.Add().

Session.Add("da dapter", sqlDataAdapter1 );
Session.Add("ds et", ds);

On the other page I have used a cast to get at the Session objects that I
supposedly stored on the other page.

SqlDataAdapter da2 =
(System.Data.Sq lClient.SqlData Adapter)Session["dadapter"]);

Dataset ds2 = (System.Data.Da taSet)Session["dset"]);

My code on the page where I want to use the data from the database(The
other
page has the ADO in the component tray) says

Session("dadapt er")=null
Session("dset") =null

I looked through the MSDN to see if I could get some error messages out of
the session object, but no go. As far as the ASP.NET I get the error
"object
reference not set to an instance of an object." What could be wrong?
--
Spencer

[Spencer H. Prue]

My code still says the session state for the two variables I stored on the
other page is equal to null. I set the da2, and ds2 equal to new
Sqldataadapter and new Dataset.The error says "The SelectCommand property has
not been initialized before calling Fill." Should I import into session state
the Select, Insert, Update, and Delete commands also? Would it be easier to
just use the sql wizard and generate the ado statements on both pages? Thanks.

Spencer

"Tampa.NET Koder" wrote:

Basically,

You just held the variable names in session state not the objects itselves.
So, to create the objects after you cast each variable reference out you
should do a
da2 = new SqlDataAdapter( );
ds2 = new Dataset():

This should allow you to use these objects.
"Spencer H. Prue" <Sp**********@d iscussions.micr osoft.com> wrote in message
news:BE******** *************** ***********@mic rosoft.com...

Hello!,

I have a using system.web.sess ionstate directive one the top of each of
two
web pages. On the first page I have the dataadapter, dataconnection, and
dataset (also in the component tray). I have used Session.Add().

Session.Add("da dapter", sqlDataAdapter1 );
Session.Add("ds et", ds);

On the other page I have used a cast to get at the Session objects that I
supposedly stored on the other page.

SqlDataAdapter da2 =
(System.Data.Sq lClient.SqlData Adapter)Session["dadapter"]);

Dataset ds2 = (System.Data.Da taSet)Session["dset"]);

My code on the page where I want to use the data from the database(The
other
page has the ADO in the component tray) says

Session("dadapt er")=null
Session("dset") =null

I looked through the MSDN to see if I could get some error messages out of
the session object, but no go. As far as the ASP.NET I get the error
"object
reference not set to an instance of an object." What could be wrong?
--
Spencer

[Tampa.NET Koder]

Ah, you didn't get the same error. Thats a start. Grant it, I don't like
the way you are doing this but I'm sure you can get this to work. Try
posting some code, so we can see what you have already. Maybe there is
something that is missing. Using the data tool is OK, only for beginners.
The more you start to use this stuff, you will see that the data tools
binded to each page will be harder to maintain.
"Spencer H. Prue" <Sp**********@d iscussions.micr osoft.com> wrote in message
news:E2******** *************** ***********@mic rosoft.com...

My code still says the session state for the two variables I stored on the
other page is equal to null. I set the da2, and ds2 equal to new
Sqldataadapter and new Dataset.The error says "The SelectCommand property
has
not been initialized before calling Fill." Should I import into session
state
the Select, Insert, Update, and Delete commands also? Would it be easier
to
just use the sql wizard and generate the ado statements on both pages?
Thanks.

Spencer

"Tampa.NET Koder" wrote:

Basically,

You just held the variable names in session state not the objects
itselves.
So, to create the objects after you cast each variable reference out you
should do a
da2 = new SqlDataAdapter( );
ds2 = new Dataset():

This should allow you to use these objects.
"Spencer H. Prue" <Sp**********@d iscussions.micr osoft.com> wrote in
message
news:BE******** *************** ***********@mic rosoft.com...

> Hello!,
>
> I have a using system.web.sess ionstate directive one the top of each of
> two
> web pages. On the first page I have the dataadapter, dataconnection,
> and
> dataset (also in the component tray). I have used Session.Add().
>
> Session.Add("da dapter", sqlDataAdapter1 );
> Session.Add("ds et", ds);
>
> On the other page I have used a cast to get at the Session objects that
> I
> supposedly stored on the other page.
>
> SqlDataAdapter da2 =
> (System.Data.Sq lClient.SqlData Adapter)Session["dadapter"]);
>
> Dataset ds2 = (System.Data.Da taSet)Session["dset"]);
>
> My code on the page where I want to use the data from the database(The
> other
> page has the ADO in the component tray) says
>
> Session("dadapt er")=null
> Session("dset") =null
>
> I looked through the MSDN to see if I could get some error messages out
> of
> the session object, but no go. As far as the ASP.NET I get the error
> "object
> reference not set to an instance of an object." What could be wrong?
> --
> Spencer

[Spencer H. Prue]

Web page 2 (aspx)

sqldataadapter da2 = (system.data.sq lclient.sqldata adapter)session["dadapter"]
dataset ds2 = (system.data.da taset)session["dset"]
da2 = new sqldataadapter( )
ds2 = new dataset()
da2.fill(ds2)
Web page(aspx) with ado.net in component tray

Session.add("da dapter", sqldataadapter1 );
Session.add("ds et", ds);

The ado.net error from the fill statement is:

"The SelectCommand property has not been initialized before calling 'Fill'

I suppose I could add the the rest of the ado to the session state, but I am
not sure if it is necessary or not. Thanks for your help.

Spencer

"Tampa.NET Koder" wrote:

Ah, you didn't get the same error. Thats a start. Grant it, I don't like
the way you are doing this but I'm sure you can get this to work. Try
posting some code, so we can see what you have already. Maybe there is
something that is missing. Using the data tool is OK, only for beginners.
The more you start to use this stuff, you will see that the data tools
binded to each page will be harder to maintain.
"Spencer H. Prue" <Sp**********@d iscussions.micr osoft.com> wrote in message
news:E2******** *************** ***********@mic rosoft.com...

My code still says the session state for the two variables I stored on the
other page is equal to null. I set the da2, and ds2 equal to new
Sqldataadapter and new Dataset.The error says "The SelectCommand property
has
not been initialized before calling Fill." Should I import into session
state
the Select, Insert, Update, and Delete commands also? Would it be easier
to
just use the sql wizard and generate the ado statements on both pages?
Thanks.

Spencer

"Tampa.NET Koder" wrote:

Basically,

You just held the variable names in session state not the objects
itselves.
So, to create the objects after you cast each variable reference out you
should do a
da2 = new SqlDataAdapter( );
ds2 = new Dataset():

This should allow you to use these objects.
"Spencer H. Prue" <Sp**********@d iscussions.micr osoft.com> wrote in
message
news:BE******** *************** ***********@mic rosoft.com...
> Hello!,
>
> I have a using system.web.sess ionstate directive one the top of each of
> two
> web pages. On the first page I have the dataadapter, dataconnection,
> and
> dataset (also in the component tray). I have used Session.Add().
>
> Session.Add("da dapter", sqlDataAdapter1 );
> Session.Add("ds et", ds);
>
> On the other page I have used a cast to get at the Session objects that
> I
> supposedly stored on the other page.
>
> SqlDataAdapter da2 =
> (System.Data.Sq lClient.SqlData Adapter)Session["dadapter"]);
>
> Dataset ds2 = (System.Data.Da taSet)Session["dset"]);
>
> My code on the page where I want to use the data from the database(The
> other
> page has the ADO in the component tray) says
>
> Session("dadapt er")=null
> Session("dset") =null
>
> I looked through the MSDN to see if I could get some error messages out
> of
> the session object, but no go. As far as the ASP.NET I get the error
> "object
> reference not set to an instance of an object." What could be wrong?
> --
> Spencer

[Elton Wang]

Hi Spencer,

Before you use SessionState to hold an object, you should
initialize it. Otherwise you only hold a null value in
SessionState. For example, you should do it like following:

SqlDataAdapter sqlDataAdapter1 = New SqlDataAdapter
(sqlQuery, connction);
DataSet ds = new DataSet();
sqlDataAdapter1 .Fill(ds);
Session.Add("da dapter", sqlDataAdapter1 );
Session.Add("ds et", ds);

HTH

Elton Wang
el********@hotm ial.com

-----Original Message-----
Hello!,

I have a using system.web.sess ionstate directive one the top of each of twoweb pages. On the first page I have the dataadapter, dataconnection, anddataset (also in the component tray). I have used Session.Add().
Session.Add("d adapter", sqlDataAdapter1 );
Session.Add("d set", ds);

On the other page I have used a cast to get at the Session objects that Isupposedly stored on the other page.

SqlDataAdapt er da2 =
(System.Data.S qlClient.SqlDat aAdapter)Sessio n ["dadapter"]);
Dataset ds2 = (System.Data.Da taSet)Session["dset"]);

My code on the page where I want to use the data from the database(The otherpage has the ADO in the component tray) says

Session("dadap ter")=null
Session("dset" )=null

I looked through the MSDN to see if I could get some error messages out ofthe session object, but no go. As far as the ASP.NET I get the error "objectreference not set to an instance of an object." What could be wrong?--
Spencer
.

[Spencer H. Prue]

Thanks for the help Elton,

I used the sqldataadapterw izard to generate the statements that were needed
for the ado. I know it's a shortcut, but the wizard said all the statements
were generated correctly. It left a protected
system.data.sql client.sqldataa dapter sqldataadapter1 statement in the wizard
generated code. I just filled the dataset with it, I didn't bother with new.
It appears to be working correctly. I also used it to do an update.

So from what the wizard generated I just added it to the session. Do you
think I should try a new sqldatadapter before the session.add? I am not sure
how to create a connection string and the sql statements. As I said, I think
the wizard did everything for me. Thanks

Spencer
"Elton Wang" wrote:

Hi Spencer,

Before you use SessionState to hold an object, you should
initialize it. Otherwise you only hold a null value in
SessionState. For example, you should do it like following:

SqlDataAdapter sqlDataAdapter1 = New SqlDataAdapter
(sqlQuery, connction);
DataSet ds = new DataSet();
sqlDataAdapter1 .Fill(ds);
Session.Add("da dapter", sqlDataAdapter1 );
Session.Add("ds et", ds);

HTH

Elton Wang
el********@hotm ial.com

-----Original Message-----
Hello!,

I have a using system.web.sess ionstate directive one the

top of each of two

web pages. On the first page I have the dataadapter,

dataconnection, and

dataset (also in the component tray). I have used

Session.Add().

Session.Add("d adapter", sqlDataAdapter1 );
Session.Add("d set", ds);

On the other page I have used a cast to get at the

Session objects that I

supposedly stored on the other page.

SqlDataAdapt er da2 =
(System.Data.S qlClient.SqlDat aAdapter)Sessio n

["dadapter"]);

Dataset ds2 = (System.Data.Da taSet)Session["dset"]);

My code on the page where I want to use the data from the

database(The other

page has the ADO in the component tray) says

Session("dadap ter")=null
Session("dset" )=null

I looked through the MSDN to see if I could get some

error messages out of

the session object, but no go. As far as the ASP.NET I

get the error "object

reference not set to an instance of an object." What

could be wrong?

--
Spencer
.

[Elton Wang]

Hi Spencer,

Apparently in your case, when you add the adapter to
session it is not initialized yet. Since it works
properly, it means you add it to session too early.

In terms of wizard, it is very easy for beginners.
However, if you completely rely on it without
understanding its underlying principles, in a little bit
complicated case you will get lost.

HTH

Elton Wang

-----Original Message-----
Thanks for the help Elton,

I used the sqldataadapterw izard to generate the statements that were neededfor the ado. I know it's a shortcut, but the wizard said all the statementswere generated correctly. It left a protected
system.data.sq lclient.sqldata adapter sqldataadapter1 statement in the wizardgenerated code. I just filled the dataset with it, I didn't bother with new.It appears to be working correctly. I also used it to do an update.
So from what the wizard generated I just added it to the session. Do youthink I should try a new sqldatadapter before the session.add? I am not surehow to create a connection string and the sql statements. As I said, I thinkthe wizard did everything for me. Thanks

Spencer
"Elton Wang" wrote:

Hi Spencer,

Before you use SessionState to hold an object, you should initialize it. Otherwise you only hold a null value in
SessionState. For example, you should do it like following:
SqlDataAdapter sqlDataAdapter1 = New SqlDataAdapter
(sqlQuery, connction);
DataSet ds = new DataSet();
sqlDataAdapter1 .Fill(ds);
Session.Add("da dapter", sqlDataAdapter1 );
Session.Add("ds et", ds);

HTH

Elton Wang
el********@hotm ial.com

>-----Original Message-----
>Hello!,
>
>I have a using system.web.sess ionstate directive one

the top of each of two

>web pages. On the first page I have the dataadapter,

dataconnection, and

>dataset (also in the component tray). I have used

Session.Add().

>
>Session.Add("d adapter", sqlDataAdapter1 );
>Session.Add("d set", ds);
>
>On the other page I have used a cast to get at the

Session objects that I

>supposedly stored on the other page.
>
>SqlDataAdapt er da2 =
>(System.Data.S qlClient.SqlDat aAdapter)Sessio n

["dadapter"]);

>
>Dataset ds2 = (System.Data.Da taSet)Session["dset"]);
>
>My code on the page where I want to use the data from

the database(The other

>page has the ADO in the component tray) says
>
>Session("dadap ter")=null
>Session("dset" )=null
>
>I looked through the MSDN to see if I could get some

error messages out of

>the session object, but no go. As far as the ASP.NET I

get the error "object

>reference not set to an instance of an object." What

could be wrong?

>--
>Spencer
>.
>

.