Read the data in the Excel file into the DataGrid

xiaoxiao2021-03-06  53

Using the Excel file as a data source of DataGrid is very simple, once the data is loaded, you can save the data to SQL Server or XML. We only need to simply use Ole DB Provider to access the Excel file, and then return to DataSet.

Below is the Excel Data Contact.xls to display:

Name Gender Address NET_LOVER MALE AMXH@21cn.com Amxh Male Amxh@21cn.com Menciic E Chapter Male AMXH@21cn.com

<% @ Page language = "c #" debug = "true"%> <% @ import name "%> <% @ import name"%> system.data.oledb "%>