SELECT simples no banco de dados MySql - VB.NET

1:  Dim ID As Integer  
2:      Using conn As New MySqlConnection("SERVIDOR")  
3:        Using cmd As New MySqlCommand("SELECT nome, idade FROM tabela WHERE idade='18';", conn)  
4:          Try  
5:            conn.Open()  
6:          Catch ex As Exception  
7:            MsgBox("Houve um erro ao abrir uma conexão com o servidor" & vbNewLine & vbNewLine & ex.ToString)  
8:          End Try  
9:          Try  
10:            Using rdr As MySqlDataReader = cmd.ExecuteReader()  
11:              While rdr.Read()  
12:                ID = rdr.Item("vapo_id")  
13:              End While  
14:            End Using  
15:          Catch ex As Exception  
16:            MsgBox("Erro" & vbNewLine & vbNewLine & ex.ToString)  
17:          End Try  
18:        End Using  
19:      End Using  

COMENTE

& Compartilhe

Tweet