In one just case I'm getting this message:
System.ArgumentOutOfRangeException - Index was out of range. Must be non-negative and less than the size of the collection.
Happens in only one instance, works fine for all other tables/queries. I read something about a bug in MSDN but not sure how I can work around it. Happens even when the record count returned is just 1 (not several records that don't fit into one page). The DataBind() throws the exception.
Dim oa As OracleDataAdapter = New OracleDataAdapter (sel, conn)
Dim ds As New DataSet()
oa.Fill (ds, "res")
recCnt = ds.Tables("res").Rows.Count.ToString()
DataGridResults.DataSource = ds
DataGridResults.DataBind()
Any help is greatly appreciated, thanks!
System.ArgumentOutOfRangeException - Index was out of range. Must be non-negative and less than the size of the collection.
Happens in only one instance, works fine for all other tables/queries. I read something about a bug in MSDN but not sure how I can work around it. Happens even when the record count returned is just 1 (not several records that don't fit into one page). The DataBind() throws the exception.
Dim oa As OracleDataAdapter = New OracleDataAdapter (sel, conn)
Dim ds As New DataSet()
oa.Fill (ds, "res")
recCnt = ds.Tables("res").Rows.Count.ToString()
DataGridResults.DataSource = ds
DataGridResults.DataBind()
Any help is greatly appreciated, thanks!