|
I want to export GridView (25000 records) to Excel. But i got an error message like : System.OutOfMemoryException was Thrown.
But i need to export the records (even more than 25000 records) to excel
How to solve this ?
|
|
|
|
|
Why the heck would you put 25,000 records (or more!) into a GridView? Do you expect your users to look at them? And perhaps work out which one of them they are actually interested in? Would you want to sit there and do that?
And if your users aren't going to look at all those, then why are you wasting time, memory and space loading this into a GridView?
Instead, look at where you are getting this data from, and transfer that directly into Excel - that way, it may well be quicker, more efficient and a lot less likely to run out of memory...
The only instant messaging I do involves my middle finger.
English doesn't borrow from other languages.
English follows other languages down dark alleys, knocks them over and goes through their pockets for loose grammar.
|
|
|
|
|
its better that i transfer that directly into Excel but i dont know how can i do this, just i know bind a gridview and then convert it to excel
|
|
|
|
|
|
how can i make my software run 24*7 as like any antivirus software
|
|
|
|
|
You can use Windows Services and install this software as a service.
This will then allow the machine to run this software whenever this machine is running.
|
|
|
|
|
How about rewriting it as a Windows Service.
|
|
|
|
|
Agreed on what Abhinav S said.
In addition to that if you have already made software then you can install that software and create task scheduler give the path of the exe and set time interval at every minute.
This may also help you.
Regards,
CodeBlack
|
|
|
|
|
The coreadudio.dll working fine in visual studio 4.0 but I can't work with visual studio 3.5. My client is using visual studio 2008. so if there is any chance to do it in 2008 .. please give the solution..
if any download link that capable of working in 2008 ,please give me
|
|
|
|
|
If you want help with this then you need to provide proper details of the problem. We cannot guess what may be happening on your system.
Veni, vidi, abiit domum
|
|
|
|
|
I got the solution for my problems .. Thanks for your reply.
|
|
|
|
|
binoyvijayan wrote: The coreadudio.dll working fine in visual studio 4.0
You mean the .NET 4.0 runtime?
binoyvijayan wrote: I can't work with visual studio 3.5
You mean the .NET 3.5 framework?
binoyvijayan wrote: My client is using visual studio 2008
That does not support .NET 4.0; either he upgrades, or you downgrade.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Don't make yourself as bad. If u want to help the post correctly or if don't understand or don't know the answer please avoid it . I had also know the words to call u, that you used. But i don't want to use like that because I am not like u.
I got the solution for my problem, So I don't want your help. And Thanks for your reply
|
|
|
|
|
binoyvijayan wrote: I had also know the words to call u, that you used.
Some explanation would be nice; which word was offensive?
binoyvijayan wrote: So I don't want your help.
It'd be inefficient to ask if someone wants help if they post a question; I usually assume that people who post a question are looking for help.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Sorry its my mistake ... Sorry once again....
|
|
|
|
|
No harm done, glad it's just a mistake
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
|
The coreadudio.dll working fine in visual studio 4.0 but I can't work with visual studio 3.5. My client is using visual studio 2008. so if there is any chance to do it in 2008 .. please give the solution..
if any download link that capable of working in 2008 ,please give me
|
|
|
|
|
HAve you checked the dependencies of the dll? Parhaps its using .NET 4.0?
|
|
|
|
|
Yes . Thats what the prpblem, it s version is 4.0. thats why its working in visual studio 3.5.
I got the solution for my doubts. I got a coreaudio as an application in visual studio 2008, So now my application working properly..
Thanks for your reply
|
|
|
|
|
Hello Guys!!
I have a panel, and i have a textbox that i can move to where i want. When i try to move outside the panel, in the top or the left of the panel, the control stops, it means, its locked to move for these directions... Buuuuut, for right or bottom, the mouse leaves the panel and the control remains invisible because its outside the panels borders..
What i want is a way to lock the left and bottom, to move the contro only inside the panel...
thanks in advance!
Rafael
|
|
|
|
|
You need to set the Cursor's Clip Rectangle in the MouseDown EventHandler for the TextBox to that of its container's ClientRectangle translated to Screen coordinates, using an offset based on the Height and Width of the TextBox:
Cursor.Clip = YourTextBox.Parent.RectangleToScreen
(
new Rectangle
(
e.X,
e.Y,
YourTextBox.Parent.ClientSize.Width - YourTextBox.Width,
YourTextBox.Parent.ClientSize.Height - YourTextBox.Height
)
);And, in the MouseUp EventHandler for the TextBox:
Cursor.Clip = Rectangle.Empty; If the Control that contains the TextBox is never resized at run-time, then, of course, you can store its ClientRectangle translated to Screen coordinates in advance. If the TextBox is always the same size, you can pre-calculate the offset Rectangle only once, and then, in the MouseDown EventHandler, just set the Location depending on the MouseDown's MouseEventArgs.Location.
This may not seem intuitive .
Google CEO, Erich Schmidt: "I keep asking for a product called Serendipity. This product would have access to everything ever written or recorded, know everything the user ever worked on and saved to his or her personal hard drive, and know a whole lot about the user's tastes, friends and predilections." 2004, USA Today interview
modified 13-Oct-13 1:51am.
|
|
|
|
|
You're the man Bill!!!! Works perfectly!!! Thanks you so much!!!!
|
|
|
|
|
Can anyone tell me how to export dataGridView to Image(.jpg) format?
|
|
|
|
|
The same way as any other control: DrawToBitmap[^], then save the bitmap as jpg, though you should probably save it as png instead, text and other high-contrast-tiny-feature things get mangled pretty badly by jpg.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
