|
OK, let me explain again.
i made a soft that get data for a database and make and XML. that XML sometimes get more than 150mb and so but i need to send the XML by email. sometime with just a compression it fix by email but sometimes not, so i need that when the size is bigger that for example 100mb, make an split the zip file. its the same if you get the file and compress it with winrar using the option "split to volumes, size" but i want to do that in c# using if its possible zip class.
|
|
|
|
|
Then you probably need to split the file into a set of new files and then zip those 'subfiles' into an archive. Or, maybe split the file and compress each part separately before emailing it to the recipient.
|
|
|
|
|
i found this code in stackoverflow:
int SegmentsCreated ;
using (ZipFile zip = new ZipFile())
{
zip.UseUnicode= true;
zip.AddDirectory(@"MyDocuments\ProjectX");
zip.Comment = "This zip was created at " + System.DateTime.Now.ToString("G") ;
zip.MaxOutputSegmentSize = 100*1024 ;
zip.Save("MyFiles.zip");
SegmentsCreated = zip.NumberOfSegmentsForMostRecentSave ;
}
the line in bold make what i want but when i copy this code into VS get errors that i don't know how to fix it, so i try to get help to do this maybe in other way. I've made it using 7zip lib but i don't want to use external lib, i want to use .net library.
thanks.
|
|
|
|
|
jackie.3981 wrote: when i copy this code into VS get errors that i don't know how to fix
Well you need to tell us what those errors are. Alternatively you could go back to SO and ask the person who wrote the code.
|
|
|
|
|
error:
CS1674 'ZipFile': type used in a using statement must be implicitly convertible to 'System.IDisposable' ConsoleApplication3
|
|
|
|
|
jackie.3981 wrote: that get data for a database
There is your solution, work out the max no records before you exceed your size limit and make multiple queries to the database. Save each query to a separate file and zip each file into s series.
No splitting, no stitching together of zipped files. You will need to manage the merge of the data in the series at the other end but that is trivial.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
My sample as follows:
Now i use Func<> can output 1 param, but i need 3 param output, how can i do it?
Func<int,double> call = y => fun(y, z);
//i need output o1,o2, like y=>fun(y,z,out o1,out o2) ?
ThreadStart start = () => fun1(x, call);
Thread th = new Thread(start);
|
|
|
|
|
Use a lambda:
private void DoThread(int i, out int j, out int k)
{
j = i * 2;
k = i * 3;
}
...
int x = -1;
int y = -1;
Thread start = new Thread(() => DoThread(6, out x, out y));
start.Start();
Thread.Sleep(1000);
Console.WriteLine("{0},{1}", x, y);
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
oh, DoThread function i want to transfer to Thread as a var, your sample is call immidiately.
ThreadO th_o = new ThreadO(x => c( x, n,out F)); //this is Func<>,but i also want to out F
Thread th = new Thread(new ThreadStart(th_o.Cons_Mult));
th.Start();
private double c(double x,double n,out double F)
{
}
class ThreadO
{
public ThreadO(Func<double[], double,="" double=""> fun1)
{
...
}
}
|
|
|
|
|
If you can handle one parameter, you can handle multiple; encapsulate all three items in a class, and set an instance of that new class as your parameter.
class MyClass
{
public string o1;
public object o2;
public int y { get; set; }
public int z { get; set; }
}
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Yes,haha, you are right, but i want my code simplex and efficient, so i hope no more class, only several variable can solve it.
Func<> can output one param, but i want more output param. ,i don't know how to do it.
how can i use delegate to define multi-output delegate ?
|
|
|
|
|
smallkubi wrote: i want my code simplex and efficient, so i hope no more class
How would boxing the result be ineffcient? And no, that was not complex.
smallkubi wrote: how can i use delegate to define multi-output delegate ?
You can return an struct or object, you can use out parameters. Or even a callback that gets called for each output-variable 
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
I think what you want here is a way to "compose" a Func that you can use later
public struct TestStruct
{
int X;
int Y;
public TestStruct(int x, int y)
{
X = x;
Y = y;
}
}
private Func<int, int, TestStruct> TestFunc = (x, y) =>
{
return new TestStruct(x * 4, y * 5);
};
private TestStruct testStruct1;
testStruct1 = TestFunc(100, 200);
«Tell me and I forget. Teach me and I remember. Involve me and I learn.» Benjamin Franklin
|
|
|
|
|
I use Interop.RSIOPC.dll to connect via "OPC" a c# code with the PLC. I browse between the tags in the PLC memory and to do that I am using some functions. Browsing is mainly "moveDown(branch name)" or "MoveUp()". This is working. But if I need to jump staright to a branch I have to use MoveTo(ref System.Array). The array is created typeof string. At runtime MoveTo returns with a generic error and after many test my guess is that problem is related to the fact that I am using managed objects while the dll operated unmanaged.
Many thanks in advance for any help.
Regards
Roberto
I add here some more details:
my c# code :
System.Array branches;
branches = System.Array.CreateInstance(typeof(string),1);
branches.Initialize();
branches.SetValue("SLC_MODBUS_BASIC", 0); //name of the branch I need to move to
MyOpcBrowserName.MoveTo(ref branches); //pass the System.Array by ref as requested by the dll
This generate the unmanaged exception "Error HRESULT E_FAIL has been returned from a call to a COM component."
Error code -2147467259
Source "Interop.RsiOPCAuto" " at RsiOPCAuto.OPCBrowser.MoveTo(Array& Branches)\r\n at ... my code..
Here below the code from OPC foundation
OPCBrowser.cpp
// (c) Copyright 1998 The OPC Foundation
.
.
.
#include "stdafx.h"
#include "OPCBrowser.h"
.
.
.
// OPCBrowser::MoveTo method
STDMETHODIMP COPCBrowserImpl::MoveTo( SAFEARRAY ** ppBranches )
{
if(*ppBranches == NULL)
return E_INVALIDARG;
// Clear out the list
ClearNames();
HRESULT hr = S_OK;
LONG lBound=0;
LONG uBound=0;
// ServerHandles
hr = SafeArrayGetLBound(*ppBranches, 1, &lBound);
if( FAILED(hr) )
return hr;
hr = SafeArrayGetUBound(*ppBranches, 1, &uBound);
if( FAILED(hr) )
return hr;
hr = MoveToRoot();
if( FAILED(hr) )
return hr;
for( LONG index=lBound; index<=uBound; index++ )
{
BSTR Branch;
hr = SafeArrayGetElement(*ppBranches, &index, &Branch);
if( FAILED(hr) )
return hr;
if(*Branch != 0 )
{
hr = m_pOPCBrowser->ChangeBrowsePosition( OPC_BROWSE_DOWN, Branch );
SysFreeString( Branch );
if( FAILED(hr) )
return hr;
}
}
return hr;
}
Thank you in any case
Roberto
modified 22-Dec-15 4:25am.
|
|
|
|
|
Hello can someone help me with some exercises? The questions are rather long so i cant post them here.
If someone is patient enough to check my code please leave a message
|
|
|
|
|
whats is the question here?
modified 20-Sep-20 21:01pm.
|
|
|
|
|
if someone is willing to check my code and help me solve my exercises please contact me via skype name:[DELETED].yo or mail me at [DELETED]@hotmail.com.
[edit]Email and Skype removed - OriginalGriff[/edit]
modified 21-Dec-15 1:54am.
|
|
|
|
|
Never post your email address in any forum, unless you really like spam! If anyone replies to you, you will receive an email to let you know.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
This is not likely to happen - you are basically asking us to mark you homework before you submit it, which is a long job with little benefit to anyone, and one we can't necessarily do: we don't know what criteria your tutor will be using to "judge" the code as we have no idea what your course it, or how far into it you are.
If you have specific questions then feel free to ask them (probably here: Qutick Answers[^]), or if you have more general discussions about the language then this forum is good. But reading you homework and judging it? Not really our "thing" - what if everyone on your course made the same request? Or everyone doing homework?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
As you can see from the other responses here, no one is going to do homework for you.
However, everyone can post specific technical questions related to code they are working on; I'd recommend you post those on the C# QA forum.
In your questions be sure to:
0. summarize the problem briefly at the start of the post
1. tag your question appropriately: WinForms ... etc.
2. show carefully selected code that will help us understand what you are doing, and format the code using CP's format facilities.
3. describe any error messages: where did the error occur, etc.
«Tell me and I forget. Teach me and I remember. Involve me and I learn.» Benjamin Franklin
|
|
|
|
|
This command is not working. It gives the error stated in the subject. Anyone knows how to solve it? Thanks.
SqlCommand Command = new SqlCommand("insert into lojas (NIF, Loja, bloqueado, DataFim, lastupdate, Nome) values ('" + grid_lic.CurrentRow.Cells[1].Value + "', " + grid_lic.CurrentRow.Cells[2].Value + "," + grid_lic.CurrentRow.Cells[3].Value + ",'" + grid_lic.CurrentRow.Cells[4].Value + "','" + grid_lic.CurrentRow.Cells[5].Value + "','" + grid_lic.CurrentRow.Cells[6].Value + "')", connection);
Command.CommandType = CommandType.Text;
Command.ExecuteNonQuery();
|
|
|
|
|
First you opened your code up to SQL Injection attacks, risking the destruction of your database.
Second, your problem is easily solvable by using parameterized queries and the SqlParameter class.
Google for "C# sql parameterized queries" and you'll find everything you need.
|
|
|
|
|
Actually I had tried another code before which also gave an error:
Additional information: Incorrect syntax near '2015'.
Unclosed quotation mark after the character string ',')'.
The code was this:
SqlCommand Command = new SqlCommand("insert into lojas (NIF, Loja, bloqueado, DataFim, lastupdate, Nome) values (" + NIF + "', " + loja + "," + bloqueador + ",'" + DataFim + "','" + lastupdate + "','" + Nome + "')", connection);
Command.CommandType = CommandType.Text;
Command.Parameters.AddWithValue("@NIF", grid_lic.CurrentRow.Cells[1].Value);
Command.Parameters.AddWithValue("@Loja", grid_lic.CurrentRow.Cells[2].Value);
Command.Parameters.AddWithValue("@Bloqueado", grid_lic.CurrentRow.Cells[3].Value);
COmmand.Parameters.AddWithValue("@DataFim", grid_lic.CurrentRow.Cells[4].Value);
Command.Parameters.AddWithValue("@lastupdate", grid_lic.CurrentRow.Cells[5].Value);
Command.Parameters.AddWithValue("@Nome", grid_lic.CurrentRow.Cells[6].Value);
Command.ExecuteNonQuery();
|
|
|
|
|
That's not how you put together a parameterized SQL string. I don't know where you got that from, but it's definitely not in any documentation.
I suggest you go back and lookup more stuff to read. This is what the string should look like:
"INSERT INTO lojas (NIF, Loja, bloqueado, DataFim, lastupdate, Nome)
VALUES (@NIF, @Loja, @Bloqueador, @DataFim, @lastupdate, @Nome)"
line breaks are there to make it readable on the site.
|
|
|
|
|
Dave is correct that is not the correct way to build a parameterized query in C#. However, if you want to know where your SQL statement was getting broken.
values (" + NIF + "', " + loja + "," + bloqueador + ",'" + DataFim + "','" + lastupdate + "','" + Nome + "')
When this query is parsed it will become
values(NIF',Loja,bloqueador,'DataFim','latupdate','Nome')
Can you spot the error?
if (Object.DividedByZero == true) { Universe.Implode(); }
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
