什么是用于检查同一文本框中的多个值的查询 [英] what is query for checking multiple values from same textbox

问题描述

我想从一个文本框中输入email_id或user_name

我正在使用此查询，但它仅占用查询的第一个字段，即email_id，user_name
失败

i want to enter either email_id or user_name from one textbox

i am using this query but it is taking only first field from query i.e. email_id it is failed for user_name

string str = "select login_with_email from PROFILE where  email_id='" + txt_login_userid.Text.Trim() + "' OR user_name ='" + txt_login_userid.Text.Trim() + "' and password= ' " + txt_login_pass.Text.Trim()+'" " ;

[edit]添加了代码块[/edit]

[edit]code block added[/edit]

推荐答案

现在只需添加()，即可检查用户是否输入了电子邮件或(具有登录名和密码)，因此，当您正确输入电子邮件和密码时，系统将不允许您登录.<​​br/>

Just add () right now you are checking if user have given email OR (have login and password), so right now when you enter email and password correctly system will not permit you to login.

string str = "select login_with_email from PROFILE where (email_id='" + txt_login_userid.Text.Trim() + "' OR user_name ='" + txt_login_userid.Text.Trim() + "') and password= ' " + txt_login_pass.Text.Trim()+'" " ; 

但是，认真的说，我不想开始指出有多少问题是错误的.至少使用sql参数.

But seriously I don''t want to start pointing how many things is wrong with this. Use sql parameters at least.

这篇关于什么是用于检查同一文本框中的多个值的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！