ThunderRock's Q&A profile
SQL Server Using fussy lookup in sql server 2005 integration services
i have 4 different databases, in each one i have a table of customers i want to combine the 4 tables of customers from the 4 databases in a new table with eliminating similar records The UNION ALL component can be used to combine the 4 datasets into one. You can then use the SORT component to eliminate duplicates. If you want to eliminate duplicates that are similar but not the same then you should look to use the FUZZY GROUPING component rather than SORT. There is plenty of online material that shows how to use it. The real trick is to work out the level of similarity that gives you the results that you need. -Jamie ...Show All
Visual Studio Tools for Office Office 2003 smallbusiness supports vsto?
Hi, does office 2003 support vsto If no, are there any extension for this version of office to supports vsto Thanks. Here is a link to the System Requirements. What is supported is clearly spelled out for you: VSTO Requirements ...Show All
Visual C# BUFFER a page into the cache before loading page into browser
If I am not mistaken (but please do correct me if I am) a webpage is buffered into the cache of the machine before it is loaded into the browser. Question: (if the above statement is true) How can I manipulate(read, write) the stored page in the cache before it can be loaded into the browser. NOTE: "It would be in C# way if possible. " Please help me in this, I am trying to manipulate a page before it is loaded into my self-made browser. Cause, if this would be possible, maybe there is also a possibility that a page can be checked for being a spoof before loading it into a browser. Hope I can find answer. Thank you and more power! Ichi If it's your "self-made" browser, you can design your own caching policy (set ...Show All
Windows Forms Is visual studio bootstrapper and clickonce bootstrapper the same thing?
Is visual studio bootstrapper and clickonce bootstrapper the same thing Well, let me qualify that... There is a Visual Studio Bootstrapper associated with the Express SKUs of VS that is unrelated to ClickOnce bootstrapping. But you will also see in many places the Bootstrapper for ClickOnce referred to as the Visual Studio 2005 Bootstrapper. The official name for the ClickOnce related Bootstrapper is the Generic Bootstrapper, but that is not very descriptive either... ...Show All
Visual Studio Express Editions Command line error D8016
I'm new to Visual and I just started programming... My problem is that when I turn a program into the Multi-Thread (/MT) form under the Runtime Library this error comes up when I build it: Command Line Error D8016: '/MT' and '/clr:pure' command-line options are incompatible Please help... I made this program 3 times and each one didn't work... I have to have it for school... I have the same problem. I want to build with static libraries (MT) because it is a small routine that I want to share with other people and my experience with DLL is it never works. Previously I could get away without CLR but now when I switch it off I get lots of compile errors. What is AssemblyInfo.cpp and do I ...Show All
Internet Explorer Development IE7 issue with Integrated Windows Authentication in IIS
Hi, I've a web application developed in ASP.NET which is hosted in a Windows 2000 server with only Integrated Windows Authentication enabled. This is to make use of Active Directory Services. Now, everything works fine with IE6. But in IE7, I get the Page Not found message. When I checked the headers, I saw the status as 401.1 which, if I am correct, basically is because of some Permission issues. Why do I get this if I use IE7 This above issue is with my Production server. Now, having said that, I've a test server which is also Windows 2000 on which everything works well. I just dont have a clue as to where the problem is with my Production server. Please help me on this ASAP as I am getting a lot of calls from my clients regar ...Show All
Smart Device Development get application exename and path
Im using VB on Visual Studio - compact framework 2.0 How can I get the path of the exefile currently running app.exename etc. is not available in the compact framework. Thank you. That works. For VB I used this code: Dim appPath As String = System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase appPath = System.IO.Path.GetDirectoryName(appPath) ...Show All
Visual Studio 2008 (Pre-release) Code Snippet Picker crashes after LINQ May 2006 CTP install
Hi all, Well, it's all in the subject ! After installing the May CTP, invoking the Code Snippet Picker either with right-click->Insert Snippet or Ctrl+k+x crashes Visual Studio... Two things to add : - It is a Standard Edition which is quite heavily CTP-installed (Workflow extensions RC4, Guidance packages, July Windows SDK, ...) - If I uninstall the C# IDE Support, it fixes the problem... but it comes back as soon as I restore the C# IDE support ! Should I try some kind of devenv /setup /helpme /please thing Thank you for your help ! Thomas Hi guys, I had exactly the same problem. So I switched to "Snippy" which is a free 3rd party code snippet edito ...Show All
Visual C# Files has invalid value "public partial class Form1 : Form" The path is not of a legal form.
Hi When i try to compile or run my program i got this error message. Files has invalid value "public partial class Form1 : Form". The path is not of a legal form. It is ok to ignore and the program runs fine. But the problem is that i cant publish the program. Regards Fredrik What do you meant by "i cant publish the program" If you are talking about a "Web Form" , then it should be inherits for System.Web.UI.Page public partial class WebForm1 : System.Web.UI.Page { } If your problem is different than above, please explain it little bit more ...Show All
Windows Forms Combobox items Adding!!
Hii, I am using c# windows application: I have two arrays of strings one named textArray and the other is valueArray. I want at runtime to display the elements of the textArray in the combobox while the items value is added from valueArray: e.g say one item is US Dollar and its value is USD. Thanks hmm so what about DataTable object i can make a datatable with two coumns one for country and the other for currency code. so i thin it would be like this theComboBox.DataSource = table; theComboBox.DisplayMember = countryColumn; theComboBox.ValueMember = currencyColumn; ...Show All
SQL Server VOTING/RATING SYSTEM: HOW TO ADD POINTS AND UPLOAD SQL VALUE?
I am trying to build a voting system. Website visitors will rate a pictures from 0-10. This value should update the amount of points already stored is SQL. I think the way to do it is passing the value of a field to a varible, performing the operation and updating the database, but I don't know how to capture a value in Sql and pass it to variable... Does anybody there could post a piece of code or point to a link where I could find this information thanks OK, what kind of code snippet do you want The one on the data access layer, or the one on SQL Server I impleneted a coting system on my site which takes the indiviual vote, adds that to the Votation table and whenever someone is requesting the Average on the particular Screencast ...Show All
Smart Device Development Smart device web service client
Hi! I can't get web service client working using Visual Studio 2003 (either VB.NET or VC#). I created a web service in Java, and published to Glassfish (aka Sun App Server 9). Tested using his web interface, works like a charm. Then I've created a Visual C# Windows application, added a web reference and either methods that return bool and complex objects works - I was amazed! So, I've created a new Visual C# Smart App project, added a web reference. When I complete this task, and try to compile, I get: D:\newPP\SmartDeviceApplication3\Web References\usuario\Reference.cs(36): 'System.Xml.Serialization.XmlElementAttribute' does not contain a definition for 'Form' and so on! The code is: [System.Web.Services.Protocols ...Show All
Software Development for Windows Vista Task Pages integrated within the Control Panel
Hi, I am developing a control panel applet specifically for Windows Vista. I need this applet tightly integrated within the UI of the control panel, such that when the applet runs, it inherits the area, look and feel of the control panel. It will have custom pages that live within the area of the control panel UI when you navigate into the applet. All of this is in line with the Windows Vista User Experience Guidlines . My question is: How do I do all of these things discussed above and in the User Experience Guidelines It is clear that the intent is for ISVs to be able to accomplish these things based on their appearance in the guidelines, but I have not found any documentation regarding the actual implementation of such things. Can you ...Show All
Windows Forms Help with NumericUpDown
Hi all, I hope someone can help me with this. I have a calculated result that i send to a numericUpDown. The value inserted in the first NumericUpDown is then collected and prcessed further. The reason why I'm using the numericupdown is that the reults will be compared to a "real value" and the user should be able to correct this since the result will be further processed. My question is how can I capture the correction, i.e. if the calculated value is 200 but the user correct it by using the up and down buttons to let's say 203 I want to get the value 3. Does anyone have a solution Thanks, //OPH In my opinion, that would complicate things, however, to do this, you need two stores, storeU ...Show All
Visual Studio Tools for Office VSTO PowerPoint Add-In - Object reference not set to an instance of an object
Hi I hope anybody can help me. I have made a Application based, VS 2005 Tools for Office SE (C#) PowerPoint Add-In which creates a new CommandBarPopup after check if it not exist. It's the same code like http://msdn2.microsoft.com/en-us/library/0batekf4(VS.80).aspx I use Visual Studio 2005, Windows XP and Office 2003 Prof. on my DEVELOPMENT Machine. I use Windows XP, Office 2003 Std. SP1, Office 2003 PIA, VSTO Runtime on the VMWare TEST Machine. Anything works fine on my development machine, but if i install the MSI of my Project Setup on my Test Machine and start PowerPoint it always view twice the NullPoint Exception "Object reference not set to an instance of an object". In my ThisAddIn.cs there are the ...Show All
