Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
161
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.40 KB | None | 0 0
  1. Dim Message As String
  2. Dim conn As New SqlConnection
  3. conn.ConnectionString = conexion
  4. Try
  5. Dim comando As New SqlCommand
  6. comando.CommandText = ("INSERT INTO
  7. Dim cn2 As New SqlConnection
  8. 'Dim encontro As String
  9. cn2.ConnectionString = conexion
  10. Dim cmd2 As New SqlCommand()
  11. cmd2.CommandText = "SELECT TOP 1 id FROM Dictamen ORDER BY id DESC "
  12. Label1.Text & "'"
  13. cmd2.Connection = cn2
  14. cn2.Open()
  15. Dim dr As SqlDataReader
  16. dr = cmd2.ExecuteReader
  17. While dr.Read()
  18. encontro = True
  19. Label2.Text() = dr.Item("id").ToString()
  20. End While
  21. Response.Redirect("reportedictamen.aspx?id=" & Label2.Text & "")
  22. End Sub
  23.  
  24. Imports System.Data.SqlClient
  25. Imports System.Data
  26. Imports CrystalDecisions.CrystalReports
  27. Imports CrystalDecisions.CrystalReports.Engine
  28. Imports CrystalDecisions.ReportSource
  29. Imports CrystalDecisions.Shared
  30. Public Class reportedictamen
  31. Inherits System.Web.UI.Page
  32. Dim conexion As String = ConfigurationManager.ConnectionStrings("Dictamen").ConnectionString
  33. Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
  34. Dim ireport As New ReportDocument()
  35. ireport = New CrystalDecisions.CrystalReports.Engine.ReportDocument
  36. Dim iConnectionInfo As ConnectionInfo = New ConnectionInfo()
  37. iConnectionInfo.DatabaseName = "(base de datos)"
  38. iConnectionInfo.UserID = "(Usuario)"
  39. iConnectionInfo.Password = "(Pass)"
  40. iConnectionInfo.ServerName = "(Ip del servidor)"
  41. iConnectionInfo.Type = ConnectionInfoType.SQL
  42. ireport.FileName = "D:sistemasnetDictamenesDictamenesreportesCrystalReport1.rpt"
  43. SetDBLogonForReport(iConnectionInfo, ireport)
  44. ireport.RecordSelectionFormula = "{dictamen.id} = " & Request.QueryString("id") & ""
  45. Me.CrystalReportViewer1.ReportSource = ireport
  46.  
  47. End Sub
  48. Private Sub SetDBLogonForReport(ByVal myConnectionInfo As ConnectionInfo, ByVal myReportDocument As ReportDocument)
  49. 'salto
  50. Dim myTables As Tables = myReportDocument.Database.Tables
  51. '-
  52. For Each myTable As CrystalDecisions.CrystalReports.Engine.Table In myTables
  53. Dim myTableLogonInfo As TableLogOnInfo = myTable.LogOnInfo
  54. myTableLogonInfo.ConnectionInfo = myConnectionInfo
  55. myTable.ApplyLogOnInfo(myTableLogonInfo)
  56. Next
  57. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement