public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { Extracciones_CSI rpt = new Extracciones_CSI(); rpt.Site = this.Site; return(rpt); }
private void Form1_Load(object sender, EventArgs e) { // rpt1.DataSourceConnections.Item(0).SetLogon("admin", "admin"); try { Extracciones_CSI rpt = new Extracciones_CSI(); ConnectionInfo myConnectionInfo = new ConnectionInfo(); myConnectionInfo.ServerName = "SVR-SQL"; myConnectionInfo.DatabaseName = "ALMACEN"; myConnectionInfo.UserID = "SA"; myConnectionInfo.Password = "******"; myConnectionInfo.Type = ConnectionInfoType.Query; myConnectionInfo.IntegratedSecurity = false; TableLogOnInfos mytableloginfos = new TableLogOnInfos(); TableLogOnInfos mytableloginfos2 = new TableLogOnInfos(); mytableloginfos = crystalReportViewer1.LogOnInfo; mytableloginfos2 = CRYSTAL.LogOnInfo; foreach (TableLogOnInfo myTableLogOnInfo in mytableloginfos) { myTableLogOnInfo.ConnectionInfo = myConnectionInfo; } foreach (TableLogOnInfo myTableLogOnInfo in mytableloginfos2) { myTableLogOnInfo.ConnectionInfo = myConnectionInfo; } rpt.SetParameterValue(0, 52); } catch (Exception ex) { MessageBox.Show("ERROR:" + ex, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Information); } DataTable datacombo = new DataTable(); DataTable datacombcliente = new DataTable(); TRAERDATOS datos = new TRAERDATOS(); // TODO: This line of code loads data into the 'ALMACENDataSet.EXTRACION_EQUIPO' table. You can move, or remove it, as needed. ///llenar combo begin SqlDataAdapter llenar_combo = datos.llenarcombobodega(); SqlDataAdapter llenarcomobocliente = datos.llenarcliente(); llenar_combo.Fill(datacombo); llenarcomobocliente.Fill(datacombcliente); //COMOBO CLIENTE COMBOCLIENTE.DataSource = datacombcliente; COMBOCLIENTE.DisplayMember = "NOMBRE"; ///COMO BODEGA COMBOBODEGA.DataSource = datacombo; COMBOBODEGA.DisplayMember = "BODEGA"; //COMBOBODEGA.DisplayMember = "NOMBRE"; //llenar como finished //TXTNUMKIT.Text = "0"; TXTCONTADOR.Text = "0"; TXTCANTIDAD.Text = "0"; SqlDataAdapter data = datos.llenargrid(); data.Fill(table); this.DataGrid.DataSource = table; DataGridViewImageColumn img = new DataGridViewImageColumn(); Image image = Extraciones.Properties.Resources.delete; img.Image = image; DataGrid.Columns.Add(img); img.HeaderText = ""; img.Name = "img"; DataGrid.Columns[3].Width = 18; }