.NETGURU
  Search:  
NamespacesDiscussions.NET v1.1Dot Net Guru's BlogIT Certification
DB2 managed provider problems during a FILL
Messages   Related Types
This message was discovered on microsoft.public.dotnet.framework.adonet.
Responses highlighted in red are from those people who are likely to be able to contribute good, authoratitive information to this discussion. They include Microsoft employees, MVP's and others who IMHO contribute well to these kinds of discussions.
Post a new message to this list...

bill yeager (VIP)
I'm having a problem trying to fill a dataset with the managed DB2 provider.
My Fill command executes with no exception, but when I try to query the
number of rows returned back in the dataset inside the immediate window
during debugging, I get the following:

?ds.Tables(0).Rows.Count
'ds.Tables' is not declared or the module containing it is not loaded in the
debugging session.

Before my Fill statement executes, I do the same command above in the
immediate window and get 0 rows, which is what I expect. The problem occurs
after the Fill statement (which btw, doesn't produce an exception).

Here is my code:
<code>
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load

Try
Dim ds As New DataSet
db2DataAdapter1.SelectCommand.Parameters.Item(0).Value = "000010"
db2DataAdapter1.Fill(ds)
Catch ex As Exception

End Try
</code>

I have no where else to turn for this. What could possibly be the problem???
Reply to this message...
 
    
Frans Bouma [C# MVP] (VIP)
bill yeager wrote:

[Original message clipped]

    Is the managed provider already released? I thought it was still beta...

[Original message clipped]

    are you sure? your code below simply swallows an exception thrown so you'll
never see it.

[Original message clipped]


--
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET Blog: http://weblogs.asp.net/fbouma
Microsoft C# MVP
Reply to this message...
 
    
bill yeager (VIP)
I simply had the "Dim ds As New DataSet" inside the try block, for which, I
obviously could not get the value of the dataset.

I moved it outside the try block, and it worked fine.

I should have seen that one.

"Frans Bouma [C# MVP]" wrote:

[Original message clipped]
Reply to this message...
 
 
System.Data.DataSet
System.EventArgs
System.Object




ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
Ad


Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews
.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT
Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project
FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.
Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials
 
ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
 Copyright © ExamGuru, Inc. 2001-2006
Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification