NickFM's Q&A profile

• SQL Server XML Bulk Load schema question

  I was wondering if someone could point me in the right direction with a schema file for importing XML into a DB - the XML file has multiple sublevels, all of which need to be imported into a single table. I have it functioning "to an extent", meaning part of the file is imported - however, some of the sublevels have been driving me nuts, and I am not sure how to get it to work for all of the columns. ANY HELP WOULD BE GREATLY APPRECIATED - I've searched high and low for any documentation that would explain how to write up the schema to be able to import. Testing the schema I have created so far works - however, it does not import all of the ...Show All

• Visual Studio Tools for Office Problems with deployment at end user

  Why doesnt this code work when the msi.file is installed on the enduser machine. Nothing happens, while when run as 'Debug' in VS development environment everything works. All this code does is displaying a messagebox when Outlook is started. The project is made with VSTO and nothing in the setup project is tampered with, ie keys and such are intact. Help please! in ThisApplication.cs: private void ThisApplication_Startup(object sender, System.EventArgs e) { MessageBox.Show("Frustration"); } in Installer.cs: public class Installer : System.Configuration.Install.Installer { public In ...Show All

• Smart Device Development How can I tell if the user clicked the OK on a form

  Hello, Is there a way to tell if the user clicked the "OK" of a form opposed to a button on the form that forced the close of them form, in vb.net I would like to disable the ability to click the "OK" button if possible. Thanks in advance. John Lars, Thanks for the help. Shows how long I've been out of programming forgot about that property. John ...Show All

• SQL Server RS Data Driven Subscription is out of control...

  Hi - I'm hoping someone can help me with a subscription problem (SQL 2000, Reporting SErvice SP2). Created a data driven subscription and made a mistake in the parameter list. It was really long, and now I can't get the subscription to stop. I've bounced the server, but as soon as we restart RS the job starts back up again. I tried to delete the subscription, but it gives me a timeout error. I've already changed the subscription (because I didn't realize the trouble) and I'm wondering if there is a way to get rid of it. Right now, I've left RS service stopped. Thanks, Mary The subscription runs via the SQL ...Show All

• Windows Forms Tab control shortcut key

  How can you set a shortcut access key for each tab of a tab control Using the & sign like you do for labels and command buttons doesnt work,(it just puts the & in the text). Also Im using vs 2005 C#. Thanks, I just came across some code that Sets up shortcut keys for the .NET tab control   private void frmReceiptWare_KeyDown(object sender, KeyEventArgs e)   {    if (e.Alt)    {             if (e.KeyCode == Keys.E)             { ...Show All

• Visual Basic add .dll

  My visual studio project fine on the development machine. I am able to install the project on other machines, but when loading one of the forms I receive the error: Could not load file or assembly "Microsoft.VsDesigner,8.0.0.0. This error only occurs on one form, all others load fine. I am not sure if I am missing a component, or if there is a way I can change the form to elimiate this dependency. Any help would be greatly appreciated.Mark It is not installed on the target machines, thus the error. I guess my question is how to add it during setup Is it part of one of the components When adding ...Show All

• Visual Studio Team System Clearing up Boot Errors in Event Log (Single Server Deployment)

  I got tired of all the boot time errors when booting TFS in a single server deployment:  TF050801 - Initialization did not complete because there was no task list registered with the TFS Registration service.  ASP.NET 1309 - Cannot open database TfsIntegration - login failed  TF30065 - Unhandled exception occurred - cannot open databse TfsIntegration.  MSSQLSERVER event 18456 - login failed for .\TFSService I figured they were related to the fact that there is no dependency on SQL Server and TFS is trying to login before SQL Server is really up. So I put a dependency on TFSServerScheduler of MSSQL ...Show All

• Visual Studio Team System Trying to run

  I'm trying to run the 'Work Items' report. But when I do I get asked for the Iteration. I'm using MSF Agile so have three iterations but none is listed in the drop down box on the report window. Is there anyway I can get to run the report (this is running Team Explorer on the same machine as TFS is installed running as TFSSetup). Thanks, It would be interesting to see if that data made it into the warehouse.  Do the other reports work Here's a link to see the state of the warehouse: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=154526&SiteID=1   ...Show All

• Visual C# how to save as a text or binary file..

  I am trying to save data that appears on a list view to a file, binary or text. My column headers are Name, Address, Phone Number, Gender and Age. I would like the program to be able to save the data rows in each line. Name Address Phone Number Gender Age John Doe 123 Pine Cir Xcity MN 55354 (252) 524 -1524 M 25 Jane Doe 251 Mars St Ycity MN 53215 (215) 521-2512 F 23 …. …. …. … … so the saved text file would look something like this.. John Doe 12 ...Show All

• Visual Studio Bad exception interception with the VS 2005 RC debugger

  I have an issue with with exception interception with the VS 2005 debugger (the project is .Net library that has been just ported from .Net 1.1 and was running quite fine through the VS 2003 debugger). Basically, I have a NUnit test that calls a method, and this call (in the unit testing context) is expected to fail by throwing a InvalidOperationException. The NUnit tests actually checks that the exception is thrown. In my project configuration, I execute the library through the nunit-console.exe application (as a custom start-up program). My problem is that the VS 2005 intercepts the InvalidOperationException although this exception is go ...Show All

• Windows Forms How to execute a method when mouse is clicked any where in the screen

  Hi, While developing a win-form application in C#, i came across the following requirement. I would like to handle the mouse click event when it is clicked any where in the screen (even out side the form, even on other controls in the form,..etc). I tried using 'wndproc' method but the problem is it is executing the code only when 'form' captured the mouse. But, if I made form to capture the mouse, other controls (which are in the form) click event is not firing even if I click on the controls. Only form is capturing the click. How to have both 'wndproc' method and click event of controls can be fired when form captured the mouse (or else) H ...Show All

• Visual C# Cast string to variable?

  Is there a way to cast a string to a variable name In my code I need to instance classes on the fly. In psuedocode I want to do this: Variable KeyValue<x>; With <x> being replaced by an incrementing number on every call (so you might end up with KeyValue0, KeyValue1, KeyValue2, etc.). Is there any way to do this in C#  I recall a way in Pascal, but that was many years ago... It's OK, I've worked it out now. Got a few minor problems, but nothing I won't solve eventually. Thanks for all the help everyone! ...Show All

• Windows Forms disk space

  i dont know if this is the appropriate forum for this but here goes. I have a problem i recently reinstaleld windows XP on my computer and after i did that i found that i only had 2 GB so i deleated a few things that did not get deleated in the reinstallation and i also compressed old files and did a disk clean up and now i only have 10 GB out of a total size of 27 GB so i should have a lot more than 10 GB and i dont think that there is any thing else that can be deleated on my computer and i still have that problem. please can sombody help me thankyou Hi, you are wrong here. I think the windows xp forums will hep you: http://www.micro ...Show All

• .NET Development Where are the ASP.NET 2 Quickstarts?

  Can someone point me to exactly where I can find the downlaod for the ASP .NET 2 quickstarts   The go.microsoft link points to asp.net site, which then doesn't seem to offer too many clues... except that the quickstarts can be consumed from that site. thanks, -s IMHO quickstart are installed by .NET Framework SDK. If you didn't choose this option in VS Installer you won't have them. I can find them in C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\QuickStart ...Show All

• .NET Development Clearing textboxes

  Is it possible, and if so how,to clear every single textbox on a form without having to set every one to textbox.clear when a button is pushed or menu item selected thx Sure, something like this void ClearAllTextboxes(Control parent) { foreach (Control c in parent.Controls) { TextBoxBase t = c as TextBoxBase; if (t != null) t.Clear(); if (c.Controls.Count > 0) ClearAllTextboxes(c); } } ClearAllTextboxes(this); ...Show All