I use following code to export data to csv file:
Response.AddHeader("content-disposition", "attachment;filename=UnicodeChar.csv");
Response.ContentType = "application/octet-stream";
StreamWriter sw = new StreamWriter(Response.OutputStream, Encoding.UTF8);[code]...
It works fine. Then I download the csv file to local and open it. At last, I save it. I open the csv file with notepad, I found it misses all commas.
I have a .net aspx project done with VS 2008 using the .Net 2.xxxx framework. This ASPX application is deployed on and 4 different 2003 Server boxes. 3 are running in total beautifully. In the 4th box is my issue. I do a FILE.EXISTS conditional test looking for case file pdf's. These case numbers are structured as such 2012-C-0421,001,0008.PDF
Please note the comma's used in the path. 3 of the 4 servers in court houses recognize the path to the pdf WITH the commas in them perfectly and the FILE.EXISTS works 100%. On the fourth box (same config we THINK) the exact same FILE.EXISTS does not return a hit even though we see the document sitting in the folder via explorer. IF we remove the commas and make it 2012-C-0421001008.pdf all is fine and document is indeed discovered with the EXISTS.
WHY on this one server does the original ducument path not function. We can not ask the court houses to change the way they store their documents so I need to make this work like the other 3. Again... same version..same .net framework... same OS (2003 server)
I want to export gridview to Excel and followed the code from the link below but never get it work.
View 1 RepliesI've programmatically generated an ASP.NET Table that is then added to a page. There is also a Button on the same page where a user can export the Table data into Excel. Very standard stuff. The data that is displayed on the page is correct but after exporting 10 rows are missing. I've checked encoding. I've compared character input: nothing unusual. Has anyone ran into this before?Here's the export code (see comment at the table...)
protected void btnExport_Click(object sender, EventArgs e)
{
string attachment = "attachment; filename=Abstracts.xls";
[code]...
I'm exporting report to excel using (crystal report built in export option),
the result of excel file is not in proper alignment.. the lines boxes are not showing in excel file
How to export with proper alignment to excel with line boxes etc... which shown in output of crystal report
I have a number that is generated from a SQL query that is populated into a tablecell as follows:
[Code]....
I get the correct value in my tablecell, except the value is 15345432. I would like to format this to show 15,345,432How can I go about doing this?
I am exporting data from gridview to excel file.My problem is that for all the string which contain "+", the rest of data begining from it is missing in excel file.For example: PWE-WER+78, when exported it will become PWE-WER.Below is my code.
[Code]....
I've a string builder, and I need to convert it to a string, and then trim any commas if there are any there (I need to get rid of them because I'm building an sql query).
Here's what I'm doing:
myStringBuilder.ToString().TrimEnd(',');
Why isn't this working??? It's not trimming any commas at the end!
I'm using c# :)
i am using the filtered text box extender.I want to allow commas like "," but not possible with the code below.how do i change this to make commas acceptable?
View 3 RepliesI am using asp.net oledb to export information to excel file. I encounter problems when the information to export becomes too big, in this case the code I have given below, the excel file generated becomes an empty spreadsheet. If I changed the loop to 1123 for insertion of the rows. The generated excel file is fine, 1125 rows, and 4 columns shown. A test program in windows form is also working fine regardless of how many rows.
Code has been simplified, "information ..." in the sql insertion command represents 1803 characters.
ExcelObjConn = "Provider=Microsoft.Ace.OLEDB.12.0;" & _
"Data Source=" & fileName & ";Extended Properties=Excel 12.0 XML"
ExcelConnection = New System.Data.OleDb.OleDbConnection(ExcelObjConn)
ExcelConnection.Open()
Try
SqlCommand = "CREATE TABLE ABC ([row1] text, [row2] text, [row3] text, [row4] text)"
ExcelCommand = New OleDb.OleDbCommand(SqlCommand, ExcelConnection)
ExcelCommand.ExecuteNonQuery()
ExcelCommand.Dispose()
For i As Integer = 0 To 1124
SqlCommand = "Insert into ABC ([row1], [row2], [row3], [row4]) Values ('information...', 'information ...', 'information ...', 'information ...')"
ExcelCommand = New OleDb.OleDbCommand(SqlCommand, ExcelConnection)
ExcelCommand.ExecuteNonQuery()
ExcelCommand.Dispose()
Next
Catch ex As Exception
Finally
If ExcelConnection IsNot Nothing Then
ExcelConnection.Close()
ExcelConnection.Dispose()
End If
End Try
I couldn't find a solution to my problem as well. What I did eventually was to run the process using another separate windows service. The code works perfectly fine running from a windows form or service program, but not asp.net, not sure why.
I want to Export Sql Server file To Text File Using Asp.net
How Can I do ..
I want to export my file with images in it to PDF. i tried the same code u hv given but its giving me error "The remote server returned an error: (404) Not Found".below is my code.
.aspx file
<%@ Page Title="Home Page" Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="GridToPDF._Default" %>
<html xmlns="http://www.w3.org/1999/xhtml" > <head id="Head1" runat="server"> <title>Untitled Page</title>
</head> <body> <form id="form1" runat="server"> <div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
<Columns> <asp:BoundField DataField="Name"
[CODE]...
I'm using a streamwriter to write a tab delimited file (for import into Mail Chimp), but the last line of the file is always missing a few characters. Doesn't matter what size the List<t> is (its small - about 128 lines)
Code:
protected void WriteTempFile(List<ChimpExportModel> list, out string filepath)
{
Guid UniFileName = Guid.NewGuid();
string path = Server.MapPath("Temp");
string writepath = string.Concat(path, @"" + UniFileName.ToString() + @".txt");
[Code] ....
I've looked at the last item of the List in the debugger and it's just like all the rest. On write, its always cutting off the last characters - which happen to be '.com'. Kinda important. Some posts say to flush and close - tried it. No change. Last characters still AWOL.
I am trying to read a CSV file which has commas embedded within certain fields.
Eg.
"Joe Bloggs", "123 Bloggs Street, Bloggsville, MA, USA", "123.34", "XYZ"
"John Doe", "12 JD Avenue, MA, USA", "53.2", "QRS"
As you can see I have the same amount of fields with a differing amount of comma characters in each. I was using the comma character (',') to split my string into different fields but this gave me varied results.
I have no control over the format of the file so restrucuring it is not an option.
Is there a way where I can split the string by using the comma and maintaining the address field as a single field.
I had been doing a type check for Double for an input field on a web page but now I need to allow commas. Can this be done using a CompareValidator or do I need to use a regex validator?
View 1 RepliesI wish to implement a fairly simple CSV checker in my C#/ASP.NET application - my project automatically generates CSV's from GridView's for users, but I want to be able to quickly run through each line and see if they have the same amount of commas, and throw an exception if any differences occur. So far I have this, which does work but there are some issues I'll describe soon:
int? CommaCount = null;
StringBuilder sb = new StringBuilder();
StringWriter sw = new StringWriter(sb);
String Str = null;
//This loops through all the headerrow cells and writes them to the stringbuilder
for (int k = 0; k <= (grd.Columns.Count - 1); k++)
{
sw.Write(grd.HeaderRow.Cells[k].Text + ",");
}
sw.WriteLine(",");
//This loops through all the main rows and writes them to the stringbuilder
for (int i = 0; i <= grd.Rows.Count - 1; i++)
{
StringBuilder RowString = new StringBuilder();
for (int j = 0; j <= grd.Columns.Count - 1; j++)
{
//We'll need to strip meaningless junk such as <br /> and
Str = grd.Rows[i].Cells[j].Text.ToString().Replace("<br />", "");
if (Str == " ")
{
Str = "";
}
Str = """ + Str + """ + ",";
RowString.Append(Str);
sw.Write(Str);
}
sw.WriteLine();
//The below code block ensures that each row contains the same number of commas, which is crucial
int RowCommaCount = CheckChar(RowString.ToString(), ',');
if (CommaCount == null)
{
CommaCount = RowCommaCount;
}
else
{
if (CommaCount!= RowCommaCount)
{
throw new Exception("CSV generated is corrupt - line " + i + " has " + RowCommaCount + " commas when it should have " + CommaCount);
}
}
}
sw.Close();
And my CheckChar method:
protected static int CheckChar(string Input, char CharToCheck)
{
int Counter = 0;
foreach (char StringChar in Input)
{
if (StringChar == CharToCheck)
{
Counter++;
}
}
return Counter;
}
Now my problem is, if a cell in the grid contains a comma, my check char method will still count these as delimiters so will return an error. As you can see in the code, I wrap all the values in " characters to 'escape' them. How simple would it be to ignore commas in values in my method? I assume I'll need to rewrite the method quite a lot.
I'm using a facebox to display a form inside a lightbox, nothing too exciting (just a couple of datepickers, some textboxes and a checkbox). However, I'm having issues with the postbacks, whenever I post back from the facebox it adds a ',' to the start of the input (so "rabbit" becomes ",rabbit") Now, I saw that there was the same issue with the modalpopup extender from the ajaxcontroltoolkit, so I assume it's a common issue.
Can anyone either explain why this is happening, or tell me how to fix it? provide a decent way of fixing this?
See attached answer for a correct solution (I fixed this eventually but didn't want to ruin the bounty question so left the answer until afterwards).
In my project i wants to display report and export it in pdf format so that i used rdlc but now my requirement is that there are some labels like name,address for it i wants to give some specific margin from left right(x,y) and i wants to give this margin by config file. "how can we set margin in rdlc from cofig file or run time?"
View 1 RepliesI need a code which can export the data from XML file to the Excel file.
View 3 Repliesi have one form where i am generating several letters and showing them in a label to view the content. now i want to export that label content into word (.doc) file on button click.
View 8 Repliesi have agridview that i fill in the runtime and i want to save or copy its data into aword file.i tried acode but when i opened the file , i found it empty.
View 5 Repliesi have someecords in grid i want ot export in excel file . i use code like below
protected void btnExportDB_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Page.EnableViewState = false;
Response.Charset = "";
Response.AddHeader("Content-Disposition", "inline;filename=voucher.xls");
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
grdMembers.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
on use this code on button click event.. file is generating but when i use same file for import in to database It gave me Error : External table is not in the expected format. For prob. of Format Type for Excel.
I have myConnectionString and it's working fine. In the Server Explorer, the Data Connection is even using myConnectionString to connect to the database. When I created my .dbml, it uses that same yConnectionString. However, now whenever I opened the .dbml file, pops up with the following message:The connection property in the web.config file is missing or incorrect.The connection string from the .dbml file has been used in its place.After this message is display and I clicked okay (because that's the only option), it creates myConnectionString2 in the web.config file with a different ID but no password provided. What is this all about? Why is it creating a second connection string with a different ID?
View 7 RepliesI am trying to export huge record (having more than 3000000 of records) to exl file.
i have one class file which have function ExportToExcell .it is working fine for samll records ..but for big record,got fallowing error
Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack.
Function is as falllow-first string for file name and othere three for any heading in exl file and datatable is data toexport.
I got all data in datatable but got error when try to export to exl
[Code]....
I have this webform which displays data from the databasenow I have an export button for it which exports the data but not the one which is displayed in the grid it duplicates the data with same name and doesnot show full address just shows firstline of the address in the grid and doesnot show the country.
<%@ Import Namespace="Exact.Hospitality.Core.Models"%>
<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="Result.ascx.cs" Inherits="Exact.Hospitality.Page.Marketing.AudienceSearch.Result" %>
<%@ Register TagPrefix="exact" Namespace="Exact.Hospitality.Core" Assembly="Exact.Hospitality.Core" %>
[Code].....