Oliwa's Q&A profile

• SQL Server Graph data question

  I have a graph that is properly displaying data for each year and then by each subsidy. However, when it displays data for the current year (2006), for the subsidies with no current data, it carries over the data (the sum of the total) from the previous year for the data points. There is no bar on the graph which is correct, however the data point from the previous year does display. For subsidies that do have data for the current year, this is being displayed properly. I am new a graphing so I hope I am explaining myself correctly. This is a simple bar graph being built in SQL RS 2005. Thanks for the information. ...Show All

• Visual Studio Tools for Office Asynchronous web service call behaves the same way.

  Using VST0 2005 with C#. I have an action pane that initiates a user request by creating a thread to query a web service. After the thread is created to do the work, the current (main) thread makes a progress bar visible and disables all action buttons and returns control to the excel application. The worker thread communicates with the main workbook via events. I have an event which signals the workbook that processing is done. At that time the workbook calls a method off of the action pane control to enable the buttons and make the progress bar invisible. While debugging, I get a message saying that I cannot perform the hiding of the progr ...Show All

• Windows Forms Using Access in a VB Project

  I am using the Access Application object in a VB project. I'm using the function DoCmd.OutputTo of the Application class to output a snapshot file to a particular directory. However, I constantly receive an error stating that I must install a printer (error 2202). The code I'm using looks very similar to this:.OutputTo acOutputReport, "", "Snapshot Format&q ...Show All

• Windows Forms list boxes more HELP needed.

  I need a way of making list boxes center the values displayed within the list.  I also need to find a way of making them unselectable without setting enabled to false or SelectionMode to None because the form won't load the way I tryed doing it if you know of another way please help me. Okay, the more that I participate  ...Show All

• Visual Studio Team System Accessing work item history from API

  How do I access the work item history from the API I want to traverse the history of the work item by entry if possible. If it is not possible, a string with all the history will help too. Thanks Hello You can fetch the work item of a particular revision from Work Item Store and then access the History Field to get the History. A sample code is here: WorkItem wi1 = WIStore.GetWorkItem(wi.Id); wi1.Open(); wi1.Title = testTitle + "Random Text"; wi1.Description = testDesc + "Random Text"; wi1.History = "Random Text"; int revisionNumber = wi1.Revision; wi1 ...Show All

• Visual Basic To do with variables

  I'm relatively new to Visual Basic, and would greatly appreciate an answer to the following question: What (in your opinion) is the best method for creating, storing, accessing, and modifying the same variables from different forms I have tried Arrays, but they just gave me more trouble than help. Thanks in advance for answers, as all help is appreciated. Create an internal static class with shared members, the shared members are actually variables you can access across your project: Friend Class MyGlobals Public Shared MyGlobalString As String = "TEST" End Class you can access MyGlobalString to any form from ...Show All

• Windows Forms DataGrid / Combobox / Query

  Hi there, i’m quite new on this VB2005 Coding, but there aren’t books in German language on this yet. So what i want to do: a DataGridView shows the content of my query, so far so good. Now i want to filter this DataGridView by a choice in a ComboBox, e.g. i choose "January" in the ComboBox, now the DataGridView should contain all Datasets from my table which contain "January" in the Column "Month". In VBA i know how to do it, but now i just don’t know how Hope someone can help me! Thank you guys! Michael Hi, If that's your situation then it would cause you some extra code. The Filter doesn't automatically skip empty values. Just par ...Show All

• SQL Server Parameterized Query Using Wildcards in VS2005

  Hey everyone, I have a smart device project in Visual Studio 2005 that has a SQL Mobile data source. I am trying to create a parameterized query that utilizes 'LIKE' and wildcards. My query is below: SELECT LocationID, StreetNum, StreetName, rowguid FROM tblLocations WHERE (StreetNum = @StreetNum) AND (StreetName LIKE '%' + @StreetName + '%') However, when I test this on my PDA, I get the following error: SQL Execution Error. Executed SQL statement: SELECT LocationID, StreetNum, StreetName, rowguid FROM tblLocations WHERE (StreetNum = @StreetNum) AND (StreetName LIKE '%' + @StreetName + '%') Error Source: SQL Server Mobile Edi ...Show All

• Visual Basic assistance: tring to setup Visual Studio's 9 pro, 16 bit subsystem error, WHY??

  everytime i try to run the install wizard I get an error box that telas me 16 bit subsystem error. I dont understand why this program would be giving me that error unless i'm missing a file in the setup that interfaces between the 64 bit my computer uses and the 16 bit setup wizard but even that i dont know how to fix. Any help would be appriciated. Thanks Comet87 What is your OS Microsoft Visual Studio 2005 System Requirements . ...Show All

• Smart Device Development Deployment error in Windows Mobile5.0 Application

  Hello another issue,i am using Winmobile5 API with C# i am just keep getting this again and again ------ Build started: Project: Mobile5Db, Configuration: Debug Any CPU ------ Mobile5Db -> C:\Documents and Settings\Adnan\My Documents\Visual Studio 2005\Projects\Mobile5Db\Mobile5Db\bin\Debug\Mobile5Db.exe ------ Deploy started: Project: Mobile5Db, Configuration: Debug Any CPU ------ Deployment and/or registration failed with error: 0x80070020. The process cannot access the file because it is being used by another process.  ========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ========== ========== Deploy: 0 succeeded, 1 f ...Show All

• Windows Forms ClickOnce online only app and Shared DLL's

  Lets say I deploy my apps using clickonce, online only option. Suppose all of the apps I deploy using clickonce go to the same location, which is simply a folder in a fileserver. Now every one of my applications has a .application file in this folder that I can create a shortcut to. After executing this .application file, all of the files needed for the correct version of the app are copied to the ClickOnce cache, then the program is run. Now... lets say I have 50 different apps, all deployed using clickonce. And lets say that ALL 50 reference the same DLL, and the DLL changes. From what I understand, I would have to open every singl ...Show All

• Visual C# Mistake in C# 2.0 specification?

    " anonymous@discussions..microsoft.com " <David M. Kean@discussions.microsoft..com > wrote in message news:44151354-d6b6-4140-9fba-6c46b5a50fd3_WBRev2_@discussions..microsoft.com ... This post has been edited either by the author or a moderator in the Microsoft Forums: http://forums.microsoft.com I just reproduced this also. This could be considered a bug in the compiler (especially if they are not following their own standard). I suggest you post a bug on the Microsoft Product Feedback Center .   Not sure what you have 'reproduced', or where you see a bug. & ...Show All

• Windows Forms printout/report generation ideas

  A quick question to ask what people tend to use as a reporting tool for winforms application that DONT use a database as their underlying data storage. In the past we've tried various methods from writing our own routines, data dynamics, component one and devexpress and found all un-satisfactory in one way or another. What I'd like is to give the end users the ability to create a template in say word and drop in markers and then fill this in, however I don't want to impose a restriction that the end users machine has to have word installed. The type of data to be filled in would be things such as graphics and other sub report ...Show All

• SQL Server Studio query results returns NULL data as actual "NULL" string

  I'm using SQL Server 2005 Management Studio and when a query returns NULL data in a column I get the actual string "NULL" output in the results. Is there any way I can stop this from happening No, it will always display "NULL" for null data.  If we were to change this behavior, what would you prefer to have in the query results ...Show All

• Windows Forms DataGridView - DropDownDataGridView Column

  I am trying to make a custom column for a DataGridView that inherits the ComboBox column. What I am trying to do is create a multi-column combobox. I had the bright idea to try to use a DataGridView for the drop down and I am having some issues. If I add the grid to the EditingControl controls collection, the grid will only display inside&nbs ...Show All