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;
}
