I have a working report, binded to a view in a MySQL database. I had to change the view with some extra fields. But in the designer these new fields are invisible. How can I refresh this databinding? My code is like this:
Dim WithEvents LL As New ListLabel
Dim prov As New DbCommandSetDataProvider
Dim Mycmd As New MySqlCommand
Mycmd.Connection = Myconnection
Mycmd.CommandText = "SELECT * FROM MyView WHERE something = true "
prov.AddCommand(Mycmd, “MyView”, “
LL.PreviewControl = Me.ListLabelPreviewControlLlCtl1
LL.AutoProjectFile = “My.lst”
LL.AutoProjectType = LlProject.List
LL.AutoShowSelectFile = True
LL.AutoDestination = LlPrintMode.PreviewControl
Anyone a solution?