Henry Chan's Q&A profile

• SQL Server Change request: Parameter mapping

  In some places in the SSIS enviroment, you can use parameters in queries, for examples in the query part of the OLE DB Command component. You do this by specifying placeholders using question marks. The question marks result in parameters on the Column Mappings tab of the Advanced Editor named Param_0, Param_1, etc. When adding question marks to the query later on, new parameters are created named Param_<x>, where ‘x’ is the next higher index number, no matter where the question mark appears in the query. If, for example, your initial query contains two parameters and later on you add a third one that appears as the first para ...Show All

• Visual C++ Funny Error

  Hello, I got this error when I try to view my form in designer mode: The name 'components' is already used by another object. Hide at System.ComponentModel.Design.Serialization.DesignerSerializationManager.System.ComponentModel.Design.Serialization.IDesignerSerializationManager.SetName(Object instance, String name) at System.ComponentModel.Design.Serialization.ContainerCodeDomSerializer.DeserializeInstance(IDesignerSerializationManager manager, Type type, Object[] parameters, String name, Boolean addToContainer) at System.ComponentModel.Design.Serialization.CodeDomSerializerBase.DeserializeExpression(IDesign ...Show All

• Visual Studio 2008 (Pre-release) Help2

  Hi all after generating my database as mydatabase file by using sqlmetal.exe  e.g(Mydatabase.cs) when i build my application i had this error "Invalid object name 'Students'." exeption in r foreach ( Student   stu in r )  although Studens class is exist i Mydatabase.cs as class ----------------------------------------------------------------------------------- public partial class Summercourse : DataContext { public Table < Book > Books; public Table < Courses > Courses; public Table < Student > Students  ; . . . } [ Ta ...Show All

• Visual C++ CFile GetStatus() Date and Time Help

  I'm want to read the date and time a file was created.  I saw that CFile GetStatus() could do what I wanted.  I'm able to display the file name and path but how the heck do you display CTime m_ctime value   I do see a number retreived while in debug mode. Thanks for your help. Thanks for the help. I was just missing this part( bold ) CString myString = myFileStatus.m_ctime .Format("Created %m/%d/%Y %I:%M %p") ; I never would of figured that out. Don't do that much with C++. If this info was in a book could you give me its Name and ISBN number. Again Thanks ...Show All

• Visual C++ Windows API not working w/VC++ Express

  Good Morning- I downloaded the Windows Platform SDK and installed it and used these instructions: http://lab.msdn.microsoft.com/express/visualc/usingpsdk/default.aspx to set it up. But they aren't working (IE: my code cannot find Windows.h). Has anyone else had this experiance with  VC++ Express I did the manual file editings to point to the include directories, etc. Is there any way in VC++ Express to confirm what paths are avialable I spent an hour dinking around with it and I got nothing. Thanks, Philip PS: Microsoft people: Note a typo on that site!!! Section 3 says to point the lib/bin/include directories to C:\Program Files ...Show All

• Visual Studio VSS checkins take an hour over a domain

  Hi all, I have lately joined a domain at my work to program against Active Directory. Most of our machines are not on the domain yet, and our VSS machine isnt. Since I have had to access the VSS machine from within our domain, checkins have been taking up to an hour or thereabouts, and quite often I get a 'Invalid handle' error. The files do get checked in in the end, but it is causing me immense pain. I have tried checking in from both vs2005 beta 2, and vss 6 (I was using the new beta vss, but gave up on that quickly), both give me these errors. Does anyone perhaps know what the problem is, and what the solution may be Thanks in advance, ...Show All

• SQL Server sql server management studio nov ctp

  I have vs2005 prof. installed along with sql express RTM I installed management studio nov ctp when I try to launch it, nothing happens any Ideas Thanks   lee d wrote: deleting the key worked for me too<br /><br />Thanks Is the SQL Server Books Online working without these keys :) ...Show All

• Visual Studio External images using parameters

  I am trying to add external images to my report, feeding the paths via parameters. Dim params(1) As Microsoft.Reporting.WinForms.ReportParameter params(0) = New Microsoft.Reporting.WinForms.ReportParameter("imageSig", My.Application.Info.DirectoryPath & "\images\sig1.gif") params(1) = New Microsoft.Reporting.WinForms.ReportParameter("imageLogo", My.Application.Info.DirectoryPath & "\images\logo.gif") Me.ReportViewer1.LocalReport.SetParameters(params) The value for my two image controls are set like so: Source=External Value=" file:/// " & Parameters!imageSig.Value Source=External Value=" file:/// " & Parameters!i ...Show All

• SQL Server Databound image in report header

  After finding out that SSRS doesn't directly support databound items in the header or footer, I found the workaround from Microsoft yesterday at http://msdn2.microsoft.com/en-us/library/ms159677.aspx . The problem is that their solution only works for the first page of the report, so it's basically useless! Because this is an image, it also means the workaround of using a parameter doesn't work, either. Does anybody have any advice Is there a solution to this problem One approach to accomplish this is to create a custom function that queries the database for the image, caches it and then returns it for us ...Show All

• Visual C++ Why is strdup() deprecated in VS 2005?

    < hyslopc@discussions.microsoft.com > wrote in message news:9a93850c-505b-48c3-bd60-44625db8bbc6_WBRev2_@discussions..microsoft.com ... This post has been edited either by the author or a moderator in the Microsoft Forums: http://forums.microsoft.com You may not care about it, but I do.  I don't want to disable the warning because I think the concerns with most of the deprecated functions are very valid, and only wished Microsoft had done this a long time ago.  As such, I have taken the opportunity to change a lot of my code to use the new functions.  The problem ...Show All

• Windows Forms ListView column autosize

  hi all, is there a way of making a ListView control autosize based on the data inside it i.e. the column adjusts to the size of the longest string inside it regards hi Frederik, thanks for your help it works, but now it makes the column smaller than the column heading. is there a way of ensuring that the column is bigger or equal to the length of the column heading ...Show All

• SQL Server Default SqlServer database creation path

  Hi, How can i get default sql server(2005) database creation path using Tsql/ or system stored procedure in previous(2000) i used undocumented sp(sp_MSget_setup_paths) to doing this. Thanks Dishan http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=965821&SiteID=1 ...Show All

• SQL Server stored procedure that performs a search is too cumbersome

  Hi I am new to this forum. I have a stored proc that conducts a search based on a number of parameters entered by the user. The way I am currently building the procedure is the following, this is one segment of the if/else structure: ------------------------------------------------------------------------------------------------------------------------------ --If latitude, longitude or distance are null and ProjectID and AnalysisTypeID are not NULL ELSE IF (@i_Latitude IS NULL OR @i_Longitude IS NULL OR @i_distance IS NULL) AND @i_ProjectID IS NOT NULL AND @i_AnalysisTypeID IS NOT NULL BEGIN SELECT Distinct Projects.ProjectName, ...Show All

• .NET Development InputWrapper Class in C#?

  Hi All,           Is there an InputWrapper Class with a getString() method in C# . If there is , in which namespace can i find this class Thanks Hi Dave,           Thanks a lot for your response and advice. I appreciate it very much. All the best. Regards ...Show All

• Software Development for Windows Vista Rules which reference Activity properties in XOML only workflows

  Has anyone been successful in creating and executing a rule that refers to an property of an activity which was dropped onto the workflow at design time in a XOML only workflow. In our scenario, we have a hosted designer which outputs XOML only workflows. In the designer, we can drop activities on to the surface and reference activity properties from anywhere on the workflow. HOWEVER, if we write a rule (in a policy or condition) which accesses a property on a dropped on activity, the workflow fails validation. It appears that it can't resolve the child activity types at validation time. When creating the workflow with XAML Activatio ...Show All