Trisk2's Q&A profile

• SQL Server Conversion failed when converting the varchar value

  I keep receiving this error: Conversion failed when converting the varchar value 'INSERT INTO temp_tableZ (Customer_Category_Key, Item_Category_Key, Sales_Rep_Key, time_member_key, Revenue, Fiscal_Year ) select Customer_Category_Key, Item_Category_Key, Sales_Rep_Key, ' to data type int When running the code below. I believe the problem has something to do with the @time_member_key in the dynamically created SELECT statement. However, I don't understand the problem or how to fix it. Can anyone provide some advice thank you, Erik drop table temp_tableZ go create table temp_tableZ ( Customer_Category_Key INT NULL, Item_Category_Key INT NULL, Sales_Rep_Key INT NULL, Revenue money NULL, time_member_key ...Show All

• Visual Studio Tools for Office How to generate Word 2003 document using VSTO2005 tools for office with ASP.NET2.0 C#?

  Hello, I have to generated Word 2003 document using VSTO2005 tools for office with ASP.NET2.0 C#. I have came across many online materials but not getting proper direction to do so. i want to create word report based on existing template. if i want to call this report onclick of button or link from webform, how can i do so how do i incorporate this office project with asp.net project. It will be a great help, if you suggest me resolve my issues. Looking forward to your kind response. Thanks in advance..!! Amit Hi Amit And what, more specifically, will the user do with these files once they've been opened in the browser Do you need to provide any editing tools, for example Or is you ...Show All

• .NET Development check if object being initialised

  Hi, Does anybody knows how to check if an object has been initialised I'm currently using the harder way that set the IsCreated value to true when the object is being initialised. Thanks. ssboyz wrote: Thanks for the answer but the object is not nothing when i declared it.For example: Dim obj as TestObject when step through in the debugging mode, the obj is not nothing. Thanks. If the obj isn't Nothing, then it must have been initialised in Sub New. ...Show All

• Software Development for Windows Vista uninstall

  How do i uninstall MS workflow foundation from my system JunJie1800, You can go navigate to Control Panel -> Add Remove Programs and uninstall Windows Workflow Foundation and the Visual Studio extensions from there. Thanks, Arjun  ...Show All

• .NET Development CLR DLL works on manufactorer PC, but not on other PC

  I made a CLR DLL in C++ Express, this dll is a devolopent tool, it contains classes useful classes for Visual Studio deveopers. I have tested it in both VCS and VC++ on the PC where I created it, 'PC1' and every thing works well. But I sent it over to another PC 'PC2' with CSharp Express and VB EXpress, but the dll works in neither. When ever a try to run an app  created on PC2 that refrences my dll it complains that it cannot load the dll file. The funny thing is it does not give me any compiler errors, and as I am refrencing it in code it seems to be working fine, it is only when I run the program that it gives me the error.  I dont understand why it works on PC1 but not P ...Show All

• .NET Development Resolution of DateTime.AddSeconds()

  The documentation says that the value parameter, which is a number of whole and fractional seconds, is rounded to the nearest tick (100 ns, or 0.0000001 s). However, my experience shows that it is rounded to the nearest millisecond. If you run the following code (C++ 2005, .Net 2.0): DateTime MyDT , NewDT ; __int64 diff ; MyDT = DateTime ( 2006 , 1 , 1 , 1 , 1 , 1 ); NewDT = MyDT . AddSeconds ( 0.1234567 ); diff = NewDT . Ticks - MyDT . Ticks ; Console :: WriteLine ( L "Difference #1: {0}" , diff ); you would see that effect. Is this a bug, a case of incorrect documentation,  or am I missing something Kamen I'm not sure where you are reading that at but the MSDN documentation (Aug 2006) ...Show All

• Windows Forms Invalid Certificate - Certificate Authority Chaining with THAWTE

  We have a ClickOnce application signed with a certificate purchased from THAWTE. When the install button is clicked on our deployment page and the publisher name is clicked, the certificate shows as invalid because the issuer of the certificate could not be found. If the setup.exe file is accessed directly, the certificate shows as valid from the setup.exe file. When the setup.exe is run, it brings up the click once installer that links to the same certificate error as above. My question is this. Can anyone provide an example ClickOnce url that has a valid certificate that will work on all windows machines with IE 6.0 or higher THAWTE was unable to help with this, is there another provider that has worked and can you provide an example ...Show All

• Visual Studio Team System Unable to access Version Control after installing SP1

  I am having trouble getting sp1 installed correctly on a single server install.  I had installed the sp1 beta and had everything working.  But now I am unable to access source control. I get HTTP code 503: TF30059: Fatal error while initializing web service with a corresponding event log entry that contains Detailed Message: TF53018: The application tier VWTEAM1 is attempting to connect to a data tier with an incompatible version. So it looks like for some reason at least the data tier did not get updated correctly.  I can access other parts of the system like work items although I do see entries in the event log when browsing the work items Detailed Message: Procedure or function SyncBISTree has too ma ...Show All

• Visual Studio Problem with references

  I am having a bit of a problem getting my build to work. Everything was fine until I started trying to version my files using the AssemblyInfo task. Now when I get to s specific project in the build it fails because it can not find the referenced assembly. The message I get is as follows Target ResolveAssemblyReferences: Primary reference "MoebiusWizardBO, Version=1.0.0.0, Culture=neutral , processorArchitecture=MSIL". C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Microsoft.Common.targe ts : warning MSB3245: Could not resolve this reference. Could not locate the *** embly "MoebiusWizardBO, Version=1.0.0.0, Culture=neutral, processorArchitecture= MSIL". Check to make sure the assembly exists on d ...Show All

• .NET Development in C# 2.0, how to create a new folder?

  Example, i would like to create a new folder, say, "MyFolder" in C:\temp using a button click in my Windows Application if (! Directory .Exists( "c:\\temp\\myfolder" )) { Directory .CreateDirectory( "c:\\temp\\myfolder" ); } ...Show All

• Internet Explorer Development How can I determine if an ActiveX component is available/installed via JavaScript?

  I am new to implementing code components in Internet Explorer. I am trying to instantiate a simple ActiveX object on a web page like so: <object id="myAxObj" classid="CLSID:EBCEC437-3386-472F-996D-1DE03174AA35" codebase="MyAxObj.cab#version=1,0,0,0"></object> Later on the page, I would like to have a simple JavaScript to inform me of the component has been downloaded and installed. if (document.getElementById("myAxObj"))... always evaluates to true even when the component is not installed on the system. This seems odd to me, as I would've expected it to be undefined. How can I determine if the code component is available via JavaScript Over on a ...Show All

• Visual Studio Express Editions messenger tutorial

  I'm fairly competent with c# (thanks to this site), however i have no expirience with any sort of network coding, i was wondering if anyone could point me in the direction of a simple messenger tutorial, where two people can just send messages back and forth in visual c sharp express for me to get the hang of simple networking in a program. thanks in advance Matt Hi Matt ! This article on the CodeProject might be what you are looking for. (On the code project site you can find - beside many other topics - many articles about network programming of which the most come along with demo sourcecode ) http://www.thecodeproject.com/cs/internet/messengerx.asp This article describes a chat s ...Show All

• Visual C# Cast <IList>

  I have something like this... public static IList < AbstractKeyValueEntity <T>> Values<T>( ListBox listBox) { IList < AbstractKeyValueEntity <T>> results = new List < AbstractKeyValueEntity <T>>(); foreach ( ListItem item in listBox.Items) { if (item.Selected) { results.Add( AbstractKeyValueEntity <T>.GetLookupByEntityID(item.Value)); } } return results; } I make a function call something like this something is of type IList something = ( some ) CallFunction .Value< some >(DownList); I get an error saying Cannot implicitly convert type ''some' to 'System.Collections.IList'. An explicit conversion exists (are you m ...Show All

• SharePoint Products and Technologies IE Crashing when opening Sharepoint list

  When a user tries to open a list in Datasheet view on our sharepoint site they are being welcomed by the nice 'IE Has encountered a problem and needs to close.' Error.  This just started a couple days ago.  This is to the point that I can't open a couple of my administrative lists anymore. We are currently running: WSS v3 MSSQL 2000 Happening on IE 6 AND IE 7 Office 2003 ONLY I have Sharepoint Designer 2007 - This has been installed and used for a couple of weeks before problem arrived. ONLY seems to be happening on Service Pack 2 computers.  I've seen lots of posts about deleting the dll 'OWSSUPP.DLL' when running Office 2007 or uninstalling ALL office 2007 products.  However I am receiving this on seve ...Show All

• Windows Forms VS2005 PDF reader ocx load file from URL?

  Can the PDF reader ocx control that comes with VS2005 load a file from a URL If so how I have been trying to do it but It seems there is not a constructor to load a file from URL or Stream Thanks I'm not sure if it makes sense to require some other component to be installed on the PC to avoid installing Acrobat Reader. You'll have an awfully hard time finding one, few companies try to compete with a very capable product that is given away for free. Maybe Open Source, ghostscript tries to do some Postscript stuff, iirc. ...Show All