MS Access database not up to date? (VS Web Developer Studio)

Bilel

New Member
I'm taking a class in C# web dev and I'm currently trying to display data from a \[code\].mdb\[/code\] (Microsoft Access) database. I have two pages that both want to show a table stored in the database in a grid view. One page's form uses function that connects the the db and then writes to the table to the grid. it connects with this call:\[code\]sqlConn = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Database);sqlDA = new OleDbDataAdapter("select * from tblPersonnel where LastName = '"+strSearch+"'", sqlConn);//Initialize a new activity DS = new dsPersonnel();//Add rows to the dataset from the data sourcesqlDA.Fill(DS.tblPersonnel);\[/code\]The database is called \[code\]PayrollSystem_DB.mdb\[/code\]. In the other page I placed a \[code\]SqlDataSource\[/code\] control on the page and connected it to \[code\]PayrollSystem_DB.mdb\[/code\]. Then set this to the \[code\]gridView\[/code\]. However when running, the the first page shows a long table with data I've entered since last week. and the 2nd page shows only data from the first day I tested it. Looking at the db in the vs explorer the tables are identical to teh second page. So I'm wondering were all the other data is being stored that the first page is showing? Am I unknowingly using a database I can't see in the solution?
 
Top