AlanKohl's Q&A profile

• SQL Server Need help with pivot or is this even possible using pivot?

  Hi, I need help with my problem. I have this set of tables that I query that will produce this result set. SeqID Time ProductName DataValue Tag 1 '1/1/2007 10:00' Tea 30 1 1 '1/1/2007 10:00' Soy 25 1 1 '1/1/2007 10:00' Coke 40 1 1 '1/1/2007 10:00' Beer 75 1 2 '1/1/2007 10:05' Tea 38 1 2 '1/1/2007 10:05' Soy 29 0 2 '1/1/2007 10:05' Coke 32 0 2 '1/1/2007 10:05' Beer 44 1 3 '1/1/2007 10:10' Tea 26 0 3 '1/1/2007 10:10' Soy 35 1 3 '1/1/2007 10:10' Coke 28 1 3 '1/1/2007 10:1 ...Show All

• Visual Studio Setting the 'Support Version' in Add/Remove programs with MSBuild Publish target

  Hi, We are using one click publishing and publish our application using MSBuild as below:- < msbuild project = " ${CCNetWorkingDirectory}\Programmer\Programmer.csproj " verbosity = " Normal " target = " Publish " > < property name = " Configuration " value = " ${project.config} " /> < property name = " PublishDir " value = " ${project.publish}\ " /> <!-- <property name="AssemblyOriginatorKeyFile" value="WindowsApplication3.snk" /> --> < property name = " PublishUrl " value = http://somewhere /> <!-- The IDE publishes to this location. It is inserted into the ClickOnce application manifest if neither the InstallUrl or UpdateUrl property is spec ...Show All

• Visual Studio September CTP?

  Anyone have any idea as to when the Sept CTP will be released Thanks John Excellent news. At the release of the July CTP, you already mentioned a GUI and a Visual Studio add-in. Will these be in the September release, or are they not expected untill the RTW 1.0 in October ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Textures don't show up when using Basiceffect

  Hi, I'm just trying to create a couple of walls and apply a texture to them. Unfortunately, when running the program the walls just come out as a grey sort of colour (depending on the texture, the shade of grey seems to change). I'm assuming there's something obvious I'm missing, so I'm hoping someone can help me out. Here's snippets of code handling the basiceffect: //In loadgraphicscontent: Texture2D wallTexture = content.Load<Texture2D>("Content\\Textures\\em2"); theWalls = new Walls(wallTexture); wallEffect = new BasicEffect(graphics.GraphicsDevice, null); //wallEffect.DiffuseColor = theWalls.TheColor.ToVector3(); wallEffect.TextureEnabled = true; wallEffect.Texture = theWalls.WallTexture; w ...Show All

• Internet Explorer Development IE7 Active Desktop

  Hey all, we have a domain here with 15 clients. The policy Active Desktop Wallpaper is enabled, so the users have a default wallpaper that they can't change. But since we've installed the final release of Internet Explorer 7 it seems like that the Active Desktop just doesn't load and there appears a blue background with an image icon like in IE when it's still loading the image... Click I'm sure the path is right and nothing has been changed on the policies for a while before IE7 was installed. Does somebody how I can fix this Thanks, Snake86 I guess we should have read the very last point on the IE7 Release Notes... bad news. I always meant to implement a cool active desktop for ...Show All

• Visual Studio Express Editions C++ Express Compiler fails after installing SP1 beta

  I have just installed VSC++ Express SP1 beta and now nothing compiles because there seems to be problems in the xutility library. Here is the version information from help: Microsoft Visual Studio 2005 Version 8.0.50727.363 (SP.050727-3600) Microsoft .NET Framework Version 2.0.50727 Installed Edition: VC Express Microsoft Visual C++ 2005 76542-000-0000011-00125 Microsoft Visual C++ 2005 Here is a simple Hello World program that won't compile: // HelloWorld.cpp : Defines the entry point for the console application. // #include "stdafx.h" #include <iostream> int _tmain( int argc, _TCHAR* argv[]) { std::cout << "Hello World\n" ; return 0; } Here ...Show All

• .NET Development Soap header namespace not send?

  Hi My program uses a AXIS webservice and need to add an soap header and in it an element with a value. My class is this: <System.Serializable()> _ <System.Diagnostics.DebuggerStepThrough()> _ <System.ComponentModel.DesignerCategory( "code" )> _ <System.Xml.Serialization.XmlType( "Vendorheader" , Namespace:= "http://ech.client.nl/vendor" )> _ <System.Xml.Serialization.XmlRoot( "Vendorheader" , Namespace:= "http://ech.client.nl/vendor" , IsNullable:= False )> _ Public Class Vendor : Inherits SoapHeader Public VENDOR As String End Class As can be seen is set the namespace in this class, but the header at the webservice ...Show All

• Visual Studio Team System Add New Stored Procedure results in endless dialog loop ???

  I had a couple of my devs install CTP4, and now they're trying to use a Database project that's part of our solution, and make changes to it. Specifically they are trying to add some stored procedures. They right-click on the Stored Procedures node, Add -> Stored Procdure, they enter the name hit OK, and it brings up the Add New Item dialog with all the file type choices (procedure, trigger, constraint, etc) with the name they typed in still there (with a "." on the end), if they hit OK it just brings back the same Add New Item dialog over and over again. It doesn't do this on my machine which is also running CTP4, but I have 2 fresh installs on other boxes here that are both exhibiting this behaviour. What could be the pro ...Show All

• Visual Studio Express Editions Security Warning Running VB Program

  Hello I have written my first a short VB program but each time I run it I get security warning box. How do I correct See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.EnvironmentPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet) at System.Security.CodeAccessPermission.Demand() at System.Windows.Forms.SystemInformation.get_UserName() at AutoBackup.Form1.Bu ...Show All

• SQL Server Access/Server

  How do you change the connection string of a DataSet We have been using MSAccess for our database, but have recently upgraded to SQLServer Express. I was able to successfully upsize the Access database and now all information resides on the server. In my VisualBasic program, the dataset itself has around 200 queries total spread out on multiple table adapters. The problem now is that none of these queries work because the dataset is bound to the Access table. I have changed connection string through code and am able to display the information, but am unable to interact with it until i get the dataset connection changed. I would rather just change the connection of the dataset somehow rather than build a new dataset, reconnect all form ...Show All

• Software Development for Windows Vista Adding roles to WorkflowRoleCollection

  Hello, I'm developing a workflow with ASP.NET authentication. I have assigned some event handlers in the workflow a WorkflowRoleCollection in their Roles property. When I want to fill the WorkflowRoleCollection with the roles that can raise the event, apparently I don't do it right. The problem is that when I raise that event I get an exception saying something like "authorization error in eventhandler guardaHorari1", and by checking the exception details I've thought that the problem is that when it checks the role of the user that tries to launch the event agains the workflowrolecollection, it doesn't find it there. I fill the collection this way: public WorkflowRoleCollection rolsModificadors = new WorkflowRoleCollection(); ...Show All

• Windows Forms tableadapter + connection pooling + corrupt connections in pool

  Hi, let's say we have plenty of table adapters in application and connection pool corrupts pretty often. How nice and elegant with minimal rewriting make those table adapters work without exceptions using this (or if you get the point of the problem and know better one) solution (idea in pseudo code): try { fill datatable using adapter with plenty of usrfull data } catch { looks like our connection pool has corrupten connections, let's clear it try to use table adapter to fill datatable once again } Hi It seems that you are using Asp.Net. Maybe someone has a better answer on the ASP.Net Data Access forums . I 've used this setup several times and i have never had any problems. Are you using st ...Show All

• Visual Studio Express Editions To Loop or not to!

  Hi there all First off, I'm brand spanking new to programming and am still feeling my way around VB Express, hence my "beginners" question. I am trying to write a programme that will calculate an implicit formula for me. The formula (in a shortened) version goes like this: (1/sqrt(k)) = -2log(2.51/(a*sqrt(k)). And the only way I can think of to do this is by a loop function. Bear in mind that the values of 'k' normally are very small (in the order of 0.0012). Also, because 'k' is not an integer, but rather a double data type, you will have to start off with a base value for the loop that is very small, maybe something like 0.0000001 and then move in increments of 0.0000001 for every loop. But even I with my very limited pro ...Show All

• .NET Development C# query foxpro

  I have wrote a program that query a foxpro table that is located on a server via odbc. The query takes forever to run. Is there a way to speed this process up all I all have is this basically System.Data.Odbc. OdbcConnection cdconn = new OdbcConnection (); System.Data.Odbc. OdbcCommand cdcommand = new OdbcCommand (); System.Data.Odbc. OdbcDataReader datareader; cdconn.ConnectionString = "Dsn=foxproconnection" ; ''''didn't know what else to use because need exclusive unchecked... cdconn.Open(); cdcommand .Connection = cdconn ; cdcommand .CommandText = "select customername, phone, zip from customerdetails" ; datareader= cdcommand ...Show All

• SQL Server "where" statement in list

  I have one dataset and two lists with one table in each list. the two tables should get their data from the same dataset. but the tables need different "where" statements. in the dataset I only can define one "where" statment. it is possible to displace the "where" statment into the two lists they should access to the dataset with their own "where" statement. My where statement for the first table is WHERE     (dbo.endgeraet.ansprechpartner IN (@usernr)) when I remove it in the dataset and put it in the table as filter, the preview gives me an error "the processing of filterexpression for the table 'table1' cannot be performed. cannot compare data of types system.int32 and system.string. please check the d ...Show All