Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You can use the <a href="http://www.c-sharpcorner.com/uploadfile/aa04e6/how-to-implement-oncustomcommand-method-in-windows-service-application/" rel="nofollow">OnCustomCommand</a> override, but this only takes an integer as an argument and does not support passing strings to the service.</p> <p>The other options would be to create a <a href="http://www.codeproject.com/Articles/38160/WCF-Service-Library-with-Windows-Service-Hosting" rel="nofollow">WCF service</a> or use <a href="http://www.codeproject.com/Articles/1111/How-To-Host-NET-Remoting-Objects-in-Windows-Servic" rel="nofollow">Remoting</a> to pass the information you need to the service and call the delete method.</p> <p>EDIT: to respond to a question in the comments about how to use OnCustomCommand in a very strange way is as follows.</p> <p>In the service you would need something like this.</p> <pre><code>private const int CMD_INIT_DELETE = 1; private const int CMD_RUN_DELETE = 0; private bool m_CommandInit = false; private StringBuilder m_CommandArg = new StringBuilder(); protected override void OnCustomCommand(int command) { if (command == CMD_INIT_DELETE) { this.m_CommandArg.Clear(); this.m_CommandInit = true; } else if (this.m_CommandInit) { if (command == CMD_RUN_DELETE) { this.m_CommandInit = false; this.deleteFile(this.m_CommandArg.ToString()); } else { this.m_CommandArg.Append((char)command); } } } </code></pre> <p>In the windows form application you would have something like this</p> <pre><code>private const int CMD_INIT_DELETE = 1; private const int CMD_RUN_DELETE = 0; private void RunServiceDeleteMethod(string delFolder) { serviceController1.ExecuteCommand(CMD_INIT_DELETE); foreach (char ch in delFolder) serviceController1.ExecuteCommand((int)ch); serviceController1.ExecuteCommand(CMD_RUN_DELETE); } </code></pre> <p>THIS IS NOT TESTED and only a proof of concept. Again, I DO NOT recommend doing it this way and the above example is only to show how NOT to do this type of communications between desktop applications and services.</p>
    singulars
    1. This table or related slice is empty.
    1. POwindows service file delete c#
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USvane
    1. USvane
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POwindows service file delete c#
      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. VTAcceptedByOriginator
    1. COOnCustomCommand are those between 128 and 256. my send string
      singulars
      1. PO
      1. USmesuts
    2. COIt can be any integer... I suppose you could if you REALLY wanted to, do a series of CustomCommand calls sending first the command to execute as a number (let's say 1) and then proceed to call the CustomCommand for each character in the file name and path followed by a 0 to indicate that you're done passing that info to the service. On the service end you could store this information and once a 0 is sent, call deleteFile with the filename you passed. I DO NOT suggest this though as it is very messy and why would you do it that way. It might be neat to try it, just to say that you've tried it.
      singulars
      1. PO
      1. USvane
    3. COthe example code the other way is there and if so, what
      singulars
      1. PO
      1. USmesuts
 

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