C#

//Sample result when you query using SQL Server.
----------------------------------------------------------------------------------------------
ProductID   Name	   ProductNumber	MakeFlag	FinishedGoodsFlag	Color
----------------------------------------------------------------------------------------------
317         LL Crankarm    CA-5965              0               1                       Black
318         ML Crankarm    CA-5938              0               1                       Black
319         HL Crankarm    CA-5990              0               1                       Black
320         Chainring      CA-5932              0               1                       Black
---------------------------------------------------------------------------------------------

//lvw = ListView control
     
DataClasses1DataContext db = new DataClasses1DataContext();

DataTable dt = new DataTable();
DataColumn dc = new DataColumn();
DataRow dr;

var products = from p in db.Products
               where p.Color != null
               select p;

#region getHeader
var headers = products.First();
foreach (var columnHeader in headers.GetType().GetProperties())
{
      lvw.Columns.Add(columnHeader.Name);
}
#endregion

ListViewItem lstItem = null;

foreach (var itms in products)
{
    lstItem = new ListViewItem(itms.ProductID.ToString());
    lstItem.SubItems.Add(itms.Name);
    lstItem.SubItems.Add(itms.ProductNumber);
    ..... and so on
}

Bitmap bmp = new Bitmap(stream);
      bmp.Save("c:\\tmp\\stage1.ico"); // save what we have here
      IntPtr Hicon = bmp.GetHicon();
      Icon icon = Icon.FromHandle(Hicon);
      // Looking at stage2.ico gives a different version to stage1.ico
      using (var fs = new FileStream("c:\\tmp\\stage2.ico", FileMode.Create, FileAccess.Write, FileShare.Delete))
      {
        int pgs = icon.Height;
        icon.Save(fs);
      }