//prepare the output stream
Response.Clear();
Response.ContentType = "text/csv";
Response.AppendHeader("Content-Disposition",string.Format("attachment; filename={0}", fileName));
//write the csv column headers
DataTable dt1;
dt1 = ds.Tables[1];
foreach (DataRow row in dt1.Rows)
{
for (int i = 0; i < dt1.Columns.Count; i++)
{
Response.Write("\"" + row[i].ToString() + "\"");
Response.Write((i < dt1.Columns.Count - 1) ? delimiter : Environment.NewLine);
}
}
DataTable dt;
dt = ds.Tables[0];
//write the data
foreach (DataRow row in dt.Rows)
{
for (int i = 0; i < dt.Columns.Count; i++)
{
Response.Write("\"" + row[i].ToString() + "\"" );
Response.Write((i < dt.Columns.Count - 1) ? delimiter : Environment.NewLine);
}
}
Response.End();
Thursday, April 21, 2011
Dynamic Create Zip file .net 2.0
Note: Add two namespace and one Reference liberary Name "vjslib".
using java.io;
using java.util.zip;
private void Zipfile(string fileName,string Extn)
{
string TempPath = Environment.GetFolderPath(Environment.SpecialFolder.InternetCache);
string allFiles = TempPath + @"\" + fileName;
Response.Clear();
Response.ContentType = "text/zip";
Response.AppendHeader("Content-Disposition", string.Format("attachment; filename={0}", fileName.Replace(Extn, "zip")));
//Response.AddHeader("Content-Length", fileName.Replace("CSV", "zip").Length.ToString());
// Ziping code.
StringBuilder sb = new StringBuilder();
string ZipFileName;
string theDirectory = TempPath;
ZipFileName = TempPath + @"\" + fileName.Replace(Extn, "zip");
FileOutputStream fos = new FileOutputStream(ZipFileName);
ZipOutputStream zos = new ZipOutputStream(fos);
zos.setLevel(9);
string sourceFile = allFiles;
FileInputStream fis = new FileInputStream(sourceFile);
ZipEntry ze = new ZipEntry(sourceFile.Replace(theDirectory + @"\", ""));
zos.putNextEntry(ze);
sbyte[] buffer = new sbyte[1024];
int len;
while ((len = fis.read(buffer)) >= 0)
{
zos.write(buffer, 0, len);
}
fis.close();
zos.closeEntry();
zos.close();
fos.close();
// popup Zip file
Response.TransmitFile(ZipFileName);
Response.End();
}
using java.io;
using java.util.zip;
private void Zipfile(string fileName,string Extn)
{
string TempPath = Environment.GetFolderPath(Environment.SpecialFolder.InternetCache);
string allFiles = TempPath + @"\" + fileName;
Response.Clear();
Response.ContentType = "text/zip";
Response.AppendHeader("Content-Disposition", string.Format("attachment; filename={0}", fileName.Replace(Extn, "zip")));
//Response.AddHeader("Content-Length", fileName.Replace("CSV", "zip").Length.ToString());
// Ziping code.
StringBuilder sb = new StringBuilder();
string ZipFileName;
string theDirectory = TempPath;
ZipFileName = TempPath + @"\" + fileName.Replace(Extn, "zip");
FileOutputStream fos = new FileOutputStream(ZipFileName);
ZipOutputStream zos = new ZipOutputStream(fos);
zos.setLevel(9);
string sourceFile = allFiles;
FileInputStream fis = new FileInputStream(sourceFile);
ZipEntry ze = new ZipEntry(sourceFile.Replace(theDirectory + @"\", ""));
zos.putNextEntry(ze);
sbyte[] buffer = new sbyte[1024];
int len;
while ((len = fis.read(buffer)) >= 0)
{
zos.write(buffer, 0, len);
}
fis.close();
zos.closeEntry();
zos.close();
fos.close();
// popup Zip file
Response.TransmitFile(ZipFileName);
Response.End();
}
Subscribe to:
Posts (Atom)
Hash Table in C#
The Hashtable is a non-generic collection and used to store the key/value pairs based on the hash code of the key. Key will be used to acce...
-
Html.TextBoxFor in MVC 2 doesn't allow the setting of the value property using the object html attributes. syntax - <%= Html.Text...
-
Dictionary<string, string> DicSearch; DicSearch = new Dictionary<string, string>(); DicSearch.Add("1", "Mohi...
-
e.preventDefault() is the key method, to disable the default operations to proceed further. We first stop the event from further bubbli...
-
****************** Type 1 ********************* System.Nullable<DateTime> dt; dt = null; ****************** Type 2 **************...