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()
}
}