title: How do I convert nchar to string in C#?
body: <p>Forgive me if this question has already been asked and answered. I just spent some time searching for my question, and I can't seem to find it.</p>
  
  <p>Anyway, I'm working in Visual Studio 2010 and MS SQL Server. I've got the database made and I'm just working on the front end stuff now. Anyway, through my searching, I have seen that nchar is not a C# data type, which is fine, but it won't seem to convert it to a string for me.</p>
  
  <pre><code>Convert.ToString(reader["SerialNum"].ToString().Trim());
  </code></pre>
  
  <p>That's the part that is giving me an error. It's saying "Cannot implicitly convert 'string' to 'int'."</p>
  
  <p>Anyone know a way to get around the whole nchar issue?</p>
  
  <p>Thanks in advance!</p>
  
  <p>Ellie</p>
  
  <p>[EDIT]:
  So here's the whole method... though I don't think anything else in here will really help.</p>
  
  <pre><code>private Row PopulateRow(SqlDataReader pReader)
      {
          Row CurrentRow = new Row();
          CurrentRow.sTransNum = Convert.ToInt32(reader["STransNum"].ToString().Trim());
          CurrentRow.serialNum = Convert.ToString(reader["SerialNum"].ToString().Trim());
          CurrentRow.itemTypeID = Convert.ToInt32(reader["ItemTypeID"].ToString().Trim());
          CurrentRow.fromLocation = Convert.ToInt32(reader["FromLocation"].ToString().Trim());
          CurrentRow.toLocation = Convert.ToInt32(reader["toLocation"].ToString().Trim());
          CurrentRow.units = Convert.ToInt32(reader["Units"].ToString().Trim());
          CurrentRow.serialMoveDate = Convert.ToDateTime(reader["SerialMoveDate"].ToString().Trim());
          CurrentRow.moveTypeID = Convert.ToInt32(reader["MoveTypeID"].ToString().Trim());
          CurrentKey.sTransNum = CurrentRow.sTransNum;
          CurrentRow.CompleteState = "OK";
          return CurrentRow;
      }
  </code></pre>