Executenonquery Connection Property Has Not Been Initialized

Executenonquery Connection Property Has Not Been Initialized. You cannot execute a query against an unopened connection You can always check if the connection is open by checking its State to see if it is Open However I would actually suggest to create the connection on demand but it depends on the code Using a global shared connection object leaves itself open to problems.

“ExecuteNonQuery Connection property has not been initialized when using stored procedures” When I try to run my above code Note that the code above is only a snippet and not the entire project.

ASP.NET ERROR ExecuteNonQuery: Connection property has not

Hi Deepak Welcome to MSDN forum and thanks for your posting! Hope you can learn as well as contributing to our forum! J Now I have proposed a useful answer and will mark it shortly If these won’t do good to your question you could “Unmark As Answer”.

ExecuteNonQuery: Connection propery has not been initialized

ExecuteNonQuery Connection property has not been initialized This could be due to the line in this code OdbcCommand cmd = new OdbcCommand (“INSERT INTO Pictures (UserID picturepath) VALUES (‘” + theUserId + “‘ ‘” + fileuploadpath + “‘)”) Full code { string theUserId = Session [“UserID”]ToString () { OdbcConnection cn = new OdbcConnection.

ExecuteNonQuery: Connection property has not been initialized.

You should pass a connection object to your OleDbCommand constructor ie dgInsertCommand = new OleDbCommand( cn) OR Assign a connection object to your insert command after you initialize oledb command dgInsertCommandConnection=cn Lingaraj Mishra Proposed as answer by Paul P Clement IV.