>>>
>>>Instead of oReader.Read() can you get the number of records? Also, I forgot a little how we assign result of the reader to GridView. It is not easy, as I recall. If you would fill a DataSet, it will be a different story.
>>
>>There are over 4K records returned. How would you do it with a dataset? This doesn't work either.
>>

>>Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
>>
>>		Dim SQL As String
>>		SQL = "SELECT * INTO #TempConstraint FROM [ApprovedFunding]"
>>		Dim oConn As New SqlConnection(ConfigurationManager.ConnectionStrings("TIPConnectionString").ConnectionString)
>>		Dim oCommand As New SqlCommand(SQL, oConn)
>>
>>		oConn.Open()
>>		oCommand.ExecuteNonQuery()
>>		oCommand.CommandText = "SELECT * FROM #TempConstraint"
>>
>>		Dim oDataAdapter As New SqlDataAdapter
>>		Dim ds As New DataSet
>>
>>		oDataAdapter.SelectCommand = oCommand
>>		oDataAdapter.Fill(ds)
>>		GridView1.DataSource = ds
>>
>>	End Sub

>
>Add a call to GridView1.DataBind() as last line.

Got it!
Thanks