surfguy0021's Q&A profile

• Visual Studio Tools for Office Excel XML Auto Column Width

  Hi, I've been trying to figure out how to get excel to automatically set the width of the columns for XML spreadsheets that I am generating.  I know this is possible for HTML excel spreadsheets (because I currently do this in some of my other programs), but it doesn't seem possible in XML.  Does anyone know if there is a way to do this   Thanks   EDIT: I apologize if this is not the right forum for this question, but I didn't see a closer matching forum. I would recommend trying The Office Development news groups http://msdn.microsoft.com/newsgroups/topic.aspx url=/MSDN-FILES/028/201/008/topic.xml ...Show All

• Visual Studio Express Editions Winsock Where is it?

  Where do I find the Microsoft Winsock Control 6.0 A website told me to load that component but I dont know how help please thanks. Hi Why not to use the System.Net.Socekt Namespace it has all the implemenation of Sockets. You can use High level and as well as low level socket programing through the managed name space. ...Show All

• Visual C++ Strange error C2228

  Hello, I am facing a very strange error with this code: Basically, I have a wrapper object, and I want to initialize it with a temporarily created object (which is perfectly legal). But depending on the declaration, the wrapper object creation fails. Here is a sample code: struct a { int s; explicit a(int s_):s(s_){} }; class a_wrapper { a m_a; public: explicit a_wrapper(const a& a_) :m_a(a_){} int get(){return m_a.s;} }; int main() { int nb_act=30; a_wrapper s1(a(nb_act));//seen as function definition s1.get(); //error C2228: left of '.begin' must have class/struct/union //type is 'overloaded-function' a_wrapper s2(a(30)); //seen as object creation s2.get(); //no error!! return 0; } For ...Show All

• SQL Server Slowly changing dimension - always shows rows as changed?!

  I created a simple type 1 slowly changing dimension, setting all the columns to "Changing Attibute". The first time I run the package it sees all rows as new and imports them into the dim as it should. Next time I run it put 100% of the rows into the "Changing Attribute Updates" and runs an update on all 90,000 rows - updating the rows to exactly what they were before If I take the DIM and the Source in SQL and join on every row the join succeeds (meaning the rows match perfectly). Shouldn't the SCD object just ignore the rows if they match Or does it assume that ALL incoming rows are either new or changed (if so why is there an output called "Unchanged Output" ). Is there some "gotcha" I am mi ...Show All

• Windows Forms MDI children's child

  I am opening a form from a MDI child form. MDI Form --> Child A Form --> Child B Form. Child B is opened from Child A. However they should both be children of the MDI form. How can I make this new form a child of the top level MDI form Thanks thanks - but is there a way to have the form be modal and confined to the borders of the MDI form. f3.ShowModal(this.MDIForm); that allows the form to leave the frame of the MDI form. Is it possible to have both ...Show All

• Windows Forms Windows XP

  2 questions. How many times can you download your Windows XP disk w/the serial number before It's no good. And. When I log onto my computer, I can log off with no problem, but when my kid logs on using his own password, he can't log off for some reason. He has to do a restart. As far as I know, Windows Must be activated each time it is installed. If your kids can't log off, try going to DOS and type in "logoff" and if that does not work, try CTRL+ALT+DEL and click on the users tab, select the account name and click the log off button. Beyond that I don't know how to help you. The following is a Windows XP help article. THIS IS PROPERTY OF MICROSOFT. You cannot log off, resta ...Show All

• SQL Server How do I get number of fields returned by query?

  Hi. I am trying to get the results of a dynamic sql statement into a #table, in order to filter them. Given that I don't know how many fields will be returned, how do I accomplish this I believe I need to create the #table in advance, and then run the dynamic string as part of an insert [eg 'insert into #table exec (@sql)' ], but in order to do this I need to know how many fields are going to be returned. The results might also be returned by a procedure rather than a simple SQL statement, so I can't just parse @sql to get the fields. As an example, declare @sql nvarchar(200) select @sql = 'select "a" as ColA, "b" as ColB' exec sp_executesql @sql returns two columns of data. I think I need to get t ...Show All

• Visual Basic MySettings vs. My.MySettings in Dataset.Designer.vb ?

  Hi, I have a VB2005 application with a dataset and that has an xsd file. When I edit the dataset diagram, even to the point of just moving a DataTable/TableAdapter box, the code behind this (MyDataset.Designer.vb) is regenerated. Unfortunately, all the "InitConnection" methods therein are generated incorrectly. I get... <System.Diagnostics.DebuggerNonUserCodeAttribute()> _ Private Sub InitConnection() Me ._connection = New System.Data.SqlClient.SqlConnection Me ._connection.ConnectionString = Global .FTPMaintenance.MySettings.Default.DefaultConnectionString End Sub To get this to complile, I have to change this (every time) to be... <System.Diagnostics.DebuggerNonUserCodeAttribute()> _ ...Show All

• Visual Basic Using SQL 2005 instead of Access for Database

  I want to change a major inventory program from access to Sql 2005, probably Express edition. My problem is that There is one master database that resides on a server. We also have the database residing on our Laptops for useage when we are in the field programming radios. In the field at this time we do not have access to the server database so must use the local database. Before we would go into the field, we would copy the current database to our computers. While in the field we would make inventory changes, but do not do adds or deletes. When we return from the field, I had a routine which would update the master from the local based on when the record was changed. How would I be able to impliment a similar way with SQL Server ...Show All

• Visual Studio Team System Checking buttons on webpage

  Hi, is it possible to check for .gif or buttons on a webpage after recording by adding some validation controls . Please help We have a help topic on validation rules here: http://msdn2.microsoft.com/en-us/library/ms404670.aspx There's a walkthrough at the bottom that talks about how to add rules or even create custom ones. To check for a gif, you'd probably want to use the Required Attribute Value rule. You'll want to set the following properties: TagName=img AttributeName=src AttributeValue=<path to image you're trying to validate> I hope this helps get you started. Josh ...Show All

• Visual Studio Express Editions Write native Windows 98 Application in VB Express

  Is it possible to write an application in Visual Basic Express which runs 'natively' (i.e. without the need for .NET frameworks) on Windows 98 If so, how is this done If not, what's the best alternative for developing such an application on a Windows XP machine Thanks John Its only the first application which would be time consuming. After its installed once, all subsequent applications would detect the framework is present and wouldnt try installing again. So basically the first 2005 application installed on the machine puts most of the requirements down and everything after that should install pretty quickly. ...Show All

• .NET Development SqlCeCommandBuilder cannot recognize VS2005 generated DataAdapter

  I created a DataAdapter (actually, it was created at my behest) in designer mode using VS2005. The generated code follows: [code] [System.ComponentModel.DesignerCategoryAttribute("code")] [System.ComponentModel.DataObjectAttribute(true)] public partial class ICD9TableAdapter : System.ComponentModel.Component { private System.Data.SqServerCe.SqlCeDataAdapter _adapter; private System.Data.SqServerCe.SqlCeConnection _connection; private System.Data.SqServerCe.SqlCeCommand[] _commandCollection; private bool _clearBeforeFill; [SystemDiagnostics.DebuggerNonUserCodeAttribute()] public ICD9TableAdapter() { this.ClearBeforeFill = true; } [SystemDiagnostics.DebuggerNonUserCodeAttribute()] private System.Data.SqlServerCE.S ...Show All

• Windows Live Developer Forums Error adding web reference in vs2005

  I have tired adding MS Live Search web reference ( http://soap.search.msn.com/webservices.asmx wsdl ) to a vs2005 project (the project is of type workflow library - .Net Framework 3.0). Once I enter the url and, after services discovery, i click add web reference... The web reference is added but I also get the error: Error 1 Custom tool error: Unable to import WebService/Schema. Value does not fall within the expected range. Any ideas what might be wrong Thanks in advance, Marko Vuksanovic. ...Show All

• Visual Studio 2008 (Pre-release) Button as drop down menu? (should be easy!)

  I've looked at examples but can't get this quite right... I want a button (not a split button) to act just like a drop down menu (like File, Edit, etc.). When I left click on the button it should bring up a context menu below it... suggestions I am not sure if this is what you want. A button with a context menu that appears with a left click <Button Height="25" Width='70'> <Button.ContextMenu> <ContextMenu Name="cm" StaysOpen="true"> <MenuItem Header="File"/> <MenuItem Header="Save"/> <MenuItem Header="SaveAs"/> <MenuItem Header="Recent Files"> <MenuItem Header="ReadMe.txt&qu ...Show All

• Visual Studio Team System How to start using TFS?

  Our team have just installed TFS on one of the servers. But problem is, none of us in the agile XP team knows how to use it! Can someone give links to tutorials or any help files that we can use to learn on it We dont even know the very basic of connecting a project to a agile project in VS2005... Thanks in advance. Microsoft press has a book for "Working with MicrosoftR Visual StudioR 2005 Team System " http://www.microsoft.com/MSPress/books/8477.asp http://www.amazon.com/exec/obidos/tg/detail/-/0735621853 v=glance Here are more books: Professional Visual Studio 2005 Team System (Programmer to Programmer) by Jean-Luc David Software Engineering with Microsoft Visual Studio Team System ( ...Show All