Using multiple Parameters after WHERE in SELECT query

Question

I'm trying to avoid populating a table and using multiple queries and statements to select a specific ID representing a Holiday from a DataGridView.

Is what I'm trying to do even possible?

The code I've got so far is as follows :

string HolidayIDQuery = "SELECT ID FROM [Holiday] WHERE PayrollNo=@PayrollNo + StartDate=@StartDate + EndDate=@EndDate"; 
OleDbCommand GetHolID = new OleDbCommand(HolidayIDQuery, conn);
GetHolID.Parameters.AddWithValue("@PayrollNo", GotPayroll);
GetHolID.Parameters.AddWithValue("@StartDate", OleDbType.Date).Value = Convert.ToDateTime(dataGridView1.Rows[LineIndex].Cells[1].Value);
GetHolID.Parameters.AddWithValue("@EndDate", OleDbType.Date).Value = Convert.ToDateTime(dataGridView1.Rows[LineIndex].Cells[2].Value);
int HolID = Convert.ToInt32(GetHolID.ExecuteScalar());

I get this Error on the bottom line.

Exception thrown: 'System.Data.OleDb.OleDbException' in System.Data.dll

Additional information: Data type mismatch in criteria expression.

Use and instead of +!

Salah Akbari
– Salah Akbari

2016-03-15 11:26:37 +00:00
Commented Mar 15, 2016 at 11:26 — Salah Akbari
– Salah Akbari, Commented Mar 15, 2016 at 11:26
+ is not the same as AND

user1666620
– user1666620

2016-03-15 11:27:26 +00:00
Commented Mar 15, 2016 at 11:27 — user1666620
– user1666620, Commented Mar 15, 2016 at 11:27

mikeb · Accepted Answer · 2016-03-15 11:31:23Z

4

You can use AND in your WHERE clause:

WHERE PayrollNo=@PayrollNo AND StartDate=@StartDate AND EndDate=@EndDate;

You might also want to try an SQL tutorial: https://www.google.com/webhp?q=sql%20tutorial

edited Mar 15, 2016 at 11:31

answered Mar 15, 2016 at 11:27

mikeb

11.5k9 gold badges73 silver badges135 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user1666620 Over a year ago

i'm not sure why this was downvoted - can the downvoter explain?

Josh Over a year ago

Cheers everyone! Can't believe I didn't try this! Thanks! EDIT: I'll be marking this as an answer as soon as I am able

vc 74 · Accepted Answer · 2016-03-15 11:48:53Z

1

Seems to be an error in your query. Instead of

SELECT ID 
FROM [Holiday] 
WHERE PayrollNo=@PayrollNo + StartDate=@StartDate + EndDate=@EndDate

try this:

SELECT ID FROM [Holiday] 
WHERE PayrollNo=@PayrollNo 
      AND StartDate=@StartDate 
      AND EndDate=@EndDate"

edited Mar 15, 2016 at 11:48

vc 74

38.3k7 gold badges80 silver badges96 bronze badges

answered Mar 15, 2016 at 11:28

Bigjim

2,27522 silver badges20 bronze badges

1 Comment

Josh Over a year ago

Thank you, I've done this and it works great! Can't believe I hadn't tried this yet!

Collectives™ on Stack Overflow

Using multiple Parameters after WHERE in SELECT query

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related