Hi,

Im a newbie in C#....I need to send an email with an excel file containing the data from the database....I use select statement to call retrieve the needed data....How would I do the attachment and how would i place the data from the database to an excel file? Sample codes please.....

thank you

You Can place the data from the database to an excel file using Excel.Querytable.

http://support.microsoft.com/?kbid=306023

i had tried the codes in that link that you gave mrbalaji but the problem is i dont have Microsoft Excel 10.0 Object Library or Microsoft Excel 11.0 Object Library in my Add Reference option because i am using windows 2000 OS not windows XP....i only have Microsoft Excel 9.0 Object Library.....so how would i do it? I cannot change OS...cos it very expensive to buy a license one...

Try this way using Excel 9.0 Obejct libary

try
try
{
SqlConnection conn = new SqlConnection("Integrated Security=yes;Initial Catalog=Emp;Data Source=(local)");
conn.Open();

SqlCommand command = new SqlCommand("select * from emp", conn);

SqlDataAdapter adapter = new SqlDataAdapter(command);
DataSet dataset = new DataSet();

adapter.Fill(dataset);


Excel.ApplicationClass excel = new ApplicationClass();

excel.Application.Workbooks.Add(true);

System.Data.DataTable table = dataset.Tables[0];
int ColumnIndex=0;
foreach( System.Data.DataColumn col in table.Columns)
{
ColumnIndex++;
excel.Cells[1,ColumnIndex]=col.ColumnName; } int rowIndex=0;
foreach(DataRow row in table.Rows)
{
rowIndex++;
ColumnIndex=0; foreach(DataColumn col in table.Columns)
  {
 ColumnIndex++;
 excel.Cells[rowIndex+1,ColumnIndex]=row[col.ColumnName];
  }
}

excel.Visible = true;

Worksheet worksheet = (Worksheet)excel.ActiveSheet;

worksheet.Activate();


}
catch (XmlException exml)
{
// catch an xmlexception errors
MessageBox.Show( exml.Message);
}