Duvida na class do vb.net
11/09/2006
0
Public Sub Atualizar(ByVal Micro As String, ByVal CPU As String, ByVal HD As String, ByVal Memoria As String, _
ByVal Placavideo As String, ByVal Placamae As String, ByVal Cdrom As String, ByVal Gravador As String, ByVal conexao As String)
Try
Dim conn As New SqlConnection(conexao)
Dim cmd As SqlCommand
Dim sqlBuilder As New System.Text.StringBuilder()
With sqlBuilder
.Append(´UPDATE Micros SET ´)
.Append(´Micro=´´ & Micro & ´´, ´)
.Append(´CPU=´´ & CPU & ´´, ´)
.Append(´HD=´´ & HD & ´´, ´)
.Append(´Memoria=´´ & Memoria & ´´, ´)
.Append(´Placa_video=´´ & Placavideo & ´´, ´)
.Append(´Placamae=´´ & Placamae & ´´, ´)
.Append(´Cdrom=´´ & Cdrom & ´´, ´)
.Append(´Gravador=´´ & Gravador & ´´, ´)
.Append(´Where Micro=´´ & Micro & ´´´) o erro de syntax e nessa linha!!!
End With
conn = New SqlConnection(conexao)
conn.Open()
cmd = New SqlCommand(sqlBuilder.ToString, conn)
cmd.ExecuteNonQuery()
conn.Close()
cmd.Dispose()
conn.Dispose()
Catch err As SqlException
MessageBox.Show(err.Message)
Catch err As Exception
MessageBox.Show(err.Message)
End Try
End Sub
Spirithell
Posts
18/09/2006
Carlosrodrigop
.Append(´Gravador=´´ & Gravador & [color=red:fc534468e8]´´, ´[/color:fc534468e8])
.Append(´Gravador=´´ & Gravador & [color=red:fc534468e8]´´ ´[/color:fc534468e8])
18/09/2006
Spirithell
28/09/2006
Carlosrodrigop
O pessoal precisa participar mais, as vezes parece que só tem eu nesse forum na area de Visual Studio.
Clique aqui para fazer login e interagir na Comunidade :)