title: How can I select a row from a datatable using two variable values?
body: <p>Alright, so what I'm attempting to do here, is select from a datatable all the rows that match two variables.  First, I queried a SPList into a datatable. The datatable has two columns, Client ID, and Model Details.  Here's some of the code, so hopefully you can get an idea of what I'm attempting.</p>
  
  <pre><code>//These are contained within a foreach loop, so will be different through each
  //iteration through.
  int iClientID = gdbData.GetClientID(iJobNumberID);
  string strModelDetails = xeApprovalUpdate.GetAttribute("ModelDetails");
  string strClientID = iClientID.ToString()
  //Here my datatable is populated from the sharepoint list I query
  DataTable dtabModelDetails = queryModelDetails(splModelDetails);
  DataRow[] drModelDetails = dtabModelDetails.Select(strClientID, strModelDetails);
  </code></pre>
  
  <p>Seeing as that didn't work, I attempted to do the following select statement:</p>
  
  <pre><code>DataTable dtabModelDetails = queryModelDetails(splModelDetails);
  string strDataExpression = "ClientID = " + strClientID + " AND Title = " + strModelDetails;
  DataRow[] drModelDetails = dtabModelDetails.Select(strDataExpression);
  </code></pre>
  
  <p>Now I'm getting a syntax error for the select statement, but I'm pretty sure my syntax is correct?  Would I get this error if my select statement returned no rows?</p>