roveglenton123
Fanatic
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

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()