Load Data From Excel To Grid View in Asp.net C#

[@kunnudev7250]

Great thanks

[@BANSODETECHSOLUTION]

You are welcome.

[@prembaboo324]

hello sir, oledb connection error occur in program, kindly give some hints how it will be solver about "System.InvalidOperationException: 'The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.'"

[@BANSODETECHSOLUTION]

Dm me on WhatsApp [phone]

[@nisargay8834]

Is this issue resolved?

[@BANSODETECHSOLUTION]

Yes

[@BANSODETECHSOLUTION]

string conStr = "";
switch (extenion)
{
case ".xls": //Excel 97-03
conStr = ConfigurationManager.ConnectionStrings["Excel03ConString"].ConnectionString;
break;
case ".xlsx": //Excel 07
conStr = ConfigurationManager.ConnectionStrings["Excel07ConString"].ConnectionString;
break;
}
Make correction in connection string

[@BANSODETECHSOLUTION]

Their is simple error of Connection string is incorrect of OLEDB Connection..
kindly check it