Gurpreet Singh Gill's Q&A profile

• SQL Server SSIS data Convertion ??

  Hello all Ho can i convert Integer to String in SSIS Derived column. Thanks in Advance Raj Lakamana I am assuming that you have already tried casting etc. I can suggest some workaround... What is the source of the Integer If it is coming from a table, you can change the "Data access mode" from "table or view" to "Sql command" and format your command like "SELECT col1, col2, convert(nvarchar(20), my_integer) as col3 from src_table..."  If it is coming via lookup, do the same by modifying the query in the advanced tab. HTH, Nitesh ...Show All

• Windows Forms Windows installer launch condition

  Hi Guys, I am trying to create a setup and deployment project in VS 2005 for a windows form project. A couple of dependencies for my application are - 1) .NET framework 2) ActiveState Perl 5.8.8 I have been able to successfully add the .NET 2.0 framework check to the launch condition. I've also added the Active Perl check but its not working right. I mean, I get a "perl not found" error even on systems where the perl is installed. How should I correct this behavior Its probably something in the Condition check that I'm messing up. Here are the properties I have for perl launch check - (Name) ActiveState Perl Condition Installed InstalllUrl <url> Message Perl could not be found. Please install ...Show All

• Visual Studio Express Editions Cannot copy website with ftp

  I have just installed VWD SP1 on a new Vista system and cannot get it to connect to my website. I have entered all the appropriate information in the conection screen and when it tries to connect the system hangs and the the program becomes non responsive. The only way out is to exit the software. I can access the site via ftp through explorer no problem with the same settings which tells me it is VWD that is causing the problem Any help would be appreciated. Thanks Michael I have exactly the same problem on a Windows XP. I installed it at the same time as a friend of mine and he connects to our FTP site with no problems. Have you recieved any answers to this problem. I am reinstalling vwd ...Show All

• SQL Server Permissions to view Stored Procedure Property

  My Production servers are SQL Server 2005 x64. I would like to allow my developers the ability to look at permissions on production stored procedures but not be able to change those permissions or alter the production code. What has to be set to allow this sort of security. I have done that for the developer group and I still get this error on Stored Procedures TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. ------------------------------ ADDITIONAL INFORMATION: Cannot show requested dialog. (SqlMgmt) ------------------------------ Property DefaultSchema is not available for Database '[HouseAccounting]'. This property may not exis ...Show All

• .NET Development SecurityException with remote PerformanceCounter under .NET 2.0

  I have some code that attempts to read a performance counter on a remote machine. Under .NET 1.1 the code works just fine, but under .NET 2.0 I get a SecurityException with a description of "Requested registry access is not allowed". Everything about the code and target machines is the same, with the only difference being that I'm running the code under a brand new installation of VS.NET 2005. As for security, I am a member of an AD group that is a member of the local "Performance Monitor Users" on the target remote machine. Under 1.1 this seems to be sufficient, but for some reason I can only create the performance counter object under .NET 2.0 if I add my group to the remote machine's "Administr ...Show All

• .NET Development Int64.Parse() and Hex Values

  Hello, I have a question regarding the way a hex string goes into an Int64. Does the Parse method assume that the string is in big endian format I have a problem I am trying to figure out and it basically comes down to, when I put a string of hex values into a Int64 and then use a bit converter to bet a byte array from it, it appears to be in reverse byte order when it comes out. Does anyone have any clues on why this is. Thanks Isaac -- Erm, hexadecimals literals are written with the most significant digit to the left, just like decimal numbers. Why do you think Parse() switches anything around ...Show All

• SQL Server SQL 2005 Setup error of 1935

  I am trying to install the client tools on an XP machine. I already had to run the .NET 2.0 repair to get past an earlier problem. 3 components fail, the first one being VS. Here are the highlights of the summary.txt file. What can I do to resolve this TIA! Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) -------------------------------------------------------------------------------- Product : Visual Studio Integrated Development Environment 2005 Error : Error 1935.An error occurred during the installation of assembly 'Microsoft.VisualStudio.CommonIDE,Version="8.0.0.0",FileVersion="8.0.50727.42",PublicK ...Show All

• Windows Forms Text field/box

  Task: I have a text box with maxlength property set to 0. What I want to accomplish is to determine whether an overfilling of the text box has occured. Example if you enter a text beyond the visual space or width of the textbox. Example: TextBox _txt = new TextBox(); _txt.MaxLength = 0; _txt.Text = "Yandisa Mtyide has been developing in C# for the last 10 months"; _txt.Width = 60; //Basically the text will overfill the text box, so if this occurs I want to notify the user that the textbox has been overfilled Thank you Try using TextRenderer.MeasureText to determine the displayed width of the text in the TextBox. ...Show All

• Visual C# internet options call

  hey i just did a browser (based in IE ActiveX), and i want to call the internet options, (from IE, the one that is in Control Panel) someone will get to you when someone know's how to. Creating another post does not really help - if someone know's the answer they will post. If the answer they provided does not work, explain what happens when you follow their answer/instructions I will now merge this thread with the other original thread ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Textured box not showing textures

  Iv been through the "How to: Apply textures to 3D Primitives" tutorial but can seem to get textures on my box. Its simply renderet in a single color (seems to be a color from the texture). Any idears code: using System; using System.Collections.Generic; using Microsoft.Xna.Framework; using Microsoft.Xna.Framework.Audio; using Microsoft.Xna.Framework.Components; using Microsoft.Xna.Framework.Graphics; using Microsoft.Xna.Framework.Input; using Microsoft.Xna.Framework.Storage; namespace WindowsGame1 { /// <summary> /// This is the main type for your game /// </summary> partial class Game1 : Microsoft.Xna.Framework. Game { Effect ...Show All

• .NET Development .NET Framework 3.0

  Does the framework 3.0 installer come with the appropiate documentation . I have framework 2.0 and VS 2005, once i install the Framework 3.0, will i have all the corresponding documentation in VS , if not, how do i install it You can download the latest MSDN Library: http://www.microsoft.com/downloads/details.aspx FamilyID=94596af5-cc58-45af-a14b-df627a31e783&DisplayLang=en Or use online help, using online help you will always have the latest documentation ...Show All

• Visual Basic Problem with GetChanges() from a DataTable Object

  I am trying to find out if a DataTable object has any changes that need to be saved to it's SQL Database using the Update() method. I looked throughout the properties of the DataTable object and can't find a Dirty property. But I did find a GetChanges() method. Problem is whenever I execute the GetChanges() method, which claims to return a DataTable of records that have been modified, I get the following error: MissingMethodException was unhandled No parameterless constructor defined for this object. Does anyone know why this is Or better yet, anyone know how I can accomplish what I am trying to do Try breaking out your code...something along these lines should work: ' Create variable for temporary DataSet. Dim ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Is there any way to tell if a sampler has a texture attached in shaders?

  Is there any way to tell if a sampler has a texture attached in shaders The default behavior is getting black when no texture attached but I want it to be some other color. That's true only for the texldl instruction which is SM3.0 only and is not the one used by sampling a texture using tex2D. For the texld instruction, it is undefined for all shader models (including SM3.0). Relying on this behavior is simply asking for trouble... ...Show All

• Visual Basic Scrolling Text/RTF Box

  I am interested in creating a scrolling text status control where the latest inputs appear at the top jof a text box and the older information is scrolled down. I don't have a lot of text information to manage, maybe 50 lines or so. I was thinking that I could create a string variable with the present contents of the text box and then insert my new information to the top of the string wih an vbcrlf and then replace the old text in the text box with the new string. Are there any simpler ways to accompish such a task. I use this status text box to capture error messages and other program generated messages. Thanks, Fred Dim TheText As String = String . Empty For x As Integer = 0 To 10 TheText = ...Show All

• Visual C# Where are the messages going to?

  hi everybody I've already successfully implemented a globally low level keyboard and mouse hook and it seems that this is all .net managed code could provide in global hooking. But after I got the message by the hook, where is this keyboard or mouse message going to the parameters and structures of hook event don't contain that information. any idea thanks in advance thanks Peter, but isn't it that when a message is posted to the message queue, the handle(hwnd) will be specified I mean in both SendMessage() and PostMessage(), the hwnd is in the parameter ...Show All