Patrick:
Return command.ExecuteReader(CommandBehavior.CloseConnect ion)
closes the connection after ExecuteReader() is called and thus closing the
datareader (the datareader is tied to the connection). You must either keep
the connection open and close it and the reader when you are done with it,
or make use of a dataset.
Personally I'd recommend you use the DataSet because then you end up with a
situation where 1 function (GetReader()) creates your connnection and opens
it, whereas calling function is responsible for cleaning up that
resource...definetly messy....Another solution would be to pass the
connection in as a parameter to GetReader() but I'd still favour DataSets
over this...
Karl
--
MY ASP.Net tutorials
http://www.openmymind.net/index.aspx - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"Patrick Olurotimi Ige" <ige@iprimus.com.au> wrote in message
news:OzrB6FtHFHA.4048@TK2MSFTNGP15.phx.gbl...[color=blue]
> Why do i get "Invalid attempt to FieldCount when reader is closed"
>
> Is the problem the way the datareader reads data as
> opposed to a dataset?
>
> When trying to compile this code:-
>
> Dim reader As IDataReader = GetReader()
>
> Dim chart As New LineChart()
> chart.DataXValueField = "Product"
> chart.DataYValueField = "Price"
> chart.DataSource = reader
> chart.DataBind()
> reader.Close()
> ChartControl1.Charts.Add(chart)
>
> Dim chart1 As New LineChart()
> chart1.DataSource = reader
> chart1.DataXValueField = "Product2"
> chart1.DataYValueField = "Price2"
> Getting the error here---> chart1.DataBind()
> ChartControl1.Charts.Add(chart1)
>
> reader.Close()
> ChartControl1.RedrawChart()
>
> With the function:-
> Function GetReader() As IDataReader
>
> Dim connection As new OleDbConnection("")
>
> Dim command As new OleDbCommand("SELECT Top 10 [ProductName] As
> Product,[UnitPrice] As Price, [UnitsInStock] As Stock FROM Products
> order by UnitPrice desc", connection)
> connection.Open()
>
> Return command.ExecuteReader(CommandBehavior.CloseConnect ion)
>
> End Function
>
>
> *** Sent via Developersdex
http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it![/color]
