Steven King's Q&A profile

• Visual Studio ItemGroup Include gives zero items

  Hi all, In our build script we have the following construct: < PropertyGroup > < FilterTables > **\Create*\*tables.sql </ FilterTables > < FilterSchemas > **\Create*\*schema.sql </ FilterSchemas > </ PropertyGroup > < PropertyGroup > < CreateDatabaseScript > $(SolutionRoot)\DbCreateTun.sql </ CreateDatabaseScript > </ PropertyGroup > <!-- Get a list of all database projects under the solution root --> < ItemGroup > < DataBaseProject Include = " $(SolutionRoot)\**\*.dbp " /> </ ItemGroup > < Target Name = " CreateDatabase " > <!-- deter ...Show All

• Visual Studio Tools for Office Unable to create Excel Workbook Project

  I just installed Visual Studio 2005 June CTP on a machine with no previous version of VS 2005. However, I get the following error when I attempt to create an Excel Workbook Project: The project cannot be created. I tried uninstalling and reinstalling both VSTO and VSNET. Then, I tried formatting and reinstalling Windows 2003. Next, I tried it on a Windows XP machine. However, all gave the same result. Note: I can create a Word Document Project without errors. Hi Installation order is quite important so would be useful if you can recall the exact order and if there was any reinstall of othe ...Show All

• Visual Studio Visual Studio 2005 Beta Setup issues

  Hi. I need some advice regarding installation issues of Visual Studio 2005 Beta 1. My Visual Studio 2005 Beta 1 got expired so I uninstalled it using the Add/Remove Programs in Control Panel, not from the installation source. Then I tried to install Visual Studio 2005 Beta 2 but Setup has detected these components from Visual Studio 2005 Beta 1: Microsoft .NET Framework 2.0 Beta Microsoft Visual J#.NET Redistributable Package 2.0 Beta Microsoft Visual Studio Emulator for Devices - ENU I have to remove those components in order for me to install Visual Studio 2005 Beta 2. I have found that I have to use the VS 2005 Beta Cleanup tool. Is it ...Show All

• Visual Basic Using images as baground slows down my program alot!!

  Hi Im working on an aplication and is far from finished, but already now the program seems to be a bit slow. I've experimented with using a picture as a bagground (i really like these small fading bagrounds from light blue to white) but this seems to realy slow my program down when switching beetwen forms (not just in design fase, also in the compiled version) i only use gif images 256 colors so it isnt large images (about 12 kb). I use the tab control and when putting a background image on it, it really slows down!! I have a labtop 2800 Mhz with 756 Mb ram and xp sp2, so the hardware shouldnt be the problem. Is there a compiler pro ...Show All

• Visual Studio Team System a "pre-sales" question of sorts about source control in TFS

  Our team would sure like to get answers to the following questions before we decide to purchase TFS. Thanks for any information or referrals. Does the version control system support moving a file or directory to a different location in Solution Explorer (via the IDE) while still retaining the history of the file Does the version control system fully support renaming a file in the Solution Explorer (via the IDE) Does the version control system support copying files or directories to a different location at the repository level, while retaining the history Does the shelving feature support shelving multiple versions of the same f ...Show All

• .NET Development changing node attributes

  Not sure if this is the right place for posting this since I'm using Visual C++ 6 and not .NET, but here it goes. I'm trying to write a small program that works with certain XML files. One of the things I'm trying to get my program to do is look through the XML file finding all tags with a certain name and changing one of their attributes to a specific value. Right now this is what I have (and since I can't find any good tutorials on implementing XML in C++ I don't even know if my code is right, I've been putting the pieces together from different MSDN articles). Also, sDP_SP_SC and m_sTarget are CStrings. #import <msxml4.dll> named_g ...Show All

• SQL Server "sa" account and domain level rights

  Hey everyone, I apologize for the newbie question but I'm looking for the correct answer. We have 4 production SQL servers at this time. When we had originally set them up the "sa" account belonged to the domain administrators group. Since we have a SQL admin team and a domain admin team we would like to remove this privilege. Is this something we can and should do Our SQL servers use mixed mode authentication and some databases are configured for Windows authentication. I would appreciate any input from the community. You are mixing some things up: "When we had originally set ...Show All

• Windows Forms Application Settings Upgrade

  From what I have seen, the application settings do not migrate from one version of the application to another. I have read about AppSettingsBase.Upgrade() but I am not sure how to apply it. Should the application call Upgrade() each time it is started If not, how should the application handle the transition between versions without requiring end-user assistance and assuming the settings are the same between versions. Thank you, Valentin There is a known issue with ApplicationSettingsBase.Upgrade in Beta2, fixed in later builds. Issue : ApplicationSettingsBase.Upgrade() throws an exception. Details : If the new ApplicationSettingsB ...Show All

• Software Development for Windows Vista ASP.NET need to shutdown runtime.. WHY? BUG?

  I am finding that if I do not shutdown the runtime (last line of sub) then the workflow I am calling does not execute again. I do not want to have to incur the performance cost to start the runtime again, but have not found a way around this. Any ideas Private Sub StartWorkflow() ' Set up the parameters Dim parameters As Dictionary( Of String , Object ) = New Dictionary( Of String , Object )() parameters.Add( "FirstName" , txtFirstName.Text) parameters.Add( "LastName" , txtLastName.Text) parameters.Add( "Company" , "" ) Dim workflowRuntime As ...Show All

• SQL Server Select date year below 1950 not valid?

  i am doing a select statement, the .sdf database file has dates from 1910 to 2020 Dim fullcurrent_date As Date = New Date(1950, 10, 2) Dim sqlstr As String = "SELECT * FROM table WHERE Start_Month <= '" & fullcurrent_date & "'" it seems to work alright, but if i were to initialize the Date as Dim fullcurrent_date As Date = New Date(1949, 10, 2) it doesn't seem to work, is there a limit somewhere as long the year is below 1950 the select statement seems to be having problem searching for that line. Thanks That simply has to fail, here's why: 1. You have date as string in query. 2. That means DateT ...Show All

• Visual Studio Team System Work Item Update Collisions

  I've noticed inconsistent behavior in how Team Founation Server handles collisions when a work item is updated from two places, simulatneously. For instance the following steps generate an error: - Open task with ID 4 in visual studio, and change a value. Do not save yet. - Open work item query in excel and modify the task wtih ID 4, and publish the changes. - Save the changes to task with ID 4 in visual studio. When trying to save the work item in Visual Studio, I get an error stating the work item has been updated, deleted, or I don't have access to it. I end up having to re-run the work item query to get a new version of the work item ...Show All

• .NET Development object reference

  If in form1 I use User user = new User(); to create my user object.  When I go to form2 how do I reference the same user object Thanks Mike I have a similar problem but with using a customRoleProvider My IsUserInRole method is set to public overrides isUserInrole so when i change Public Overridable function IsUserIRole(username as string, Rolename as string) to Shared Overridable function ... VS yells at me and says that I can;t share an overridable function any ideas where i'm actiually getting the error is here Protected Sub Page_Load( ByVal sender As Object , ...Show All

• SQL Server efficient JOIN query

  Please help me with the efficient JOIN query to bring the below result : create table pk1(col1 int) create table pk2(col1 int) create table pk3(col1 int) create table fk(col1 int, col2 int NOT NULL, col3 int, col4 int) insert into pk1 values(1) insert into pk1 values(2) insert into pk1 values(3) insert into pk2 values(1) insert into pk2 values(2) insert into pk2 values(3) insert into pk3 values(1) insert into pk3 values(2) insert into pk3 values(3) insert into fk values(1, 1, null, 10) insert into fk values(null, 1, 1, 20) insert ...Show All

• Visual Basic reading bytes in reverse order

  I need to read three bytes at the following offsets: 13583, 13584, 13585. Except, I need to read them in reverse order (13585, 13584, 13583) Say the bytes in those offsets are so: 13583 = 0E 13584 = 45 13585 = 1F Now in normal reading order it would be 0E451F which would be 935199 in decimal. But, in reverse order (the order i need) it would be 1F450E or 2049294 decimal. I have no clue how I can do this. I spent about 45 minutes looking through the object editor and found nothing that would help me. Any ideas   Dim foo as integer = (B( 13585 ) << 16) or (B(13584) << 8)   or B( 13583) It's simp ...Show All

• SQL Server AS2005 September CTP Memory Error

  I get "Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed." while executing query set with cube browser in SQL Server BI Dev Studio. The same error I get while executing query with VB code (via ADOMD). The source of the error is AS2005 OLEDB Provider. One important information: I have installed Sept CTP on clean Windows XP Pro, there were no previous versions of SQL 2005 installed. Any ideas what's up Maybe some missing parameter in connection string I agree.  I have gone through all sorts of uninstalls and ...Show All