v-amb
November 1st, 2010, 07:46 AM
Anyone can tell , how will i create a zip file of below csv generated code..what is the code for that?
Thanks in advance
my .csv generated code is.....
if (RadioButtonList1.SelectedItem.Text == "CSV")
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=DataTable.csv");
Response.Charset = "";
Response.ContentType = "application/text";
StringBuilder sb = new StringBuilder();
for (int k = 0; k < dtTemp.Columns.Count; k++)
{
sb.Append(dtTemp.Columns[k].ColumnName + ',');
}
sb.Append("\r\n");
for (int i = 0; i < dtTemp.Rows.Count; i++)
{
for (int k = 0; k < dtTemp.Columns.Count; k++)
{
sb.Append(dtTemp.Rows[i][k].ToString().Replace(",", ";") + ',');
}
sb.Append("\r\n");
}
Response.Output.Write(sb.ToString());
Response.Flush();
Response.End();
}
Thanks in advance
my .csv generated code is.....
if (RadioButtonList1.SelectedItem.Text == "CSV")
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=DataTable.csv");
Response.Charset = "";
Response.ContentType = "application/text";
StringBuilder sb = new StringBuilder();
for (int k = 0; k < dtTemp.Columns.Count; k++)
{
sb.Append(dtTemp.Columns[k].ColumnName + ',');
}
sb.Append("\r\n");
for (int i = 0; i < dtTemp.Rows.Count; i++)
{
for (int k = 0; k < dtTemp.Columns.Count; k++)
{
sb.Append(dtTemp.Rows[i][k].ToString().Replace(",", ";") + ',');
}
sb.Append("\r\n");
}
Response.Output.Write(sb.ToString());
Response.Flush();
Response.End();
}