happybappa's Q&A profile

• Visual Studio 2008 (Pre-release) Usercontrol Nightmare

  I do not know what I am doing wrong but I am starting to pull my hair out. I am using VS and EID to create a quite complex UI, and I am trying to use usercontrols to encapsulate as much as I can. However... Any user control I create and put on a window or page either never renders and just shows up with the classname of the usercontrol in the top left corner, OR when you place it on the page in EID it says "Cannot instantiate <ClassName>" which takes up the whole of the page/window and means you can't position it properly (but will render when you run it). I must be missing something here, should a newly created UserControl ...Show All

• Visual Studio Tools for Office How to do this in C#

  I am trying to create PivotTable in Excel using c# The full code for the funtion is as follows; public void stgPivot() { Xl.Application xlApp; xlApp = (Xl.Application)System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application"); Xl.Workbook wb = xlApp.ActiveWorkbook as Xl.Workbook ; Xl.Worksheet ws = xlApp.ActiveWorkbook.Worksheets["Sheet2"] as Xl.Worksheet; Xl.PivotCaches pch = wb.PivotCaches() ; pch.Add(Xl.XlPivotTableSourceType.xlDatabase,"Sheet1!R3C2:R28C9").CreatePivotTable(ws.Cells[8,3],"PivTab1",Type.Missing, Type.Missing); Xl.PivotTa ...Show All

• Visual Basic Converting String to double?

  OK i have a plain text file in a rich text box. This plain text file contains for the most part just text, but it has several chunks of data which are apparently stored as doubles For Example this string here: 33333oH@33333oH@26/01/06 I happen to know that the date field is a date of payment, and apparently, the data before this is the amount paid. The original program i am trying to read was written in quickbasic 7. I don't know enough to know how to do what i what. I've tried Try Dim test As String test = "33333oH@33333oH@" Dim Result As Double Result = Convert.ToDouble(test) ...Show All

• .NET Development ADO.net Code

  Hi guys, Could anyone please help! I'm trying to write some ado.net code on the "Page_Load" events as: dim cmd as new sqlcommad cmd.commandtext... The problem is that the "sqlcommand" is not being recognized by the intellisence. Any help is greatly appreciated. Thank you ...Show All

• .NET Development To Disable Cut and Paste in a VB.Net Application

  Hello, I have an application in Visual Basic .NET and I would like to disable "Cut and Paste" when the user is entering data in a Text Box and next clicks the right button on the mouse. I saw these options are available but I would like to disable them. Best Regards, Joanna. Hi, Do you want to disable just those options or is it OK to remove the entire menu For removing the entire menu, simple add a "ContextMenuStrip" control from the Toolbox and set this using the ContextMenuStrip property on the Textboxes. Now when you run the application and right click, you will not get any menu at all. Regards, Vikram ...Show All

• SQL Server Is this possible?

  Hey guys, I wrote a T-SQL query to retrieve all errors name and count the error for each error name based on some conditions. Assume that errors_name is a column name in Error table and the error_count is a calculated field. Here is my question; when I run the query, obviously, it displays the list of errors name and the corresponding errors count which only meets the where condition . However, what I need is to list all the errors name (even if they don't meet the condition) and assign a zero value to the error count column for those errors name that do not fulfill the where condition. Can anybody assist me Appreciate your ...Show All

• SQL Server SQLServer2005_SSMSEE.msi & SqlServer2K5_BOL.msi

  After I installed SqlServer2K5_BOL.msi, Microsoft SQL Server Management Studio Express CTP does not launch any more. How can I use both SSMSEE and BOL I would be very skeptical when downloading either of those files. MS download servers currently have a fairly serious (in my opinion) problem with syncronizing their mirroring. It seems to lead to some mirrors providing outdated files - it's meant to be transparent to the end user so you typically don't even know you may be downloading from a mirror, or receiving an outdated file. See these forum threads for details: http://forums.microsoft.com/MSDN/ShowP ...Show All

• Visual Basic Cannot save my.settings if one of the setting fields is a sortedList

  The following gives me a null reference error. Setting: name = Recipe, type = SortedList, scope = User Code: my.settings.Recipe = new SortedList my.settings.Recipe.Add("aKey", "aString") my.settings.Save() < Null reference error occurrs here. I have tried (and failed) with many different approaches to use a sorted list in my.settings. I would love to know the correct way to do this. the "Synchronize" button is added after Beta2. try upgrade to release version. http://msdn.microsoft.com/vstudio/products/trial/ ...Show All

• Windows Forms dynamically create control by type name

  I am trying to create a panel control with some generic layout logic that can contain a number of different usercontrols of different sizes.  I would like to be able to set the name of the particular usercontrol to be contained at design time, then create this control at run time using the name of the usercontrol class.  Thanks for any h ...Show All

• Visual Basic SerialPort Readline Vs ReadByte Vs Read Vs ReadExisting Vs ReadTo

  I have managed to get my vb app to talk to another pc sending a text file via hyperterminal - Transefer - Send text file and using SerialPort in the vb app. If I use ReadByte or ReadChar I get the 1st byte of data sent across, if I use any other Read I get absolutely nothing. The text file has an Newline (LF) character present so would expect Readline to function ok. Tried ReadTo with a known character in the file, again it stops at the Read statement, same with ReadExisting and Read which should just take the contents into the buffer on issue of the statement. Added a .BytesToRead statement after the .ReadByte statement and it shows 0 ...Show All

• Windows Forms How to make minimized application flash in Task Bar?

  Hi, When my application runs, the user sets up some parameters and then they click on "Go". The application minimizes and waits for stuff to happen. It may take several hours before further user interaction is required. When my app has some information to give to the user I want it to remain minimized but to be able to attract the attention of the user so they know they need to do something. I don't want it to un-minimize because the information collected is not that important that the user should be always interrupted. Can anyone give me some clues as to how to make my application flash on the Task Bar Actually, maybe flashing might be a b ...Show All

• Visual Basic Open

  Can someone tell me how to open an application manifest if you do not have .net on your computer. I don't know. What did you want to do A manifest file is for use by your exe. You say the machine does not have .NET on it, if so, then you can't run the app, so I can't understand what you're trying to achieve - to run the app you require the framework. Why would you be playing with the manifest file on a machine that can't run your app ...Show All

• Windows Forms Could not load type "TaskVisionWS.Global"

  I actually can't get it working. When I try to navigate to http://localhost/taskvisionws/authservice.asmx I get the following error message: Parser error .... Could not load type TaskVisionWS.Global I tried to put the TaskVisionWS.dll in the GAC but it isn't a strongly named assembly so this doesn't work. Any ideas  anytime  ;)  That's what we're all here&nb ...Show All

• Visual C# obfuscate dll

  How can i obfuscate dll in vs2003 You can use Dotfuscator Community Edition including in vs2003, open your project in tools->Dotfuscator Community Edition ...Show All

• Software Development for Windows Vista Beta 2.2 does not require WinFX RTC? What about WPF then?

  I am quite confused now. I am currently on Beta 2. That requires WinFX RTC. Now with Beta 2.2 it's saying it's not compatible with any WinFX RTC. Does that mean I could not develop WPF apps with Beta 2.2 because that depends on WinFX Feb CTP Hi Perry, If you are using WPF you should stay with the WinFX Feb CTP which is the latest WinFX CTP currently. WF Beta 2.2 is not directly compatible with that CTP and so you should not install WF Beta 2.2 and the WinFX Feb CTP at the same time. The next CTP or other release of WinFX will resolve this version incompatibility. But for now to use WF and WPF you should use the WinFX CTP. The ...Show All