title: Pass Array Parameter in SqlCommand
body: <p>I am trying to pass array parameter to SQL commnd in C# like below, but it does not work. Does anyone meet it before? </p>
  
  <pre><code>string sqlCommand = "SELECT * from TableA WHERE Age IN (@Age)";
  SqlConnection sqlCon = new SqlConnection(connectString);
  SqlCommand sqlComm = new SqlCommand();
  sqlComm.Connection = sqlCon;
  sqlComm.CommandType = System.Data.CommandType.Text;
  sqlComm.CommandText = sqlCommand;
  sqlComm.CommandTimeout = 300;
  sqlComm.Parameters.Add("@Age", SqlDbType.NVarChar);
  StringBuilder sb = new StringBuilder();
  foreach (ListItem item in ddlAge.Items)
  {
       if (item.Selected)
       {
           sb.Append(item.Text + ",");
       }
  }
  
  sqlComm.Parameters["@Age"].Value = sb.ToString().TrimEnd(',');
  </code></pre>