forum

Home / DeveloperSection / Forums / ExecuteReader requires an open and available Connection. The connection's current state is closed.

ExecuteReader requires an open and available Connection. The connection's current state is closed.

Tarun Kumar 2316 24-Feb-2016

Hi everyone,

When trying to connect to MSSQL Server I am getting following error

ExecuteReader requires an open and available Connection. The connection's current state is closed.

Please help

c# .net sql server sql

Updated on 24-Feb-2016

Can you answer this question?

Answer

24-Feb-2016

I think you forgot to open your connection.
check following line of code:

if (_conn.State==ConnectionState.Closed)
 _conn.Open();
Happy Coding!!!