Sqlite and wisej

0
0

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

 

  • You must to post comments
0
0

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.

  • You must to post comments
0
0

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 must to post comments
0
0

You have missing references. It’s not a Wisej related issue. I suggest you use nuget to get the correct sqlite installation.

  • You must to post comments
Showing 3 results
Your Answer

Please first to submit.