|
|||||||
|
|
|
![]() |
|
|
Strumenti |
|
|
#1 |
|
Senior Member
Iscritto dal: Sep 2004
Messaggi: 3967
|
[VB.Net + Access]Problema filtro dati e like
Ciao a tutti
ecco il codice incriminato: Codice:
Try
Dim db As New DbClass
db.OpenConnection()
Dim adapter As New OleDb.OleDbDataAdapter
Dim sSql As String = "SELECT t1.Valore, t1.Colore FROM tabella as t1 " & _
"WHERE @parametro1 LIKE @parametro2"
Dim selectCommand As New OleDb.OleDbCommand(sSql, db.ActiveConnection)
adapter.SelectCommand = selectCommand
selectCommand.Parameters.Add(New OleDb.OleDbParameter("@parametro1", OleDb.OleDbType.VarChar).Value = txtValore.Text)
selectCommand.Parameters.Add(New OleDb.OleDbParameter("@parametro2", OleDb.OleDbType.VarChar).Value = txtColore.Text)
Dim ds As New DataSet
adapter.Fill(ds, "table")
Dim bs As New BindingSource
bs.DataSource = ds.Tables("table")
bNav.BindingSource = bs
dgView.AutoGenerateColumns = False
dgView.DataSource = bs
GridProperty()
db.ActiveConnection.Close()
Catch ex As Exception
End Try
__________________
Dai wafer di silicio nasce: LoHacker... il primo biscotto Geek
|
|
|
|
|
| Strumenti | |
|
|
Tutti gli orari sono GMT +1. Ora sono le: 20:54.



















