🔒 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,103
Guests online
3,640
Total visitors
4,743

Forum statistics

Threads
2,306,633
Posts
29,173,142
Members
1,193,961
Latest member
Antagonist123
Back
Top