读书人

大家帮着看一下如何修改总是报一个F

发布时间: 2012-05-16 11:12:12 作者: rapoo

大家帮着看一下怎么修改,总是报一个FROM 子句语法错误
代码
Public Class Form3

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim objConn As New OleDb.OleDbConnection
Dim objDa As New OleDb.OleDbDataAdapter
Dim objComm As New OleDb.OleDbCommand
Dim objDs As New DataSet
Dim WhereStr As String
WhereStr = ""
If TextBox1.Text <> "" Then
WhereStr = "time='" + TextBox1.Text.Trim() + "'"
End If
'设置连接字符串,告诉程序应当如何连接到数据库
objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='C:\seis\seismsys\seismsys\Database\seisys.mdb'"
'设置SQL命令,告诉程序如何取数
objComm.CommandText = "Select xuhao as 序号,time as 时间,result as 结果,station as 台站代码 From tb_result"
If WhereStr <> "" Then
objComm.CommandText = objComm.CommandText & "where" & WhereStr
End If
objComm.Connection = objConn
objDa.SelectCommand = objComm
objConn.Open()
objDa.Fill(objDs, "tb_result")
objConn.Close()
'把DataGridView1的DataSource属性设置为刚刚取到得数据表,这样就可以显示数据
DataGridView1.DataSource = objDs.Tables("tb_result")
End Sub
End Class

[解决办法]
If WhereStr <> "" Then
objComm.CommandText = objComm.CommandText & " where " & WhereStr
End If
是不是Where两边没空格啊?你debug一下这个语句试下。

读书人网 >VB Dotnet

热点推荐