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]code block added[/edit]