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

Please help

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

TOP

Still the same

TOP

本帖最後由 z1022 於 2019-8-16 14:14 編輯
Still the same
X-Engineer 發表於 2019-8-16 13:50

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

TOP

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

TOP

本帖最後由 z1022 於 2019-8-16 14:49 編輯
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

TOP

Thanks all, resolved

just add "space" in (?,?)

Solution : (?, ?)

TOP

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

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

via HKEPC Reader for Android

TOP

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



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

TOP

本帖最後由 artai 於 2019-8-24 16:54 編輯

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


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

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

TOP