ASP.net中如何做到模糊查询

yodong

Function MyQueryMethod(ByVal 书名 As String) As System.Data.DataSet

        Dim connectionString As String = "server='abc'; user id='sa'; password='95916rodong'; Database='books'"

        Dim sqlConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connectionString)

        Dim queryString As String = "SELECT [书籍].* FROM [书籍] WHERE ([书籍].[书名] = @书名)"

        Dim sqlCommand As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(queryString, sqlConnection)

        sqlCommand.Parameters.Add("@书名", System.Data.SqlDbType.NVarChar).Value = 书名

        Dim dataAdapter As System.Data.SqlClient.SqlDataAdapter = New System.Data.SqlClient.SqlDataAdapter(sqlCommand)

        Dim dataSet As System.Data.DataSet = New System.Data.DataSet

        dataAdapter.Fill(dataSet)

        Return dataSet

    End Function' Insert page code here

'

Sub Button1_Click(sender As Object, e As EventArgs)

DataGrid1.DataSource=MyQueryMethod(TextBox1.Text)

DataGrid1.DataBind()

End Sub

===========

上面是向导写的SQL语句,开发工具是web  matrax

我想改为模糊查询:

Dim queryString As String = "SELECT [书籍].* FROM [书籍] WHERE ([书籍].[书名] like '%" &  @书名 & "%')"

为何不成功呢?

cg1

已经在 CSDN 回答你了