Hierarchy and Image

Hierarchy and Image

Posted by: patrik on 25 July 2023, 6:53 am EST

• 

  patrik

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 25 July 2023, 6:53 am EST

  dtStr = System.Type.GetType("System.String");
  dtInt = System.Type.GetType("System.Int32");
  dbImage = System.Type.GetType("System.Drawing.Image");
  
  myDataSet = new DataSet();
  myDataSet.EnforceConstraints = false;
  
  Level1 = myDataSet.Tables.Add("Level1 ");
  Level1 .Columns.AddRange(new DataColumn[]
  {
  new DataColumn("Image", dbImage),
  new DataColumn("ID", dtInt),
  new DataColumn("Text", dtStr)
  });
  
  Level1 .Rows.Add(new object[] {Properties.Resources.move, 1, "Text" });
  

  I have this code working without image, is it possible with image?

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 26 July 2023, 12:42 am EST

  Hi Patrik,

  You can update the code as shown below to add image type column in a DataTable:

  dtStr = System.Type.GetType("System.String");
  dtInt = System.Type.GetType("System.Int32");
  dbImage = System.Type.GetType("System.Drawing.Image");
  myDataSet = new DataSet();
  myDataSet.EnforceConstraints = false;
  Level1 = myDataSet.Tables.Add("Level1 ");
  Level1.Columns.AddRange(new DataColumn[]
  {
      new DataColumn("Image", typeof(byte[])),
      new DataColumn("ID", dtInt),
      new DataColumn("Text", dtStr)
  });
  Level1.Rows.Add(new object[] { imageToByteArray(Properties.Resources.excel), 1, "Text" });

  public byte[] imageToByteArray(System.Drawing.Image imageIn)
  {
      MemoryStream ms = new MemoryStream();
      imageIn.Save(ms, System.Drawing.Imaging.ImageFormat.Gif);
      return ms.ToArray();
  }

  We have attached a sample application for your reference. Please check ImageColumn.zip

  Thanks & Regards,
  
  Aastha

• 

  patrik

  • Post Options:
  • Link
    Copy

  Posted 26 July 2023, 2:02 am EST

  Thanks.

  This solve the problem.