RDMarkus's Q&A profile

• SQL Server Lookup Transform

  Hi! I am a newbie, grateful for some help. I have a Source Ole DB w sql-command selecting the customer.salary and customer.occupation, which I want to match with demo_id in Ole DB destination. salary, occupation also in dim_demographic. But in Lookup editor I find no column demo_id... how do I do this The lookup must select against your table with demo_id in it... We need more information here... If you can't find demo_id in your lookup table, and you need it to be there, well then you probably have the wrong table defined in your lookup. ...Show All

• SQL Server Can you unpivot on multiple keys with the unpivot transform

  Hi all, I have more than 1 set of columns I'm trying to normalize, can an unpivot transform handle 2 unpivots around DIFFERENT keys in the same transform If not, would the suggestion be unpivot into temp tables for whatever needs normalizing, than run an update query to generate the row that is desired Thanks in advance. Mark Mark Frank wrote: Hi all, I have more than 1 set of columns I'm trying to normalize, can an unpivot transform handle 2 unpivots around DIFFERENT keys in the same transform If not, would the suggestion be unpivot into temp tables for whatever needs normalizing, than run an update query to generate the row that is desired Thanks in advance. Mark ...Show All

• Visual C# scope problem

  hi I've had this weird problem which is that : i declared this multidimensional array Code: public string[,] selectedTextInfo; i've initialize it in the form constructor Code: selectedTextInfo = new string[/*rows count*/, 2]; i've givin it a values in the load form event in a for loop Code: selectedTextInfo[i-2, 0] = editDataset.Tables[0].Rows [1].ToString(); selectedTextInfo[i-2, 1] = editDataset.Tables[0].Rows [2].ToString(); but when i'm trying to access a value from this array in the SelectedIndexChanged combobox event the value is null or empty " no text displayed just a blank" Code: MessageBox.Show(selectedTextInfo[0, 1]); //when i print the same messagebox ...Show All

• Visual Basic is their any reflector like tool in VB6

  i am having VB6 dll. i want's to get the source code, methods and whatever inside that dll. Is their any tool like reflector in .NET. Thanx in Advance. No, VB6 executables don't carry the same amount of metadata that managed executables do. You can view the exported types in the embedded typelib with a tool like OleView, but that's about it. ...Show All

• Visual C# Webbrowser control for setting proxy?

  I trying to create my own custom web browser, using the webbrowser control in VS 2005. I trying to deal with setting proxy server, but i just cannot do it. How to set proxy for my custom webbrowser？ i try using webproxy and webclient class, but still doesnt work for me. Try not to suggest modifying registry directly, and not to suggest going to internet explorer setting to change proxy. All I wanted to know if whether there is a class, such as mshtml, or whatever, that can be used to set proxy, such that the webbrowser control (that come along with VS 2005) can use that proxy for navigation. This question is the one of the most pathetic question asked on internet..cos I surf many forums. Many people ask this question, but  t ...Show All

• SQL Server Retrieving data types is slow

  Hello, i'm using SMO to retrieve information from various databases. It works well except for one thing. When I call the Column.DataType property to get the SQL type of a column it takes a very long tine. I have a few databases, each with some tables. There are about 75 columns I think. If I just browse all columns with SMO and write each name if it not a system one, it takes about 15 seconds (pretty much anyway). If I also retrieve the data type it takes about one minute. Any ideas why The server is a local one. Thanks ...Show All

• Visual Basic Converting PDF to TIFF

  In my current project I have a requirement to convert pre-existing PDF documents to TIFF documents as part of a process in a Windows Service. I've seen and demo'ed a few third party tools such as EasyPDF and PDFRasterizer. I was wondering if anyone knew of any open source or other solutions I should consider. Hi, Someone on here maybe able to automate this process.>> 1) Open PDF file in a maximised window. 2) Select FIT TO WINDOW option. 3) PASTE the window to the clipboard. 4) Open PhotoShop ( or a package that can save TIFF's ) 5) PASTE into Photoshop or similiar. 6)a) Ask the user for a base file name for each page like myLecturePDF01.tif 6)b) Advance the file number e.g. myLecturePDF02.tif, myLec ...Show All

• Visual Studio Express Editions Printing

  This area is a little confusing.. Please, would someone assist here or provide code to simplify. I tried the below code but it only prints "this will be bold" and "this will start at 400 pixels" - borrowed code I am trying to use the dialogue box just like a standard program where the user chooses the settings and all functionality available in windows.   Shihan     Thanks but that did not work... please, how do I set up printing with the standard window print controlls with the print dialogue box Shihan ...Show All

• Gadgets Getting settings to function

  I am writing my first gadget. I am writing the settings.html file. I want to have five radio buttons in the settings. I have created the form and the five radio buttons. I'm not sure how to return the value of the selected radio button to the main program. If someone could explain to me how to take the value of the chosen radio button and report it back to the main program, preferably as an integer, that would be great. Here is a section of my settings.html <body onload="init()"> Play sound to count down to every: <form name="intervalform"> <input type="radio" value="no" name="interval" />do not play sound<br /> <input type="radio" value="minute&qu ...Show All

• Visual Studio 2008 (Pre-release) I want to specify attached property for Binding.

  For instance, I want to know the change in the Grid.Row property in the MyGrid class. It is the following codes that I tried. public class MyGrid : Grid { static MyGrid() { FrameworkPropertyMetadata metaData = new FrameworkPropertyMetadata(0); metaData. PropertyChangedCallback += OnAttachedRowChanged; Grid.RowProperty.OverrideMetadata ( typeof(MyGrid), metaData ); } private static void OnAttachedRowChanged( DependencyObject d, DependencyPropertyChangedEventArgs e) { // It is not called. MessageBox.Show( "Call OnAttachedRowChanged" ); } ｝ It is not possible to straighten out that problem by "Grid.RowProperty.OverrideMetadata". Please teach the method of receiving the notification. ...Show All

• Visual C# Dynamic Thread Creation

  Greetings everyone, I have found myself in an empasse while trying to dynamically create an array of threads. Let me try to explain what I mean by "dinamically creating". One of the four overloads of the Thread constructor takes as a parameter a ThreadStart delegate, which needs a method name in order to be fulfilled: System.Threading.Thread m_MyThread = new Thread(new ThreadStart(MyMethod)); My scenario is different and a bit more complicated, in fact I haven't been able to find a working solution - I'm not even sure if what I'm trying to accomplish it's possible at all. I am developing a plug-in system for a commercial 3D engine. Some methods inside these plugins can be run on a different thread if the plugin devel ...Show All

• Visual Studio The filename selected is not recognized as legal

  I'm completely new to VSS and am having problems. I can add projects and solutions to the database I've created, but I can't seem to open them from another machine. If I go to File, Open Project and select SourceSafe (LAN) and browse and select my SLN file (or VBPROJ file for that matter) and try to open it I get this error: The filename selected is not recognized as legal. Please select another file or rename the selected file. Any help would be appreciated. Like I said, I'm very new to this. I don't think it's related to the file name - I have this problem on my PC, when attempting to open any solution or project from SourceSafe through the open project dialogue. The same projects work fine from ot ...Show All

• Visual Studio Team System Webtesting

  1. While recording a webtest, pop up messages are displayed while resetting user password, unlocking a user,etc. But while running the webtest the pop messages are not displayed. Hence i am not able to validate whether the password is changed or not. Please guide me as to how will i be able to validate the pop up messages displayed 2. While running the script for creating a new user, the user is not given appropriate permissions, since when the script reaches the permissions page the Contact Info ID and Account ID are encrypted. However the new user account is created but he does not have any links when logged in with the newly created user What creates the new set of permissions Are they created throu ...Show All

• Visual Studio Team System Team build database project

  My company is developing a distributed application. We have many solutions and projects. One of those projects is a Database project where we build C# stored procedures and deploy them to sql server 2005. The Database project references assemblies from other project that have been created on sql server. When we use team build to build the database project we get errors that it can't find the references to those assemblies. Again, these assemblies exist on sql server and are referenced in the project. My question is how does team build get the assemblies out of sql server when it builds a database project Jeff Sessions I'm not familiar with this, so it would be helpful if you'd post the build l ...Show All

• Software Development for Windows Vista simple Human Workflow doesn't work

  Hello everyone, visual Studio can't start debugging because the debug target: ... HumanWorkflow WinformDemo.exe is missing. when i run the Sample, i became 30 errors. for example Error 4 Activity 'emailToManager' validation failed: Path 'leaveXmlData' used to specify member for 'EmailWorkflow' is invalid. Path needs to point to valid member. .cs 1 Error 5 Activity 'emailToManager' validation failed: Path 'managerEmailId' used to specify member for 'EmailWorkflow' is invalid. Path needs to point to valid member. can somebody help me thanks a lot iowi The version of the sample you are using was not written for the version of the product you are using. Which version of the product are you using My guess is you are ...Show All