|
You need to split it over several records as it is too large for the data type. Use a sequence number on each record to allow you to stitch it back together in the right order. As an alternative, would it be possible to put the data in a file and store the file details in the database?
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi Bob,
Thanks for your reply. Let me tell you one thing that I am going to create a desktop mail storage. Still I am not sure how to store the messages in an elegant way. This was my first try to store the content of the message in sqlce db. Is there any other better way to do this?
|
|
|
|
|
There is no nice solution. Each datatype of any database, be it sqlce, oracle, sybase or whatever has a size limit and there is no way around this. In the past when storing large data items I have had to split the data over several records and join them back together for display etc.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Anindya Chatterjee wrote: I am going to create a desktop mail storage
Let me know what are the step(s) you following currently....For example read email one after another and store it to the database....
Thanks
Md. Marufuzzaman
I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.
|
|
|
|
|
What I am following are a very simple steps as follows:
Start application
search for accounts in settings
if nothing found
show creation dialog
create folder and storage tables
save the settings
if found
check for folder structure
if not synchronized
create folders at folder table
add its parent folder if any
check for mails in each mail
if not uptodate
download mails for each folder and save to storage table
if uptodate
start the listeners
|
|
|
|
|
Hi.
Anybody know how to equivalent in C# following types :
CInternetSession session;
CHttpConnection* pServer = NULL;
CHttpFile* pFile = NULL;
Thanks .
We are haven't bug,just temporarily undecided problems.
|
|
|
|
|
HTTP stuff is contained in the System.Net[^] namespace. The WebRequest[^] class example demonstrates a typical usage scenario.
|
|
|
|
|
Hi,
Is there any .Net open source tool which basically detect all the devices which are connected over the connected network like Printer, Router etc ?
|
|
|
|
|
good day to everyone... I would like to know, how to deploy my .net web service in win7...I'm getting a hard time making it functional in win7. thanks a bunch for your help.
|
|
|
|
|
1. You probably need to describe what it is that doesn't work for anyone to be able to help you.
2. I would be surprised if there wasn't any good articles/videos/tutorials on this matter. No luck on google?
|
|
|
|
|
no luck on google...or maybe i'm just querying a wrong question...i'm about to test my web service in win7.but unfortunately, i'm having a hard time figuring out how to configure the IIS7 to deploy my web service.i also want to test through my vmware before i deploy it.but i can't manage to make my apps in vmware which,am using winxp to communicate with my web service in win7...thanks u bunch again...
|
|
|
|
|
Maybe this article on Codeproject will get you started. Don't know if there are any specific tricks on Win7 though..
What errors are you facing in your vm-ware system running WinXP?
|
|
|
|
|
i've already seen that article...the article is not that detailed in explaining on how to deploy a website.still, thank you...
|
|
|
|
|
You can try this[^] one for deploying App to IIS7.
Thanks
Md. Marufuzzaman
I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.
|
|
|
|
|
I am getting a weird delay when writing a file. I am not able to figure out where the delay is coming from.
The facts:
I map a drive to a NT server (W:\)
I copy a file at W:\largefile.dat to W:\Archive\largefile.dat
My copy loop:
try
{
using (FileStream sourceStream = new FileStream(nd_CopyDrive.LocalDrive + "\\" + fi.Name, FileMode.Open))
{
byte[] buffer = new byte[64 * 1024];
using (FileStream destStream = new FileStream(nd_CopyDrive.LocalDrive + "\\Archive\\" + fi.Name, FileMode.Create))
{
int q;
while ((q = sourceStream.Read(buffer, 0, buffer.Length)) > 0)
{
destStream.Write(buffer, 0, q);
}
}
}
}
When the file is completely written my program hangs at the closing bracket for the second using statement.
Nothing is shown in the Output window that gives me some clues. This block of code IS running in a background worker as added information.
Could my problem be related to how the CLR "releases the memory used to store objects that are no longer required".
If I place a debug marker at that ending bracket and perform a step into, the Output window shows:
Step into: Stepping over method without symbols 'System.IO.Stream.Dispose' (which takes forever to complete)
Any help would be greatly appreciated!
|
|
|
|
|
I'll bet if you put a call to destStream.Flush() just after the Write while loop, it would solve the mystery.
I'm reasonably sure that the delay is due to the data actually being written to the file.
|
|
|
|
|
Flush is called by Close which is called by Dispose, which, of course, is called when leaving the using scope.
So no, calling Flush before the won't actually do anything different.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
It would solve the mystery by exposing exactly what's causing the slowdown.
|
|
|
|
|
Will it give information about network latency, data packets, etc.? No, it won't expose anything more than an extra statement to set a break point on.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
When you step over it, it will take a long time to execute the Flush statement.
It would solve the mystery for me, maybe someone else would be too dense.
|
|
|
|
|
Richard Andrew x64 wrote: maybe someone else would be too dense.
An uncalled for statement. If you can't remain civil then please don't comment.
There are other ways to debug a problem than just hitting F10. Knowing and understanding the processing that are occurring is also a big help.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Look who's talking about being civil!
You're the guy who's always breaking Rule 3 in HOW TO ANSWER A QUESTION.
|
|
|
|
|
I certainly didn't mean to start a fight over debugging... 
|
|
|
|
|
No fighting. Some people just resort to insults and deflection when their arguments can't be defended professionally.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Have you trying just using File.Copy to see if there is any difference? It does basically the same thing but it may be something to test. Otherwise I'd say it's just the process of finalizing the writing of a large file, nothing you're going to solve without stepping into the unmanaged realm.
I know the language. I've read a book. - _Madmatt
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Badger | [badger,badger,badger,badger...]](https://www.codeproject.com/script/Forums/Images/badger.gif)
