help i have an error in vb.net (1 Viewer)

[dastonecutters]

hi all im doing a web page for my major this year and im having problems with some code... the error is

Object reference not set to an instance of an object.

what is this and how do i fix it please help

 

[sunny]

You tried to use an object (variable) before you created it. Please post up a section of your code related to this error.

 

[dastonecutters]

u see this part is in a public sub inside a public sub...


Public Sub RetrieveInfoFromDB()
Dim strSQL As String
Dim dbC As dbConnection
Dim ds As DataSet

strSQL = String.Format("SELECT access.ID, Access.LastName, Access.FirstName, Access.PhoneNum, access.access FROM Access")

ds = dbC.RecordSet(strSQL)

DataGrid1.DataSource = ds.Tables(0).DefaultView
DataGrid1.DataBind()
dbC.Close()
dbC = Nothing
End Sub

 

[Winston]

is DataGrid1 defined elsewhere?

 

[dastonecutters]

yeh datagrid1 is an actual object but the error is on

ds = dbC.RecordSet(strSQL)

 

[Winston]

Originally posted by dastonecutters
yeh datagrid1 is an actual object but the error is on

ds = dbC.RecordSet(strSQL)

are you sure RecordSet method will return a DataSet object?

 

[dastonecutters]

it works when it isnt in a class and stuff i might jus leave it for my teacher cause he is the one who put it in a class