forum

Home / DeveloperSection / Forums / ExecuteNonQuery: Connection property has not been initialized.

Ask Question

ExecuteNonQuery: Connection property has not been initialized.

Tarun Kumar 1682 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

c# c#  .net  sql server  sql 
Updated on 23-Feb-2016
Tarun Kumar

Tarun Kumar

Follow

Can you answer this question?

Answer

1 Answers

Uttam Misra

Uttam Misra

23-Feb-2016
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();

Liked By