如何在visual basic 2010中存储密码和日期{} [英] How to store password and date{} in visual basic 2010
本文介绍了如何在visual basic 2010中存储密码和日期{}的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想在visual basic 2010中使用密码和电子邮件ID创建办公应用程序,并联系手机号码,但它的错误是错误插入声明。
请帮我解决这个问题.i已经写了一个dbcontrol.class代码来连接访问detabase并且运行得很好。
yogesh vaidya
我尝试过:
Private Sub saveuserdata()
access.execquery (select * from userdata ORDER BY username ASC)
如果NOTEMPTY(access.exception)则MsgBox(access.exception):退出Sub
'添加参数
'添加参数
access.addparam(@ usernm,Textusername.Text)
access.addparam(@ pass,txtpassword.Text)
access.addparam(@ fnm,txtfirstname.Text)
access.addparam(@ lnm,txtlastname.Text)
access.addparam(@ email,txtemail.Text)
access.addparam(@ cont,txtcontact.Text)
access.execquery(插入a_sbupdate(用户名,[密码],名字,姓氏,电子邮件,mobaile_no)& _
值(@ usernm,@ pass,@ fnm,@ lnm,@ email,@ cont);)
如果不是String.IsNullOrEmpty(access.exception)那么MsgBox( access.exception):退出Sub
MsgBox(USER ADDED SUCCESSFULY !!!,登录更多...)
Me.Close()
Form1.Show()
解决方案
不要以明文形式存储密码;请阅读简单解释安全密码验证 [ ^ ]。
列名:电子邮件无效,因为连字符是操作员。
我将其更改为电子邮件,但您可以将其括起来:[电子邮件]
i want create office application in visual basic 2010 with password and email id and contact mobile no , but it's split a err that " err in insert into " statement .
please help me to solves this.i was already write a dbcontrol.class code to connect access detabase and it run a perfectly.
yogesh vaidya
What I have tried:
Private Sub saveuserdata() access.execquery("select * from userdata ORDER BY username ASC") If NOTEMPTY(access.exception) Then MsgBox(access.exception) : Exit Sub 'Add parameter 'Add parameter access.addparam("@usernm", Textusername.Text) access.addparam("@pass", txtpassword.Text) access.addparam("@fnm", txtfirstname.Text) access.addparam("@lnm", txtlastname.Text) access.addparam("@email", txtemail.Text) access.addparam("@cont", txtcontact.Text) access.execquery("insert into a_sbupdate (username,[password],firstname,lastname,e-mail,mobaile_no) " & _ "values(@usernm,@pass,@fnm,@lnm,@email,@cont); ") If Not String.IsNullOrEmpty(access.exception) Then MsgBox(access.exception) : Exit Sub MsgBox("USER ADDED SUCCESSFULY !!! ,LOGIN TO PROSIDE MORE... ") Me.Close() Form1.Show()
解决方案
Do not store passwords in clear text; please read Secure Password Authentication Explained Simply[^].
Column name: "e-mail" is not valid as hyphen is an operator.
I'd change it to "Email", but you could just bracket it: "[e-mail]"
这篇关于如何在visual basic 2010中存储密码和日期{}的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文