Why does it throw a Invalid operation exception?

Question

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

Sam Hobbs · Answer

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 Palaniswamy · Answer

Hi friend, refer the below article. http://www.dotnetspider.com/resources/4459-How-use-SqlTransaction-object-C.aspx

Rakesh Jha · Answer

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" ; cmd. CommandType = CommandType .StoredProcedure; cmd.Connection = con; SqlTransaction trn = con.BeginTransaction(); hope it will help, also you can change connection string like above given.

Why does it throw a Invalid operation exception?

Answers (3)