Export table data from database to excel sheet

Question

Plz view the following code and fine the error in it and I also added the required references in the project but still showing the error and also plz help me how to export to pdf file also

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Data.SqlClient;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using Microsoft.Office.Interop.Excel;

//Program for Displaying details of an Employee based on the Selection of Employee Id

namespace ComboBoxDemo

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

        private void Form1_Load(object sender, EventArgs e)

        {

            // TODO: This line of code loads data into the 'adityaDataSet1.EmpTable' table. You can move, or remove it, as needed.

            this.empTableTableAdapter.Fill(this.adityaDataSet1.EmpTable);

            // TODO: This line of code loads data into the 'adityaDataSet.EmpLogin' table. You can move, or remove it, as needed.

            this.empLoginTableAdapter.Fill(this.adityaDataSet.EmpLogin);

            comboBox1.Text = "";

            SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=Aditya;User ID=sa;Password=123");

            con.Open();

            SqlCommand cmd = new SqlCommand();

            cmd = con.CreateCommand();

            cmd.CommandType = CommandType.Text;

            cmd.CommandText = "select EmpId from EmpTable";

            SqlDataAdapter dto = new SqlDataAdapter(cmd);

            DataSet ds = new DataSet();

            dto.Fill(ds, "EmpTable");

            comboBox1.DataSource = ds.Tables["EmpTable"];

            comboBox1.DisplayMember = "EmpId";

            comboBox1.ValueMember = "EmpId";

            con.Close();

        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)

        {

            comboBox2.Text = "";

            SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=Aditya;User ID=sa;Password=123");

            con.Open();

            SqlCommand cmd = new SqlCommand();

            cmd = con.CreateCommand();

            cmd.CommandType = CommandType.Text;

            cmd.CommandText = "select EmpName from EmpTable where EmpId='" + comboBox1.SelectedValue + " ' ";

            SqlDataAdapter da = new SqlDataAdapter(cmd);

            DataSet ds = new DataSet();

            da.Fill(ds, "EmpTable");

            comboBox2.DataSource = ds.Tables["EmpTable"];

            comboBox2.DisplayMember = "EmpName";

            comboBox2.ValueMember = "EmpName";

            con.Close();

        }

        private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)

        {

            comboBox3.Text = "";

            SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=Aditya;User ID=sa;Password=123");

            con.Open();

            SqlCommand cmd = new SqlCommand();

            cmd = con.CreateCommand();

            cmd.CommandType = CommandType.Text;

            cmd.CommandText = "select Location from EmpTable where EmpId='" + comboBox1.SelectedValue + " ' ";

            SqlDataAdapter adap = new SqlDataAdapter(cmd);

            DataSet ds = new DataSet();

            adap.Fill(ds, "EmpTable");

            comboBox3.DataSource = ds.Tables["EmpTable"];

            comboBox3.DisplayMember = "Location";

            comboBox3.ValueMember = "Location";

            con.Close();

        }

        private void comboBox3_SelectedIndexChanged(object sender, EventArgs e)

        {

            comboBox4.Text = "";

            SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=Aditya;User ID=sa;Password=123");

            con.Open();

            SqlCommand cmd = new SqlCommand();

            cmd = con.CreateCommand();

            cmd.CommandType = CommandType.Text;

            cmd.CommandText = "select Salary from EmpTable where EmpId='" + comboBox1.SelectedValue + " ' ";

            SqlDataAdapter adap = new SqlDataAdapter(cmd);

            DataSet ds = new DataSet();

            adap.Fill(ds, "EmpTable");

            comboBox4.DataSource = ds.Tables["EmpTable"];

            comboBox4.DisplayMember = "Salary";

            comboBox4.ValueMember = "Salary";

            con.Close();

        }

        private void button1_Click(object sender, EventArgs e)

        {

          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);

            xlWorkSheet=(Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

            int i = 0;

            int j = 0;

            for (i = 0; i <= dataGridView1.RowCount - 1; i++)

            {

                for (j = 0; j <= dataGridView1.ColumnCount - 1; j++)

                {

                    DataGridViewCell cell = dataGridView1[j, i];

                    xlWorkSheet.Cells[i + 1, j + 1] = cell.Value;

                }

            }

            xlWorkBook.SaveAs("csharp.net-informations.xls", Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);

            xlWorkBook.Close(true, misValue, misValue);

            xlApp.Quit();

            releaseObject(xlWorkSheet);

            releaseObject(xlWorkBook);

            releaseObject(xlApp);

            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();

            }

        }

           

        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)

        {

        }

    }

}