If IsNumeric(Text1.Text) Then
clienteadodc.CommandType = adCmdText
clienteadodc.RecordSource = "Select * from Clientes where codcliente =" + Text1.Text
Else
MsgBox "Erro, coloque um valor númerico por favor.", , "Erro..."
End If
If IsNumeric(MaskEdBox3.Text) Then
clienteadodc.CommandType = adCmdText
clienteadodc.RecordSource = "Select * from Clientes where bicliente =" + MaskEdBox3.Text
Else
MsgBox "Erro, coloque um valor númerico por favor.", , "Erro..."
End If
If IsNumeric(MaskEdBox2.Text) Then
clienteadodc.CommandType = adCmdText
clienteadodc.RecordSource = "Select * from Clientes where nifcliente =" + MaskEdBox2.Text
Else
MsgBox "Erro, coloque um valor númerico por favor.", , "Erro..."
End If
If IsNumeric(MaskEdBox5.Text) Then
clienteadodc.CommandType = adCmdText
clienteadodc.RecordSource = "Select * from Clientes where telefonecliente =" + MaskEdBox5.Text
Else
MsgBox "Erro, coloque um valor númerico por favor.", , "Erro..."
End If
If IsDate(MaskEdBox1.Text) Then
clienteadodc.CommandType = adCmdText
clienteadodc.RecordSource = "Select * from cliente where datanascimento=#" + MaskEdBox1.Text + "#"
Else
MsgBox "Erro, coloque uma data correcta por favor.", , "Erro..."
End If
clienteadodc.CommandType = adCmdText
clienteadodc.RecordSource = "Select * from Cliente where cpcliente like '" + MaskEdBox4.Text + "%'"
clienteadodc.CommandType = adCmdText
clienteadodc.RecordSource = "Select * from Cliente where localidadecliente like '" + text2.Text + "%'"
clienteadodc.CommandType = adCmdText
clienteadodc.RecordSource = "Select * from cliente where moradacliente like '" + text6.Text + "%'"
clienteadodc.CommandType = adCmdText
clienteadodc.RecordSource = "Select * from cliente where mailcliente like '" + text3.Text + "%'"
clienteadodc.CommandType = adCmdText
clienteadodc.RecordSource = "Select * from cliente where nomecliente like '" + text1.Text + "%'"