Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>This ought to do the trick...</p> <pre><code>var processInfo = new ProcessStartInfo(fileName); processInfo.Verb = "openas"; Process.Start(processInfo); </code></pre> <p>Although, Oded makes a great point - not knowing exactly how/where you intend to use such functionality means this might not be the answer for your situation.</p> <p>Recent comments on this answer go to show I wasn't very detailed in the first place. A problem will arise if you try to <code>openas</code> a file that already has the <code>open</code> verb defined against that type of file. Similarly, if you try to <code>open</code> a file that doesn't have that verb defined there'll be trouble. The issue would be:</p> <blockquote> <p>Win32Exception: No application is associated with the specified file for this operation</p> </blockquote> <p>Off the top of my head I suggested to Thomas that in order to use this kind of code in a production application you would need to be thorough and perhaps check the registry, or otherwise find out whether or not a file can and should be opened with any given verb. It could be simpler than that when you consider <a href="http://msdn.microsoft.com/en-us/library/system.diagnostics.processstartinfo.verbs%28VS.90%29.aspx" rel="nofollow"><code>ProcessStartInfo.Verbs</code></a>: this will, once the <code>fileName</code> is set, provide you with a collection of possible verbs associated with the file type. This should make it easier to determine what to do with which file.</p> <p>To wrap up, as I mentioned to Thomas, you will need to take care and add some complexity/intelligence to your application - this answer certainly isn't a catch-all solution.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow can I show the "Open with" file dialog?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USGrant Thomas
    1. USGrant Thomas
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    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. CODoesn't work... Win32Exception, "No application is associated with the specified file for this operation"
      singulars
      1. PO
      1. USThomas Levesque
    2. CO@ThomasLevesque It will only work if no 'default programs' are defined; that is to say, if there is a `Open with...` context menu for the file then this will fail. If it's an unknown file type with simply an `Open` option then this will work. The reverse is also true: using the `open` verb for known file types will launch the default program but wil lraise this same exception if unknown. So, in a proper application you want to be thorough about this; maybe doing a lookup in the known file types repo (registry) and basing your decision of how to open on facts given by the system.
      singulars
      1. PO
      1. USGrant Thomas
    3. CO@ThomasLevesque In fact, you don't even need to go to such lengths: [`ProcessStartInfo.Verbs`](http://msdn.microsoft.com/en-us/library/system.diagnostics.processstartinfo.verbs(VS.90).aspx) will be populated with the possible verbs for a file when the `fileName` is set, meaning you can just check if the `open` verb is defined and if not use `openas`. This doesn't catch all cases I bet, so add your own cleverness at will.
      singulars
      1. PO
      1. USGrant Thomas
 

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