Office中国论坛/Access中国论坛

标题: ASP.net中如何做到模糊查询 [打印本页]

作者: yodong 时间: 2004-12-11 23:37
标题: ASP.net中如何做到模糊查询
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 时间: 2004-12-22 01:50
已经在 CSDN 回答你了

欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/)