Question

vb.net如何操作sqlite数据库

Try
Dim conn As New System.Data.SQLite.SQLiteConnection(SqliteStr)
Dim cmd As New SQLiteCommand("SELECT * FROM Jinkou", conn)
conn.Open()
Dim ds As New DataSet()
Dim da As New SQLiteDataAdapter(cmd)
da.Fill(ds) ‘在些处报错，报formatException
conn.Close()
dg.DataSource = ds
Dim counts As New Integer
counts = dt.Rows.Count()
lbl合计.Text = "共：【" + counts.ToString() + "】条数据"
Catch ex As SqlException
MsgBox(ex.Message)
Catch ex As Exception
MsgBox(ex.Message) ’异常抛到这里
End Try

求各位大神给出解决方案

Answer 1

sqlite没用过，不过初始化da是new ****DATAadapter(查询语句，conn)这样初始化吧

追问

我那样写是另外一种写法，也行的，

追答

修改一下你的查询语句吧，把列名都加上，应该是某一列的格式有问题吧

修改一下你的查询语句吧，把列名都加上，应该是某一列的格式有问题吧