guys i’m testing trial Wisej-2.0.28.exe with visual studio 2019 but i get the following errors
Imports System
Imports Wisej.Web
Imports System.Data.SQLite
Public Class Page1
Private Sub ComboBox1_DropDown(sender As Object, e As EventArgs) Handles ComboBox1.DropDown
Dim myconnection As New SQLiteConnection(“Data Source=C:\Users\Samuel\Desktop\Work\DOCTEST Copy.db;Version=3”)
myconnection.Open()
Dim cmd As New SQLiteCommand
cmd.Connection = myconnection
cmd.CommandText = “Select size from DOC”
Dim rdr As SQLite.SQLiteDataReader = cmd.ExecuteReader
Dim dt As New DataTable
dt.Load(rdr)
rdr.Close()
myconnection.Close()
‘AlertBox.Show(“you click down the combobox”)
End Sub
End Class
Severity Code Description Project File Line Suppression State
Error BC30652 Reference required to assembly ‘System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089’ containing the type ‘DbConnection’. Add one to your project. WisejWebPageApplication2 C:\Users\Samuel\source\repos\WisejWebPageApplication2\WisejWebPageApplication2\Page1.vb 8 Active
Error BC30652 Reference required to assembly ‘System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089’ containing the type ‘DbConnection’. Add one to your project. WisejWebPageApplication2 C:\Users\Samuel\source\repos\WisejWebPageApplication2\WisejWebPageApplication2\Page1.vb 9 Active
Error BC30652 Reference required to assembly ‘System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089’ containing the type ‘DbCommand’. Add one to your project. WisejWebPageApplication2 C:\Users\Samuel\source\repos\WisejWebPageApplication2\WisejWebPageApplication2\Page1.vb 12 Active
Error BC30652 Reference required to assembly ‘System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089’ containing the type ‘DbCommand’. Add one to your project. WisejWebPageApplication2 C:\Users\Samuel\source\repos\WisejWebPageApplication2\WisejWebPageApplication2\Page1.vb 14 Active
Error BC30002 Type ‘SQLite.SQLiteDataReader’ is not defined. WisejWebPageApplication2 C:\Users\Samuel\source\repos\WisejWebPageApplication2\WisejWebPageApplication2\Page1.vb 16 Active
Error BC30002 Type ‘DataTable’ is not defined. WisejWebPageApplication2 C:\Users\Samuel\source\repos\WisejWebPageApplication2\WisejWebPageApplication2\Page1.vb 17 Active
Error BC30652 Reference required to assembly ‘System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089’ containing the type ‘DbCommand’. Add one to your project. WisejWebPageApplication2 C:\Users\Samuel\source\repos\WisejWebPageApplication2\WisejWebPageApplication2\Page1.vb 16 Active
Error BC30652 Reference required to assembly ‘System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089’ containing the type ‘DbConnection’. Add one to your project. WisejWebPageApplication2 C:\Users\Samuel\source\repos\WisejWebPageApplication2\WisejWebPageApplication2\Page1.vb 20 Active
I think you need to add System.Data to your project. Wisej has nothing to do with how .NET works. It’s a .NET library. If your setup works without Wisej it also works with Wisej.
Luca,
I have installed System.Data.SQLite.Core and System.Data.SQLite from the nuget.org but i get the same errors. Can you please advise?
You have missing references. It’s not a Wisej related issue. I suggest you use nuget to get the correct sqlite installation.
Please login first to submit.