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

Re: How to Upload large size file to server

wasimsharp30-Jun-09 2:33

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

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

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

Dushan123 wrote:
please help me to do this task.

Any specific help you want, or should we engage our mindreading skills?

Re: Sql query designer

musefan30-Jun-09 2:16

musefan

30-Jun-09 2:16

J4amieC wrote:
or should we engage our mindreading skills?

No, save that for the forums dedicated to mindreaders

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

Re: Sql query designer

J4amieC30-Jun-09 2:17

J4amieC

30-Jun-09 2:17

Most of the time, this is that forum Hmmm | :|

Re: Sql query designer

musefan30-Jun-09 2:19

musefan

30-Jun-09 2:19

J4amieC wrote:
Most of the time, this is that forum

you did not have to write that, I already knew you were going to say it Wink | ;)

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

Re: Sql query designer

musefan30-Jun-09 2:30

musefan

30-Jun-09 2:30

....hmmmm, that's an interesting thought...

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

Re: Sql query designer

K030630-Jun-09 2:06

K0306

30-Jun-09 2:06

I think you are asking about Joins in SQL, if this right,try the below links for Joins

SQL Join Link1[^]

SQl Joins Link2[^]

Re: Sql query designer

Dushan12330-Jun-09 2:31

Dushan123

30-Jun-09 2:31

I need to visualize the sql joins like sql query analyzer

Dushan Perera

Re: Sql query designer

musefan30-Jun-09 2:18

musefan

30-Jun-09 2:18

Dushan123 wrote:
I need to develope simple sql query designer

the word 'simple' strikes me as being one you clearly should not have included in a post asking for help.

I mean, if it's so simple then why do you need help with it

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

Re: Sql query designer

Pete O'Hanlon30-Jun-09 2:36

Pete O'Hanlon

30-Jun-09 2:36

OK - what have you got so far? How are you representing your tables? What diagramming methods are you using?

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.