Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>After much gnashing of teeth and pulling of hair, I was able to come up with a workable solution. It seems there is some undocumented strangeness going on under the covers with .NET and its OLE drag and drop support. It appears to be trying to use .NET remoting when performing drag and drop between .NET applications, but is this documented anywhere? No, I don't think it is. </p> <p>So the solution I came up with involves a helper class to help marshal the bitmap data between processes. First, here is the class.</p> <pre><code>[Serializable] public class BitmapTransfer { private byte[] buffer; private PixelFormat pixelFormat; private Size size; private float dpiX; private float dpiY; public BitmapTransfer(Bitmap source) { this.pixelFormat = source.PixelFormat; this.size = source.Size; this.dpiX = source.HorizontalResolution; this.dpiY = source.VerticalResolution; BitmapData bitmapData = source.LockBits( new Rectangle(new Point(0, 0), source.Size), ImageLockMode.ReadOnly, source.PixelFormat); IntPtr ptr = bitmapData.Scan0; int bufferSize = bitmapData.Stride * bitmapData.Height; this.buffer = new byte[bufferSize]; System.Runtime.InteropServices.Marshal.Copy(ptr, buffer, 0, bufferSize); source.UnlockBits(bitmapData); } public Bitmap ToBitmap() { Bitmap bitmap = new Bitmap( this.size.Width, this.size.Height, this.pixelFormat); bitmap.SetResolution(this.dpiX, this.dpiY); BitmapData bitmapData = bitmap.LockBits( new Rectangle(new Point(0, 0), bitmap.Size), ImageLockMode.WriteOnly, bitmap.PixelFormat); IntPtr ptr = bitmapData.Scan0; int bufferSize = bitmapData.Stride * bitmapData.Height; System.Runtime.InteropServices.Marshal.Copy(this.buffer, 0, ptr, bufferSize); bitmap.UnlockBits(bitmapData); return bitmap; } } </code></pre> <p>To use the class in a manner that will support both .NET and unmanaged recipients of the bitmap, a DataObject class is used for the drag and drop operation as follows.</p> <p>To start the drag operation:</p> <pre><code>DataObject dataObject = new DataObject(); dataObject.SetData(typeof(BitmapTransfer), new BitmapTransfer((sender as PictureBox).Image as Bitmap)); dataObject.SetData(DataFormats.Bitmap, (sender as PictureBox).Image as Bitmap); (sender as PictureBox).DoDragDrop(dataObject, DragDropEffects.All); </code></pre> <p>To complete the operation:</p> <pre><code>if (dea.Data.GetDataPresent(typeof(BitmapTransfer))) { BitmapTransfer bitmapTransfer = (BitmapTransfer)dea.Data.GetData(typeof(BitmapTransfer)); (sender as PictureBox).Image = bitmapTransfer.ToBitmap(); } else if(dea.Data.GetDataPresent(DataFormats.Bitmap)) { Bitmap b = (Bitmap)dea.Data.GetData(DataFormats.Bitmap); (sender as PictureBox).Image = b; } </code></pre> <p>The check for the customer BitmapTransfer is performed first so it takes precedence over the existence of a regular Bitmap in the data object. The BitmapTransfer class could be placed in a shared library for use with multiple applications. It must be marked serializable as shown for drag and drop between applications. I tested it with drag and drop of bitmaps within an application, between applications, and from a .NET application to Wordpad.</p> <p>Hope this helps you out.</p>
    singulars
    1. This table or related slice is empty.
    1. PODrag and Drop between Instances of the same Windows Forms Application
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMichael A. McCloskey
    1. USMichael A. McCloskey
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PODrag and Drop between Instances of the same Windows Forms Application
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COGreat answer. Very cool. +1
      singulars
      1. PO
      1. USJudah Himango
    2. COHi Michael! I like your approach. Thanks for the answer! This has bugged me for quite some time and your solution is a good solution to a recurring problem. However, I did find another solution which might be better (at least shorter) in the case of trasfering common clipboard formats. That solution is described below. In any case I want to give you the "accepted answer" cred since your solution is probably more adoptable to the general case. Please review my solution below for a different way to solve this problem. - Peder -
      singulars
      1. PO
      1. USPedery
    3. COYour find is very interesting and is probably the best solution for your case. I fully intend to dig into that article and experiment with this technique. It's a bit sad that such effort was necessary on both our parts to solve this. I cringe anytime I need to interact with the shell from .NET as the marriage is typically a rocky one. Thanks for the credit and even more for the additional information on this topic.
      singulars
      1. PO
      1. USMichael A. McCloskey
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload