Dataset error

[cpopham]

The error that I am getting is: Value cannot be null. This is using an Access DB

 

My connection works fine.

 

Here is the code

Public Function GetPersonnel() as Dataview

Dim dv as DataView

Dim da as Oledbdataadapter

Dim ds as dataset

Dim strSQL as as string = "SELECT tblPersonel.KeyPersonel AS Key, " & _

"tblPersonel.LastName & ', ' & tblPersonel.FirstName AS Contact " & _

"FROM tblPersonel

Dim cn OledbConnection

cn = Me.ConnectLogIn

da = New OledbDataadapter(strSQL, cn)

da.Fill(ds) <-------------------This is the line throwing the error

 

Any ideas?

 

Thanks, Chester

[Robby]

Are these typos or this is the way your code looks, if the latter I'm surprised it even compiles...

 

it should be (and by the way, you don't need to prefix with the table name when there's only a single table in your query)

 

Also, 'key' is a keyword in SQL server, I'm not sure about Access

 

Dim strSQL as as string ="SELECT KeyPersonel AS myKey, (LastName & ', ' & FirstName) AS Contact FROM tblPersonel "

[cpopham]

Thanks, for the help... I had to change a couple of other things to make it work. I usually prefix with a table to make my code easier to follow.

 

Chester

[pelikan]

Also note - ds is uninitialized ie Null object reference.