MikeT1021's Q&A profile

• SQL Server checking length and triming the value at ','!

  Hi all! I have a record coming from the database having of F_name,L_name, and M_name being concatenated and separated with comma. In an expression of a textbox control value I would like to check the length of this record and if it is more than 12 only to take the first values till the comma’,’ which appears prior to the 12 th character and truncate the rest. For example: Record from the database= FirstName,LastName,MiddleName 1) GAUTHIER, JEFFREY, Jane     D esired result GAUTHIER, b/c if Last name is added it will be more than 12. 2) Jane, JEFFREY, GAUTHIER D esired result Jane, b/c if Last name and first ...Show All

• Visual Studio set CustomBeforeMicrosoftCommonTargets=$(MyEnvVar)morepath/my.targets

  set CustomBeforeMicrosoftCommonTargets=$(MyEnvVar)my.targets Why does the above not work with CustomBeforeMicrosoftCommonTargets and MyEnvVar both defined in the environment I would think that msbuild would expand the above value of CustomBeforeMicrosoftCommonTargets just fine before using it, but it doesn't seem to work. Well, kinda. I'm saying don't do it with environment variables :) I'm not sure why it doesn't do what you expect, and I asked Jeff and he didn't know off the top of his head. We'll ask the rest of the team and see if we can figure out if this was an explicit design decision. Eit ...Show All

• Visual Studio 2008 (Pre-release) WCF ROUTER - Changing binding on the router error

  Hi, I hosted WCF router inside console (inside iis I am still experiencing some problems). It works fine when I am routing client message(wsHttpBinding) to service with wsHttpBinding. I tried to route message(wsHttpBinding) to netTcpBinding binding service, but I got error message: {"The server did not provide a meaningful reply; this might be caused by a contract mismatch, a premature session shutdown or an internal server error."} Can someone help me with this Has anyone sample of routing message from http to tcp transport This is my routing table: < routes > < route > < xPath > /s12:Env ...Show All

• Visual C++ Fill a combo, with an array of strings, returned by a C# com visible DLL

  Hi all., I 'm currently programming in C# , and i made a dll (com visible) with my database access functions, and i wanna use these functions in an old application in VC++ 6.0. How can i call this function in my vc6 project and access its functions to fill my combos with database information My functions return strings array and i wanna fill a combo with it. I really don't understand a piece of C++ 6.0 code so things gets worst. Maybe some of you can help me solving this trouble. Thanks in advance, regards, Tiago Teixeira I'm not sure if your C# code will work as I don't do any C# myself. But... Here is how to fill a CComboBox with ...Show All

• Smart Device Development not able to connect to Internet with Pocket PC 5

  Hi, I am trying to connect to internet using proxy server option with Windows Pocket PC 5. I have provided the proxy server ip address and the port correctly. But still when I try to connect to the internet it displays the error below. "Connot connect with current connection settings." Secondly I want to send mails using Pocket PC 5, but since I am not able to connect to the Internet sending mails is not possible. Please let me know if any step apart for the ip address and port number (for the proxy server) has to be done to connect to internet form Pocket PC 5. Parag Dave Abhi ...Show All

• .NET Development DrawString in .NET

  Hi, I am trying to use the DrawString function so that it does not put a space at the heading and trailing of a string I have tried MeasuretrailingSpaces but that doesn't seem to work. I want the string to start exactly at my x coordinate. Do i have to set the StringFormat to achieve this rotsey This method is only defined for the WinForms controls. You might want to ask your question on forums.asp.net . ...Show All

• SQL Server Stored proc concatenation problem

  I have a stored proc that looks like this CREATE PROCEDURE InvByRange03 InvNum int = NULL, AS DECLARE @vcWhere nvarchar(1000) DECLARE @vcSelect nvarchar(1000) SELECT @vcSelect='SELECT InvNum, Company, StatementDate, TotCharged, Paid FROM Invoices WHERE' Select @vcWhere='' IF Not @InvNum IS NULL SELECT @vcWhere=@vcWhere + AND InvNum = ' + @InvNum When I compile this sp it compiles alright, but then I execute it I get an error message of "Conversion failed when converting the nvarchar value ' AND InvNum = ' to data type int" Can someone see what the problem is and tell me what the proper syntax is for glueing an n ...Show All

• Visual Studio Problems with Debbuging on Intel Pentium D950 (Visual C# Express)

  Hello, I have a problem while debugging my Application. I have a application which uses a SerialPort to communicate with external devices. When I put a breakpoint at the DataRecived method, the application stops there but before I can step through it takes several seconds before the key-press was recognized. I'm not sure but imho it has to do with my new PC it's a DualCore and I guess the DataRecived Event is called in a different thread as my Application thread. So mayb it's a synchronize problem with the two cores and the Visual C# Express IDE. While I debbuged the application at my old PC (single core) the debugger reacts normal. Is there ...Show All

• Windows Forms DataGridView with MultiColumn Combo Box

  C# Windows Form] I would like to have one of my DataGridView columns as  Multi-Column ComboBox  column. Can anyone help me on this Hi, Have you figure out how to create a multi-column combobox in the DataGridView Can you guide me through on this or do you have a sample code for it Thanks ...Show All

• Visual C# Switching off computer using C#

  Is it possible to switch off computer using c# I know that it is possible when using c/c++. There is a method called exitWindows or exitWindowsEx, but I can't find it in Visual C# Express Edition 2005 The .NET framework must by definition call Win32 functions, but it does not expose all the functions that exist. pInvoke fills this gap. The following is a C# class that deals with all the traps involved in shuting down the PC. using System; using System.Runtime.InteropServices; namespace Shutdown { /// <summary> /// Summary description for Shutdown. /// </s ...Show All

• .NET Development debgugging a .net assembly that's instantiated from VB6

  i have a .net assembly that i reference from VB6. The .NET assembly is a class library. How can i debug the .net assembly at runtime from VB6 Any help is appreciated. Thanks. John In order to debug a class library (of any sort) you must have the debugger run an executable. Normally people create little test apps to run their class library through. In your case you should just build your VB6 app. Then go into the project settings for your class library (in .NET) and specify that it should use an external program (under VS2005). Under VS2003 you'll select Program from the Debug Mode option under the project debug settings. Spe ...Show All

• Visual Studio Express Editions Splitting multibyte variables

  I have a variable CRC As UShort 16 bits unsigned and CRChi/ CRClo As Byte. In Delphi and most assemblers I can split CRC into 2 bytes by (or similar) CRChi=High(CRC) 'Get the top 8 bits CRClo=Low(CRC) ''Get the bottom 8 bits How do I do this in VB2005 As you may gather I want to get the CRC value for strings or characters send out and then append the CRC (it may be High/Low or Low/High). If there is a way of dividing even larger integers such as 3  or 4 bytes (for 24 and 32 bits CRC) then it would even be better. I have seen something about converting integers into byte arrays but I'm not clear on how to go about it. Thank ...Show All

• SQL Server Error while registering a new sql server

  TITLE: New Server Registration ------------------------------ Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again. ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53) When I try to regiter a sql server, I take this error message. I a ...Show All

• Windows Forms How do I Deploy the WinFX Runtime Components?

  I have an app that has dependencies on WinFX (WCF to be specific) so I'd like to be able to deploy the WinFx Runtime Components with the app but I don't see the runtime components listed in the list of Prerequisites. So, is it possible to include the WinFx Runtime Components in the ClickOnce deployment and if so, how Thanks, Greg Hi Greg, You should create a bootstraper package and put it in a folder in this directory C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\WinFxPackage Restart VS and you will see your package in the prerequisite dialog. I did the package for WinFx, if you wan ...Show All

• Visual Basic How To Add Coulmn in table MS Access database

  I'm using VB2005 , 2003 I have created my database, but with time I need to add or delete some columns in my table, How can I do it ReneeC wrote: What I am working on IS ADO.NET accept for table Creation/Persistence and is only intended to local Access databases. Are you saying that DAO would be better Jumping in here again...The primary advantages for using DAO are performance and full support of Access database features. Otherwise, it's a dated, clunky object library that requires interop to work with .NET. I personally don't use it unless absolutely necessary. My recommendation is to use the Jet OLEDB P ...Show All