01.
Dim
xcmd
As
OleDbCommand =
New
OleDbCommand(
"SELECT * FROM Type WHERE TypeID="
& txtTypeID.Text &
""
, xconn)
02.
xrec = xcmd.ExecuteReader()
03.
If
xrec.Read
Then
04.
txtTypeID.Text = xrec.Item(
"TypeID"
)
05.
txtTypeName.Text = xrec.Item(
"TypeName"
)
06.
Else
07.
txtTypeID.Text =
" "
08.
txtTypeName.Text =
""
09.
10.
MsgBox(
"ไม่พบข้อมูล"
)
11.
12.
End
If