Re: [.NET] 讀取輸入的字來呼叫資料表的資料列
※ 引述《siaujan (...)》之銘言:
恕刪 假設 id name (id int pk)
================
100 jack
101 tommy
pos=101
Sub ShowRecord(ByVal pos As Integer)
Dim objRow As DataRow
objRow = objDataSet.Tables("comicDB").Rows.Find(pos)'id
if not (objRow is nothing) then
'TextBox6.Text = objRow("PW")
TextBox2.Text = objRow("name").tostring 'Get "tommy"
'TextBox3.Text = objRow("性別")
'TextBox4.Text = objRow("聯絡電話")
'TextBox5.Text = objRow("出生日期")
else
'not find
end if
End Sub
--
◢████
█◤By Phill 創新科技,美化人生。
█ ╭══╮═╦╦╮╭══╮╭═╦╮╔══╮╮ ╮═╦╦ ╔══╮
█ █◤ ║╰╦╦ ╠╣ ║╰╦╦╠═╬╣╠═╦╮╰╦╦╯ ╠╣ ╠╣
█◣ ◤█◤║ ╠╣ ╠╣ ║ ╠╣║ ╠╣║ ╠╣ ╠╣ ╠╣ ║╰╔╗
◥██◤ ◤ ╰═╩╯╰╩╩═╰═╩╯╰ ╰╝╚═╩╯ ╰╝ ╚╝ ╚═╩╯
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 220.132.147.250
※ 編輯: Phill 來自: 220.132.147.250 (05/04 12:54)
推
05/04 16:22, , 1F
05/04 16:22, 1F
推
05/04 20:06, , 2F
05/04 20:06, 2F
→
05/05 00:15, , 3F
05/05 00:15, 3F
推
05/05 17:27, , 4F
05/05 17:27, 4F
推
05/06 01:21, , 5F
05/06 01:21, 5F
→
05/06 01:22, , 6F
05/06 01:22, 6F
→
05/06 01:24, , 7F
05/06 01:24, 7F
→
05/06 04:50, , 8F
05/06 04:50, 8F
→
05/06 04:52, , 9F
05/06 04:52, 9F
推
05/06 14:04, , 10F
05/06 14:04, 10F
推
05/06 15:08, , 11F
05/06 15:08, 11F
討論串 (同標題文章)