title: Howto place data from DataSet to List
body: <p>Im trying to add data in a dataset into a List. This is my function in C#</p>
  
  <pre><code>  public List&lt;ProductsDAL&gt; GetAllProducts(string sqlQuery)
    {
       DataSet dsinsert = GetDataSet(sqlQuery, "tblProducts");
       List&lt;ProductsDAL&gt; bPList = new List&lt;ProductsDAL&gt;();
  ProductsDALforeach (DataRow item in dsinsert.Tables[0].Rows)
       {
         this.Product_ID = item["Product_ID"].ToString();
         this.ProductDescr= item["ProductDescr"].ToString();
         bPList.Add(this);
       }
       return bPList;
    }
  </code></pre>
  
  <p>The result in the dataset is like</p>
  
  <pre><code>column1 - colum2
  A         1 
  B         2
  C         3
  D         4
  </code></pre>
  
  <p>But I think the result in the list is:</p>
  
  <pre><code>column1 - colum2
  D         1 
  D         1
  D         1
  D         1
  </code></pre>
  
  <p>When I insert this set of data into another database I only get this:</p>
  
  <pre><code>column1 - colum2
  D         1 
  </code></pre>
  
  <p>What am I doing wrong in my function ?</p>