Torna al Thread

1° STEP: string percorso = this.lblNomePerc.Text; string cartella = percorso + "\\PlazArch.accdb;Persist Security Info=False;"; string connetionString; OleDbConnection connection; OleDbDataAdapter adapter; DataSet ds = new DataSet(); // string Testo = this.txtFornitore.Text; connetionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + cartella; connection = new OleDbConnection(connetionString); try { connection.Open(); 2° STEP: //Articoli System.Data.OleDb.OleDbDataAdapter cmdArt = new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM Art_Prev_Temp WHERE ID_Ut = " + IDUtente, connection); DataTable objTable = new DataTable(); cmdArt.Fill(objTable); //Destinatario System.Data.OleDb.OleDbDataAdapter cmdDest = new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM Destin_Prev_Temp WHERE ID_Ut = " + IDUtente, connection); DataTable objTableDest = new DataTable(); cmdDest.Fill(objTableDest); //Pagamento System.Data.OleDb.OleDbDataAdapter cmdPag = new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM Pagamento_b_Prev_Temp WHERE ID_Ut = " + IDUtente, connection); DataTable objTablePag = new DataTable(); cmdPag.Fill(objTablePag); //Trasporto System.Data.OleDb.OleDbDataAdapter cmdTrasp = new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM Trasporto_Prev_Temp WHERE ID_Ut = " + IDUtente, connection); DataTable objTableTrasp = new DataTable(); cmdTrasp.Fill(objTableTrasp); //Note System.Data.OleDb.OleDbDataAdapter cmdNote = new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM Note_Prev_Temp WHERE ID_Ut = " + IDUtente, connection); DataTable objTableNote = new DataTable(); cmdNote.Fill(objTableNote); //Formule System.Data.OleDb.OleDbDataAdapter cmdFormula = new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM Apri_Chiudi_Prev_Temp WHERE ID_Ut = " + IDUtente, connection); DataTable objTableFormula = new DataTable(); cmdFormula.Fill(objTableFormula); 3° STEP: string RepPath = Application.StartupPath + "\\Preventivo.rpt"; CrystalDecisions.CrystalReports.Engine.ReportDocument Report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); Report.Load(RepPath); //Alimentazione del report con le tabelle caricate' Report.Database.Tables["Art_Prev_Temp"].SetDataSource(objTable); Report.Database.Tables["Destin_Prev_Temp"].SetDataSource(objTableDest); Report.Database.Tables["Trasporto_Prev_Temp"].SetDataSource(objTableTrasp); Report.Database.Tables["Note_Prev_Temp"].SetDataSource(objTableNote); Report.Database.Tables["Pagamento_b_Prev_Temp"].SetDataSource(objTablePag); Report.Database.Tables["Apri_Chiudi_Prev_Temp"].SetDataSource(objTableFormula); this.crystalReportViewer1.ReportSource = Report; 4°STEP: crystalReportViewer1.Refresh(); connection.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); //Console.WriteLine(ex.Message); // frmConnServer.Show() } }
Copyright © dotNetHell.it 2002-2025
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5