用DBDATAADAPTER怎么实现模糊查询？？？？？

[xrxrxr]

[icyer]

什么意思？

[greatree]

DataView带有Filter属性

[Soft21]

大家好啊，不错，我得好好看看书了，不好意思。

[龙腾九霄]

设定关键字，用store procedure ，很容易。。

[seeking_du]

DataTable.Select Method (String, String) [C#]
比如：
dtProducts.Select("ProductName like me%","ProductID");
呵呵。第一个string是相当于where后面的条件。第二个string
是相当于order后面的条件。可惜的是，似乎这个不能做类似于
join或者union的查询

[daehappy]

up!gz!

[congxz]

Private Sub BindData(Optional ByVal myID As String = "")
Dim ds As New DataSet()
Dim ssql As String

If Not Cache("DataSet_LiangJv") Is Nothing And myID = "" Then
ds = CType(Cache("DataSet_LiangJv"), DataSet)
Else
If myID <> "" Then
ssql = "SELECT * FROM JILIANG.JGQJ where FENLEIDAIMA='%" & myID & "%' order by FENLEIDAIMA"
Else
Response.Write("没有分类代码参数")
End If
Dim cn As New OleDb.OleDbConnection("Provider=MSDAORA;Password=1212;User ID=web;Data Source=stcorcle")
Dim Da As New OleDb.OleDbDataAdapter()
Da.SelectCommand = New OleDb.OleDbCommand(ssql, cn)

Da.Fill(ds, "LiangJv")
Cache("DataSet_LiangJv") = ds
cn.Close()
End If
End Sub

[daehappy]

up!gz!