Exporting database to excel file

i am exporting database to excel file.

Code as follows,

public partial class _Default : System.Web.UI.Page

{

SqlConnection con ;

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

con== new SqlConnection("Server=(local);initial catalog=Rental;Trusted_Connection=True");

string sql = null;

string data = null;

int i = 0;

int j = 0;

Excel.Application xlapp;

Excel.Workbook xlWorkBook;

Excel.Worksheet xlWorksheet;

object misvalue = System.Reflection.Missing.Value;

xlapp = new Excel.ApplicationClass();

xlWorkBook = xlapp.Workbooks.Add(misvalue);

xlWorksheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

//cnn = new SqlConnection(connectionstring);

con.Open();

sql = "Select * from mis";

SqlDataAdapter da = new SqlDataAdapter(sql, con);

DataSet ds = new DataSet();

da.Fill(ds);

for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)

{

for (j = 0; j <= ds.Tables[0].Columns.Count - 1; j++)

{

data = ds.Tables[0].Rows[i].ItemArray[j].ToString();

xlWorksheet.Cells[i + 1, j + 1] = data;

}

MessageBox.Show("Excel file created , you can find the file E:\\excel.xls ");

}

private void releaseObject(object obj)

{

try

{

System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);

obj = null;

}

catch (Exception ex)

{

obj = null;

MessageBox.Show("Exception Occured while releasing object " + ex.ToString());

}

finally

{

GC.Collect();

}

From the Above Code there is one line called MessageBox.Show("Excel file created , you can find the file E:\\ excel .xls");

when click the button the message shows "Excel file created,you can find the file E:\\ excel .xls.

but when i see the E folder under excel, the excel is not there.what is the mistake in the above code line. please help me.

Thanks,

Rao,

public static DataTable GetDataTableFromExcel(string SourceFilePath) { string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + SourceFilePath + ";" + "Extended Properties=Excel 8.0;"; using (OleDbConnection cn = new OleDbConnection(ConnectionString)) { cn.Open(); DataTable dbSchema = cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); if (dbSchema == null || dbSchema.Rows.Count < 1) { throw new Exception("Error: Could not determine the name of the first worksheet."); } string WorkSheetName = dbSchema.Rows[0]["TABLE_NAME"].ToString(); OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [" + WorkSheetName + "]", cn); DataTable dt = new DataTable(WorkSheetName); da.Fill(dt); return dt; } }