| 	
	
	
		
		|||||||
  | 
		
| 
 | 
![]()  | 
	
	
| 
		 | 
	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: 14:23.









		
		
		
		
			
 
 







