Setting Database Connections in many Pages in a webproject

[Flovit]

I want to use table1 in page1 and table2 in page2 of a database in one website .

when I add table2 to page2 my page1 connection lost .

 

please help me .

[PlausiblyDamp]

Any chance you could post a bit of your code to give us some idea of how you are attempting this?

Are you creating and opening a connection on every page? Are you refreshing the dataset on page_loads or storing it in a session variable between page refreshes?

 

the following may be worth a look as well

http://www.xtremedotnettalk.com/showthread.php?t=75209

http://www.xtremedotnettalk.com/showthread.php?t=75076

[Flovit]

I dont know the right way for doing this ,

but what I tried is code something like this :

 

in page1

 

 

this.dbCon = new System.Data.OleDb.OleDbConnection() ;

this.adb1 = new System.Data.OleDb.OleDbDataAdapter();

this.ds1 = new ShipProject.dataset1();

this.dbCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +

Server.MapPath("~/database/data.mdb") ;

 

in page2 I cant access to dbCon so I create another one like page1's connection .

but the problem apeared :

my first dbConnection lost .

What I must to do for it ,

Thanks

[pelikan]

ADO .NET uses a disconnected dataset model - you should load both your tables into

one dataset using one connection - the connection is then released - now use your tables.