|
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 '%" & @书名 & "%')"
为何不成功呢?
|
|