rfid 0 Posted August 16, 2007 Report Share Posted August 16, 2007 Viva, Como posso saber quantos registos tem a tabela, em VB2008? O código que uso é: Try cmd.CommandText = "SELECT * FROM Utilizadores Where NomeUtilizador ='" & cboUtilizadores.Text & "'" rsServico = cmd.ExecuteReader rsServico.Read() 'aqui queria a instrução Select Case rsServico.RecordCount (fazia assim em VB6.0) ' Case > 0 cboUtilizadores.Items.Add(rsServico.Item("NomeUtilizador")) 'Case else ' MsgBox("Não há registos", MsgBoxStyle.OkOnly, "Operação cancelada") 'End Select rsServico.Close() Catch ex As Exception MsgBox(ex.Message, MsgBoxStyle.OkOnly, "Falha na Ligação.") End Try Link to post Share on other sites
Asgorath 0 Posted August 16, 2007 Report Share Posted August 16, 2007 Usa o SqlDataReader.HasRows "The Dark Side Clouds Everthing. Impossible To See The Future Is."My rig: Intel Core 2 Quad Q9450 | abit IP35P | 4G Kingston 800 Mhz | XFX GeForce 9800 GX2 1G ddr3 | 2X WD5000AAJS 500Gb Sata 2 | PSU 600W || Caixa El-Diablo | Creative XMod Link to post Share on other sites
rfid 0 Posted August 16, 2007 Author Report Share Posted August 16, 2007 como se faz isso? Obrigado. Link to post Share on other sites
Tiago Salgado 2 Posted August 17, 2007 Report Share Posted August 17, 2007 if rsServico.HasRows then ... end if Link to post Share on other sites
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now