explode's Q&A profile

• SQL Server convert getdate() to string dd-mm-yyyy

  I would like to convert getdate() value to string of dd-mm-yyyy format in SSIS... how can I achieve this Jamie Thomson wrote: Mahesh, Thanks for posting that! I would actually rather they give us the ability to build user defined functions rather than adding a plethora of new out-of-the-box functions. ask and ye shall receive: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=166367 ...Show All

• Visual C# Keyboard Shortcuts

  How do setup keyboard shortcuts on my application Say that I wanted a user to be able to press "Ctrl + S" and have it open the "Save Web page Dialog"... How would I do that Thanks much! Landon Hi, Landon Parks To verify that the Ctrl key and the S key are pressed at the same time, follow these steps: 1. Open Visual Studio .NET. 2. Create a new Visual C# Windows Application project. 3. Add a Button to the form. 4. In the form, type the following code: private void Form1_Load( object sender, EventArgs e) { // Set these when the form loads: // Have the form capture keyboard events first. this .KeyPreview = true ...Show All

• SQL Server Lookups and their error flows

  So I have three lookups in a row in my data flow. Basically they are doing data quality checks for me using a reference table. I want to be able to take the error flows of the three lookups and merge them together (union all) so that I can insert the "errors" (or non matches) into a table. Can't do it. Because SSIS deems non-matches as "errors" you automatically get the errorCode and errorColumn fields. When you try to union a lookup error output with another lookup's error output, you can't do it. What I would like to see is a lookup act more like a conditional statment where you have three outputs of a lookup table: match found, no match found, and error. Either that, or I'd like to be able to edit the names of the errorCode and errorCol ...Show All

• Software Development for Windows Vista SDK error:

  Hi all, My sdk command prompt is giving an error when i tried to build some source code like 'cl' is not recognized as internal or external command. I feel there some problem with the enviromental variable. Any ideas Thanks in advance If your compiler install did not alter the base environment variables then this problem will occur. What you can do is go to the folder where the compiler is installed and run its command prompt, then from that command window cd (change directory) to the SDK folder and execute the environment vars cmd or bat file. You may need some command line switches to tell it if it should be debug or retail etc. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA GameStudio Express: Calculate Normals

  Hi. Right now I'm using VertexPositionColor and an index buffer to create a terrain and I'm going to do a transition to VertexPositionColorNormal. I currently have the following 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 _DStarField { public class Terrain { private GraphicsComponent graphics; private Camera _cam; private int width; private int height; private int [ ...Show All

• Visual Studio Team System Shared Workspace error message

  Hello! I have a development team, which for various reasons created their workspaces to map to the same network drive location. Example: user1 has workspace for $/TP1/folder1 mapped to I:\folder1 where I:\ is the network location accessible to all his team members. He usually works on items in folder1 and doesn't touch other folders in the Team Project. user2 also has his workspace mapped to I:\folder2. He works with items in folder2 only. Now, user1 is OOO and user2 is trying to modify folder1 contents. User1 doesn't have anything checked out from TFS. User2 maps his folder1 workspace to I:\folder1 as well. He checks out a file, makes modifications and checkes it back in. The out put window shows that Changeset <#> is ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Will the MethodInfo class in System.Reflection be available on Xbox 360?

  I know portions of System.Reflection will not be available on the XBox 360 version of the .NET Compact Framework. I'm wondering if the MethodInfo class will, It would be nice to be able to call C# methods by name and I can't think of any security reason why this would be a problem. ...Show All

• Windows Forms Highlight row when hovering DataGridView

  I want to design my DataGridView so that when the mouse hovers over a row, the row changes its BackColor. I have most of the code correct, except that once a row is highlighted, the row does not go back to its original color when I hover over another row. What am I doing wrong Here's my code: private void MouseMove( object sender, MouseEventArgs e) { // Sets BackColor of the datagrid row that the mouse is hovering over. Point pt = new Point (); DataGridView . HitTestInfo hti; pt = this .PointToClient( new Point (e.X,e.Y)); hti = dataGridView1.HitTest(e.X, e.Y); if (hti.Type == DataGridViewHitTestType .Cell) { dataGridView1.DefaultCellStyle.BackColor = Color .White; dataGridView1.Ro ...Show All

• Visual Basic Import DLL

  I have a DLL and know the functions in it. The DLL is located in my Program Files folder and I would like to use those functions in a VB program. How do I set the imports tag to reference the DLL so that I can use those functions The DLL Information that I am trying to use is as follows: The .DLL Files MRWSCRIPT.DLL - Scripting dynamic Link Library functions MRWSCRIPT.LIB - Scripting Development Import Library Scripting API Functions and Data Structures     This API Library was written for the Windows (R) 32 bit programming environment. SCREENINFO The purpose of the SCREENINFO structure is used to keep track of the current cursor position and MAGIC window size. SCRE ...Show All

• SQL Server Extended Procs using C#

  What is the procedure to create a extended stored procedure using C#. Actually we have created a dll file using c# and it was added to the bin folder of mssql server. Also dll file is added to the sql server using "xp_extendedproc" But while executing the extended proc we got this error "ODBC: Msg 0, Level 16, State 1 Cannot load the DLL xp_TestSql.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.)" No!  Again, created Extended Stored Procedures in .NET languages is not supported.  Did you read the KB article I posted a link to -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 -- ...Show All

• SQL Server Linked Server/DTC Error in WinXP Vs Win2003Server

  Client side: WinXP Pro with MSDE 2000 Server side: Win2003 Server with SQL Server 2000 I've got the error message when creating linked server and running the DTC across two database servers, ""Error 18452: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection." But, orginially, if the Server side is Win2000 Server with SQL Server 2000, everything is okay. When I migrate it to the Win2003Server platform, this thing happened. I've also applied the following solution but it still doesn't work. http://support.microsoft.com/default.aspx scid=kb;en-us;827805http://support.microsoft.com/default.aspx scid=kb;en-us;827805 and http://support.microsoft.com/ kbid=873160 and the l ...Show All

• Visual Studio Express Editions View source code!!!

  Hey, how can i view the source code on a webbrowser ok. 1) did you navigate to a webpage first in the webbrowser Me.theWebBrowserControl.Navigate(" http://www.microsoft.com ") 2) did you do this to display the code in a textbox after the page was loaded Me.theTextBox.Text = Me.theWebBrowserControl.DocumentText   remember, you have to wait until the contents of the webpage have been loaded in order for you to view the source/code of that site otherwise you will get nothing, as you currently maybe experiencing. Select the webbrowser control in designer view. View the events (lightning icon in the properties window) and double click "documentCompleted" to create the document completed event so it will ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA GSE for 360 ? - This Holiday Season ?

  ... Just Checking ... The XNA GSE for the 360 is supposed to be released ... "This Holiday Season" ... Any actual Date Ranges at this Point http://blogs.msdn.com/xna/archive/2006/12/11/xna-game-studio-express-has-been-released.aspx \ ...Show All

• Visual Studio Express Editions Microsoft Visual+++ Runtime Library

  I had unsuccessful download Norton SystemWorks 2006 and went on alive chat from Symantecs, I explained my situation and a person gave me instruction "For assitance to use the Symantec removal tools to remove left over Norton files and registry entries of previous installation of Norton products." So as I followed it, restart and then when I got in Windows, strange pop up with screen and said "Microsoft Visual+++ Runtime Library, then next "Runtime Error! Program C:\WINDOWS\system32\bcmultry.exe This application has requested the Runtime to terminate it in an unusual way. Please contact the application support team for more information." Also I noticed some of my program cannot open it like ipod, scanner, and as wel ...Show All

• Visual Basic SQL 2005 and MS Visual Studio 2003

  After I looked the 'RELATED QUESIONS' my questions were answered. My question was "Can MS Visual Studio 2003 and SQL Server 2005 Express Edition be used together " No they can't be used. Since I just started to learn Visual Studio 2003 and updating from VB 6, I find myself having to stick with this verison of VS. Now my question is there a cd I can get MSDE 2000 I call MS and talk to may people and they seem to think there is no way to get this product. I down loaded MSDE 2000; but, all the other programs that look like should come with this mgr, etc. could not be found on the down loads. Any help would be appreciated. THANKS Ray actually I've just confirmed, you are able to use VS2003 and SQL ...Show All