🔒 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,080
Guests online
989
Total visitors
2,069

Forum statistics

Threads
2,274,856
Posts
28,958,885
Members
1,233,461
Latest member
Kdgwapo
Back
Top