Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

ExecuteNonQuery: Connection property has not been initialized.

Tarun Kumar 2071 23 Feb 2016

I am getting error "ExecuteNonQuery: Connection property has not been initialized." while executing command in C#.

SqlCommand cmd = new SqlCommand();
                cmd.CommandText = "My Insert Query";
                cmd.ExecuteNonQuery();

Please help

Ask by Tarun Kumar

Updated 23 Feb 2016

1 Answers

Uttam Misra 23 Feb 2016 Accepted Answer

You forgot to assign connection to the SqlCommand, you can use the constructor or property

use following line of code

SqlCommand cmd = new SqlCommand();
                cmd.Connection = con;
                cmd.CommandText = "My Insert Query";
                cmd.ExecuteNonQuery();

MindStick Training

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.