Hide Expand
Copy Code
Copy Codestring connectionstring = null;
string sql = null;
string data = null;
int i = 0;
int j = 0;
Microsoft.Office.Interop.Excel.Application xlApp;
Microsoft.Office.Interop.Excel.Workbook xlWorkBook;
Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value; xlApp = new Microsoft.Office.Interop.Excel.Application(); xlWorkBook = xlApp.Workbooks.Add(misValue);
xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); connectionstring = "Data Source=(local);Initial Catalog=Report_Database;integrated security=True";
cnn = new SqlConnection(connectionstring); cnn.Open();
sql = "SELECT * FROM Report_Tab";
SqlDataAdapter dscmd = new SqlDataAdapter(sql, cnn); DataSet ds = new DataSet(); dscmd.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;}}xlApp.ActiveWorkbook.SaveCopyAs("C:\\Users\\sajid\\Desktop\\test.xls");xlApp.ActiveWorkbook.Saved = true;xlApp.Quit();releaseObject(xlWorkSheet);releaseObject(xlWorkBook);releaseObject(xlApp);MessageBox.Show("Excel file created , you can find the file D:\\Sam-informations.xls");

Replies
Know the answer? Post it — somebody with the same question will find it here.