title: Error in creating a list with SqlParameter as type
body: <p>To build a dynamic query I am writing some code like this</p>
  
  <pre><code>StringBuilder sql = new StringBuilder();
     sql.Append("SELECT ... all your columns ... FROM yourTable");
     List&lt;SqlParameter&gt; parameters = new List&lt;SqlParameter&gt;(); 
     if (!string.IsNullOrEmpty(paraCategory))
           {
          sql.Append("[Category]=@Category,");
           parameters.AddWithvalue("@Category", paraCategory);
           }
     sql.Length -= 1;
     sql.Append("ORDER BY CreatedDate");
     ds = SqlHelper.ExecuteDataset(GlobalSettings.DbDSN, CommandType.Text, sql.ToString(), parameters);
  </code></pre>
  
  <p>Now it throws an error like this</p>
  
  <pre><code>Error   1   'System.Collections.Generic.List&lt;System.Data.SqlClient.SqlParameter&gt;' does not contain a definition for 'AddWithvalue' and no extension method 'AddWithvalue' accepting a first argument of type 'System.Collections.Generic.List&lt;System.Data.SqlClient.SqlParameter&gt;' could be found (are you missing a using directive or an assembly reference?)
  Error   2   The best overloaded method match for 'Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(string, System.Data.CommandType, string, params System.Data.SqlClient.SqlParameter[])' has some invalid arguments   
  Error   3   Argument 4: cannot convert from 'System.Collections.Generic.List&lt;System.Data.SqlClient.SqlParameter&gt;' to 'System.Data.SqlClient.SqlParameter[]' 
  </code></pre>
  
  <p>I am not sure what I need to do now..please lend a hand/</p>