CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2013
    Posts
    1

    SQL transaction Error

    I am receiving this error message when running the code below

    'The transaction associated with the current connection has completed but has not been disposed. The transaction must be disposed before the connection can be used to execute SQL statements.' occurred when attempting to 'Execute query'


    Code:
    #region Export_Admissions
    
    	[Promote(PromotionTargets.All)]
        [Category("Export")]
        public static void Export_TONAdmissions(EXPORT_TON_Admissions1 myData,TON_Export_Import.Declarations.TON_Export_ImportData LocalData)
        {
    	try{
    		
    		
    		object missing = System.Reflection.Missing.Value;
            object Visible=true;
            object start1 = 0;
            object end1 = 0;
    		
    		
    		string template = @"C:\BPMv9 MailMerge Templates\TON Main Export Template.xlsx";
         	Application Excel = new ApplicationClass();
    		Workbook wb = Excel.Workbooks.Open(template,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing);
    		Microsoft.Office.Interop.Excel.Worksheet mySheet = (Microsoft.Office.Interop.Excel.Worksheet)wb.Sheets["TON_Admissions"];
    					
    		int row;
    		int col;
    		row = 7;
    		col = 1;
    		
    		myData.Dispose();
    		DataSet ds = myData.Read();
    		
    		
    		foreach (DataRow theRow in ds.Tables[0].Rows)
    		{
    							
    			mySheet.Cells[row,1] = theRow["ID"];
    			mySheet.Cells[row,2] = theRow["CourseDataID"];
    			mySheet.Cells[row,3] = theRow["CourseID"];
    			mySheet.Cells[row,4] = theRow["Code"];
    			/*mySheet.Cells[row,5] = theRow["Title"];
    			mySheet.Cells[row,6] = theRow["Year"];
    			mySheet.Cells[row,7] = theRow["StTypeID"];
    			mySheet.Cells[row,8] = theRow["StType"];
    			mySheet.Cells[row,9] = theRow["ProposedTarget1"];
    			mySheet.Cells[row,10] = theRow["ProposedTarget2"];
    			mySheet.Cells[row,11] = theRow["ProposedTarget3"];
    			mySheet.Cells[row,12] = theRow["ActualIntake1"];
    			mySheet.Cells[row,13] = theRow["ActualIntake2"]; 
    			mySheet.Cells[row,14] = theRow["ActualIntake3"];
    			mySheet.Cells[row,15] = theRow["PreviousTarget1"];
    			mySheet.Cells[row,16] = theRow["PreviousTarget2"];
    			mySheet.Cells[row,17] = theRow["PreviousTarget3"];
    			mySheet.Cells[row,18] = theRow["In_Year_Offers"];
    			mySheet.Cells[row,19] = theRow["Intake_Total"];
    			mySheet.Cells[row,20] = theRow["Intake_Clearing"];
    			mySheet.Cells[row,21] = theRow["Intake_Deffered"];
    			mySheet.Cells[row,22] = theRow["Intake_DefferedExpected"];*/		
    					
    			row++;
    		}
    		
    	
    		
    		row = row + 2;
    		//mySheet._Protect("ask4report",missing,missing,missing,missing);
    		Excel.Visible = false;
    		
    		string SaveDir;
    		SaveDir = LocalData.txtFolderName; 
    				
    		wb.SaveCopyAs(@"C:\BPMv9 MailMerge Documents\TON\Main Export\" + SaveDir + "_Export.xlsx");
    		
    		
    		
    		System.Threading.Thread.Sleep(30000);
    		myData.Dispose();
    		Excel.Quit();
    		System.GC.Collect();
    		
    				foreach (Process process in Process.GetProcessesByName("Excel"))
    
               {
    
                   process.Kill();
    
               }
    	}
    	catch {
    		//System.Threading.Thread.Sleep(3000);
    		foreach (Process process in Process.GetProcessesByName("Excel"))
    
               {
    
                   process.Kill();
    
               }}
    
    		
        }
       
    	
    	#endregion Export_Admissions

  2. #2
    Arjay's Avatar
    Arjay is offline Moderator / EX MS MVP Power Poster
    Join Date
    Aug 2004
    Posts
    13,490

    Re: SQL transaction Error

    Where is myData defined?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured