WayneW's Q&A profile

• Software Development for Windows Vista What are the alternatives to using GetActivityByName in RuleConditions in XOML only workflows

  What are the alternatives to using GetActivityByName() in RuleConditions in XOML only workflows when re-hosting the Designer Control It is unreasonable to expect customer business users to understand casting and write rule conditions of the form ((SomeNamespace.Workflow.Common.ActivityLibrary.ConsoleWritelineActivity)this.GetActivityByName("fred")).Message == "test" What are my options here I am in the same boat as you. I was hoping that this new CTP would correct this problem but it doesn't. I haven't tried creating a type provider yet but feel like it shouldn't be necessary. I even tried to create a generic method on the workflow to get the activity but that didn't work either. I haven't tried i ...Show All

• Visual C# Making a Send To Shortcut

  I have an c# VS 2005 winform that takes file list variables via Environment.CommandLine passed from a Send To link to my application. So I need to create a shortcut to my application in the user's Send To folder. I am able to build a MSI to install my application and create the shortcut in the User's Send To Menu location but when I right click from windows explorer I do not see the short cut as a Send To target. If I simply copy the shortcut to some other location such as User's Program Menu I see the shortcut as expected in Programs start menu location, which launches my application. How can I get my Send To shortcut to show up in windows explorer right click context menu I have other questions about the nature of the shortcut and why ...Show All

• Visual Studio 2008 (Pre-release) [WCF-RC1] Adding claims in UserNamePasswordValidator

  OK, another dumb *** question (folks, I am _trying_ to research these things first before bothering you, and I'm starting to feel like a child who can't do his homework!) My STS is based on the Federation example in the RC1 release, and it uses a custom UserNamePasswordValidator to validate the client credentials. In the Validate method, I look up the user in the DB, validate the password etc and return true. Then, within the GetIssuedClaims override that "Issue" calls, I need to create the claims that will be added to the SamlToken. However, the values of the claims that I want to add are stored in the DB in the row that I just looked up in the Validate method, and I really don't see why I would need to look them up again. How c ...Show All

• SQL Server Howto use DATEDIFF(); in SQL Express

  Im trying to lern MS SQL Express to my PHP5 websites so now get eyes open for View and i will try to make views in my MS SQL database. Bot this command here i get the rong result SELECT DATEDIFF(yy, '1985/10/21', '2006/10/18') AS Fdag FROM table the problem is im not 21 year old im only 20 bot about 6 days im 21 bot the SQL say im 21 year old so ist can't rember deferind whit the date. i hob i get get help here :) tanks enyway :) Oh my! Why do you think I posted a sample code:) declare @start datetime declare @end datetime set @start = '1985/10/21' set @end = '2006/10/18' select ( cast ( convert ( varchar ( 10 ), @end , 112 ) as int ) - cast ( convert ( varchar ( 10 ), @start , 112 ) as int ))/ 1000 ...Show All

• SQL Server Viewing- VS Development Security

  Hi everyone I am having some difficulty getting the security on the Report Server to function correctley. Here's what's happening: I log onto Report Server using a certain account. This account is linked to a security role on the cube and to a certain company code within the cube. After building a report in Report Builder using this account and deploying it, I then run it from Report Server. It only displays the values in the parameters that are allowed for this user that I have logged in with. This is correct. However when I open BI and build a report and deploy it, the security settings on Report Server no longer take effect correctley. The parameter dropdowns are left empty where a certain company code should be. Does a cert ...Show All

• Visual Studio Express Editions Help,Start Button Thing

  Well,i recently "edited" explorer.exe and changed my start menu text,and (im 14) everyone at school wanted one...so...i need help,i already have a code,but it wont work,Just in Case,the program is supposed to display an input box with a max of 5 chars,and  when you ok the input box,it will change the text of the start(instead of start,something else) i do have a code,but it simply will not work,it does not limit input box to 5 chars and it does not change text,heres the code, Please if you have a better code,simpler or otherplease put it...anyways,here's the code ' Public Class Form1 Dim jeff As String Private Declare Function SendMessage Lib "user32" Alias "SendMessageA" ( ByVal hwnd As Lo ...Show All

• SQL Server Training

  Whose training courses would you all recommend Ideally, I would like a data warehouse modeling course that discusses Analysis Services 2005 secondarily. I usually recommend this book: http://www.msftdwtoolkit.com/Index.htm . I have not been to their DW-cources yet but the book is really good. They have also a site dedicated to general DW-design problems that is relevant for the SQL Server BI-platform and other competing technologies. www.kimballgroup.com I do not gain anything for recommending it. HTH Thomas Ivarsson ...Show All

• SQL Server Restoring database from MS SQL 2000 to SQL Express 2005

  Hello, I tried to restore a database which I backuped from MS SQL 2000 to SQL Express 2005 but it always failed with the following error message. What could be the problem Restore failed for Server 'SERV\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo) Additional information System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'gtp' database. (Microsoft.SqlServer.Express.Smo) Thanks hi, Kira_26 wrote: hi, i still encounter the same problem after i have followed all your suggestions and help. Do I need to create a blank database in sql 2005 express edition prior to backing up Thanks a lot ...Show All

• .NET Development Try refreshing the table adapter

  It is my understanding that when using a TableAdapter and selecting the proper options, Insert, Delete and Update statements are generated. The Update statement should work just using the following: myTableAdapter.Update(changes); Where changes is the DataSet containing the modified data. This logic works great for one of the tables in the DB but not for another. Learning this new stuff is Confusing at best - Frustrating at worst. Help appreciated, Michael Check the Update, Insert, Delete command of the myTableAdapter, and check the query statement of all of them. TableAdapters are created for only one table, if you want to modify more than one table, you have to change the query statements acco ...Show All

• SQL Server Errors using multiple parameters in a SQL Statement

  In an OLE DB Source in an SSIS package, we are having difficulties using multiple parameters in a SQL statement. Using a single ' ' works fine, but I've read that when you want to map more than 1 parameter you should use 'Parameter0, Parameter1, etc'. The problem is that when we use Parameter0 and Parameter1 and then try to map it, it says that the query contains no parameters. Can anyone help with the correct way to use multiple parameters in a SQL query that's part of an OLE DB Source task Thanks, Mike Mike Batton wrote: With the following options, here's what happens when I click on the parameters button: Select * from TEW_D_DT where dt_key = Parameter0 and cal_yr_id ...Show All

• Visual Basic How to print additional table's data in EXcel tab (Windows application)

  Using VB 2005 To all Users: I have this problem when i using vb and transfer data to excel to print. The problems comes as the 1st table is able to print while the rest of the table tab do not have data.. Could anyone help me with this asp I will be greatful Pls provide sample code/links asap ya! i mean is that i have more than 1 spreadsheets. But the data is not filled up! Could u help me with this ...Show All

• Microsoft ISV Community Center Forums Run Time Error 9 when Calling a Userform

  Hi folks, I am getting a run time error # 9 when I run a macro that calls a Userform or when I try to run code in a Userform module. The code performs beautifully on my computer, but it did not work on a coworker's computer. It ended up working on 3 out of the 5 computers I have tried it on. I have tried changing security settings to low, and a bunch of other stuff, but I cannot get the code to run on the computers that get the run time error on them when I try running the code on them. I get the run time error when I try to load or show any userform in the workbook and I get it if I try to run code that is in the userform module. However, if I paste the code into a regular module and run it, the code runs fine. Does anyone know what co ...Show All

• Windows Forms ClickOnce - prerequisites update/install problem

  Hello We are doing a project where we are using clickonce and it works really well and has given us few problem. There is one problem tho that's very strange and we havent been able to find a solution for yet. as part of our clickonce we added one extra "prerequisites"; "Microsoft visual studio 2005 report viewer" but the problem is the same with all the "prerequisites" beside form the default .net one. when clients try too install the application they just get an empty error box.. there is no text at all.. just the red error symble and a ok button. If we remove all but the default "prerequisites" and redeploy it works fine.. we add it again and redeploy the same error again. We tryed to place the updates ...Show All

• Visual Basic riddle me this -- memo fields from Access

  I've encountered a problem with Memos from Access...  basically I'm running into Nulls when I shouldn't be. I've isolated the problem with as few number of variables as I can: I have 1 Access 2003 database in the location: c:\vb\sampledb.mdb This database has 1 table, "test" The table "test" has 3 fields,  testAutoNum - Autonumber  testText - text  testMemo - memo The table "test" has two rows, [1] [test] [test] [2] [test] [test] I have 1 VB Application with a reference to "Microsoft ActiveX Data Object 2.9 Library". There is one form, Form1, with one textbox, txtTest, and one command button, Command1.  The following code is used: Dim objRS As ADODB.Recor ...Show All

• Visual Studio Tools for Office Migrating VBA Excel solution to VSTO solution

  Hi all, We have an Excel VBA solution to generate Excel reports. Macros coded will fetch the data and populate it into Excel templates. Now this solution is to be migrated to a .net Excel solution. As recommended by microsoft, We exported the VBA code in .bas files and created a VB6 project. This VB6 project was converted to VB.net code using the conversion wizard. It is working as being an vb.net EXE. But we want it to be an Excel solution to reduce data marshalling overhead. Question Should we migrate the now converted .net code as a module to VSTO Excel solution or add it as a macro. VS.net provides seperate IDE for both. Is macro approach creates overhead Please suggest. Manish ...Show All