spattewar's Q&A profile

• Audio and Video Development Validator Stopped Working

  The HD DVD Validator recently stopped working could it be because of an upgrade of internet explorer (7.0.5700.6) or do I need to install something again The simulator works fine. Greets! Try re-installing; it *may* have installed a custom JScript.dll that was then clobbered by IE. That shouldn't really have happened though... Can you get it to work at al, eg just by running with a / command-line switch ...Show All

• SQL Server How to specify datatypes for Excel columns?

  So I have Excel Source in my dataflow - so I do a simple transform and try to save it to db and guess what - a freaking error message: Columns blahblah and BlahBlah cannot convert between unicode and non-unicode datatype. I cant figure this MS stuff out - why the heck is this data from excel unicode to begin with & I just dont feel it is right to always use the derived columns to convert datatypes when dealing with Excel data. Am I missing something again or is it another one of those MS gotchas -- Note - all profanity in this post is replaced with words like freaking, stuff, gotcha and so on by the author Jamie Thomson wrote: Why not Because I would prefer to do my own data mapping instead of using deri ...Show All

• Visual Studio Tools for Office Error by deployment outlook addin

  Hallo, I have make a outlook addin in vs 2005 for a outlook 2003 client.  I use the tutorial from http://www.supinfo-projects.com/en/2006/add_in_outlook_2007_en/6/  to deploy the application. en get de error: Cannot set the security policy. The specified solution code group name is not valid. In the custom action's " CustomActionData " property, have i enter the following value /assemblyName="OutlookAddin.dll"/targetDir="[TARGETDIR]\" /solutionCodeGroupName="Absolute.OutlookAddin" /solutionCodeGroupDescription="Code group for sampleAddin" /assemblyCodeGroupName="OutlookAddin" /assemblyCodeGroupDescription="Code group for SampleAddin" /allUsers=[ALLUSERS] the " Rollback " and " Uninstall " nodes with the following v ...Show All

• Visual Basic Disabling selectionmode in datagridview

  Is there any way to diasable the selection of a cell in a datagridview Or do you have to make the selection backcolor=nothing Or even better, can you make it only "circle" a cell if you select it I remember that you could do it in vb6 with the flexgrid. i dont think there is a "nonselect" type enum in the DataGridView SelectionMode. I guess when the cell has got focused (looking at the event when fired: cellClick/CellEntered) you can unselect it by setting the "currentcell" property to null. other than this, i can't seem to find anything else. hope it helps in some way! ...Show All

• Windows Forms File Conditions

  Has anyone successfully set a file condition I include an MDB in our installation. Upgrade installations may overwrite previous versions. I'm using the following in the Condition property of the MDB file: ProductVersion < 1.0.9. That alone, and a change of the version in the Project Properties, has no affect on the installation. The file gets overwritten every time, unless I set the MDB's Permanent property to True and then it NEVER gets overwritten. ProductVersion < 1.0.0 has no affect on the installation. Any thoughts An upgrade that uses RemovePreviousVersions is basically an uninstall of the old product followed by an install of the new product, so the question of "overwrite" doe ...Show All

• .NET Development Remoting Error with ExecuteReader()

  I am working on a project in VS 2005, written in VB with an ASP.NET client and Console Application server. Quick overview: * Server connects to an Oracle 9 database. I've created a class (in it's own .dll) called DBConnection which nests an OracleConnection object. The class is marked with the <Serializeable()> tag and it inherits MarshalByRefObject. The server creates an instance of this class which it then publishes. * I have another .dll containing classes which are pretty much no more than representations of tables in the database and one class which does the Searching, Adding, Removing of these class objects to the database. All of these classes are tagged with <Serializeable()> and inherit MarshalByRefObject. These ...Show All

• .NET Development database MDI application Dataset update question using VB .NET 2003 & SQL Server

  Hello, I am a few months into .NET (changing access DB client server - VB6.0 Application). Although update/merge strategy works quite well, I need a notification mechanism that allows a viewing client application to see updates from another user. I am trying the follwong: 1.Polling the database for changes. 2. Look into alternatives. Some seem to point to DB triggers. Could you point me in the right direction Thanks, Nick You should take a look at query notifications in .NET 2.0. Using Query Notifications http://msdn2.microsoft.com/en-us/library/t9x04ed2.aspx Since you are using VS.NET 2003 (.NET 1.1) I realize this may not resolve your immediate need, but you might ...Show All

• Windows Live Developer Forums DIV Help!

  How do I get my own <div>, and not a custom control to stay on the map at 3D mode I remember seeing that in the wiki... I see the "el." specs and they seem to relate to using the custom control from the sdk. I am trying to display a div there... Or do I just change the "el" to the div id ...Show All

• .NET Development Event Model for observable pattern in Code Access Security

  Hi, anybody know of a way to listen for code access security assert or grant requests from assemblies running in another appdomain. I know the new sandbox feature ahs been added to the activator, but in scenarios where UI plug-ins are being loaded into an external partially trusted domain, SecurityException seems to be untrappable by the hosting application resulting in the Security Exception Dialog bos bubbling up to the end user. In certain tests I ran, it seemed that the only way to prevent this is to wrap the Application.Run() call in a try catch and add a block for SecurityException. The problem with this is you kinda have to refactor that code out into a seperate function that you can recursively call everytime the exception is t ...Show All

• SQL Server How to modify the query string of a dataset?

  Hi, I have a few questions. Suppose that i have a report based on this sql: Select * from table1 Now I want to be able to add a Where clause on that sql command programmatically. Like: Where name = 'Max' How can I do that Yupper, I got it, I used a similar appoach and your .net code should allow you more flexibility than I had just in RS. You can take a couple of approaches, but the one I took was that I create a report that contains all the possible columns on the report and based off of what the used selected, I used the column expression to hide columns not used. In my SQL statement, I created a dynamic SQL where I tested by column values and if that were present I would add ...Show All

• Smart Device Development Invoking Beep on Pocket PC using C#

  Hi, Am developing an application where i have to alert a Beep sound in a Intermec 700 series pocket pc built on Windows mobile 2003 OS. However i get a missing method exception at runtime saying "Can't find PInvoke Dll kernel32.dll". I tried using the playsound function as well. However i get some other dll cannot be invoked at runtime. I am pasting the code sample here Beep function [ DllImport ( "Kernel32.dll" )] [ return : MarshalAs ( UnmanagedType .Bool)] public static extern Boolean Beep( UInt32 frequency, UInt32 duration); Beep(750,300) PlaySound function [DllImport("winmm.dll", SetLastError = true, CallingConvention = CallingConvention.Winapi)] ...Show All

• Commerce Server Discounts

  How can i manpulate many discounts to show them on aspx page ( we are using commerce server 2007, SQL 2005, VS 2005) I try Your code and see in allDiscounts all my discounts. When I apply ApplyProductFilter or ApplyCategoryFilter it always returns zero items. Still I set productid or category id with discount. Esp. for product id wich in my bascet gets the correct discount. I use virtual catalogs and set the discount on the virtual catalog for the category the product belongs to. Any idea why I not get any results at all Regards Johan ...Show All

• SQL Server Adding a global reference to a custom assembly

  I have a custom assembly that around 150 reports all need to make use of. Is there a way for me to put this assembly reference in some global settings file so that I don't have to add the reference for every report individually SQL Server 2005/VS 2005. ...Show All

• SQL Server XP_CMDSHELL with variable

  Hello I want to execute the following: DECLARE @ToolsPath AS NVARCHAR ( 4000 ) DECLARE @location varchar ( 255 ) EXEC master . dbo . xp_regread 'HKEY_LOCAL_MACHINE' , 'SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Setup' , SQLPath' , @location OUTPUT SET @ToolsPath = '"' + @location + 'Setup\Binn\sqldiag.exe" -E -O c:\sqldiag.txt -C' EXEC xp_cmdshell @ToolsPath My problem is in line EXEC xp_cmdshell @ToolsPath. It doesn't seem to accept the variable as where it works fine with the complete path I'm sure there must be a workaround or something. What am I missing Thanks! Worf Use like this SELECT @ToolsPath = xp_cmdshell ' '"' + @ ...Show All

• Smart Device Development FileStream Write Timeout Read Exception

  It appears from the help file that the FileStream class has an accessible "WriteTimeout" property. The write path for the file is the flash (SD) card on the device. I wrote some test code using standard FileStream and Binary Writer objects to check what the default timeout was and came up with the exception listed at the foot of this message in response to the code below. The code is for a Pocket PC under the .Net Compact Framework 2.0. Why are timeouts not supported on this stream Do I need to override the "CanTimeout" property to work around this Is it because the target device is a flash memory card Note that there does seem to be some kind of inherent timeout occurring (I haven't measured it exactly but its over ...Show All