Re: DataView Timeout Becomes SQLReader Sorting Issue

From: Robir (RGustavirssen_at_nospamWirnbergessen.org)
Date: 03/13/04 

Date: Fri, 12 Mar 2004 17:26:44 -0800

I'm not sure where to begin - but here goes:
<<<so I looked around and found that if I use a SQLReader I can specify a
Timeout value>>>
The ADO.NET SQLCommand object has a timeout value... so you can specify that
even when not retrieving data via a SQLDataReader.

A SQLDataReader is meant only for forward-only read-only activity. If you
want the data coming through a SQLDataReader to be sorted, then it has to be
sorted by SQL Server (i.e., an ORDER BY clause in your query or stored
procedure).

Because a DataReader is forward-only, I doubt it's possible to create a view
on it. I've never seen anyone try it. I could be wrong.

Try retrieving your data into a DataSet or even a free-standing DataTable
and then create the view on that. I believe that's how it was designed to
hang together.

Good Luck

"Alex Davidson" <alexdNOSPAM@synergycsi.com> wrote in message
news:c2tidl$21apgr$1@ID-204064.news.uni-berlin.de...
> I am having issues with a page timing out while using DataView to go to
SQL
> to run a Stored Procedure to populate a DataGrid so I looked around and
> found that if I use a SQLReader I can specify a Timeout value.
>
> Problem now is how to sort the data as desired.
>
> Right now I am using pieced together code to try to iterate through the
> SQLReader data and put it into a DataView so it can be sorted but it
errors:
>
> System.NullReferenceException: Object reference not set to an instance of
an
> object.
>
> on the line "Dim dr As DataRowView = myDV.AddNew" below.
>
> Can someone suggest the correct code, or maybe there's a better way?
>
> Code:
> Dim myDV As DataView
> con = New
> SqlConnection(ConfigurationSettings.AppSettings("GenesisConString"))
> cmd = New SqlCommand("Execute GetInactiveCustomers '" &
> Request.QueryString("Div") & "', '" & varInactiveWhereField & "', '" &
> varInactiveWhereValue & "'", con)
> cmd.CommandTimeout = 120
> con.Open()
> Dim results As SqlDataReader = cmd.ExecuteReader()
> Do While results.Read()
> Dim dr As DataRowView = myDV.AddNew
> dr("InvoiceCustomerID") = results("InvoiceCustomerID")
> dr("InactiveCustName") = results("InactiveCustName")
> dr("InactiveAddress1") = results("InactiveAddress1")
> dr("InactiveAddress2") = results("InactiveAddress2")
> dr("InactiveCity") = results("InactiveCity")
> dr("InactiveState") = results("InactiveState")
> dr("InactiveZip") = results("InactiveZip")
> dr("InactivePhoneNo") = results("InactivePhoneNo")
> dr("InactiveLastInvoiceDate") = results("InactiveLastInvoiceDate")
> dr("InactiveRepName") = results("InactiveRepName")
> dr("GP") = results("GP")
> dr.EndEdit()
> Loop
> con.Close()
> results.Close()
> myDV.Sort = varInactiveSort
> InactiveCustomersDataGrid.DataSource = myDV
> InactiveCustomersDataGrid.DataBind()
>
>
> Thanks,
> Alex
>
>

Relevant Pages

  • Re: Advantech ADAM-6018 Communication With LabView
    ... bytes and reports a timeout error. ... Buffered?Waits until all bytes you specify ... This technique is the most flexible, ...
    (comp.lang.labview)
  • Re: Start and end time of a job
    ... How do I specify a starting time AND and an ending time? ... As another recourse, a "timeout" adverbial function, script, ... typeset sleep_pid=$! ...
    (comp.unix.shell)
  • Re: DataView Timeout Becomes SQLReader Sorting Issue
    ... > The ADO.NET SQLCommand object has a timeout value... ... >> I am having issues with a page timing out while using DataView to go to ... >> found that if I use a SQLReader I can specify a Timeout value. ...
    (microsoft.public.dotnet.framework.aspnet)
  • [CFR] Specify the lock(1) timeout unit
    ... .Op Fl t Ar timeout ... +Specify the time measurement unit for the time limit. ... Disable switching virtual terminals while this terminal is locked. ...
    (freebsd-hackers)
Loading