1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
|
Sub CreateRapport(ByVal Requete As String, ByVal TYPEQ As Integer)
Dim myData As New DataSet
Dim cmd As New MySql.Data.MySqlClient.MySqlCommand
Dim myAdapter As New MySql.Data.MySqlClient.MySqlDataAdapter
Dim myReport As New ReportDocument
Dim conn As New MySql.Data.MySqlClient.MySqlConnection("datasource=" + IPDBSERVER + ";username=" + DBLOGIN + ";password=" + DBPASS + ";database=" + DBNAME + "")
Try
conn.Open()
cmd.CommandText = Requete
cmd.Connection = conn
myAdapter.SelectCommand = cmd
myAdapter.Fill(myData)
myData.WriteXml("C:\XML", XmlWriteMode.WriteSchema)
If TYPEQ = 1 Then
myReport.Load(Application.StartupPath + "\modele1.rpt")
ElseIf TYPEQ = 2 Then
myReport.Load(Application.StartupPath + "\modele2.rpt")
ElseIf TYPEQ = 3 Then
myReport.Load(Application.StartupPath + "\modele3.rpt")
End If
myReport.SetDataSource(myData)
MonForm.myViewer.ReportSource = myReport
conn.Close()
MonForm.ShowDialog()
Catch ex As Exception
MessageBox.Show(ex.Message, "Report could not be created", MessageBoxButtons.OK, MessageBoxIcon.Error)
End Try
End Sub |
Partager