Thomas.Goddard's Q&A profile

• .NET Development how to open excel file (on server), write some value to it and save it in ASP.Net

  hi guys, Hello, I’m having a excel problem need your guys advice.   The feature is: (open-write value-save) 1)         ASP.Net to open the excel file on server directory 2)        ASP.Net will automatically insert values (username and current date time) into cell E1 3)        ASP.Net will automatically save the file  example: i have a yield.xls on server directory, i would like to open it and automatically insert some value like username in certain field (say E1) then save it. thank you.   Here are some samples how o work with ...Show All

• Visual C# Add Reference to A DLL (assembly) Causes DevEnv.Exe To Crash!

  Hi I have the Windbg of the crash. All I did, is try to add a DLL to the project to see what it has, and IDE crashed on me. I have the dump of the crash. Can you help I have the dll. I try to add it as a reference to see it in the object browser and it crashes IDE. This dll is unmanaged dll, and its part of a network sniffing tool, I found on the net, and want to see what it contains to understand how it works. ...Show All

• SQL Server Convert Long To DateTime

  Hi. I need to convert a vb function into a user-defined function in a stored procedure. The vb function converts a long datatype into Date datatype. Here is the VB function: Function LongToTime(lTime As Long) As Date LongToTime = (lTime \ 10000) / 24 + ((lTime Mod 10000) \ 100) / 1440 + (lTime Mod 100) / 86400 End Function The function is used to convert a timestamp(hhmmss) into a more readable format. Would it be possible to create a function similar to this in an SQL stored procedure Thanks in advance Wesley translation of your vb function should be CREATE FUNCTION fn_LongToTime ( @lTime int ) RETURNS smalldatetime AS BEGIN DECLARE @dt smalldatetime ...Show All

• .NET Development HttpUtility.UrlEncode(str) How to?

  Can anybody tell me how to implement this correctly I have tried using it directly, but although HttpUtility is initially recognised, it does not hold any methods other than '.ToString()' and 'GetType(); etc... Also I have tried declaring it in many ways in the code but I just cannot get it to function. The closest I have become is generating it as a 'public sealed class' and inserting the method in there; unfortunately this didnt come off. I am having real trouble defining this so please any help in any way would be great.   Thanks alot   JWH. See this post please: Edit: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=937059&SiteID=1 I hope this will help! ...Show All

• Visual C# PInvoke changes

  I got this message on my recently upgraded 2005 project : A call to PInvoke function ....::SendMessage' has unbalanced the stack. This is likely because the managed PInvoke signature does not match the unmanaged target signature. Check that the calling convention and parameters of the PInvoke signature match the target unmanaged signature. My external signature is: DllImport("user32.dll", EntryPoint="SendMessageA")] public static extern int SendMessage (IntPtr hwnd, int wMsg, IntPtr wParam, object lParam); I looked into this and found some sites indicating that I could have problems with 64-bit code if I used an object for lParam or anything but IntPrt for the return type. The question I have is: I'm not building 64-bi ...Show All

• Visual C++ Multiple Compilation

  I have a class defined in a header, for example Node root;, but when I compile and link I recieve a link error, saying it has already been defined. To get rid of this I placed #pragma once at the top of the header, to no effect. I then replaced it with #ifndef DIRECTXSCENE #define DIRECTXSCENE 10 and then at the bottom: #endif This did nothing either. Any suggestions Mike For the actual class I have: class Node { public: Node(); } in the header, and then the actual code for Node::Node() in the cpp file. I did this so the class could be accessed by other cpp files. I also have in it an instance of the class Node, Node main. It is this that is causing the error ...Show All

• Visual Studio Express Editions trying to place a graphic on top of an image

  Hi, I'm trying to place a graphic on top of an image using the following with no luck. Can anyone help   If AnalogValue >= 100 Then            PictureBox4.SendToBack()            formgraphics.FillRectangle(Brushes.Red, 430, 200, 10, 5)         Else             formgraphics.FillRectangle(B, 430, 50, 10, 5)         End If  Regards, Ken yes...you are using the forms graphics object instead of the pictureboxes graphics o ...Show All

• Audio and Video Development Questions regarding MFT implementation

  Hi, I have some questions regarding MFT: 1) How to get topology loader enum my MFT I register my MFT in MFT decoder category, but it's not enum'ed when I set a partial topology to media session. 2) I try to get D3D manager as mentioned in previous threads, but I found IMFTransform::GetAttributes is never called. 3) When output format changes, I set pOutputSamples[0].dwStatus = MFT_OUTPUT_DATA_BUFFER_FORMAT_CHANGE and return MF_E_TRANSFORM_STREAM_CHANGE in IMFTransform::ProcessOutput. But no one try to get my new preferred output type. Is there anything I need to take care Thanks in advance. Patrick Becky, Thanks for your help. I'll check the MFTEnum function. For (3), yes I see sub ...Show All

• Visual Studio Reportviewer print dialog problem

  My .NET version 2 application creates reports by calling a method from a dll (which I also wrote) which displays a form containing a user control which in turn contains a ReportViewer. I set the viewer's .ReportPath, .BindingSource, and .DataSource properties and call the .RefreshReport method. The viewer displays the report correctly. When I click the viewer's Print button, the Print dialog correctly appears, but I have to click the dialog's Print button twice to actually send the report to the printer. What could be causing this Hello Brian, above you mentioned 2 Problems. For one problem you provided a KB Article #. Now i contacted Microsoft support for the second problem (the one you c ...Show All

• Visual C++ QuickWatch Expression Type column hidden

  Is there any way to see the Type of an Expression in the QuickWatch window without resizing the Type column with the mouse every time the window is opened I seems that the newfangled TREEGRID1 (ClassNN) control neither responds to a {Ctrl}{NumPad*} to automatically resize, nor does it remember its last settings always defaulting to show me the first 5 or 6 letters of the type name (usually std::v or boost:). As the new floating tooltips are also keyboard disabled I find that I'm stuck between a mouse and a hard place. Am I overlooking the obvious Many thanks, AS Hi nobugz, I really appreciate the quick response, and to many this would be a workaround - but mice make me sneeze.... atchoooh! ...Show All

• Visual Studio Express Editions Need to get a double variable into a Windows Form label

  Currently trying to finish a project for school and the only thing holding me up is getting the form to display the total for a restaurant aplication. The first way it was done is to click the submit button and a new messageBox would appear showing the total. MessageBox.Show("Total: " + check.Total.ToString("c"), "Check Total"); How do I get that to appear in a label within a form Any help would be appreciated. this.label4.Text = or do I have the wrong idea ...Show All

• Visual C++ Managed C++ vs. C# - any difference in performance?

  Hi Guys! Is Managed C++ faster than C# ~Matt " "Brendan Grant"@discussions.microsoft.com " < "= UTF-8 B QnJlbmRhbiBHcmFudA== ="@discussions.microsoft.com > wrote in message news:b465e9e8-d76c-4cff-a8a2-3c5df1d4a28d@discussions.microsoft.com ... In theory yes... but only in very limited cases. Remember that both Managed C++ and C# get compiled into MSIL... so at the MSIL level all things are equal and just as performent. Differences can arise however when it comes to optimizations at the compiler level... and despite my love for C#, I’ve got to admit that those C++ guys have been at compiler writing for a little longer and can likely optimize ...Show All

• Visual Basic Trying to disable a menu item

  Total beginner here. I'm trying to disable a menu item when a certain criteria is not met. The menu item is called "Administrate Users" and I am trying to disable it through the following code: If userName <> "Criteria" Then For Each FileMenuItem As MenuItem In Me .Menu.MenuItems If FileMenuItem.Text = "Administrate Users" Then FileMenuItem.Enabled = False End If Next End If The error message I'm getting is: System.NullReferenceException was unhandled Message="Object reference not set to an instance of an object." Any help Many thanks Mark You're trying to access the ...Show All

• Smart Device Development Open the Add New contact app inside Contacts

  Hi, How can I directly open the default Add New contact application inside mobile Contacts with a click of a button in my application I know it would be something like this but this code returns error Win32 app can't be found. I'm using C#. private void btnNew_Click(object sender, EventArgs e) { System.Diagnostics.Process.Start("\\Windows\\Contacts.exe") } Anyone can help Thanks. Thanks. Seems like my assumption was right. By the way, System.Diagnostics.Process.Start(" \\Windows\\Start Menu\\Programs\\Contacts.lnk works at first place but once Contacts page is displayed, it returns error - the same error message: Win32 exception. ...Show All

• SQL Server What does AverageOfChildren aggregate function in SSAS 2005 actually do?

  Folks, Have any of you been playing around with SSAS 2005 to have worked out what the AverageOfChildren aggregate function actually does I was expecting it to do the equivalent of a simple AVG() with a GROUP BY in SQL, but it seems to be doing something additional to that. No-one in the team I work in has been able to work out what exactly it is doing. Any info would be appreciated! Cheers, Kenneth Well, that's a question that Microsoft can best address, but from my point of view: There's been a simple way to implement an average since OLAP 7: Sum/Count I wouldn't view a semi-additive average as useless; it depends on the domain. For example, in any kind of queueing s ...Show All