DRD32206's Q&A profile

• SQL Server Problems in excel exportation

  Hi, When I exported a report in excel format, The zeros are exported in a different way --> O or () or empty. I check the zeros in the report and they are in correct format 0 and without decimals. Somebody knows to the reason and some way to solve it ...Show All

• Visual Studio Relationships between compartment objects

  I'm having difficulties creating connectors between compartment objects in two different domain classes. Been playing around with it for a while and keep running into the following problems, could somebody explain to me exactly why this happens Error 1 The name 'GetSourceShapeForControlToHandler' does not exist in the current context Error 2 The name 'GetTargetShapeForControlToHandler' does not exist in the current context Error 3 'ITT.MVC.MVCDiagram' does not contain a definition for 'GetSourceRolePlayerForLinkMappedByControlToHandler' Error 4 'ITT.MVC.MVCDiagram' does not contain a definition for 'GetTargetRolePlayerForLinkMappedByControlToHandler' Error 5 The name 'GetParentForControlClassHasEventHandlers' does not exist in ...Show All

• Visual C# No Overload error help

  I'm creating a TreeView at runtime. This tree loads, the app populates it from a database and the child nodes are updated correctly. However, I'm currently getting this error after adding a line of code that would handle any node selection: Error 1 No overload for 'OnTreeView_AfterSelect' matches delegate 'System.EventHandler' I've created an instance of the TreeView at the class level and added code to create it and add it to the form at run time. The error occurs when the build gets to the highlighted line in the code below. I have read thru the MS online help concerning this and I'm very confused because according to all of the samples I've come across, I'm doing everything right. I know there must be something I've missed. ...Show All

• Visual Basic Adding data in one column together

  I'm working on my first database application and I am stuck on how to add all the data in one column and display that total with a label. I've searched the forum with no luck. The data in the column is currency. Thanks for all the help Here is the code I have so far not included irrelevant stuff. Basically started back from the beginning. I've been reading tutorials and help files for 4 days straight and have tried countless times to get the sum of just 1 field in just 1 table:) Table = "WagerAccess" Field = "Winnings" Red Code below = where I would like the query to take place Public Class Form1 Private Sub WagerAccessBindingNavigatorSaveItem_Click(ByVal sender As System.Ob ...Show All

• Visual Studio Error 1606. Could not access network location. SP1 for VS 2003 & 2005

  I tried to install the SP1 for VS2003 Pro and I get the Error 1606 Could not access network location:. I have gone through all the reg fixes for this that I can find on line, but still get the error. I have re-loaded the SP1 file, turned off the firewall, virus protection etc. but no go. Any ideas would be helpful. Thank You Strange deal indeed. I had the CD in the drive and thought I would see if it would re install or repair something in VS 05 that might cause the problem :Error 1606" Well now when I start the setup file to install VS 05 I get the same error message "Error 1606. Could not access network location:. I went into services and turned on everything that had to do with network control, inclu ...Show All

• Architecture Looking for Business Analysis template document...

  Hello, I don't know if I'm writing to the right forum... I have to start the business analysis process for a huge project within my company. I'm more experienced on the Technical analysis, I know what the business analysis involve but to write documentation is not my core skill and english is not mother language so I would like to ask if somebody can send me some kinds of template document (if it exists ...) to start to work on. Thankx for any help Marina B. Hi marina B. The best set of templates I have seen is from the MSF for Agile Software Development. MSF Process Guidance can be downloaded from here: http://www.microsoft.com/downloads/details.aspx familyid=9F3EA426-C2B2-4264-BA0F-35 ...Show All

• Visual C++ Linker errors in VS2005 fro CRT Functions

  Hi, I am trying to migrate a very big VS 6.0 project to VS2005 and have almost done through, but I am facing very basic linker error at the end. I do not have any idea on the same and someone please help.Below is the error llist I get. <<<<<<<<<<<<<<<<<<<<<<Linker>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Linking... LINK : warning LNK4098: defaultlib 'MSVCRT' conflicts with use of other libs; use /NODEFAULTLIB:library opcrestrc.obj : error LNK2019: unresolved external symbol "__declspec(dllimport) public: void __thiscall std::basic_ios<char,struct std::char_traits<char& ...Show All

• Software Development for Windows Vista State Machine Exception Handling

  Can anyone tell me what the best practice is to handle exceptions in a state machine process. I would like to move the instance to different error states depending on the type of exception. It would seem that normal compensation processing is not available in a State Machine Regards Jaco Hi Jaco Thanks for the reply. Yes i did do that, i created a simple console application, with a state machine workflow.In the stateinitialization activity i added a fault handler, which had faulttype set to System.Exception and then i added a code activity which was doing FaultHandler1.Fault.Message, but the Fault was returning null. The exact same thing when i did it for Sequential Workflow, it has the fault populated fine. Any Advice ...Show All

• SQL Server Only 9999 Rows after MERGE JOIN in SQL Server BIDS

  I've gote 2 Tables with about 50.000 rows and I left outer join them with MERGE JOIN. The result are 9999 rows. Has anybody got the same problem. Maybe it's a bug! Daniel Krebs wrote: I've gote 2 Tables with about 50.000 rows and I left outer join them with MERGE JOIN. The result are 9999 rows. Has anybody got the same problem. Maybe it's a bug! Merge joining is one of the trickiest components to use in SSIS. First make sure the data is sorted when it gets into the merge join; then you have to tell to the data flow pipeline how the data is sorted by changing some properties in the source component. Alternatively, you could place a Sort transform before the merge join; but that is ...Show All

• .NET Development Web Service client has "nothing" for result.

  I have a crazy situation where I'm hitting a web service (written in Java), with a client I'm writing in VB (2005, with ASP 2.0)... the return type from the web method is a complex data type (not that complex - just has four different strings). It is consistently returning "nothing" when I call the web method. Here's the thing: I can hit the same web service with XML Spy sending in the same information, and that works just fine. I also used a sniffer tool and was able to see that my client is indeed receiving the correct response back from the server via HTTP... it's just that Dot Net is losing it somehow and by the time it gets back to my VB code, it says there's "nothing" there. (Argh!) Has anybody hit a situati ...Show All

• SQL Server How to create a stored procedure to query the data mining model?

  How to create a stored procedure to query the data mining model Where can I find some sample code Thanks. Joe. Details on how to create a stored procedure can be found at http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnsql90/html/SQLDMPrgrm.asp whitetaper In the "Extending the Functionality of SQL Server Data Mining" section there are multiple examples of stored procedures. One of them, ExecuteContentQuery, shows exactly how to execute a (content) query over a mining model. The content query can be replaced with any other DMX query returning flattened results Hope this helps ...Show All

• SQL Server delete multiple rows with 2 ids

  Hello All, I have a table: idSurrogate int identity id1 int id2 int id1 + id2 is a unique index I need to delete multiple rows from the table given a list of id1 and a list of id2 In other words @id1List = '10,20,30' @id2List = '1,3,5' I need to delete these 3 rows from the table 1) @id1=10 and @id2=1 2) @id1=20 and @id2=3 3) @id1=30 and @id2=5 I am a bit lazy today - can anyone help out with a delete sql stmt Thanks! HPEvju, After reading Umachandar Jayachandran's answer, I was put on the right track and used my own udf that essentially does the same as your splitAry. Thanks for all your help ...Show All

• Windows Live Developer Forums VEMap.GetMapView() returning only the lat/longs for upper left tile

  I am using the VEMap.GetMapView() to get a VELatLongRectangle object that represents the current map view. I am trying to get the upper left and bottom right lat/long pairs to use as a bounding box for a sql query of some spatial data being used to create pushpins. I have the call in an onClick event handler but it only seems to return the lat/longs for the upper left tile in the map view no matter where I click on the map. What gives Any ideas I was having some issues with GetMapView also, i assume it was due to my div nestings or map resizings. Anyone i switch to use: map.PixelToLatLong(0,0) and map.PixelToLatLong(800,600) (asumming you know the size of your map - replace 800,600 - i know this bec ...Show All

• Windows Forms hyperlink in datagridview

  I'm using a GridView in C#.Net 2005. One of the column of the GridView is Hyperlink Column. When i click the hyperlink i want some message to be displayed in another datagridview page and that should be retreived from database based on the link message. i know how to put the hyperlink to the text,but i dont konw how to retreive information based on that link. How can i achieve this Where should i write my coding Hi Shirisha, I assume you must have used DataGridViewLinkColumn to display your HyperLinks. In that case, in order to repspond to User Clicks on HyperLinks, you must handle the CellContentClick event. This event is distinct from the CellClick and CellMouseClick events, which occur when a user clicks anywhere in a ...Show All

• Visual C# Find the right library at runtime

  Hello, Im writing a program that checks several company's websites for prices and compares them. Since every website is different, i have a different library with specific methods for each website. I want to be able to add libraries later on without having to change the source of my program. What i wanted to do was specify the library names in xml, use that to make an arraylist of websites, and use reflection to use those libraries. However, the program can't find the libraries unless i add the right reference before compiling. Is it possible to add libraries and use them without having to add a reference and recompiling my program Thanks in advance, Stijn I still haven't gotten this completely right... ...Show All