Hi sujayanand,

Refer the below article.

Import data from Excel to GridView in ASP.Net

hi dharmendr bro,

As I am using SQLConnection I need of SqlConnection link. I tried to change but in this line I am getting error.

dtExcelSchema = connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

No need to change OLEDB to SQL. You just need to import the namespace System.Data.OleDb.