Quick dating
Custom Menu
  • ct dating restrictions
  • Adult horny chat games
  • NEWS
    If you like a boy or a girl then simply say hi or hello and as soon as he/she cross the limit do not wait to say bye!!! Join our Arab chat room and English chat room as well.


    Dataadapter rowupdating

    the only "hitch" comes on one of the more complex queries (query needs to poll five different tables, and decide based on some SQL functions which data to include/exclude - clearly not the most efficient query I've every written, but given the needs of the application it is really the only way to grab what is needed and prevent the user from seeing some information that should remain confidential - because what needs to remain confidential changes dynamically, there is no other way than the complex query to get it...

    but I digress) the query normally takes about 25 to 30 seconds to run, and when I rewrote the query to give me a count of the records the "count" query still takes about 10-15 seconds to run...

    Of course, it would add to the amount of data being transferred and slow it down a bit :-( Or even use a stored procedure to select into a temporary table then return the count of records in that table and finally return the records.

    Andrew You have already answered your own question.

    I have experimented with the dataadapter rowupdating event, but even if I can get that working (and so far I can't) it will only tell me how many rows it's already done, not how many it has to go... NET Application Architect, Enthusiast, & Evangelist T. Bradley - Hi, I'm something of a noob at this, but here it is... Harlow" V, As Stephany suggests, you unfortunately don't know how many rows until your done. like: Protected Overrides Sub On Load(By Val e As Event Args) My Base. I have experimented with the dataadapter rowupdatingevent, but even if I can get that working (and so far I can't) it willonly tell me how many rows it's already done, not how many it has togo...

    I thought about running two queries on the database (one to count the number of records I should expect and one to return the records) but, really, there's got to be a better way. Value = 1 End Sub NOTE: You need to set Progress Bar1. I have an app that fills a dataset from a SQL database, and then writes the dataset to an xml file. I am basically just replicating data to the local user's machine, and several of the queries take a long time to run over VPN connection to the database (the way most of my users will use it), so I sank the whole operation into a Background Worker so that the user's app wont freeze up while it is running. NET Application Architect, Enthusiast, & Evangelist T. What I will do is use a "typical" number for max rows on the progress. I thought about running two queries on the database (one tocount the number of records I should expect and one to return therecords) but, really, there's got to be a better way.

    I have an app that fills a dataset from a SQL database, and then writes the dataset to an xml file. I am basically just replicating data to the local user's machine, and several of the queries take a long time to run over VPN connection to the database (the way most of my users will use it), so I sank the whole operation into a Background Worker so that the user's app wont freeze up while it is running. Value = 1 End Sub NOTE: You need to set Progress Bar1. I have an appthat fills a dataset from a SQL database, and then writes the datasetto an xml file. I am basically justreplicating data to the local user's machine, and several of thequeries take a long time to run over VPN connection to the database(the way most of my users will use it), so I sank the whole operationinto a Background Worker so that the user's app wont freeze up while itis running.

    I would love to use the backgroundworker progresschanged event to control a progress bar and show the user how much longer the background operation is going to take, but I can't seem to figure out how to make that happen... Max Value End Sub Private Sub Timer1_Tick(By Val sender As System. Maximum value to a sufficiently high value to ensure you don't exceed it when you set Progress Bar1. I would love to use the backgroundworker progresschanged event tocontrol a progress bar and show the user how much longer the backgroundoperation is going to take, but I can't seem to figure out how to makethat happen...

    Has anyone out here had any success in developing a solution that returns progress indication on filling a dataset from a SELECT query that they can post? If the query is simple and efficient theoverhead will be negible but if it is complex and/or inefficient then theoverhead could be considerable.

    If the select statement was of the form SELECT COUNT(*), [other stuff], would SQL Server be efficient enough to only do the count once?

    Then could that value be retrieved from the dataset before the dataset is filled?

    You MUST know what the target is before you can compare anything tothe target.

    The dataadapter has no knowledge of how may rows it is going to'import' until it has finished.

    Leave a Reply


    Pages: [1] 2 3 4 5 6 | Next | Last


    




    Copyright © 2017 - schoolvoshod.ru