Torna al Thread

Dim adptSel1 As New OleDbDataAdapter("SELECT * FROM ope_cpp WHERE elemento = '0202008P_'", cnx) Dim dtstPrin As New DataSet Dim tblSel1 As New DataTable cnx.Open() adptSel1.Fill(dtstPrin, "Tbl1") cnx.Close() Dim Col1 As DataColumn = New DataColumn Dim Col2 As DataColumn = New DataColumn With Col1 .ColumnName = "fotoConvEle" .DataType = System.Type.GetType("System.Byte[]") End With dtstPrin.Tables(0).Columns.Add(Col1) For Each i As DataRow In dtstPrin.Tables(0).Rows Dim fsEle As New FileStream(Mod_Var.rootF & "\" & i.Item("elemento") & "\foto\" & i.Item("url_fot").ToString, FileMode.Open) Dim brEle As New BinaryReader(fsEle) i.Item("fotoConvEle") = brEle.ReadBytes(brEle.BaseStream.Length) brEle = Nothing fsEle.Close() fsEle = Nothing Next dtst1.WriteXml(Server.MapPath("./app_data/report.xml")) Dim rpt As New CrystalDecisions.CrystalReports.Engine.ReportDocument rpt.Load(Server.MapPath("./crystalreport.rpt")) rpt.Database.Tables("preview").SetDataSource("dtst1") CrystalReportViewer1.ReportSource = rpt CrystalReportViewer1.DataBind()
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5