TA123's Q&A profile

• Visual Studio Express Editions Saving 2 ListBoxes to a text file

  I'm making a little phonebook program, and for it to be actually useful it needs to be able to save the phonebook. How would I go about doing this I think My.FileSystem has methods to load and save files to text, as in ReadAllText and WriteAllText. You can create your items as a string and then save them out that way. ...Show All

• SQL Server URGENT BUG FIX REQUIRED- "Internal Query Processor Error: The query processor encountered an unexpected error during execution."

  "Msg 8630, Level 16, State 6, Line 1 Internal Query Processor Error: The query processor encountered an unexpected error during execution." I receive the above error whenever I try to update a particular row/column in one of my tables. I am using SQL Server 2005 SP1. An example query would be: update myTable set myDateColumn = null -- any date value can go in here and it still won't work where myRowId = 12345 I can select the row and update the other columns in the table, but I just can't update this particular column in this particular row. Has there been any occurrence of this bug before I have tried restarting the database and server. There are 1,703,797 rows in the table and 7 columns. The query usually runs instantly, how ...Show All

• Architecture Learning design patterns

  Hi all, I'm very interesting of learning design patterns. I need your help please with two things : 1. Guid me start with easy patterns to understand then go harder. So if you have a list sorted by easy levels. 2. If you have links for concrete exampls for each design. Please help. Best regards... For a more in depth and practicle study of design patterns I recommend "Holub on Patterns - learning design patterns by looking at code". This is not suitable for beginners though. ...Show All

• Visual Basic Good Systems and Analysis Design

  Wher can I get some free help on Systems analysis and design for VB.net applications. jwooley wrote: If at first you don't succeed, RTFM. Nice one! ...Show All

• Visual Studio Express Editions Subtracting column 2 from column 1, showing answer in column 3

  Hi all, I have created a database for my work, and have loaded it onto my form in Datagridview, what I need to do it is be able to have it automatically delete whatever is entered into column 2 from the total which is has been entered into column 1 and show the answer in column three. eg Total Required for week No. Uplifted. Remaining 10 2 8 The number in column to (Number uplifted) will be updated continuously so would like it to update column 3 (remaining) when it is changed. Any help with this would be very much appreciated Regards, Diane this would really be done at the SQL level, however, you can go through each row of data, ...Show All

• Software Development for Windows Vista NLA API documentation

  Where can I find the latest information on the Network Location Awareness API for Vista The only document I can find is quite outdated (from WinHEC 2005 - April 18, 2005) Regards, Fernando Thanks Cathy, I'll check this out. Regards, Fernando ...Show All

• SQL Server Package variables

  Couldn't quite find the answer I was looking for via a forum search. I have 9 packages that are currently called by a master package - all child packages take a datetim e variable from the master package which is subsequently used in the child processes. The question I have is that if I run the master package manually from Visual Studio I can set the master package variable manually to a date of my choosing and run it, which works fine. However we will be wishing to automate the package execution at some point and want to know the best way to run the package(s) on an automated basis and have the data variable supplied to the master package. What would be the best way to do this Presently we have a variable called MasterPackage ...Show All

• Visual Studio Express Editions Connecting VB Express 2005 to ODBC 3.51

  Hi Im a new guy at VB but im loving it :) im having some trouble in connecting an MYSQL DB in the Visual Basic Express 2005. I use the wizard for adding new connection but the pre configured connection doesn’t apear, only the connection driver to Access Database and SQL Server driver. But the driver (and connection) to Mysql server isn’t there.Can some one help me Best regardsFrederico Pereira Hi i already went to that website to and already made that connection.I have the MYSQL ODBC 3.51 installed. But the problem is that i need the Connection from the menu "DATA SOURCES" cause from there i can manage tables etc. It seams to be more simply sor a newbie like me. And of course i take all the advantage of all funcions of the V ...Show All

• Windows Forms Tooltip Owner Draw

   Just working on a customised tooltip and in the meanwhile i realised that, when isballoon property is set to true, also ownerdraw is set to true..interestingly the draw event is not firing!!!. what could be the reason.. is this by design or a bug Thanks for the reply. all that i am trying to do is, have a balloon tooltip and with some small image which can take me to a context menu plus some additional stuff. So, i tried by keeping isBallloon to True and also OwnerDraw to True and then writing the code under draw event assuming that balloon window type will be created on its own as i kept isBalloon to true and remaining stuff handling in draw event.. but unfortunately it is not firing....Can you pl ...Show All

• Visual Studio Team System Whether uploading documents can be playbacked

  On recording, I uploaded a Excel and on playback it shows RequestFailed: Could not find file 'C:\Inetpub\wwwroot\For_testing\TestResults\vijay 2007-02-09 22_01_57\Out\SheetTemplate.xls'. Kindly suggest Hi, I can't find any named "$TestDeploymentDir" in my coded part. This is my exact code on my playback. request5Body.FormPostParameters.Add( new FileUploadParameter ( "ctl00$ContentPlaceHolderBody$FileUploadStepSignSheet" , "SignInSheetTemplate.xls" )); I am uploading that excel from my c drive, so I have changed it to request5Body.FormPostParameters.Add( new FileUploadParameter ( "ctl00$ContentPlaceHolderBody$FileUploadStepSignSheet" , "c:\ ...Show All

• Windows Search Technologies Problem crawling with a hierarchical custom protocol handler

  I have developed a hierarchical custom protocol handler that I'm integrating with Windows Search on Vista. The handler has a IUrlAccessor and IFilter implementation that enumerates the contents of a directory by returning the search URL of each "file" in the directory as a text chunk with the STAT_CHUNK structure specifying the GathererPropset and PID_GTHR_DIRLINK propid. My understanding is that the indexer should take these URLs and queue them for indexing, in which case I should see subsequent calls to CreateAccessor with those URLs. However, instead I'm seeing the indexer call CreateAccessor once to get the directory accessor, then it reads the dirlink text chunks, but it never make the expected additional calls to Create ...Show All

• Windows Live Developer Forums Getting multiple pages with Find

  When using find, I'm having trouble figuring out how to get the next page of results. I call find with the same input except for the index, but I keep getting the same results back. I'm not sure how FindNearby is supposed to help since the API doesn't suggest I can pass in an index value, or supply a callback function. (I also need to process the info before displaying it) suggestions ...Show All

• Visual Basic How to answer incoming calls ...

  Hi I am trying to write an application in vb.net which answers incoming phone calls as plays the voices which I want on the phone. also it should understand the DTMF tones. I'd be glad if you giude me. thanks I recommend your start here: http://www.google.com/search q=answer+incoming+calls+vb.net&rls=com.microsoft:*&ie=UTF-8&oe=UTF-8&startIndex=&startPage=1 ...Show All

• Visual Studio Team System Process of TFSWarehouse fails

  We moved our TFS to a new hardware. Everything seams to be fine now - but Process the TFSWarehouse (pt. 29 in How to: Move your Team Foundation Server from One Hardware Configuration to Another) fails. These are the lines where errors start: Processing Measure Group 'Build Changeset' completed successfully. Start time: 10.01.2007 11:48:13; End time: 10.01.2007 11:48:16; Duration: 0:00:03 Processing Partition 'Build Changeset' completed successfully. 79083 rows have been read. Start time: 10.01.2007 11:48:16; End time: 10.01.2007 11:48:16; Duration: 0:00:00 SQL queries 1 SELECT [Build_x0020_Changeset].[__ID] AS [Build_x0020_Changeset__ID0_0],[Build_x0020_Changeset].[Build] AS [Build_x0020_ChangesetBuild0_1],[Build_x0020_Change ...Show All

• SQL Server Stored proc poor performance need help with query optimization

  I currently have a stored procedure in our SQL Server 2000 environment that will run great most of the time but periodically throughout the day it will start to run poor. Once I issue an sp_recompile on one of the largest tables (NominationScheduledQuantity with 2 million rows) in the database the stored procedure runs great again. I am assuming this is because a more up to date plan was generated. The code of the stored proc is: CREATE PROCEDURE ursp_Nom_GetDisaggNominations ( @ContractID INT, @DateGasFlow DATETIME, @CycleCode CHAR(3), @FilterZeroQuantityNomFlag CHAR(1), @TransTypePooling CHAR(2), @CycleCodeTmy CHAR(3), @CycleCodeEvn CHAR(3), @CycleCodeID1 CHAR(3), @CycleCodeID2 CHAR(3) ) AS BEGIN Set NoCount On DECLARE @TodayDat ...Show All