How to populate a datagrid in windows form with the datas from an excel file

 public  void export_datagridview_to_excel(DataGridView dgv, string excel_file)

        {

            int cols;

            //open file

            StreamWriter wr = new StreamWriter(excel_file);



            //determine the number of columns and write columns to file

            cols = dgv.Columns.Count;

            for (int i = 0; i < cols; i++)

            {

                wr.Write(dgv.ColumnsIdea.Name.ToString().ToUpper() + "\t");

            }



            wr.WriteLine();



            //write rows to excel file

            for (int i = 0; i < (dgv.Rows.Count - 1); i++)

            {

                for (int j = 0; j < cols; j++)

                {

                    if (dgv.RowsIdea.Cells[j].Value != null)

                        wr.Write(dgv.RowsIdea.Cells[j].Value + "\t");

                    else

                    {

                        wr.Write("\t");

                    }

                }



                wr.WriteLine();

            }



            //close file

            wr.Close();

        }

  string strPath = @"C:\Test.xls";

            string strXLScon = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strPath + ";Extended Properties=Excel 8.0";

 

            OleDbConnection oledbConn = new OleDbConnection(strXLScon);

            oledbConn.Open();

            OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Sheet1$]", oledbConn);

            OleDbDataAdapter oleda = new OleDbDataAdapter();

            oleda.SelectCommand = cmd;

 

            DataSet ds = new DataSet();

 

            oleda.Fill(ds);

 

            this.dataGridView1.DataSource = ds.Tables[0];

            this.dataGridView1.DataBind();

Thank you for posting at Dotnetfunda
[Administrator]

Thank you for posting at Dotnetfunda
[Administrator]

Thank you for posting at Dotnetfunda
[Administrator]