Terry Smith's Q&A profile

• Visual Basic How to Transfer Data from DataGridView to MS Excel File and MS Word 2003

  if any one now How to Transfer Data from DataGridView to MS Excel File and MS Word 2003 or suggest to me >>> palestine , Just like I described in the previous post, please use the ADO.NET data access methods. ADO.NET is an improved edition of ADO 2.6 but run on .NET Framework. Also the ODBC, OLEDB are commonly used in data access. There are so many descriptions on this subject and here I will give you an example on access and data modified using the DataGrid. In the example, there are two main method you'd better pay more attention: RefreshData() and SaveChanges() method Imports System.Data.SqlClient Public Class Form1 Inherits System.Windows.Forms.Form Public Const ConnectionString ...Show All

• Visual Studio Team System Unit Test Dll.config/App.config in TFS build process

  Hi, We have a lot of unit tests converted from NUnit and these unit test use Dll.config files. The converted unit tests run successfully in IDE, but when I created a build type from TFS Team Build. The build type runs fine for compiling but fails in the Unit Test step. Searching the trn file, I found out the file path defined in the app.config file can not be retrieved in the unit tests assembly. Can anyone tell me how to use app.config in the build process I also would like to know where the tests run during the build process (in Build Machine or in the Drop machine). Thanks. It should work normally, as when you run them in your machine, can you check the app.config is correctly in source control , abo ...Show All

• SQL Server run SSIS package with ODBC connection via SQL agent

  It seems there a lot of problems running SSIS packages under the sql agent. I have read the knowledgebase articles regarding permission issues etc but I still can't get my job to run. I can run any package as a job apart from a package that connects to an external database via an odbc connection. Has anyone had any luck with this and can let me in on the secret. Hey Andy Thanks for the reply, it seems that the issue is that I'm using a 64 bit OS and 32 bit odbc driver and when sql agent runs it uses the 64bit program files as opposed to the 32 bit program files which means that it couldn't find my odbc dsn. So to get around this had to create a batch file which calls the 'x86' program files. Have al ...Show All

• Visual Studio Team System New Project Creation Problems

  I have a couple of problems that I suspect may be related. When I attempt to create a new top level Team Project on my local development machine’s Team Explorer, the project creation fails as the “Groups and permissions created…” message briefly appears on the wizard. After the problem occurs, I see the following error message in the New Team Project wizard (I included an excerpt from the log file further below): Error TF30170: The plugin Microsoft.ProjectCreationWizard.Groups failed during task GroupCreation1 from group Groups. Explanation Plugin error text: “TF50608: Unable to retrieve information for security object $PROJECT:vstfs:///Classification/TeamProject/5150e28f-d381-4c04-891d-f36b8de47c8b, it does not exist. ...Show All

• SQL Server Linked Server To Oracle Causes SQL Server Instance to Crash

  When running a linked server to Oracle using the MSDAORA driver using in-process option checked, I'm getting the following error: "A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)" This then causes the instance to crash. In the Event Log, it shows: SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server ...Show All

• Visual Studio Team System Deleted AD resource causes publishing error

  We had a user leave the company who had tasks assigned in Team System. The next time we published the Project we got a publishing error and had to reassign all the tasks to an active resource. Project Server is able to gracefully recover from this type of event...Team System should also. Doug, Thanks for the feedback. Were you expecting all tasks for that user to be automatically assigned to Active Consider the scenario where you want to know what tasks were assigned to the user who left the company and then load balance them across other users. Wouldn't it be easier to accomplish this with the current design Instead, if we automatically assigned all these tasks to Active, you'd have to manually updat ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Is Boo a viable option for Scripting for both PC and XBox360?

  I'm just wondering if anyone has tried getting Boo to work for scripting on the XBox360, or is there some feature that Boo takes advantage of on the PC that isn't available on the console I've been reading that IronPython isn't an option, and LuaInterface wouldn't work either, since P/Invoke doesn't seem to be supported for security reasons. Can anyone shed some light It would be greatly appreciated. Thanks, Kevin As you mentioned, the reason LuaInterface doesn't work on the Xbox 360 is because LuaInterface uses native code (via P/Invoke). IronPython uses dynamic code generation (System.Reflection.Emit) which is not supported on the Xbox 360 framework. The best place to find out if you can use Boo is to a ...Show All

• Visual Basic Find all PCs in a network

  I am using VB 2005 How can I search all active PCs in a network in vb.net Regards This .BAT file works for me. i should be able to do the same using VBS and VB.net @ECHO OFF FOR /F "TOKENS=2* DELIMS=:" %%a IN ('ipconfig ^| find "IP Address"') DO SET IP=%%a FOR /F "DELIMS=. TOKENS=1,2,3" %%1 IN ("%IP%") DO SET IPR=%%1.%%2.%%3. SET IPR=%IPR: =% SET /A NUM=0 :REPEAT IF %NUM%==256 GOTO EOF SET /A NUM=%NUM%+1>NUL SET IP=%IPR%%NUM% TITLE CHECKING %IP% PING %IP% -n 1 -w 100 >NUL IF %ERRORLEVEL%==1 (ECHO %IP% NO REPLY) ELSE (ECHO %IP% OK) GOTO REPEAT :EOF TITLE SCAN COMPLETED ECHO. ECHO. PRESS ANY TO QUIT PAUSE>NUL :EXIT EXIT ...Show All

• .NET Development How about constructors that are selfaware?

  I ran into a solvable problem that led to the following consideration: why not allow a return null from a constructor There maybe times when the state of a system may not allow the instantiation of an object. I posted the following on the Code Project: http://www.codeproject.com/script/comments/forums.asp msg=1591017&forumid=1650#xx1591017xx What do you think Hi Giancarlo Yes, there are imporant side effects to using partially constructed objects. You cannot assume any member variables have been initialized yet, you cannot assume the security state or culture. Consider the Dispose pattern. Inside your Dispose method, you should be freeing any unmanaged resources. You cannot assume they have been initialized, so you'll ...Show All

• Visual Studio Tools for Office Outlook 2007 Beta error

  Outlook 2007 now cannot be started due to a corrupted MAPI32.DLL file. It suggest that this may have been couse by installing foreigh messageing software. Is the Outlook MAPI32.dll file available for download This would be much easier than the instruction to reinstall Outlook 2007 beta -- I think. Please advise. Thank you. Hi, I am closing this thread due to lack of activity. If this is still an issue, please open a new thread. Regards, Darryn Lavery [MSFT] ...Show All

• SQL Server How do I install SQL Server Management Studio

  From everything I read SQL Server Management Studio is only installed when you install SQL 2005 server. I am using SQL Server 2000 sp3 so I have the Enterprise Manager. Is there a way to install it or some other tool I can use to manage/view my sql everywhere database You could install the SQL Express management Tools and try them. ...Show All

• Visual Studio Team System More about modifying web parts on Team Portal

  Hi, After applying the hot fix to the previous problem I reported, I now found that any web parts I want to add can only be added to the left column of the web page, there is no other choices in the drop down list. Is this a bug too or is there anything I need to do to add web parts to the right column Thanks, Maggie Hi Maggie, Yes, our template only has one column, oddly enough. You can change this by using FrontPage 2003, opening the web site, and adding a new region to it. -Dennis ...Show All

• Visual Studio Express Editions button question

  ok this is proabley simble but i ahve no clue how to do this is vb i ahve 2 buttons and i want one to clear the test in textbox1 and i want the other to copy what is typed i ntextbox1 ne way you wounderful people can help me out To clear Textbox1 place this code in Button1_Click event (created by double clicking on the button in the designer): textbox1.text = vbnullstring To copy text in Textbox1 place this code in Button2_Click event (created by double clicking on the button in the designer): My.Computer.Clipboard.SetText(textbox1.text) Use My.Computer.Clipboard.GetText() to retrieve the text. ...Show All

• Visual Studio 2008 (Pre-release) Virtualized panels and lots of images

  Hi! I have a question related to virtualizing panels and images. I need to present lots of images (hundreds or even thousands) in a thumbnail view - like Max is doing... I solved thumbnail generation problems, but now I hit into other issue. I am using virtualizing panel - lets say for simplicity that I am using ListView with VirtualizingStackPanel.IsVirtualizing="True". I have made my own little class that holds basic info about thumbnails and has BitmapImage property that loads thumbnail on-demand. Here is the issue... Application start and uses about 30MB RAM. If I scroll down through the whole collection of about 2000 thumbnails (usually their size is 150x112 or 112x150), the memory used by the applicatio ...Show All

• .NET Development Problem reading XML Schema?

  Hi, I have the XSD below and the corresponding XML. If I try to read it usind ReadXml with XmlReadMode.ReadSchema it returns no data. However with XmlReadMode.InferSchema it works. What is missing here Thanks ------------- CODE DataSet ds = new DataSet(); ds.ReadXml(@"C:\Documents and Settings\db2admin\My Documents\Visual Studio 2005\Projects\WindowsApplication1\WindowsApplication1\XMLFile1.xml", XmlReadMode.ReadSchema); XSD < xml version="1.0" encoding="utf-8" > <xs:schema id="XMLSchema1" targetNamespace="http://tempuri.org/XMLSchema1.xsd" elementFormDefault="qualified" xmlns="http://tempuri.org/XMLSchema1.xsd" xmlns:mstns="http://tempuri.org ...Show All