public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { Prueba rpt = new Prueba(); rpt.Site = this.Site; return(rpt); }
private void Form1_Load(object sender, EventArgs e) { /*dataGridView1.Columns.Add("PK_Api_codigo", "codigo"); * dataGridView1.Columns.Add("api_descripcion", "name"); * dataGridView1.Columns.Add("FK_Codigo_modulo", "mod"); * dataGridView1.Columns.Add("status", "sta"); * * dataGridView1.Rows.Add("1", "Ramos", "1", "1"); * dataGridView1.Rows.Add("2", "Ramoas", "2", "1"); * dataGridView1.Rows.Add("3", "Ramosb", "1", "1"); * dataGridView1.Rows.Add("4", "Ramosc", "2", "1");*/ DataSet ds = new DataSet(); try { using (var conn = new OdbcConnection("dsn=colchoneria")) { conn.Open(); { using (var cmd = conn.CreateCommand()) { cmd.CommandText = "SELECT * FROM tbl_aplicacion"; OdbcDataAdapter m_datos = new OdbcDataAdapter(cmd); ds = new DataSet(); m_datos.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; } } conn.Close(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } DataTable Dt = new DataTable(); Dt = (DataTable)dataGridView1.DataSource; // Se crea un datatable que contenga los datos del data grid DLL__Reporteador.Visualizador vp = new Visualizador(); Prueba pp = new Prueba(); //vp.generarReporte(Dt, pp); AdministradorDeReportes frm = new AdministradorDeReportes(); frm.getDatosNecesariosParaReportes2(Dt, pp); /*MySqlConnection conexion = new MySqlConnection("Server=localhost; User Id=root; Password='******'; Database=nombre_de_la_BD"); * * ------------------------------------------------- ---- * * Luego en el evento Load del Form carga los datos al DataGridView: * * MySqlDataAdapter da = new MySqlDataAdapter("select * from CLIENTE", conexion); * DataSet ds = new DataSet(); * da.Fill(ds); * dataGridView1.DataSource = ds.Tables[0];*/ }