Peter Barnet's Q&A profile

• Visual Basic How to change properties dynamically

  Hi   - I have a problem parsing an object between these two subs below. I keep getting this error: Unable to cast object of Type 'Microsoft.Office.tools.excel.NamedRange' to type 'Microsoft.Interop.Excel.Range'. Void UpdateRangeControl(System.Windows.Forms.Control) What can I do to to make it work. Any help will be much appriciated. Ezero Private Sub Expenseform_TextChanged( ByVal sender As System.Object, ByVal ...Show All

• SQL Server Access Permissions on server scoped objects for login

  We are having problems with the response times from UPS WorldShip after switching from SQL Server 2000 to 2005. I think that the problem can be fixed from the database end by setting the permissions correctly for the user/role/schema that is being used by WorldShip to connect to the server but, I'm not sure how to do it. The Setup Client UPS WorldShip 8.0 running on XP Pro SP2 Connecting via Sql Native Client via SQL Server Login Connec ...Show All

• Windows Forms Cannot CreateDesigner for MainMenu

  In my designer host, if I have a MainMenu component called "mainMenu", I am unable to get a Designer using the following techniques: GetDesigner(mainMenu); TypeDescriptor.CreateDesigner(mainMenu, typeof(IDesigner)); I would like to get this to work ASAP, so I don't want to wait for MenuStrip. Does anyone know how to get the IDesigner that Visual Studio uses for MainMenu design Thanks, Greg Hmm... Are we allowed ...Show All

• Software Development for Windows Vista K2 captaris Vs Windows workflow

  Can somebody let me know what are the outof box activities,roles realted to activities , versioning of workflows which differentiates K2 & captaris from WF. what are those additional features provided by workflow products like k2 whne they are going to create their new products from WF itself. It is very much necessary for me as WF is not going to cost anything while other workflow management softwares cost very much. I know that ...Show All

• Windows Forms GDI+ graphics and viewport

  Hello, I am using .NET 2.0 and building a custom control. There are multiple graphics elements that I would like to render on the surface. When drawn together they form the complete control image but need to be managed separately because they might have different scale, units, move indendently, and are updated at different times for different reasons. My idea was to maintain several buffers or graphics objects that I could use draw into an ...Show All

• Windows Forms MDI Parent background color

  Hey guys, just a quick question. Is there any way I can change the color of the MDI parent background from that gray Look at this article from msdn How to change the background color for an MDI parent form in Visual C# Hope it helps ...Show All

• Visual C# Setting not found in thread

  I have an application that starts a thread that reads from an xml file. the path to this file is stored in a property setting. The problem is that i get a SettingsPropertyNotFoundException saying that it can't find the setting. (The setting is there, though; I checked.) However, if I access the setting before I start the thread, I get NO exception. Not even when I access it in the thread, later on. This only happens when I debug the applicati ...Show All

• SQL Server Alternate Synchronisation Partners

  Yes, I know synchronisation to alternate partners is deprecated in SQL2005 but.... In SQL2000 there is a Sync Partners tab in the publication properties dialog that allows you tick a checkbox for each co-publisher to be enabled as an alternate synchronisation partner. What is the equivalent in SQL2005 I've set up replication in SQL2000 following these instructions http://support.microsoft.com/ kbid=321176 and it works. Now I'm trying to do ...Show All

• SQL Server inner join on reverse records

  I have some data that looks like this Col1 Col2 SumCol XXX,YYY, 5 XXX,ZZZ,6 ZZZ,XXX,7 YYY,XXX,2 I want to do a inner join on that data so I get this XXX,YYY, 7 XXX,ZZZ,13 Right now I'm using a CTE set to do that, is there a better way akula wrote: I want to do a inner join on that data so I get this XXX,YYY, 7 XXX,ZZZ,13 Why that should't be a YYY, XXX, 7 ...Show All

• Visual C# Throttle CPU speed

  Hey all, I need to control the speed (in hz) that a c# application executes at. I want to be able to simulate the program running at 600Mhz, 1Ghz, 2Ghz, etc... Anyone any idea how to do this I would prefer to code the CPU throttling into the C# app rather than use a external program. Thanks, Stevoie for what exactly is this needed if you're running in a loop, you can use System.Threading.Thread.Sleep(); to s ...Show All

• .NET Development Serialize Web Service Data Type

  Hi, I use WSDL comand line tool (wsdl.exe) to generate source code of proxy for a webservice, compile that source code on the fly using particular instance of ICodeCompiler into standalone assembly, create instance of proxy class using Reflection, e.g. Activator.CreateInstance() One of the known webservice methods returns an abstract data type defined in the wsdl. How do I import the type     MethodInfo method ...Show All

• Windows Forms Converting ASCII string to a hex

  Does anyone know how i can convert an ascii string to hex I'm using C# however the statement I used is entirely .Net framework, and should be possible in any language, though it might be the in stead of C# 'int' you need ...Show All

• Visual C# In C# ,is there any similar to "vbCrLf" in visual basic ?

  When I manipulate with a string , i dont know the way similar to "vbCrlf" in visual basic . Please help me a little , thank you very much.Maybe its easy for many people here. I think that this is that you need. :) System.Environment.NewLine ...Show All

• Visual Studio Express Editions probing

  Hi to all, I created a private assembly for example mydll.dll,and i didn't placed this dll in application folder.I placed it in another folder for ex dir1 in application folder in order to implement probing.my application is mydllclient.cs.I created a config file with code < configuration > < runtime > < assemblyBinding xmlns = " urn:schemas-microsoft-com:asm.v1 " > < probing privatePath = &q ...Show All

• Visual Studio Tools for Office VSTO & MS Access

  I'm just trying to get up to speed on the new Visual Studio 2005 and the new Tools for Office.  We do a lot of work with MS Access (and Excel) and what I find odd is that in all the articles I've read there is not mention of MS Access w.r.t. the VSTO.  Do the VSTO not work with MS Access   What am I supposed to use if I am doing development with Access 2003 Can someone please clarify how VSTO works with MS Access   We've alr ...Show All