🔒 Closed Pahelp po about visual basic & sql , project po namin bali kulang po ako code for search

Status
Not open for further replies.
personal data form for vb and sql database ung code nlng sa search kailangan ko, bali dapat madisplay ung record nila base sa eninput ko na id #, doon ako sa localhost/phpmyadmin gumawa ng database
 
ts. Anong Language ba gamit mo? mahirap mag bigay ng source code kapag hindi alam kung anong language :D

ito sa VB .Net

Code:
 db_Conn.Open()

            SQLSTR = "Select * from tbl_Info where fldIDNumber = '" & txtIDNumber.Text & "'" 'bale yung txtIDNumber.text is a txtbox po.
        
            dbCommand = New OleDbCommand(SQLSTR, db_Conn)
            dbReader = dbCommand.ExecuteReader
            dbReader.Read()

            If dbReader.HasRows Then
               txtIDNumber.text = dbReader.Item(0)
               txtName.text = dbReader.Item(1)
               'dipende sayo TS kung ano mga ilalabas mong data. 
           Else
                MessageBox.Show("ID NUMBER NOT FOUND!", sysMsg, MessageBoxButtons.OK, MessageBoxIcon.Information)
                txtIDNumber.Text = ""
            End If
            db_Conn.Close()
 
Status
Not open for further replies.

About this Thread

  • 4
    Replies
  • 1K
    Views
  • 4
    Participants
Last reply from:
roveglenton123

Trending Topics

Online now

Members online
1,069
Guests online
1,080
Total visitors
2,149

Forum statistics

Threads
2,285,930
Posts
29,034,514
Members
1,217,733
Latest member
redzhubko
Back
Top