zogman's Q&A profile

• SQL Server Quick Import Wizard Question - Importing XML Data

  Hello, I want to import some XML data from the internet. For example, http://www.somexmldata.com/ returns some well formatted XML data that I want to import into SQL Server 2005. If I create an Integration Services Project it's easy - I use an 'XML Source' and specify the URL as the 'XML location'. Job done! However, I want to do it using the Data Import Wizard - how do I accomplish the same thing Many thanks, Ben Unfortunately, we were not able to add support for XML sources to the Import Wizard. That is something that should be part of our upcoming work. You are welcome to request that at th ...Show All

• Visual Studio Team System Correct steps to add users to team project

  Hi, this may be documented, and if so, I would appreciate your telling me where; to add users to the project so that they can be assigned work items what are the correct steps Thanks, Barton You can find a set of walkthroughs for Team Foundation on the following MSDN page. http://msdn2.microsoft.com/library/ms181232(en-us,vs.80).aspx Buck ...Show All

• Software Development for Windows Vista sql services

  I seem to have some trouble with the SQL services. SqlPersistenceService, SqlTrackingService and so forth seem to work fine. At least the events are fired that the workflow instance gets persisted on idle and so on. Event the samples like Lab3/Ex2 run fine. But there is never something in the database visible. Also the WorkflowMonitor does not see anything. I suspect that the sql services never commit their changes to the database, so everything works virtually fine as one console app workflow most likely uses only one sql connection therefore non committed data by itself is visible to it. I use the right database, if I change the c ...Show All

• Windows Forms Help me designer has Bugs bugs bugs

  For some reason whenever I use certain controls in Visual Studio 2005 the designer will not reload the form and I get Initialization errors in the designer. Ive downloaded the TaskVision app to see if it was something that I was doing, but I am unable to view any complex forms in that project either.. One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may require code changes. The designer cannot process the code at line 58, please see the Task List for details. The code within the method 'InitializeCompone ...Show All

• Smart Device Development Connection to SQL Server 2000

  Hi, I am trying to connect to an SQL Server 2000 database using VB.NET 2005 CF. When I run the application (code below), I get the following error: An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.SqlClient.dll Additional information: SqlException Can anyone help me solve this problem When I use the same code in a windows application from, it works fine, but it doesn't when I run it on my device. Imports System Imports System.Windows.Forms Imports System.Data Imports System.Data.Common Imports System.Data.SqlClient Public Class Form1 Inhe ...Show All

• Visual Studio Team System Cannot auto-merge when two consecutive lines have changed

  Hi, Here's a very simple scenario: 2 users check out the same file concurrently. User A checks the file back, with changes to line 7 only User B checks his file back, with changes to line 8 only User B gets the conflict notification.However, User B is not allowed to auto-merge. Why User B has to go through the 3-way merge to resolve the conflict. Why can't TFS automatically merge when two consecutive lines have changed thanks, Tony There are technical reasons why hunks are parsed the way they are, but it ultimately boils down to safety. There's no way for a text engine to verify code ...Show All

• Visual Studio Express Editions Express registration: going crazy...

  I searched the whole forum, I found 32 links with th e"activation key" None of them helped me. I just installed Web Express. I go to Help->Register Product (Many post states that there is an "Activate product" in Help. No, there is nothing like thios. It is "Register product" instead.) I get a web page, I log in with my passport. Finally I receive a web page that looks exactly like this: Thank you for registering! Your e-mail address has been verified and a "thank you" e-mail with links to valuable registration offers and resources has been sent to your inbox. And if you haven’t done so already, subscribe toda ...Show All

• SQL Server Return the data from a table ordered by its hierarchy

  How can I create a function that returns hierarchical data from a table with this structure: - CategoryID - CategoryName - CategoryFather I want to bring the result set like this... CategoryID | CategoryName | CategoryFather | HierarchicalLevel 1 | Video | 0 | 0 2 | DivX | 1 | 1 3 | WMV | 1 | 1 4 | Programming | 0 | 0 5 | Web | 4 | 1 6 | ASP.Net | 5 | 2 7 | ColdFusion | 5 | 2 How can I do this Does anybody has a sample code I need this on SQL Server 2000 and if it's possible (but not too necessary) in SQL Server 2005. Thanks. In SQL Server 2005, you can use Recursive CTSs to achieve the same. WITH HierarchyListing ...Show All

• SQL Server Display datasource information in header

  Does anyone know how to display datasource information in the header of a report Aside from Value, can you tell me what properties are avaliable via the ReportObjectModel please I can't find any help on this. ...Show All

• Windows Forms Reference to System.Data created for every new form

  Every time I create a new form it creates a reference to System.Data and puts the 'using' statement at the top of the code file. But if I delete this line of code and delete the reference, it still compiles fine. Is this just a redundancy overlooked ...Show All

• Visual Studio Express Editions How to disable the space bar in maskedTextBox?

  I have a masked text box of an IP address. the mask is set as 099.099.099.099 and it allows user to enter space bar. I' like to know how to disable the space bar key i.e. when a user press space bar then nothing happen, the cursor is still at the same position.. I've tried to use the keyDown and keyPress with the e.handled = true; but it dose not work. Can anyone help me Thank you The '9's in your mask mean numbers 0-9 or space. For an IP you probably want a mask of "990\.990\.990\.990" Using "\." instead of '.' should avoid having the decimal point being globalize ...Show All

• Windows Forms Nasty drop down border of Combo

  I'm developing ComboBox derrived control (with tree being dropped down) and I'd like to now how to remove that nasty 1 item height rectangle appearing each time I'm  pressed a combo button (I'm drawwing all drop down stuff by myself and want this rectangle) How it looks  ________ [text IVI] (*1) ~~~~~~ -------------------------------- [ this thing I want to not appear] (*2) ~~ ...Show All

• Smart Device Development wifi API for pocket pc 2003???

  Hi experts, I really need to get all the wifi information in pocket pc 2003. I test with Qtek 9090. I try to search all in msdn and qtek page, but i can't found any informations about it. Can you show me how to do that with API Second question: Can we know when the GSM network is enable or not If i understand exactly i have to use TAPI 2.0 for pocket pc 2003 can you show me some sample code for pocket pc 2003 Thank you so much. Julien This is all you need for WiFi API's: http://www.microsoft.com/whdc/device/network/802x/80211_netadapt.mspx http://support.microsoft.com/default.aspx scid=kb;[LN];328601 regards, KC ...Show All

• Visual C# can someone convert this snipet of VB to c#?? Just Some Simple one (basics)

  Hi This shouldn`t be difficult .. but i dont know VB But what does this means... He declare a function named with "Afunction" and then in the body of that fucntion he says.. Afunction= ..... LoL , how does he do that or what does that mean in c# can a name of a function take some value Please tell it what does this means in c# hi, looool i don't know what do you talk about , i guess it will be better if you post the function here best regards ...Show All

• SQL Server Dataset Question

  I have a dataset which is calling a stored proc in my SSRS 2005 report. The stored proc just returns one value which is the result of a SUM in my stored proc's sql query. When I reference that field from my dataset, SSRS puts SUM() around the fieldname. This is causing an issue because I have a complicated expression in my table footer and need to just reference that field by it's name without SUM. Why is it putting SUM around my one field If I take out the SUM around that field, SSRS can't recognize it as a valid dataset field anymore I'm not quite sure I understand why you are putting Datasource as the field in parenthesis unl ...Show All