displaying the contents of excel file in gridview in c# language

Question

hi frnds please explain me how t o view the excel data in grid view in C#lang. regards chiranjeevi

Mahesh Chand · Answer

As you can see from Ankur's code above once you have data from excel to filled in a DataSet/DataTable you can bind using DataSource property of GridView something like this: GridView.DataSource = DataTableReturnedByTheMethod();

Ankur Gupta · Answer

System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(Provider=Microsoft.Jet.OleDb.4.0; Data Source =  + strFileName + ; Extended Properties = \Excel 8.0;HDR=Yes;IMEX=1\;); conn.Open(); string strQuery = SELECT * FROM [ + Table + ]; System.Data.OleDb.OleDbDataAdapter adapter = new System.Data.OleDb.OleDbDataAdapter(strQuery conn); System.Data.DataSet ds = new System.Data.DataSet(); adapter.Fill(ds); return ds.Tables[0];