sql - Database not Updating 1000 -
hi heres code has no errors when check database nothing added
private sub button4_click(byval sender system.object, byval e system.eventargs) handles create_btn.click call getconnect() if new_username.text = "" , new_password.text = "" , new_pass_code.text = "" msgbox("check empty textbox or wrong admin password", msgboxstyle.critical, "needed") else con.open() sql = "insert accounts (username, password, pass_code) values('" _ & new_username.text & "','" _ & new_password.text & "' , '" _ & new_pass_code.text & "')" dim sqlcomd new sqlclient.sqlcommand sqlcomd.commandtext = sql sqlcomd.connection = con sql = sqlcomd.executenonquery msgbox("data saved") con.close() end if
try check connection string. data might saving database.
Comments
Post a Comment