Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#
i have following code
 
 OdbcCommand Command = MainClass.Conn.CreateCommand();
  Command.Connection = MainClass.Conn;
  
  using (OdbcTransaction transaction = MainClass.Conn.BeginTransaction())
            {
                Command.Transaction = transaction;
                try
                {
                    string saveStOpen = "Insert Statement.. "; \\ This This Is SQL Statement
                    Command.CommandText = saveStOpen;
                    Command.ExecuteNonQuery();
 
                    string saveGRNSub = "Insert Statement.."; \\ This This Is SQL 
                    Command.CommandText = saveGRNSub;
                    Command.ExecuteNonQuery();
 
                    OdbcCommand OpenTemp = new  OdbcCommand("SELECT * FROM GRN_TEMP WHERE (UserName = '" + MainClass.GetComputerName() + "')", MainClass.Conn);
                    OdbcDataAdapter da = new OdbcDataAdapter(OpenTemp);
                    DataTable dt = new DataTable();
                    da.Fill(dt); \\ This Point Genarate An Error 
 
                    if (dt.Rows.Count >0)
                    {
                        MessageBox.Show(dt.Rows.Count.ToString());
                    }
                    
                    
                    //}
                    //readTemp.Dispose();
                    
                    transaction.Commit();
 
at da.Fill(dt);
Generate Error (executereader requires the command to have a transaction )
 
how to avoid this error
 
I highly appreciate in advance
Posted 12-Nov-12 21:47pm
Edited 12-Nov-12 21:54pm
v3
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

You need to set the transaction after setting the connection object in command
 
Check this example
http://msdn.microsoft.com/en-us/library/2k2hy99x%28v=vs.71%29.aspx[^]
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Open the Connection Before Filling the DataTable
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 710
1 OriginalGriff 543
2 Abhinav S 318
3 thatraja 245
4 Tadit Dash 140
0 Sergey Alexandrovich Kryukov 8,322
1 OriginalGriff 4,790
2 Peter Leow 3,784
3 Maciej Los 3,515
4 Er. Puneet Goel 3,107


Advertise | Privacy | Mobile
Web02 | 2.8.140415.2 | Last Updated 13 Nov 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid