Click here to Skip to main content
12,817,318 members (36,247 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: VB SQL ADO.NET Access VB.NET
I'm trying to get a record by using the Id from the client but it keeps telling me no record found

here is the code:

Private Sub btnBuscar_Click(sender As Object, e As EventArgs) Handles btnBuscar.Click
        Try
           
            Dim str As String ' str = string "string"
            str = "SELECT * FROM tblClientes WHERE (NumId = " & txtNumID.Text & ")"
            'Instruccion de SQL
            Dim comando As OleDbCommand = New OleDbCommand(str, miConeccion)
            dataReader = comando.ExecuteReader
            While dataReader.Read()
                txtNombre.Text = dataReader("Nombre").ToString
                txtApe.Text = dataReader("Apellido").ToString
                txtCiudad.Text = dataReader("Ciudad").ToString
                txtNumT.Text = dataReader("Telefono").ToString
                txtSS.Text = dataReader("Seguro Social").ToString
                txtZipCode.Text = dataReader("ZipCode").ToString
            End While

        Catch ex As Exception
            'mensaje en caso de error;
            MsgBox("No se encontro la informacion")
        End Try
        miConeccion.Close()
    End Sub

I'm not used to VB most of the time I use C# and I do not know if it's a bracket thing or something else, Thank You
Posted 23-Feb-13 22:54pm

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

If it is saying that no records are found, it is because there are no records where the NumId batch the text you typed in the text box. Check your data - both the text box content and the database.

And don't do it like that!
Do not concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Use Parametrized queries instead.


[edit]
If what you mean is that you get the message box saying "No se encontro la informacion", then you need to look at the exception detail, either by adding it to the message box text, or by looking with the debugger - we can't give accurate advice if we don't know what it is complaining about!
[/edit]
  Permalink  
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.170308.1 | Last Updated 24 Feb 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100