Why does it throw a Invalid operation exception?

rick Hussain

hi,
in my method i have the following lines:

 

 try

 { 

   SqlConnection con = new SqlConnection(@"Data Source=ttt100;Initial Catalog=TEV20;Integrated Security=True");
    SqlCommand cmd = new SqlCommand();
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.Connection = con;
 

    SqlTransaction trn = con.BeginTransaction();

}
// there is some code after this...

at the linke where i call BeginTransaction() it throws Invalid Operation exception
the following video shows what is excatly happening: http://www.youtube.com/watch?v=Sc5c40WT89M
thanks

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs16y ago
Just read the error message; I think it is totally clear. It says that the connection is not open (right?); I don't see an open for the connection. The YouTube video took time and if you spent the time looking at the error message, you would save everyone's time. The YouTube video is difficult to watch; the important part is at the end and is shown for just a fraction of a second at the end. It would be more efficient to just post a screen shot showing the exception and possibly the code could be shown separately.
Gomathi Palaniswamy16y ago
Hi friend,

refer the below article.

http://www.dotnetspider.com/resources/4459-How-use-SqlTransaction-object-C.aspx
Rakesh Jha16y ago

I suppose you are missing commandtext property.

SqlConnection con = new SqlConnection(@"server=servername; database=dbname; user id=username; password=password;");
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "procedure"; <---- put your procedure name here
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
SqlTransaction trn = con.BeginTransaction();

hope it will help, also you can change connection string like above given.