How to refere a specific month in a database table asp.net

See more:

C#

ASP.NET

Hi!

I am trying to count all the entrys in the table with a specific month, but i don't know how this is my code:

string cmdStr = "select count (*) from tranzactii where COD_CLIENT = '" + Convert.ToInt32(GridView1.SelectedRow.Cells[0].Text) + "' and DATA_TRANZACTIE(Month)='" + luna_precedenta + "'";

SqlCommand VerificaUtilizator = new SqlCommand(cmdStr, conexiune);

...................................................................
DATA_TRANZACTIE - this is my datetime variable in my table and luna_precedenta is the month i want to refere.

Pls can someone help me..

sorry for the bad english