Bill H123's Q&A profile

• Visual Studio Tools for Office What happened to Cells(row,column)? Also Late Binding.

  Hi, In VBA I used to be able to access a cell with Cells(Row,Column).  In VSTO I seem to be having a problem.  I can get Range("A1") for example, but often I like to the use the row, column numbers. I've tried: Dim t As Date t = CDate (Globals.Sheet1.Cells.Item(4, 6).value). The cell holds a date.  This seems to work.  However when I have Option Strict On  I get  Late Binding not allowed . I don't get the late binding error if I use:  t = CDate (Globals.Sheet1.Range( "F4" ).Value)               Art ...Show All

• SQL Server Fail to Connect Report Service via Management Studio

  Dear sir, I installed a copy of SQL Server 2005 Evaluation Edition in my XP Professional Computer. When I try to connect to Report Service using Management Studio, it fails to connect with the following error: ********************************************** TITLE: Connect to Server ------------------------------ Cannot connect to XXXXXXXXXXXX ------------------------------ ADDITIONAL INFORMATION: The server committed a protocol violation. Section=ResponseStatusLine (Microsoft.SqlServer.Management.UI.RSClient) ********************************************** I have no problem connect to other services. Also, I can connect to the Report Manage ...Show All

• SQL Server Query on Custom source Component

  Hi in the acquireconnection method Using the below statment I can get a connection Object oledbConnection = cmado.AcquireConnection(transaction) as OleDbConnection; from the connection object I can get the connectionstring from the object by calling oledbConnection.connectionstring() property which will have all the details like DataBase, UserName & other Inofrmation but there is no password Info. How to get the password Information, I need that information since I will use that info to make OCI calls to fetch the data from the Oracle database in m,y custome source component. any help is much appriciated thanks i ...Show All

• Windows Forms Overriding a method Help

  Scenario I have a base Treeview,when a user expands the node I have method that is called only within this event. I would like to override this method. How can I do this I dont want to override the expand event of the treeview but just this one method that is called within the expand event of the treeview. Any suggestions Thanks Thanks for replying I have made the method in the base Treeview virtual,however in the form when start typing "public override etc I dont get my virtual treeviewmethod. Am I missing something here ...Show All

• .NET Development Question on ManagedDbgCA.exe

  Hi all, Recently I am looking at some topics on Visual Studio .Net - Remote Debugging and found a tool ManagedDbgCA.exe in Program Files\Microsoft Visual Studio .NET 2003\Common7\Packages\Debugger. Can someone tell me what is it for and how to use it Thanks for help!! This is a setup custom action. It doesn't do a whole lot -- it just invokes 'ngen /debug' to pre-JIT the .NET Framework for debugging. It is also gone in the 2005 release -- we use the retail ngen images of the .NET Framework instead of a debuggable version. ...Show All

• Visual FoxPro Urgent! How to change the value of a range in an Excel worksheet in VFP?

  Dear Experts, I've formatted a range from Text to Date in an Excel worksheet using codes in VFP, however when I open the worksheet to view the format is changed but the values still showing as text. Also found that the values will only change when i double-click on each indiviual cell on the worksheet, how can i do it using codes in VFP Your help appreciated. Andrew You can check the type of the field IMPORT FROM myFile.xls TYPE XLS select myFile locate scan do case case type('myDateField') = 'C' ldDate = ctod(myFile.MyDateField) case type('myDateField') = 'D' ldDate = myField.MyDat ...Show All

• Visual Studio visual studio and new file types

  I use BizUnit and it requires xml based test scripts. I call my scripts *.testx and have written a mini-compiler to check their content. I want to register this new extension with Visual Studio so it can view/edit my files like any xml file (currently shows as a text file) . How do I do that I haven't associated my compiler with my file type yet but that seems a straightforward process (I base this hope on the STRINGS utility) Can anyone help Jason If your file is XML, then you do not need to register it to edit as XML. Simply open the file. If a text file is opened in Visual Studio, and that ...Show All

• Windows Forms FileOk Event problem

  My handler for the FileOk event of a dialogbox just won't work.My code for the handler goes like this : void saveFileDialog1_FileOk( Object^ sender, System::ComponentModel::CancelEventArgs^ e ) { label1->Text = "test" ; } label1 is a label on the form and i want to change its text property just to check if the handler works.The saveFileDialog control shows itself after a click on a menu button.And when i click on the save button of the dialogbox, nothing happens.Any help I just typed the code under some other event handlers my program uses.Well this is my first windows ...Show All

• Smart Device Development pocketpc 2003 se emulator network problem

  hi , i am really suffering from this problem. i can not connect to the network via ppc2003 se emulator on visual studio 2005. i installed vpc driver(virtual machine network services driver version2.6....)but this exception occurs:'unable to connect' and 'the network resources can not be found or you dont have permission to access'. what i have tried are: -installing vs2005 on a new machine -installing vpc driver(version 2.6.) -reinstalling device emulator in vs 2005 setup -using active sync -changing emulator device id Note: once i managed to connect to the internet then it went i need any useful idea please ...Show All

• Visual Basic How to associate 2 forms in ONE class?

  Hello All,    I have a dilemma, and I'd appreciate any help any one can offer.  I'm a little new to Visual BASIC .NET, as I come from mainly a Java background.  My problem is this :  I have this huge number of classes right, and they mostly all have forms that take input or have buttons for specific choices to be made by a user.  Now, for a part of this whole project, I'd like to nest a class which has a simple form associated with that class, which takes in a number from the user, inside another class which I want to call when the user hits a button on the form associated with the "outer" class. So basica ...Show All

• Visual Studio Express Editions Sentence recognition.

  The idea is that we are making a piece of work for two of my scholar subjects. My friend and me thougt it would be nice to make a A.I. that can recognize sentence and can process them. The problem is: I dont know how to make a programm analyse a sentence. Please help, Douwe If you ever watched StarWars, He's the "grand Jedi" he is the "master" he teachs Darth Vader's son, Luke to be a Jedi as he planned in the 3rd movie... ...Show All

• Visual Studio Team System Replace TFVC with another source control

  Hi, Is it possible to replace TFVC with another source control in a VSTS environment Or could we do one thing - handle version control events (check-in/check-out, etc) and redirect them to another source control with corresponding events. Will this lead to duplication of records and if it will need tools to maintain conssitency of records Let me know your suggestions and approaches. If it is not doable, could you please explain it with reasons. Thanks, Saurabh You can't replace the version control in TFS in the sense that you would somehow plug a new one into the server. You can certainly use a ...Show All

• Visual C++ Need help with a program...

  Hey everybody. I've written this program and cannot figure out why it won't work. Here are my requirements... A teacher wants a program which will test students’ memory of the values of small integers squared. She asks for a program which prompts the students for an integer. It then asks them for that number’s square. If their answer is correct they are congratulated if it is incorrect the correct value is given. Because she wants the class to practice with this she asks that the program continue to prompt the students until they enter the integer: 0. The program will then thank the student and terminate. INPUT: ...Show All

• Visual Studio Express Editions MS Access DoCmd.FindRecord Equivalent

  Hi, Is there a standard way to reproduce the following VBA code in VB.Net 2005 Express Me.CustID.SetFocus Docmd.FindRecord Me.ListCustomers Thanks. It's easy enough to set focus to a control but there is no direct equivalent to DoCmd in Visual Basic Express 2005. What is Me.ListCustomers in this example ...Show All

• Visual Basic How to Registe Visual Basic Express Edition Beta??

  Currently, I have installed.I tried the link on HELP,but none webpage about registe on display on my screen. Who can tell me how to get the free SN for Visual Basic Express Edition Beta Tks!! Download the release copy of VB Express Edition and then try again. http://msdn.microsoft.com/vstudio/express/vb/download/default.aspx For more info on registering product http://msdn.microsoft.com/vstudio/express/register/faq/default.aspx There were a whole number of items fixed for release so you'll definately get a more relaible product if you use the release editiion and its free - so ...Show All