Sam England's Q&A profile

• .NET Development Where is Sysem.ServiceModel?

  I just installed VS 2005 with version 2.0 of the framework. I'm attempting to work through a WCF example. I don't see the ServiceModel in the AddReference list. Is this a 2.0 or 3.0 component Information on the SDK can be found at: http://msdn.microsoft.com/windowsvista/downloads/products/getthebeta/default.aspx ...Show All

• SQL Server noob question of how to combine two tables from two different servers.

  I got two tables from 2 different server A and B. I do a OLEDB source [server A] with "select ID, currencyNo, exchangerate from table A" I do another OLEDB [ server B] source with "select currencyNo, currencyName from table B" i want to combine these two OLEDB sources with a resultset "select ID, currencyNo, currencyName, exchangerate from table A , B where A.currencyNo = B.CurrencyNo" how do i do this in SSIS sorry if i m a noob. I dun want to use linked servers. can someone help Running that kind of query is not something that SSIS is going to do magically for you. You have to ask your DBA to set link servers (assuming they are SQL Server). O ...Show All

• .NET Development error SDL1013 when adding a web reference

  Hi everybody, I get the following error when trying to add a web reference from a Visual Studio 05 (Prof) C++ project: ------ Build started: Project: test, Configuration: Debug Win32 ------ Creating web service proxy file for fr_urssaflocalhost ... c:\Documents and Settings\NU\Mes documents\Visual Studio 2005\Projects\test\test\fr_urssaflocalhost\WebServiceAncre.wsdl(253,54) : error SDL1013 : could not resolve part, with [ namespace = "http://schemas.xmlsoap.org/soap/encoding/" name = "string" ] sproxy : error SDL1002 : failure in generating output file: "fr_urssaflocalhost.h How can I fix this issue (the webservice itself works perfectly) please I feel a bit desperate about thi ...Show All

• Visual C# How to implement drag and drop between excel and C# ListView

  Hi, Does anyone know how to implement drag and drop between excel and ListView in C# Drag and drop a single string is easy. But i don't know how to drag and drop a group of cells. Thanks Lee I find out the solution and done this way: MemoryStream stream = new MemoryStream(); StreamWriter writer = new StreamWriter(stream); int columnCount = listView1.Columns.Count; for ( int i = 0; i < columnCount; i++) { writer.Write(listView1.Columns .Text); if (i+1 < columnCount) writer.Write("\t"); } writer.WriteLine(); for ( int j=0;j<listView1.Items.Count;j++) { for ( int i = 0; i < listView1.Items[j].SubItems.Count; i++) { writer.Write( listView1. ...Show All

• Software Development for Windows Vista Modified CTextureRenderer freezes System when used with multiple Threads

  Greetings everybody, My App needs to copy the content of a IMediaSample-Videoframe to several Direct3D-Textures. I do this via Texturelock and memcpy, which works quite nice. I've done it successfully sequential with 4 memcpys and now want to do it iwth multiple Threads for better performance. The Problem is that my whole Systems freezes after an arbitrary time of Playback and I have to do a hard restart. My Textureloader-Threads are build like this: do { WaitForSingleObject(pThis->m_hTLA_Go[index],INFINITE); -> Lock texture memcpy(pTxtBuffer,pThis->m_Samples[index],pThis->m_textureWidth*pThis->m_textureHeight*4); -> Unlock the Texture ReleaseSemaphore(pThis->m_hTLA_Done[index],1,&pre); } ...Show All

• Visual Studio Is there a way for an msbuild task locate an assembly using a Registry entry

  If I already know the Registry entry which contains the path to an assembly, can I use this registry item to locate the assembly the assembly is located at C:\export\bin\Debug\Tools\Configuration.BuildTask.dll I have a registry entry something like this: [HKEY_LOCAL_MACHINE\SOFTWARE\Configuration\Common\Paths] "BuildTask"="C:\export\bin\Debug\Tools\Configuration.BuildTask.dll" How can I access this from the project files build task Is there some way in the project file to extract the data from the registry entry first <UsingTask TaskName="Configuration.BuildTask" AssemblyName="Configuration.BuildTask" /> I do not want to create another Task to do this for me as the reason for this is because ...Show All

• SQL Server Dropdown parameter in Report Builder

  Hi, Is it possible to create a dropdown parameter in Report Builder The result I want to get is (for example): The parameter is "Project". Next to the parameter should be a dropdown box from where I can select a project (for example: project1, project2, ...). Once the parameter is selected, and I click "view report", the report should only display data from the selected project. The only other options available in the Filter dialog screen are: "Field" is in list "Field" contains "Field" equals But none of these methods of creating a parameter generate a dropdownbox from where items can be selected, equal to those in the database. So ... is it even possible to create a dropdown p ...Show All

• SQL Server Putting DDL statemnets (CREATE SCHEMA), in a transaction

  Are T-SQL DDL Statements allowed within a transaction in SQL Server 2005 Hi, I'm working with some folks on a VS add-in that maps conceptual data models to physical DBMS implementations. Currently, the only target that doesn't generate a schema creation script inside a transaction is SQL Server 2005. Being a development project, having the CREATE SCHEMA script in a transaction would be useful, to avoid the need to clean out the parts of the DDL script that did run, and just start with a new iteration. When I asked why, they thought that SQL Server didn't allow DDL statements to run inside a transaction. Searching this, I could only find references that suggested you shouldn't (for performance reasons - but these are not an issue in this ...Show All

• SQL Server Insert Word Document into SQL Server Table as Blob

  Here is my problem. I have a table of Candidates Record_id first_name last_name Resume_Text Resume Resume_Path I need to insert the resume word documents on a remote drive into the database. The resume_path in the candidate table has the path for me: x:\john_doe_resume to identify which resume should be loaded for each candidate into the candidate table. I can't seem to find any documentation on how to write a procedure to accomplish this. Any help greatly appreciated. While I haven't done it, here are a few references I found: http://support.microsoft.com/default.aspx scid=kb%3ben-us%3b258038 http://www.sqlservercentral.com/forums/shwmessage.aspx forumid=169&messageid=243427 ...Show All

• Windows Forms Error in populating ComboBox and ListView Control...

  hai frendz, I tried the below prog, but cant get the reason for error.The ERROR is System.FormatException: Index(zero based) must be greater than or equal to zero or less than the size of the argument list. Line number :152 and the other is, the ListView control is also not getting properly as needed. In this prog, I used 2 tables StudentsDetails & StudentsMarks. Anybody pls help me to come out with this problem... The code is, using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; using System.Data.OleDb; namespace DBApps { /// <summary> /// Summary description for Form1. /// </summary> public class StudentsForm : S ...Show All

• SQL Server AMO Question - Distinct members in Cube

  Hi, How to filter members in a dimension. To meet a requirement, I made a table as a Fact and a Dimension. In the said table, I have a column which is varchar and contains unique values always. They can be said as 'A' or 'B' or 'C'. For all records in the said table, any of these three values can be present. But they are not from any lookup table but come from a third party system. Using the AMO object, I am listing all the values are members. But the problem I am facing is, I am getting all values as members. As per my requirement, I must list only distinct of them I am setting the DimensionAttribute object's Usage property to Key, OrderBy to OrderBy.Name and Type to Regular. What other property need to be set to list ...Show All

• .NET Development Can we have properties in Webservices

  Can we have properties in Webservices like we have in iclasses and interfaces. bool StatusChanged{ get; set;} regards ...Show All

• Visual Studio Team System Error when viewing workitem details over web

  I have my build server runingnicely, but when an exception occurs, it creates an email to me with a link similar to the following: http://<tfsserver>:8080/WorkItemTracking/WorkItem.aspx artifactMoniker=283 However, clicking the link displays the message: "The given key was not present in the dictionary." I understand that this is probably a mis-configuration of the data warehouse data, but I'm unsure where to look. Can anyone offer suggestions as to where to look first I've enabled tracing by http://localhost:8080/Warehouse/v1.0/tftrace.aspx All=Verbose (as proposed in some places on forums). ... and I've found errors in trace one line per one try of displaying a work item weblink (each time ...Show All

• Windows Live Developer Forums Doesn't VE already do geocoding natively?

  Just trying to understand how to implement a geo coding system into a VE map. If anyone can point me in the right direction that would be great. I did notice however, that if you use the map.route() function you can use lat/lon or an address to plot the route. Technicially this geo codes teh address to a lat/lon point on the map. From this shouldn't there be a method of using and address in a funciton and getting a lat/lon out of it Hi, Actually in order to use the services now replace http://local.live.com with http://dev.virtualearth.net/legacyservice You can also refer to http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=2339290&SiteID=1 for more info Hope that he ...Show All

• Visual C# Parametersized property!?

  I am *very* surprised at the fact that C# does not support parameterized property! The only thing I get is the so-called Indexer, but that does not provide the same functionality as parameterized property. For example, I can write the following code in VB: Public Class test Property Name(ByVal key As String) As String Get Return key End Get Set(ByVal value As String) End Set End Property Property Address(ByVal key As String) As String Get Return key End Get Set(ByVal value As String) End Set End Property End Class The two properties both have a String parameter and both return a String object. However, in C# I can only write only *ONE* indexer: public ...Show All