[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.inetserver.asp.db

torelyonothers usedefficiently

Allemydwene

12/28/2013 8:34:00 AM

The IOC has announced a new supply agreement that will see Nike supply uniforms and products to International Olympic Committee members and staff.The agreement will begin in January 2013 and runs until the end of 2016. Uniform and products will be provided to the IOC for the Olympic Games in Sochi in 2014, Rio in 2016, the Youth Olympic Games in Nanjing in 2014 and Lillehammer in 2016, as well as for IOC Sessions, Evaluation Commissions and other events as required.Timo Lumme, Managing Director, IOC Television and Marketing, said "We are delighted that we have reached this agreement with Nike, the world's leading sports and fitness company, and we feel that this relationship will be a great fit for the IOC.""We're honoured to be working with the IOC and we look forward to this being the start of a long and successful relationship", commented Nike Brand President Charlie Denson.Nike supplied competition apparel to more than 100 national federations at the London 2012 Olympic Games, along with footwear to thousands of individual athletes. The company is also the official NOC sponsor for the USA, Brazil, Kenya and Estonia. The Nike Swoosh also adorned the competition and ceremony clothing and footwear for the four Independent Olympic Athletes who competed under the IOC flag in London.Nike Total 90 Aerow II Professional Football Fifa Aprvd en fait, ce n'est ni plus ni moins qu'une complémentaire assurance (identicar) Tu vois cette carte, dit la femme, bon, ben je veux que dans ces pays là, les gens arrêtent de se taper dessus à tout bout de champ. <a href=http://www.siouxfallschamber.com/burberryoutlet.cfm&g... Outlet Store</a> L'accueil de Mr Prost est exemplaire aussi bien au téléphone que dans la réalité. L'appartement est charmant et pourvu de tous les équipements mentionnés. C'est très clair, joliment décoré et fonctionnel.en choisissant soigneusement le sac à main Mulberry droit Devant l travail de modération que ceci demandait et le peu de respect des règles de publication, je viens donc de décider de fermer cette rubrique.note de service Les commentaires sur Presse Voil? les media sont actuellement sans impunit?sur ce sujet, et influence l'inconscient collectif. Ils disent "faut il avoir peur des Chinois?"= incitation ?la haine raciste. Ils disent "les Chinois sont riches et sont des patrons"= prug raciste complement faux, quand on sait que 80% des Chinois sont des paysans gagnant ?peine de quoi vivre, et des ouvriers sur exploit. Ils utilisent des racourcis pour attirer l'audimat. <a href=http://www.voyagesschmitt.fr/doudouner.c... Air Max</a> Pour le transfet de dossier c'est le lycé d'accueil qui se chargera de contacté ton ancien lycé. Partie 1 S'organiser Les cuisines collectivesa change pas le monde, mais. ça aide. Yet somehow sneaker heads are not wired that way. Read me on Twitter also be sure to verification out and like i would say the Examiner Kicks Facebook piece and subscribe to all of our Youtube channel which must be full of updates and commentary you won't meet here. Jabbar was your own basketball phenom and the mans famed "Sky hook" was his / her unblockable signature shot that experts claim kept finding the string for 1560 NBA online. <a href=http://www.voyagesschmitt.fr/doudouner.c... Pas Cher</a> La mise de cette cousine eût, au besoin, expliqué ce sans gêne. Mais je sens que ça va mieux, le bébé gigote moins, il est plus reposé, et moi aussi, j'ai arreté le café, et quand je sens les vertiges, je dors. > Le prix ? si ce sont des ventes d\'occasion cela peux s\'expliquer pour des gens qui n\'en ont plus besoin, qui veulent changer de mod ou qui ont besoin d\'argent <a href=http://www.opportunitysf.com/burberrysale.cfm&g... Outlet Online</a> Vivement que je me tire dans un pays où le manga est à 3 euros et le livre standard à 10 euros. This is being achieved by collaborative efforts involving researchers with very different interests CIM faculty and students come from the School of Computer Science, Department of Electrical and Computer Engineering, and the Department of Mechanical Engineering. Ce casque est à 180/200, je l acheté 150 sur le net, aujourd on le trouve facilement en dessous. C le prix à mettre dans un bon casque, surtout qu ne le change pas tous les ans, le rapport qualité/prix est vraiment correct. <a href=http://www.voyagesschmitt.fr/doudouner.c... Air Max 90</a> Muni de l'étiquette qui lui sera remise en même temps que son dossard, chaque coureur se verra offrir la possibilité de déposer un sac à dos qu'il récupèrera à la fin de la course sur présentation de son dossard. 69 contacts BISTOURI A TOUT FAIRE <a href=http://www.siouxfalls.com/moncleroutlet.cfm>www.siouxfalls.com/moncleroutlet.cfm... Ils leur ont dit : Vous n pas mourir parce que vous allez mettre un morceau de chiffon sur votre tête Notre combat principal est contre l américain et il faut rester ensemble derrière Khomeiny contre cet impérialisme américain . Les femmes ont répondu Nous n pas fait la révolution pour retourner en arrière (le slogan des manifestantes). Pourtant, leurs luttes ont été réprimées et brisées par tous les moyens. Elles ont perdu. Et elles ont perdu tout ce qu avaient obtenu : la dignité. En 1986, j'avais déjà essayé de faire ce film, se souvient le réalisateur. Mais, à l'époque, nous n'avions pas réussi à réunir assez d'argent pour financer l'adaptation du livre de Louo Kouan Tchong, considéré chez moi comme l'Iliade chinoise. Hongkong était incapable de faire ce type de film à grand spectacle. J'ai donc abandonné l'idée pour un moment . Selon son communiqué, la force de l'ONU a donné aux rebelles du M23 jusqu'à jeudi 16H00 (20H00 GMT) pour aller "remettre leurs armes à la base de la Monusco" et rejoindre un programme de démobilisation. <a href=http://www.forwardsiouxfalls.com/spydersoutlet.cfm... Jackets Sale</a> La guerre anti islamiste de plus de dix ans (à partir des années 1990) a changé la donne. Depuis, la société civile et nombre de partis d'opposition dénoncent ce qu'ils appellent "l'islamisation rampante" de l'Algérie, accentuée avec le Printemps arabe qui a vu l'arrivée au pouvoir d'islamistes dans plusieurs pays. Je comprends les personnes qui ne sont pas à l'aise envers les enfants différents. C'est sur que ça demande plus de temps et c'est pas tout le monde qui est prêt à ça. Moi j'ai la chance de savoir ce que c'est et cela ne me fait pas peur. J'étudie même pour devenir enseignante pour les jeunes ayant une déficience intellectuelle et ça me fascine réellement! D'après les premiers éléments de l'enquête, ils semblent avoir été victimes de coups portés à l'arme blanche. Les gendarmes ont relevé "une scène de crime très violente". Des dizaines de coups de couteau et de machetteont été portés à l'homme. Ce dernier présente également plusieurs blessures de défenses aux main. L'autopsie de son épouse doit avoir lieu lundi après midi. Selon le Midi Libre, les deux corps portaient de nombreuses traces de mutilation. <a href=http://www.voyagesschmitt.fr/doudouner.c... Air Max 95</a> Dans le Grand Stade Lille Métropole, le LOSC est en quête d'exploit ce soir face au Bayern Munich. Suivez le match minute par minute en cliquant sur le lien ci dessous: Lost (Perdu) Alors oui le rugby ce n pas que le jeu d et la défense joue un role primordiale. Mais heuresement que dans ce blog comme dans les commentaires de Monsieur Villepreux on parle du jeu, des initiatives, des essaies, du panach <a href=http://www.siouxfallschamber.com/burberryoutlet.cfm&g... Bags</a> a alors ! On dirait toi sur Comlive, la même fougue, le même allant ! Quand BB commmence gigotter, sac de couchage. Pour viter qu'il ne se dcouvre. Tarantino fait la danse de "Pulp Fiction" en recevant le prix Lumière 2013le 19 oct. à 15h25Le cinéaste américain Quentin Tarantino a reçu vendredi soir à Lyon le prix Lumière 2013 des mains de son actrice fétiche Uma Thurman et devant "sa famille" au cours d'une soirée placée sous le signe de l'humour mais aussi de l'émotion. <a href=http://www.siouxempirefarmshow.org/KarenMillen.cf... Millen Outlet</a> M. Duhamel arr le match temporairement! is not surprising. Presently, Part of the production version is produced in imitation of Guangzhou and Fujian, Guangzhou, produced good quality. Price naturally full of tricks, the price can be up to several hundred dollars difference. Some cheap snow boots, but also play tricks on the internal material. Only in the upper position Mais quand il pose ses doigts contre ma nuque, ce simple contact sur ma peau me donne la chair de poule. Jamais une personne ne m'avait fait un tel effet. Je réagis à ses mains comme à une réaction chimique.ça donne un résultat bizarre. Aaaah je repense encore à cette sensation lorsqu'il me touche, et tous mes poils se dressent, à l'affut. Est ce qu'il ressent la même chose? Si seulement.
4 Answers

Jim Rand

11/7/2007 2:36:00 PM

0

Did putting this code in prior to the data binding help?
this.Application.ScreenUpdating = false;





"CerfurMark" <CerfurMark@discussions.microsoft.com> wrote in message
news:120588A0-A7D3-4FF7-BF28-FE3C6598B830@microsoft.com...
> Yes, you are correct, it is not an ADO.NET problem. ADO.NET gets the 61K
> records almost instantly. The bottleneck occurs in the binding of the
> dataset to the ListObject control in Excel. I will try posting this in
> another discussion group.
> Thank you.
>
> "Miha Markic" wrote:
>
>> Hi,
>>
>> I don't think this is ado.net related problem. You should do some
>> performance measuring, perhaps using a performance profiler to find the
>> origin of the bottle neck.
>>
>> --
>> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
>> RightHand .NET consulting & development www.rthand.com
>> Blog: http://cs.rthand.com/blogs/blog_with_...
>>
>> "CerfurMark" <CerfurMark@discussions.microsoft.com> wrote in message
>> news:B8BD6529-5C23-46F7-AA63-62AF9A224AC1@microsoft.com...
>> > If I use Excel to open an Excel file with 61K records, they appear
>> > instantly.
>> > If I fill an ADO.NET recordset in Visual Basic with 61K records, it
>> > fills
>> > almost immediately. But if I bind the dataset to a ListObject in Excel
>> > in
>> > VSTO, then populating the workshseet takes 20 minutes. I can use a
>> > For...Next loop to read the dataset and fill each row of the worksheet,
>> > but
>> > that takes a couple of minutes. What is the way to instantly fill an
>> > Excel
>> > spreadsheet with a dataset from SQL Server?
>>
>>


CerfurMark

11/7/2007 4:58:00 PM

0

When I call the myTableAdapter.Fill() operation, a blue rectangle appears
around all of the cells that were bound to the ListObject, but nothing else
is happening to the screen during the loading of the data. So when I tried
your suggestion, all that happened is that the blue rectangle didn't appear.
No performance improvement. The way I know that ADO.NET is fast is because I
tried the myTableAdapter.Fill() operation without being bound to the cells
and it executed in a second or two. I tried loading 2500 records and it
takes about 20 seconds with the bound ListObject for the data to appear. Why
can ADO.NET query 61K records instantly, but it takes 10 minutes to get them
into the Excel cells?

I'm using VB in VSTO, not VBA, so the syntax for me is
Globals.ThisWorkbook.Application.ScreenUpdating = false.


"Jim Rand" wrote:

> Did putting this code in prior to the data binding help?
> this.Application.ScreenUpdating = false;
>
>
>
>
>
> "CerfurMark" <CerfurMark@discussions.microsoft.com> wrote in message
> news:120588A0-A7D3-4FF7-BF28-FE3C6598B830@microsoft.com...
> > Yes, you are correct, it is not an ADO.NET problem. ADO.NET gets the 61K
> > records almost instantly. The bottleneck occurs in the binding of the
> > dataset to the ListObject control in Excel. I will try posting this in
> > another discussion group.
> > Thank you.
> >
> > "Miha Markic" wrote:
> >
> >> Hi,
> >>
> >> I don't think this is ado.net related problem. You should do some
> >> performance measuring, perhaps using a performance profiler to find the
> >> origin of the bottle neck.
> >>
> >> --
> >> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
> >> RightHand .NET consulting & development www.rthand.com
> >> Blog: http://cs.rthand.com/blogs/blog_with_...
> >>
> >> "CerfurMark" <CerfurMark@discussions.microsoft.com> wrote in message
> >> news:B8BD6529-5C23-46F7-AA63-62AF9A224AC1@microsoft.com...
> >> > If I use Excel to open an Excel file with 61K records, they appear
> >> > instantly.
> >> > If I fill an ADO.NET recordset in Visual Basic with 61K records, it
> >> > fills
> >> > almost immediately. But if I bind the dataset to a ListObject in Excel
> >> > in
> >> > VSTO, then populating the workshseet takes 20 minutes. I can use a
> >> > For...Next loop to read the dataset and fill each row of the worksheet,
> >> > but
> >> > that takes a couple of minutes. What is the way to instantly fill an
> >> > Excel
> >> > spreadsheet with a dataset from SQL Server?
> >>
> >>
>
>
>

Jim Rand

11/7/2007 6:26:00 PM

0

I'm just starting with VSTO. One concern that I have, other than deployment
issues, is the cost of interop calls between managed and unmanaged code.
Because of this concern, right from the get-go, I'll be limiting VSTO
programming to just those things that are unique to .NET such as obtaining
data via web services. The rest of the programming is going to be done
using straight VBA in the Excel unmanaged space.

An interesting experiment for you would be to write the data in csv format
to a file like "data.csv". Then, from within Excel, open "data.csv" as just
another worksheet.


"CerfurMark" <CerfurMark@discussions.microsoft.com> wrote in message
news:83AE0EB8-6C84-4A88-8D22-CD096E93CF1F@microsoft.com...
> When I call the myTableAdapter.Fill() operation, a blue rectangle appears
> around all of the cells that were bound to the ListObject, but nothing
> else
> is happening to the screen during the loading of the data. So when I
> tried
> your suggestion, all that happened is that the blue rectangle didn't
> appear.
> No performance improvement. The way I know that ADO.NET is fast is
> because I
> tried the myTableAdapter.Fill() operation without being bound to the cells
> and it executed in a second or two. I tried loading 2500 records and it
> takes about 20 seconds with the bound ListObject for the data to appear.
> Why
> can ADO.NET query 61K records instantly, but it takes 10 minutes to get
> them
> into the Excel cells?
>
> I'm using VB in VSTO, not VBA, so the syntax for me is
> Globals.ThisWorkbook.Application.ScreenUpdating = false.
>
>
> "Jim Rand" wrote:
>
>> Did putting this code in prior to the data binding help?
>> this.Application.ScreenUpdating = false;
>>
>>
>>
>>
>>
>> "CerfurMark" <CerfurMark@discussions.microsoft.com> wrote in message
>> news:120588A0-A7D3-4FF7-BF28-FE3C6598B830@microsoft.com...
>> > Yes, you are correct, it is not an ADO.NET problem. ADO.NET gets the
>> > 61K
>> > records almost instantly. The bottleneck occurs in the binding of the
>> > dataset to the ListObject control in Excel. I will try posting this in
>> > another discussion group.
>> > Thank you.
>> >
>> > "Miha Markic" wrote:
>> >
>> >> Hi,
>> >>
>> >> I don't think this is ado.net related problem. You should do some
>> >> performance measuring, perhaps using a performance profiler to find
>> >> the
>> >> origin of the bottle neck.
>> >>
>> >> --
>> >> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
>> >> RightHand .NET consulting & development www.rthand.com
>> >> Blog: http://cs.rthand.com/blogs/blog_with_...
>> >>
>> >> "CerfurMark" <CerfurMark@discussions.microsoft.com> wrote in message
>> >> news:B8BD6529-5C23-46F7-AA63-62AF9A224AC1@microsoft.com...
>> >> > If I use Excel to open an Excel file with 61K records, they appear
>> >> > instantly.
>> >> > If I fill an ADO.NET recordset in Visual Basic with 61K records, it
>> >> > fills
>> >> > almost immediately. But if I bind the dataset to a ListObject in
>> >> > Excel
>> >> > in
>> >> > VSTO, then populating the workshseet takes 20 minutes. I can use a
>> >> > For...Next loop to read the dataset and fill each row of the
>> >> > worksheet,
>> >> > but
>> >> > that takes a couple of minutes. What is the way to instantly fill
>> >> > an
>> >> > Excel
>> >> > spreadsheet with a dataset from SQL Server?
>> >>
>> >>
>>
>>
>>


Tom Garth

11/15/2007 11:06:00 PM

0

Whether it's ADO.NET or ADO in the VBA, copying an array to the worksheet has
been the quickest I have worked with.

There are lots of other options though. Great link here, with additional
links at the bottom.

http://support.microsoft.com/default.aspx...

--
Tom Garth


"CerfurMark" wrote:

> When I call the myTableAdapter.Fill() operation, a blue rectangle appears
> around all of the cells that were bound to the ListObject, but nothing else
> is happening to the screen during the loading of the data. So when I tried
> your suggestion, all that happened is that the blue rectangle didn't appear.
> No performance improvement. The way I know that ADO.NET is fast is because I
> tried the myTableAdapter.Fill() operation without being bound to the cells
> and it executed in a second or two. I tried loading 2500 records and it
> takes about 20 seconds with the bound ListObject for the data to appear. Why
> can ADO.NET query 61K records instantly, but it takes 10 minutes to get them
> into the Excel cells?
>
> I'm using VB in VSTO, not VBA, so the syntax for me is
> Globals.ThisWorkbook.Application.ScreenUpdating = false.
>
>
> "Jim Rand" wrote:
>
> > Did putting this code in prior to the data binding help?
> > this.Application.ScreenUpdating = false;
> >
> >
> >
> >
> >
> > "CerfurMark" <CerfurMark@discussions.microsoft.com> wrote in message
> > news:120588A0-A7D3-4FF7-BF28-FE3C6598B830@microsoft.com...
> > > Yes, you are correct, it is not an ADO.NET problem. ADO.NET gets the 61K
> > > records almost instantly. The bottleneck occurs in the binding of the
> > > dataset to the ListObject control in Excel. I will try posting this in
> > > another discussion group.
> > > Thank you.
> > >
> > > "Miha Markic" wrote:
> > >
> > >> Hi,
> > >>
> > >> I don't think this is ado.net related problem. You should do some
> > >> performance measuring, perhaps using a performance profiler to find the
> > >> origin of the bottle neck.
> > >>
> > >> --
> > >> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
> > >> RightHand .NET consulting & development www.rthand.com
> > >> Blog: http://cs.rthand.com/blogs/blog_with_...
> > >>
> > >> "CerfurMark" <CerfurMark@discussions.microsoft.com> wrote in message
> > >> news:B8BD6529-5C23-46F7-AA63-62AF9A224AC1@microsoft.com...
> > >> > If I use Excel to open an Excel file with 61K records, they appear
> > >> > instantly.
> > >> > If I fill an ADO.NET recordset in Visual Basic with 61K records, it
> > >> > fills
> > >> > almost immediately. But if I bind the dataset to a ListObject in Excel
> > >> > in
> > >> > VSTO, then populating the workshseet takes 20 minutes. I can use a
> > >> > For...Next loop to read the dataset and fill each row of the worksheet,
> > >> > but
> > >> > that takes a couple of minutes. What is the way to instantly fill an
> > >> > Excel
> > >> > spreadsheet with a dataset from SQL Server?
> > >>
> > >>
> >
> >
> >