Import Excel Error: The ConnectionString property has not been initialized

Last Reply 3 months ago By pandeyism

Posted 3 months ago

hello,

Read and Import Excel Sheet into ASP.Net GridView Control

i am using this snippet and it gives error when i click on upload button

please advice

Server Error in '/' Application.
The ConnectionString property has not been initialized.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.InvalidOperationException: The ConnectionString property has not been initialized.

Source Error: 

Line 50: 
Line 51:         //Get the name of First Sheet
Line 52:         connExcel.Open();
Line 53:         DataTable dtExcelSchema;
Line 54:         dtExcelSchema = connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

Source File: c:\Users\Imtiaz\Downloads\ReadExcelToGrid\ReadExcelToGrid\CS.aspx.cs    Line: 52 

 

You are viewing reply posted by: pandeyism 3 months ago.