Question

用户代码未处理 System.Data.SqlClient.SqlException 列名 '%线%' 无效。

Imports System
Imports System.Collections.Generic
Imports System.Linq
Imports System.Web
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Data.SqlClient

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
GridView1.Visible = True
Label1.Visible = False
Dim cxt As String
Dim cxnr As String
cxnr = TextBox1.Text
Select Case DropDownList1.Text
Case "名称"
cxt = "名称"
Case "类型"
cxt = "类型"
Case "地点"
cxt = "存放地点"
Case "具体位置"
cxt = "具体位置"
End Select
If DropDownList1.Text <> "查询全部数据" Then
If cxnr = "" Then
MsgBox("请输入查询条件！")
Else
Dim conn As SqlConnection = New SqlConnection(connster)
conn.Open()
Dim sqlstr As String = "SELECT * FROM haocai WHERE " + cxt + " LIKE " + Chr(34) + "%" + cxnr + "%" + Chr(34)
Dim cmd As SqlCommand = New SqlCommand(sqlstr, conn)
If (cmd.ExecuteScalar <> Nothing) Then
Dim dr As SqlDataReader = cmd.ExecuteReader()

GridView1.DataSource = dr
GridView1.DataBind()
dr.Close()
Else
GridView1.Visible = False
Label1.Visible = True
End If
End If

Answer 1

"SELECT * FROM haocai WHERE " + cxt + " LIKE " + Chr(34) + "%" + cxnr + "%" + Chr(34)
虽然不懂VB，但是，拼接的有问题