narasiman rao

narasiman rao

  • NA
  • 519
  • 768.9k

i am exporting databsae to excel file

Aug 28 2012 5:50 AM

i am exporting databsae to excel file

this is my 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 c:\\csharp.net-informations.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();
            }
        }
    }

In the above code there is one line as follows
 MessageBox.Show("Excel file created , you can find the file c:\\csharp.net-informations.xls");


Whether can i change it as  follows
 MessageBox.Show("Excel file created , you can find the file C: \\ Documents and Settings \\ram\Desktop \\ excel.xls");    (this is the path name where i want to save the record from database to excel)

please help me and send the code.



Answers (1)