Simple Data Access in a windows form - walkthrough problem

K

KnooKie

New member
Joined
Feb 1, 2005
Messages
2
Location
UK
i am just starting out learning .NET and have just gone through that particular walkthrough found inm the help files. using VB.NET. Everything appears to be correct but on clicking the load button i get the following error and have no idea why ?

An unhandled exception of type System.Data.OleDb.OleDbException occurred in system.data.dll


it highlights this line (copied from the walkthrough) when the error occurs.....

OleDbDataAdapter1.Fill(DsAuthors1)



The oledbdataadapter can happily SELECT the data from SQL Server.

any ideas ?
 
worked it out..........

the walkthrough suggested using SQL Server and an oledbdataadapter because it was more generic.

As soon as i removed the oledbdataadapter and instead used a sqldataadapter (more SQL Server specific) everything was fine.
 
Back
Top