Object reference not set...

[Amy Snyder]

I have the following sub that is called to load a data grid. It works
without a problem until I uncomment the dv.sort line. When I uncomment
the line I get the error: Object reference not set to an instance of an
object. The error is pointing to that line. What am I doing wrong?

Public Sub LoadGrid()
Dim ds As New Data.DataSet
Dim dv As New Data.DataView
Dim strSQL As String

strSQL ="my sql statement"

ds = DataHandler.GetDataSet(strSQL,
ConfigurationSettings.AppSettings("DataSourceConne ctionString"))
dv = CType(ds, DataSet).Tables(0).DefaultView

HandleSort(SortExpression)
'dv.Sort = Session("Sort").ToString & " " &
Session("SortDirection").ToString

dg.DataSource = dv
dg.DataBind()
lblLegend.Visible = True

End Sub


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[George Durzi]

Are those two session variable not null?

"Amy Snyder" <am**@yahoo.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

I have the following sub that is called to load a data grid. It works
without a problem until I uncomment the dv.sort line. When I uncomment
the line I get the error: Object reference not set to an instance of an
object. The error is pointing to that line. What am I doing wrong?

Public Sub LoadGrid()
Dim ds As New Data.DataSet
Dim dv As New Data.DataView
Dim strSQL As String

strSQL ="my sql statement"

ds = DataHandler.GetDataSet(strSQL,
ConfigurationSettings.AppSettings("DataSourceConne ctionString"))
dv = CType(ds, DataSet).Tables(0).DefaultView

HandleSort(SortExpression)
'dv.Sort = Session("Sort").ToString & " " &
Session("SortDirection").ToString

dg.DataSource = dv
dg.DataBind()
lblLegend.Visible = True

End Sub


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[David Coe, MCP]

Amy -

You need to do a nothing (null) check on those before you can use them to make sure they are not null.

For instance:

If Not IsNothing(Session("Sort")) then
' this one is okay
else
' take some measures
end if

If Not IsNothing(Session("SortDirection"))
' this one is also okay
else
' take some measures
end if

Now they should be good to go.