CARACTERIZA?ÃO DE UMA STRING
Alguém sabe como se caracteriza uma string, integer eu sei que se caracteriza assim:
Dim sqll As String = [Ô]SELECT * FROM Cad_Cliente where N_Cad =[Ô] & codigo
E texto?
Dim sqll As String = [Ô]SELECT * FROM Cad_Cliente where N_Cad =[Ô] & codigo
E texto?
pois está dando esse erro,
Dim nom As String
nom = Label5.Text
Dim sqlll As String = [Ô]SELECT * FROM Cad_Cliente where N_Cad = [ô][Ô] & nom & [Ô][ô][Ô]
Dim cm2 As New OleDb.OleDbCommand(sqll, dbcon)
Dim dr2 As OleDb.OleDbDataReader
Dim flagg As Boolean
Try
dbcon.Open()
dr2 = cm2.ExecuteReader
If dr2.HasRows Then
While dr2.Read
If dr2.Item([Ô]N_Cad[Ô]) = nom Then
flag = True
Label5.Text = dr2.Item([Ô]Nome[Ô])
End If
End While
End If
If flagg = False Then
End If
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
dbcon.Close()
Dim nom As String
nom = Label5.Text
Dim sqlll As String = [Ô]SELECT * FROM Cad_Cliente where N_Cad = [ô][Ô] & nom & [Ô][ô][Ô]
Dim cm2 As New OleDb.OleDbCommand(sqll, dbcon)
Dim dr2 As OleDb.OleDbDataReader
Dim flagg As Boolean
Try
dbcon.Open()
dr2 = cm2.ExecuteReader
If dr2.HasRows Then
While dr2.Read
If dr2.Item([Ô]N_Cad[Ô]) = nom Then
flag = True
Label5.Text = dr2.Item([Ô]Nome[Ô])
End If
End While
End If
If flagg = False Then
End If
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
dbcon.Close()
Tópico encerrado , respostas não são mais permitidas