LiamD's Q&A profile

• SQL Server Reading and writing same variable to a script

  It looks like its not possible to both read and write the same variable from a script using the conventional Me.Variables.<variable> syntax. I can only assign a variable as Readonly or ReadWrite and not both. If I assign it ReadOnly I can only access it in the PreExecute subroutine. If I assign it ReadWrite I can only access it in the PostExecute subroutine (in fact doesn't this just make it WriteOnly in fact ). So I can only either read in or read out a variable using this syntax, noth both. Is this right So the read and write a variable to a script, the VariableDispenser approach is the only option to use. Is this right and is ...Show All

• Windows Forms Threading in Windows Service

  Hi, I am creating a windows service that I need to read configuration information into from an XML file.  When I try to do so in the OnStart event handler, windows cannot start the service presumably because the handler is not returning within the 30 seconds allowed by the SCM. I think the way to fix this would be to read the confiruration in ...Show All

• SQL Server CreateSubscription - Specify the Job Name or Get the GUID Job Name

  We're using the CreateSubscription method to schedule a report for automatic delivery, using SQL Server Agent. Everything is working great. But, we had a question (or two). Is there anyway to specify the name of the SQL Server Agent job that gets created when the CreateSubscription method is called If so, how If not, is there anyway to get the GUID job name back after calling CreateSubscription TIA No. The guid for the SQL Agent job is not exposed through the SOAP Api's. Why not just give them the subscription information Instead of trying to tell them the SQL Agent Job, tell them the subscrip ...Show All

• Visual Studio Tools for Office Capturing Out of office event in Outlook 2003

  Hi all, I'm writing an addin for outlook, where I need to capture out of office event (when user turns out of office on / off). I would also need to be able to get the out of office message that user has entered when out of office is enabled. What is the easiest way to do this I'm using VS.Net 2003 (C#) for addin development. Thanks in advance. Hey, We could use CDO or Extended MAPI to turn on/off Out of Office rules. However both CDO or Extended MAPI are not supported from managed code. I don't know if we can capture the event using Outlook Object Model. A quick search did not show any way o ...Show All

• SQL Server Pivoting currency text file

  Hi! I have a currency exchange rate flat file with this format: date;USD;EUR;SEK; 01-01-2004;8.232;8.00;1.43; 02-01-2004;8.232;8.00;1.43; ..and so on. I need to pivot this to: 01-01-2004;USD;8.232; 01-01-2004;EUR;8.00; .. and so on.. Anyone got any tips on how to achieve this Try the UNPIVOT transformation. It does exactly what you need to do. There is a useful walkthrough demo in BOL that explains what the UNPIVOT transformation does.   -Jamie ...Show All

• .NET Development Socket Connections do not seem to close properly

  Hello, I have created a TCP socket Client program and a Listener program consisting of mainly MS sample code.  The two programs do communicate, but once the client has disconnected using TCPclient.Close, the client socket shows a CLOSE_WAIT in the "netstat" command and does not go away until the Listener is shutdown. I have tried the Client program with a commercial Listener program, and it does not leave the client socket in CLOSE_WAIT.   The client socket listing is gone from the netstat command.  This makes me think there that the MS Listener sample code is not closing the client socket properly. Any ideas   ...Show All

• .NET Development Open/Stream url into a string?

  How do I open a web page and load everything into a string I'm trying to do something like myData = OpenURL(someurl); Thanks. Depending on what technology you want to use, take a look at http://search.msdn.microsoft.com/search/default.aspx siteId=0&tab=0&query=+OpenURL I don't have more details but you try and let us know if you face specific issues. Thanks, Ayman Shoukry VC++ Team ...Show All

• Visual Studio Little question...

  Hi Rajeev, another little question... what about the wonderful reporting tool embedded with access it seems to me amazing that microsoft has forgotten it for so many years.. no way to reproduce it in .net version, right It was the best reporting tool I have seen in the planet, and this many many years ago... like star wars... :) Thanks a lot :) Hi albnig, You would to look Crystal Report to .NET. Good Coding! Javier Luna http://guydotnetxmlwebservices.blogspot.com/ ...Show All

• Visual C++ CFileDialog::GetNextPathName() returns extra backslash

  Hello, the Visual C++ 2005 Version of CFileDialog::GetNextPathName() returns one backslash to much (e.g. C:\\temp\filename.cpp instead of c:\temp\filename.cpp). It does not happen with 2003 but the code for this function was changed extensively. Christian ...Show All

• Windows Forms Problem With CheckedListBox

  I' have more then one cheked objects in the list but I get the same (first) value all the time, despite the index is change. Hear Is the Code strQuery = "SELECT code,name FROM tbl001 ORDER BY name"; orclDa = new OracleDataAdapter (strQuery, strOrclConn); orclDa.Fill(orclDs, "tbl001"); clbMifalim.DataSource = orclDs.Tables["tbl001"]; clbMifalim.DisplayMember = "name"; clbMifalim.ValueMember = "code"; foreach ( int i in clbMifalim.CheckedIndices) { MessageBox .Show("Index#: " + i.ToString() + ", Value is:" + clbMifalim.SelectedValue + "."); } Thanks Siva, Very nice ...Show All

• Windows Forms Send text to another form

  Or, get text from a textbox or label from parent form under conditions. Ok, declared this on parent form... public bool isFoward = false ; And, in the button click event.... isFoward = true ; compose newMsg = new compose(); newMsg.Show(); So, when I read isFoward from the parent form in the load event from compose form..... if (frmMail.isFoward) this .txtMessage.Text = "test"; But, isFoward is always false I even tried to create a hidden label to read but is always an empty string. I can read textbox contents though from parent form. Suggestions Thanks, Zat ...Show All

• Visual Studio Tools for Office Most flexible deployment is to GAC?

  Working on a VSTO Word application. Users will need to be able to pull documents from a Sharepoint site that use the app as well as email them to each other, and also be able to work offline... Right now I have decided to install the assemblies into the application folder. However, I assume that if two users install into different app folders (or if Program Files is on D: for one user...) then they cannot email the document from one user to another and have it work (I haven't tested this yet). So it seems the best place to install the assemblies would be in the user's GAC and have them strong named and refer to them that way from the d ...Show All

• Smart Device Development .obj/.exe files geneerated by VS2005 are 3x the size generated by eMVC++

  We are finding that the .obj/.exe files generated by VS2005 are much larger than those generated by eMVC++ with similar compiler/linker options set (all debugging options have been turned off). Running a stirngs utility against the .obj files produced a huge number of '$Mnnnnnn' references, where '$M' was constant and 'nnnnnn' was an ever increasing integer. Compiling such that .asm files are produced showed that these references seem to be associated with DCD psuedo instructions used for padding ( ). The difference between the VS2005 generated files and eMVC++ files is that there are SIGNIFICANTLY more of them in the VS2005 versions. Any ...Show All

• Visual Studio Express Editions Configuration Manager Platform vs. Options - VC++ Directories

  Good afternoon... In quite a few places in VC++ Express I can access the Configuration Manager (ex.: right-click Solution).  And there I can create a New platform (Active Solution Platform). But does it do for me to create a new platform   What can I with this I've tried looking in the help (MSDN Express I guess).  And there's a maze of links that don't really answer the question, they just come back to the original article!!! I personally use such other platform or new platform for 64 bit development. Thanks,   Ayman Shoukry   VC++ Team ...Show All

• Windows Forms Adding a user control in a cell in Datagrid

  Hi, I am working on C# Windows forms Application. I need to dynamically add a user control in each cell of Datagrid depending on some condition.Is this possible and if yes cud I know how to do it.... Thanks, Regards, livehed Maybe this job is already done for your purposes. Check the webside: http://www.datagridcolumnstyles.net/easyDataGrid.asp ...Show All