Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to Export Data to Excel?

Answer Posted / santoshsutar1983

protected void Button3_Click(object sender, EventArgs e)

{

DataTable dt = GetData();

string attachment = "attachment;
filename=Employee.xls";

Response.ClearContent();

Response.AddHeader("content-disposition",
attachment);

Response.ContentType = "application/vnd.ms-excel";

string tab = "";

foreach (DataColumn dc in dt.Columns)

{

Response.Write(tab + dc.ColumnName);

tab = "\t";

}

Response.Write("\n");



int i;

foreach (DataRow dr in dt.Rows)

{

tab = "";

for (i = 0; i < dt.Columns.Count; i++)

{

Response.Write(tab + dr[i].ToString());

tab = "\t";

}

Response.Write("\n");

}

Response.End();

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to track links visited in google using iframes

2692


Code for Creating a Form Using PlaceHolder Controls?

2781


Code for Presenting Parent/Child Data in a Data Grid Row?

2509


Coding for .NET Delegates?

2499


What is the code of Password Recovery or Forget your password? Plz tell in c # language.

3926


i have a gird with columns all are coming from database,this will bind in item templete in gridview as textboxex.and i have button below named Update.i want to update all the records in the grid,but if user change the value of one textbox,what is the easy way 2 do this

2530


How we use ajax in asp.net through javaScript. Please givee me an example.

2944


Code for Document Validation in XML.NET?

2334


How to Bind Nested XML to a Repeater Control with Container.DataItem?

3598


Code for Using Keyboard Events?

2545


how to create a search bar which access data from various websites and retrieves the data

2942


ArrayList declaration in .net

3184


Coding for Synchronizing Cache Access in ASP.NET?

3591


Common UI for Multiple web applications. Suppose there are 35 websites using same third party controls.These 3rd party controls are made together that all 35 websites can use these controls.If we put all 3rd party controls and use its dll in 35 websites,only class files will be accessable. But I want to use CSS,images also in all 35 websites. how I can design the N-tier solution for this project.

2660


How to get Dynamically Linked Comboboxes Set?

2405