错误：语法错误（操作符丢失在'起点="起点"and'终点='终点'),请问怎么回事？错在哪里？

[星星点灯&一路向前]

a: If txtqidian.Text = "" Then txtqidian.Text = "起点"
If txtzhongdian.Text = "" Then txtzhongdian.Text = "终点"

qidian = txtqidian.Text
zhongdian = txtzhongdian.Text

sql_qidian = "起点='" & qidian & "' and "
sql_zhongdian = "终点='" & zhongdian & "'"

If qidian = "起点" Then qidian = ""
If zhongdian = "终点" Then zhongdian = "'"

sql_chaxun = "select * from gongjiaoluxian where " & sql_qidian & sql_zhongdian & "order by 时间权重"

Adodc1.RecordSource = sql_chaxun
Set DataGrid1.DataSource = Adodc1
DataGrid1.Refresh
Adodc1.Refresh
txtcount.Text = DataGrid1.ApproxCount
Exit Sub

[syszj]

If txtqidian.Text = "" Then txtqidian.Text = "起点"
If txtzhongdian.Text = "" Then txtzhongdian.Text = "终点"

qidian = txtqidian.Text
zhongdian = txtzhongdian.Text

If qidian = "起点" Then qidian = ""
If zhongdian = "终点" Then zhongdian = ""

sql_chaxun = "select * from gongjiaoluxian where 起點='" & qidian & "' and 終點='" & zhongdian & "' order by 时间权重"
有一點疑問就是你用到order by,那*代表的是gongjiaoluxian 中所有的字段這樣是不對的.

[chenyu5188]

Adodc1.RecordSource = sql_chaxun
Adodc1.refresh'要刷新一下控件
Set DataGrid1.DataSource = Adodc1
DataGrid1.Refresh
txtcount.Text = DataGrid1.ApproxCount
Exit Sub

[hdj0569]

引号好像不配对