---
title: "select Query with AND Condition"  
description: "select Query with AND Condition"  
author: "Anonymous User"  
published: 2014-11-27  
updated: 2014-11-28  
canonical: https://www.mindstick.com/forum/12711/select-query-with-and-condition  
category: "asp.net"  
tags: ["database"]  
reading_time: 1 minute  

---

# select Query with AND Condition

I want to [select](https://www.mindstick.com/forum/160534/orderby-then-select-vs-select-then-orderby-performance) [user](https://www.mindstick.com/articles/13001/multi-statement-table-valued-user-defined-function-in-sql-server) but i cant get it . Here's my [query](https://www.mindstick.com/blog/202/sub-query-in-sqlserver)

```
        SqlCommand myCommand = new SqlCommand("Select * from Users where Email=" + UserEmailPass.Email + "And Password=" + UserEmailPass.Password, conn);        SqlDataReader Detailsreader = myCommand.ExecuteReader();
```

Is my query correct or not>? please help

## Replies

### Reply by Anonymous User

SqlCommand myCommand = new SqlCommand("Select * from Users where Email=@mail and Password@pass" , conn);

System.Data.SqlClient.SqlParameter par = new System.Data.SqlClient.SqlParameter("@mail", UserEmailPass.Email );

System.Data.SqlClient.SqlParameter par1 = new System.Data.SqlClient.SqlParameter("@pass", UserEmailPass.Password);

myCommand.Parameters.Add(par);

myCommand.Parameters.Add(par1);

SqlDataReader Detailsreader = myCommand.ExecuteReader();

DO NOT USE string concat!!!!


---

Original Source: https://www.mindstick.com/forum/12711/select-query-with-and-condition

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.