本文介绍了我想将数据保存在数据库中,但是如果用户名和密码已经存在,则我想保存数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
用于保存的按钮
Button for saving
Dim objsmem As New BussinesLog.Login If TxtPosmem.Text = "Application_Admin" Then If TxtUser_mem.Text = objsmem.User_nameM And TxtPassmem.Text = objsmem.Passwords Then LitMessage.Text = ("This User_name or password already exists") ElseIf TxtUser_mem.Text <> objsmem.User_nameM And TxtPassmem.Text <> objsmem.Passwords Then objsmem.User_nameM = TxtUser_mem.Text objsmem.Function_id = 1 objsmem.Passwords = TxtPassmem.Text objsmem.Question = DropDownList2.SelectedValue objsmem.Answer = TxtAnsmem.Text objsmem.Position = TxtPosmem.Text objsmem.Save_Mem_Account() MsgBox("Hope it works", MsgBoxStyle.Information, "SAVING>>>>>") End If End If推荐答案
让存储过程对其进行处理,并返回一个值,指示它是重复的用户ID(如果有).密码是否存在真的不重要,仅是用户ID. Let the stored procedure handle it and return a value indicating that it''s a duplicate userID (if it is). It really shouldn''t matter if the password exists or not - just the user ID.
更多推荐
我想将数据保存在数据库中,但是如果用户名和密码已经存在,则我想保存数据
发布评论