IEnumerable - DataTable Export to Word / Excel / PDF / HTML

Hi try this link
http://www.codeplex.com/Exporter

Export or save data to Excel from C#.net using oledb

In this code create excel file in the desktop and push data to the file from dataset...

import header

using System.Data.OleDb;

//create dataset

Dataset ds=new dataset();

//create connection string

string strconnstring = @"Provider=Microsoft.Jet.OLEDB.4.0;" +

@"Data Source=C:\Users\SabiQ\Desktop\Itemdetails.xls;" +

"Extended Properties= \"Excel 8.0; HDR=YES;\"";

OleDbConnection oconn = new OleDbConnection(strconnstring);

OleDbCommand ocmd = new OleDbCommand("", oconn);

oconn.Open();

foreach (System.Data.DataTable dt in ds.Tables)

{

string valuename = "(";

bool first = true;

foreach (DataColumn dc in dt.Columns)

{

if (!first)

{

//ocmd.CommandText += ",\r\n";

ocmd.CommandText += ",";

valuename += ", ";

}

//ocmd.CommandText += " [" + dc.ColumnName + "] ";

//valuename += " [" + dc.ColumnName + "] ";

ocmd.CommandText += " " + dc.ColumnName + " ";

valuename += " " + dc.ColumnName + " ";

first = false;

}

ocmd.CommandText += ")";

valuename += ")";

bool i = true;

foreach (DataRow dr in dt.Rows)

{

string values = "(";

first = true;

foreach (DataColumn dc in dt.Columns)

{

if (!first)

{

values += ",";

values += "' " + dr[dc] + " '";

//first = false;

}

else

{

//values += ",";

values += "' " + dr[dc] + " '";

first = false;

}

}

values += ")";

if (i)

{

i = false;

ocmd.CommandText = "CREATE TABLE TABLE1( quality Char(15),shade Char(15),designID Char(15),designName Char(15),color Char(15),patternID Char(15),patternColor Char(15),picture Char(15))";

ocmd.ExecuteNonQuery();

}

ocmd.CommandText = "INSERT INTO [TABLE1$]" +

valuename + "VALUES" + values;

ocmd.ExecuteNonQuery();

}

}

vb to c# converter

With the help of this link, we can convert c# code into vb.net and vise versa..

http://converter.telerik.com/