[操作疑難] VB - textbox.text to accdb

X-Engineer

Please help

537923

sql cmd一定錯, 試下改做VALUES (?,?)

X-Engineer

Still the same

z1022

Still the same
X-Engineer 發表於 2019-8-16 13:50

example
https://stackoverflow.com/questi ... t-into-oledb-vb-net

X-Engineer

It successful write into DB if I give only one field and values

z1022

It successful write into DB if I give only one field and values
X-Engineer 發表於 2019-8-16 14:24

try
https://stackoverflow.com/questi ... atabase-using-oledb

X-Engineer

Thanks all, resolved

just add "space" in (?,?)

Solution : (?, ?)

artai

梗係錯啦
您個parameter 都串錯字，留意一下INSERT 裡面個password ，同您放入那個@password有乜分別？

下次佢提你乜，望果度多兩眼。

via HKEPC Reader for Android

faiwaic

Still the same
X-Engineer 發表於 2019-8-16 13:50

    樓主, 對下 db field 名 有冇 username 同 password ...
第二 (?.?) 應該係 (@username, @passwd )

artai

Dim strSQL ="INSERT INTO tablename (username, password) VALUES (@u_name, @p_word)"


....
...Parameters.AddWithValue("@u_name", yourUserName)

...Parameters.AddWithValue("@p_word", yourPassword)