Lior S wrote: lot of dataTable exception are u using DataReader.Read or DataAdapter.Fill ? ThaScorpion

you can use the concepts of OpenXML for bulk updates in sql server. this can minimize ur updates from a number of rows to be updated to 1. regards sAqIb "Our scientific power has outrun our spiritual power. We have guided missiles and misguided men." Dr. Martin Luther King Jr.

Lior S wrote: basically the main slowing reason is the UPDATE procedure since it is searching in more then 5 million records to fit to the conditioned row for the update. Sounds like the search component isn't very efficient. Are you searching on the primary key, or an index? If not make an index from the columns on which you are searching. *** Developer Day 4 in Reading, England on 2nd December 2006 - Registration Now Open *** Upcoming Scottish Developers events: * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog | Photos

Is your code multithreaded ? Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog

Don't post the same question in multiple forums.. Best Regards, Apurva Kaushal

Thanks for your help and redirection. Lior

You might want to check out Dino's article[^].

Hello, I think you have to pick one of these possibilities. public override Font Font { get { return base.Font; } set { base.Font = value; } } private Font \_font; public new Font Font { get { return \_font; } set { \_font = value; } } public new Font Font { get { return base.Font; } set { base.Font = value; } } private Font \_myfont; public Font MyFont { get { return myfont; } set { myfont = value; } } Hope you found youre solution! All the best, Martin

I am not sure about the method but you can fire the event from java script. by using do_postback method. :mad: Sathik