验证.NET项目中的数据库数据

Question

Im正在数据库表列中搜索85。列值可能包括以下内容"85〃；或"；85〃；或"；852〃；或385〃；或13857或"；85/1"；等等…

"SELECT * FROM FullData where (SYNO LIKE '%" + Z1 + "%' OR SYNO LIKE '%" + Z2 + "%'")

这是我的密码。有人能帮我只得到85或零件吗？或者85是(85/1 85/A等…(

提前感谢

Answer 1

让我们假设这是一个Sql Server数据库。您的代码可能是这样的。

Private Sub Button3_Click(sender As Object, e As EventArgs) Handles Button3.Click
Dim dt = GetFullData("85")
DataGridView1.DataSource = dt
End Sub
Private Function GetFullData(SearchString As String) As DataTable
Dim dt As New DataTable
Dim sql = "Select * FROM FullData where SYNO Like @SearchString;"
Using cn As New SqlConnection(ConStr),
cmd As New SqlCommand(sql, cn)
cmd.Parameters.Add("@SearchString", SqlDbType.VarChar).Value = $"%{SearchString}%"
cn.Open()
Using reader = cmd.ExecuteReader
dt.Load(reader)
End Using
Return dt
End Using
End Function