A
Agnes
I found that when I fill over 10,000 records to a dataset, there will be an
error "Internal Connection error". Please help.
error "Internal Connection error". Please help.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Miha Markic [MVP C#]
Perhaps some sort of timeout issue?
A
Agnes
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
tables successfully , and then
I fill in the dataset and then export to excel. No solutions ???
Please help
Miha Markic said: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 said:I found that when I fill over 10,000 records to a dataset, there will be
an error "Internal Connection error". Please help.
M
Miha Markic [MVP C#]
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/
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 said: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 said: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 said:I found that when I fill over 10,000 records to a dataset, there will be
an error "Internal Connection error". Please help.
G
Guest
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#
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 said: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 said: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 said: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/
I found that when I fill over 10,000 records to a dataset, there will be
an error "Internal Connection error". Please help.
M
Miha Markic [MVP C#]
Why?
W
William \(Bill\) Vaughn
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)
-----------------------------------------------------------------------------------------------------------------------
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 said: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 said: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 said: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>
???????:[email protected]...
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/
I found that when I fill over 10,000 records to a dataset, there will
be
an error "Internal Connection error". Please help.
C
Cor Ligthert [MVP]
With what you simulate the behaviour of the DataAdapter.
Cor
Cor
Esref DURNA said: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 said: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 said: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>
???????:[email protected]...
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/
I found that when I fill over 10,000 records to a dataset, there will
be
an error "Internal Connection error". Please help.