C#

DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            // Specify connection options and open an connection
            NpgsqlConnection conn = new NpgsqlConnection("Server=localhost;User Id=xxx;" +
                                    "Password=xxx;Database=xxx;");


            conn.Open();

            string query = "SELECT xxxx";
            //// Define a query
            NpgsqlCommand cmd = new NpgsqlCommand(query, conn);

            //// Execute a query
            NpgsqlDataReader dr = cmd.ExecuteReader();


            //// Read all rows and output the first column in each row
            while (dr.Read())
                data.Add(new Lagerteile() { ID = (int)dr["ID"], Kunde = dr["Name"].ToString(), Liefertermin = (DateTime)dr["Liefertermin"], WANr = dr["WaNr"].ToString(), Name = dr["Bezeichnung"].ToString(), Pos = dr["Pos"].ToString(), Stk = (int)dr["Stk"] });



            conn.Close();

          dg123.DataContext = data;

1. Open the source file with a FileStream
2. Chain a DeflateStream onto the filestream (just pass in constructor)
3. Read from the deflate stream the number of bytes you want in your chunks (into byte array)
4. Write entire byte array to individual file.
5. Goto 3 (until end of filestream).

jackie.3981 wrote:

how to split a file while compress it.

int SegmentsCreated ;
using (ZipFile zip = new ZipFile())
{
  zip.UseUnicode= true;  // utf-8
  zip.AddDirectory(@"MyDocuments\ProjectX");
  zip.Comment = "This zip was created at " + System.DateTime.Now.ToString("G") ;
  zip.MaxOutputSegmentSize = 100*1024 ; // 100k segments
  zip.Save("MyFiles.zip");

  SegmentsCreated = zip.NumberOfSegmentsForMostRecentSave ;
}

jackie.3981 wrote:

when i copy this code into VS get errors that i don't know how to fix

CS1674	'ZipFile': type used in a using statement must be implicitly convertible to 'System.IDisposable'	ConsoleApplication3