How many records are exist in database ? depend upon the record size it may take time.secondly your database connection is also affect the scenario.ThanksKoolprasd2003Editor, DotNetSpider MVMMicrosoft MVP 2014 [ASP.NET/IIS]