C#NET2008 DataReader Row Count

[lenniekuah]

Hullo Friends,
I need your help. Please help me.

I am using C#NET3.5. and DataReader.
I am trying to retrieve the Row Count from the DataReader without using WHILE DataReader.READ()

This is the error:
Cannot implicitly convert t' to 'int'. An explicit conversion exists (are you missing a cast?)

Here are the overall coding:

Private Sqlcommand sqlcmd;
Private SqlDataReader DR;
Private sqlconnection sqlconn;
Private string connstr;
 
 
Int intRowCnt = 0;
 
string strSqlDR = "";
  strSqlDR += "Select count(*) from testInvoices ";
  strSqlDR += "Where(CustomerID=n'" + strCustID + "')";
 
Sqlconn = new sqlConnection(connstr);
sqlConn.Open();
sqlCmd = new SqlCommand(strSqlDR,sqlConn);
intRowCnt = sqlCmd.ExecuteScalar(); ----- error