William
Mon Nov 27 11:22:03 CST 2006
Huh?
I expect you've reached the "database" (Excel's) capacity... I would look
for a better architecture--a way to keep the data in the database and pull
far fewer rows into Excel.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
-----------------------------------------------------------------------------------------------------------------------
"Esref DURNA" <esref_durna@hotmail.com.and.microsoft.com> wrote in message
news:91EBA736-C746-4A91-97CC-B77A19BE1D9F@microsoft.com...
> if i was you i will check the connectionstate every insertion.
> dont let this to be done by the adaptor.
> create a dataset foreach loop and insert the records with in a loop by a
> command executenonquery method and check the connection before every
> execute
>
> --
> Esref DURNA
> Software Engineer
>
> www.esrefdurna.com
> Asp.Net , C#
>
>
> "Miha Markic [MVP C#]" wrote:
>
>> Hi,
>>
>> I was just guessing the cause. First you need to find the cause of the
>> error
>> and then you can solve it, right?
>> I don't have a clue what and how exactly you are doing it. Nor do I know
>> which .net version are you using nor what database, etc.
>>
>> --
>> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
>> RightHand .NET consulting & development www.rthand.com
>> Blog:
http://cs.rthand.com/blogs/blog_with_righthand/
>>
>> "Agnes" <agnes@dynamictech.com.hk> wrote in message
>> news:OfppfIWEHHA.1220@TK2MSFTNGP04.phx.gbl...
>> > so, there is no method to solve ?I use Store procedure to fill in the
>> > SQL
>> > tables successfully , and then
>> > I fill in the dataset and then export to excel. No solutions ???
>> > Please help
>> >
>> > "Miha Markic [MVP C#]" <miha at rthand com>
>> > ???????:0681E102-9E79-4BF2-9B44-68B61CB825B9@microsoft.com...
>> >> Perhaps some sort of timeout issue?
>> >>
>> >> --
>> >> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
>> >> RightHand .NET consulting & development www.rthand.com
>> >> Blog:
http://cs.rthand.com/blogs/blog_with_righthand/
>> >>
>> >> "Agnes" <agnes@dynamictech.com.hk> wrote in message
>> >> news:%23UTNrOVEHHA.4280@TK2MSFTNGP04.phx.gbl...
>> >>>I found that when I fill over 10,000 records to a dataset, there will
>> >>>be
>> >>>an error "Internal Connection error". Please help.
>> >>>
>> >>
>> >
>> >
>>
>>