Pushing query result in an excel or csv file.

Manikrag

Hi Guys,

Is it possible to have query result in a excel or csv file instead of having it in a datareader or dataset. please let me konw one or the other way to do it.

Thanks,
Manik

IanWright

Well if it's in some sort of a dataset, I'm assuming you can itterate over rows and columns?

If so you could just built a little CSVWriter of your own?

r035198x

Also your database probably already supports a command that exports data as csv.

insertAlias

There is no framework element that will automatically dump your query into a CSV from code. But as Ian suggested, just iterate through your results and make your own.

r035198x

Quote:

Originally Posted by insertAlias

There is no framework element that will automatically dump your query into a CSV from code. But as Ian suggested, just iterate through your results and make your own.

But using the built in database commands would be much faster as the commands are already well optimized for that and there will be no need to write any code. Generally it is better to do with code only what the database cannot do.

insertAlias

Right, I was assuming that he had some need to do it programatically, possibly part of a larger process. If not, your way is definitely best.

Manikrag

It was very easy, sharing it for others. You can put your datagrid in the excel file with the same grid feel.

Expand|Select|Wrap|Line Numbers

 myDataGrid.DataSource = ds;

myDataGrid.DataBind();

dbConn_data.Close();

myDataGrid.Visible=true;

 //Adding Grid data in Excel sheet -start    

Response.Clear(); 

Response.AddHeader("content-disposition", "inline;filename=SurveyReport.xls");

Response.Charset = "";

Response.Cache.SetCacheability(HttpCacheability.NoCache);

Response.ContentType = "application/vnd.xls";

System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

myDataGrid.RenderControl(htmlWrite);

Response.Write(stringWrite.ToString());

Response.End();

Pushing query result in an excel or csv file.

re: Pushing query result in an excel or csv file.

re: Pushing query result in an excel or csv file.

re: Pushing query result in an excel or csv file.

re: Pushing query result in an excel or csv file.

re: Pushing query result in an excel or csv file.

re: Pushing query result in an excel or csv file.

Similar C# / C Sharp bytes

/bytes/development

/bytes/it

/bytes/other

/bytes/about