Post reply

Getting ''view'' data to external application(s) from SQL2005

  • August 16, 2007 at 10:27 am

    #174291

    I want to selectively 'get' (transmit) either a complete row or individual column from a Management Studio 'view' to another running applicationwhen a user 'clicks' (dblclicks etc) on a row or column on that view.  The case: (1)user opens a view in SQL2005 management studio. (2)click-selects either a row of interest or column of interest. (3)Mgmnt Studio sends (msg) selection somewhere that another application can retrieve containing the selected data.  I'm not particular about the method used. I've looked for Mgmnt Studio (SQL2005) 'Events' that might be raised by the 'click' (must be one internally at least!) without success.  I've looked into 'hooking' such an event - doable if I can find the event (with the data selected).  I always have an open connection to the db but am not aware of the possibility that I can send unsolicited (push) data from db to client via the connection.  I will use the data in the external app to create custom queries into numerous tables/dbs for analysis purposes.  Any ideas?  Any solutions?(preferred!!)

    Thanks,  jack

  • August 17, 2007 at 1:55 am

    #727558

    This is not a simple thing to do If you want to know what a user is currently accessing in the user interface of Management Studio, you could try to write an add-in to Management Studio. This is not supported, but possible (See SQL Refactor and SQL Prompt). Management Studio is basically just a crippled and extended Visual Studio 2005, so a similar add-on mechanism is supported.

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • August 17, 2007 at 10:21 am

    #727696

    Thanks Andras,

    I'm not familiar with 'Refactor' nor 'Prompt', but I'll look them up online to see how they can help me.  The DataGrid control has a 'ButtonClick' event it raises.  I have been able to detect the 'click' event from the Mgmt Studio view (which is in a DataGrid control) using the SPY++ application supplied with Visual Studio.  The problem I have there is that I don't get any of the 'data', or (in my opinion) a pointer to something, just the event.  I could determine which row to query for (when it was the target of the click) if I got a row index (or something) with the event that is raised.  I haven't been able (yet) to find a list and properties of events raised from SQL Server 2005 or the Mgmt Studio.  Somewhere within MS the list must exist.  If anyone can point me to them I'd be most appreciative.  At least then I could use the 'event' or dismiss it as a strategy.

    regards,  jack

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply