Re: How to Upload large size file to server - C# Discussion Boards

wasimsharp30-Jun-09 2:21

30-Jun-09 2:21

Hi friend i am creating WindowDesktop application that will upload a large size of file to the server.
now when i upload file of small size its uploaded with no problem but when i upload large size of 62Mb or so it throw exception. can any body tell me that how can i upload large file and can i also pause uploading and resume Uploading feature
<pre

filestream="" stream="new" filestream("c:\\xyz.zip",="" filemode.open);

="" byte[]="" buffer="new" byte[stream.length];
="" int="" i="0;
" while="" ((i="stream.Read(buffer,0," buffer.length))>0)
="" {

="" ftpwebrequest="" request="(FtpWebRequest)FtpWebRequest.Create("ftp://ftp.abc.com/"" +="" path.getfilename("c:\\xyz.zip"));
="" try
="" {
="" request.method="WebRequestMethods.Ftp.UploadFile;
" request.credentials="new" networkcredential("demo123",="" "demo123");
="" request.usepassive="true;
" request.usebinary="true;
" request.keepalive="false;
"
="" request.timeout="int.MaxValue;

" reqstream="request.GetRequestStream();
" reqstream.write(buffer,="" 0,="" buffer.length);
="" reqstream.beginwrite(buffer,="" buffer.length,="" callback,="" "aa");
="" reqstream.close();
="" }
="" catch="" (exception="" ex)
="" stream.close();="">

i use both Write and BeginWrite method

WANTED wasim khan(Killed 50 Innocent Buggs, Distroyed 200 Exception, make 5 Project Hostage) any Compnay Hire him will pay 30,000. Best place where u can get him is Sorcim Technologies Murre Road RWP

Re: How to Upload large size file to server

Vimalsoft(Pty) Ltd30-Jun-09 2:28

Vimalsoft(Pty) Ltd

30-Jun-09 2:28

We cannot know unless you tell us what Expetion you are getting

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Re: How to Upload large size file to server

wasimsharp30-Jun-09 2:33

wasimsharp

30-Jun-09 2:33

Hi Vuyiswa Maseko

Error is "Unable to write data to the transport connection: An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full."

WANTED wasim khan(Killed 50 Innocent Buggs, Distroyed 200 Exception, make 5 Project Hostage) any Compnay Hire him will pay 30,000. Best place where u can get him is Sorcim Technologies Murre Road RWP

Re: How to Upload large size file to server

Vimalsoft(Pty) Ltd30-Jun-09 2:37

Vimalsoft(Pty) Ltd

30-Jun-09 2:37

musefan is Right increase the Buffer and see what happends

Re: How to Upload large size file to server

musefan30-Jun-09 2:40

musefan

30-Jun-09 2:40

I'm actually suggesting to reduce the buffer size.. but I assume that is what you meant anyway Wink | ;)

Life goes very fast. Tomorrow, today is already yesterday.

Re: How to Upload large size file to server

Vimalsoft(Pty) Ltd30-Jun-09 2:42

Vimalsoft(Pty) Ltd

30-Jun-09 2:42

Its one of those Days Smile | :)

today its the Final day of my Project Smile | :)

Am tired

Re: How to Upload large size file to server

musefan30-Jun-09 2:43

musefan

30-Jun-09 2:43

I see

Just out of interested what is your project? is it a course project?

Life goes very fast. Tomorrow, today is already yesterday.

Re: How to Upload large size file to server

Vimalsoft(Pty) Ltd30-Jun-09 2:47

Vimalsoft(Pty) Ltd

30-Jun-09 2:47

My Company is in Education Industry

My Department Smile | :)

Timetabling
==============

We Create Clash Free Timetables

Where i come in
===============

ASP.NET 2.0, 3.5

Silverlight 2

WPF

SQL

Cool Suspicious | :suss:

We are release a new Version of our Product , so worked every Sunday Smile | :)

but that has come to an end today Smile | :)

Re: How to Upload large size file to server

musefan30-Jun-09 2:58

musefan

30-Jun-09 2:58

Interesting Wink | ;)

Life goes very fast. Tomorrow, today is already yesterday.

Re: How to Upload large size file to server

musefan30-Jun-09 2:33

musefan

30-Jun-09 2:33

I have not really read your code but my first guess would be your buffer array size is causing the issue. The buffer should not contain all the data else you may as well use the stream itself.

Try a buffer size of 1024 - that's a common size that is used.

Life goes very fast. Tomorrow, today is already yesterday.

Re: How to Upload large size file to server

wasimsharp30-Jun-09 2:42

wasimsharp

30-Jun-09 2:42

yes i set the buffer size to 1024
it working but in process it threw exception couple of time "The underlying connection was closed: An unexpected error occurred on a receive."

WANTED wasim khan(Killed 50 Innocent Buggs, Distroyed 200 Exception, make 5 Project Hostage) any Compnay Hire him will pay 30,000. Best place where u can get him is Sorcim Technologies Murre Road RWP

Re: How to Upload large size file to server

musefan30-Jun-09 3:01

musefan

30-Jun-09 3:01

Try creating the response stream (and closing it) outside of the while loop then just write the buffer contents in each loop.

Life goes very fast. Tomorrow, today is already yesterday.

Re: How to Upload large size file to server

Anthony Mushrow30-Jun-09 3:08

Anthony Mushrow

30-Jun-09 3:08

Two things.

i = stream.Read(buffer,0, buffer.Length)

That's fine, but later on

reqStream.Write(buffer, 0, buffer.Length);

You try to send the whole buffer, but if you only read 215 bytes in to the buffer in the first place then you would be sending garbage.

You should use the variable you set before to make sure you only send what you read in.

reqStream.Write(buffer, 0, i);

It would probably be fine since the whole file would be put in the buffer, but just to be safe.

As for your other problem, if you use BeginWrite you need to wait until the callback before closing the stream, at the moment you could be closing the stream while you're still trying to send data down it.

If you where to use the regular Write method, you would probably want to check how many bytes where actually written and make sure you send all of your data.

My current favourite word is: Delicious!

-SK Genius

Game Programming articles start -here[^]-

MySQL restore database through c#

mariamkhaqan30-Jun-09 2:06

mariamkhaqan

30-Jun-09 2:06

Hi I have used multiple ways to restore mysql schema through c# but it doesnot seems to work as the database doesnot restores properly,
please tell me what to do, my code for restore is as under

string filename = backupName;
                StreamWriter file = new StreamWriter(filename);
                file.WriteLine("@ECHO off");
                file.WriteLine("cls");
                file.WriteLine("set DBchoice=%1%");
                file.WriteLine("set User=%2%");
                file.WriteLine("set Password=%3%");
                file.WriteLine("set pathchoice=%4%");
                file.WriteLine("");
                file.WriteLine("@REM Remove double quotes from the path");
                file.WriteLine("@REM SET pathchoice=%pathchoice:\"=%");
                file.WriteLine("@REM SET pathchoice=%pathchoice:\"=%");
                file.WriteLine("");
                file.WriteLine("mysql -u " + Id + " --password=" + pwd + " " + dbName + "<" + path);

                file.Close();

the other one is

StreamReader file = new StreamReader(path);
                ProcessStartInfo proc = new ProcessStartInfo();
                string cmd = string.Format(@"-u{0} -p{1} -h{2} {3} {4} {5}", Id, pwd, serverHost, dbName + "<", path);
                proc.FileName = "mysql";
                proc.RedirectStandardInput = true;
                proc.RedirectStandardOutput = false;
                proc.Arguments = cmd;//"-u root -p smartdb > testdb.sql";
                proc.UseShellExecute = false;
                Process p = Process.Start(proc);
                string res;

                res = file.ReadToEnd();
                p.StandardInput.Write(res);

                // res = p.StandardInput.Write .StandardOutput.ReadToEnd();
                //file.WriteLine(res);
                p.WaitForExit();
                file.Close();
                return "Data restored successfully";

please give me any suggestions

regards,
Mariam

Re: MySQL restore database through c#

Pavel123123__27-Oct-09 5:32

Pavel123123__

27-Oct-09 5:32

StreamReader file = new StreamReader(fromFile);
string res;
res = file.ReadToEnd();
file.Close();
ProcessStartInfo proc = new ProcessStartInfo();
proc.FileName = "mysql.exe";
proc.CreateNoWindow = true;
proc.RedirectStandardInput = true;
proc.Arguments = string.Format(" -u{0} -p{1} -h{2} -D{3}", userName, password, serverName, databaseName);
proc.UseShellExecute = false;
p.StandardInput.Write(res);
p.StandardInput.WriteLine("quit");

Re: MySQL restore database through c#

adiono26-Dec-09 23:52

adiono

26-Dec-09 23:52

I've try this code and it's work fine!

StreamReader file = new StreamReader(restoreFile);
ProcessStartInfo proc = new ProcessStartInfo();
string cmdArgs = string.Format(@"-u{0} -p{1} -h{2} {3}", UserID, Password, Location, DatabaseName);
proc.FileName = "C:\\Program Files\\MySQL\\MySQL Server 5.1\\bin\\mysql.exe";
proc.RedirectStandardInput = true;
proc.RedirectStandardOutput = false;
proc.Arguments = cmdArgs;
proc.UseShellExecute = false;
Process p = Process.Start(proc);
string res = file.ReadToEnd();
file.Close();
p.StandardInput.WriteLine(res);
p.Close();

"&lt;" or "<" can causes error because ProcessStartInfo doesn't recognize it!
Good Luck!

Re: MySQL restore database through c#

ogimenezb31-May-11 6:05

ogimenezb

31-May-11 6:05

I have been looking around because I have big dumps (200MB) and .NET kept going out of memory.

The solution is:

ProcessStartInfo proc = new ProcessStartInfo();
string cmdArgs = string.Format(@"-u{0} -p{1} -h{2} {3}", UserID, Password, Location, DatabaseName);
proc.FileName = "C:\\Program Files\\MySQL\\MySQL Server 5.1\\bin\\mysql.exe";
proc.RedirectStandardInput = true;
proc.RedirectStandardOutput = false;
proc.Arguments = cmdArgs;
proc.UseShellExecute = false;
Process p = Process.Start(proc);
p.StandardInput.WriteLine("source " + restoreFile);
p.Close();

Sql query designer

Dushan12330-Jun-09 1:28

Dushan123

30-Jun-09 1:28

I need to develope simple sql query designer. basicaly i have problem on represent the joins. please help me to do this task.

Dushan Perera

Re: Sql query designer

J4amieC30-Jun-09 1:32

J4amieC

30-Jun-09 1:32