Anthony Wong 6's Q&A profile

• Visual Studio Problems with .net 2.0 beta 2

  I tried installing visual basic 2005, the installer download all the files and ran through the install then after that had all red crosses next to everything and said that .net framework 2.0 beta 2 had failed resulting in everything else failing, I have read other posts on this and tried installing after downloading from microsoft manually and recieved this error: Error 1719 Windows Installer Service cannot be accessed, this can occur in safe mo ...Show All

• SQL Server extracting the specified record no of records from database table

  hi all, I need to select the no of records on the basis of specified range of records. In oracle i found rownum, i could not find it in sqlserver. how the data are extracted from the huge records.. I have used temporary table,map the table primary key to the next table with identity but i dont find it good. I need to ignore the insert the data in next table or craeting new table having the rowid ... Is there some other best wa ...Show All

• Visual Studio Team System Exception has been thrown by the target of an invocation

  Hey, i got this error after creating two sql data sources to the same connection and the same datatable. What is going on Can you not have two object connected to the same thing You should post this question in the .NET Data access forum: http://forums.microsoft.com/msdn/ShowForum.aspx ForumID=45   The exception that's been discussed on this thread (and that you've encountered) is a general runtime exception that indicates a problem ...Show All

• .NET Development Windows App Not working over Network

  I've got a windows app that connects to a DB and copies a few files from a network share to the local PC. The app is ran on the network share because everybody in our company uses it and when modifications are made, we don't want to have to redistribute 50 or so copies of the .exe. Every time I run the program from the network, I get a standard Windows error and Microsoft wants me to send them the information, it doesn't get too involved oth ...Show All

• SQL Server Cannot create a connection to data source !!!! SSRS 2005

  I cannot get this error resolve either for myself or any users, and I'm actually part of the Admin group! Furthermore, a user with whom I'm tring allow to view this report keeps getting prompted for their windows username and password. I thought that since this datasource was set to Windows Authentification that it would just pass it through I'm pulling my hair out at this point: Screen Shots: http://www.webfo ...Show All

• .NET Development Web controls

  I am currently using IE WebControls Version 1.0  on the windows XP professional machine and it works fine but if i install it on windows 2003 it dont work(i see contents of two tabs one below other). I using it for the Tabstrip control ONLY. Any known issues   do i have to install something else I checked the microsoft website for help on the above webcontrol it says "Microsoft Internet Explorer WebControls are not currently sup ...Show All

• SQL Server Stored Procedure

  Hi, im doing a stored procedure, it's for changing the data type of several columns, specifically the number of decimals, so i want to pass this as a parameter, but i cant use this in the alter column command, example, im doing this create procedure XYZ @decimals int as alter table XYZ alter column XYZ decimal(18, @decimals) go any idea how to make this work you have to use dynamic SQl create procedure XYZ ...Show All

• SQL Server Lookup - full caching vs partial caching vs no caching

  I needed to do lookup on tables with approx 1 million records (how else do I know if record already exists ). Full caching: SSIS caches all million records (consuming around 1 GB RAM) and cripples my lowly system with only 1GB physical RAM. This works for now, but the lookup tables will keep on growing. This means that full pre-caching may not scale for this scenario. Partial caching and No caching: I don't really know h ...Show All

• SQL Server retrieves the information about the pipeline components

  Dear Experts, I can look the values of the proprieties in each PipelineComponentInfo, for example: ComponentType: Transform CreationName: DTSTransform.Merge.1 Description: Merge Transformation FileName: C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents\TxMerge.dll FileNameVersionString: 2000.90.1049.0 IconFile: C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents\TxMerge.dll IconResource: -201 ID: {08AE886A-4124-49 ...Show All

• Visual Studio Tools for Office Upgrade record

  How can i upgrade record from excel to db table (msaccess), when i use vsto dataset merged into excel spreadsheet Have you a sample please Thank you Carlo Cantoni Hi Carlo, Yes, you should be able to use the same code within a Microsoft Word VSTO project to update the underlying data source. You would obviously need to change the code slightly such as: Globals.ThisDocument.CustomersTableAdapter.Update(G ...Show All

• Visual Studio Express Editions How can open file in my project by double click on it ?

  Hello, How can I open *.txt or *.doc fles in my project by double click on it like notepad or Wordpad please try to explain the idea, this will be helpfull in alot of projects in the future Thanks. Hi, here is the code that will open an file with its default associated program: Process.Start( "c:\\CommunicatorMobile_PlanningDeploymentGuide.doc" ) hope thats what you were asking for. ...Show All

• .NET Development Is .net framework 2.0 redistribuable freely redistribuable with commercial product

  Hi, I know .net framework redistribuable is free, but is it also free when shipped with a commercial product JRE is free, but fees (1 $ per product) are to be paid in case of providing in with a commercial product, so it could be the same for .net framework I've been googling a while about this, but could not find a Microsoft official information about this. Could you give me a link about this Thanks a lot! Thibaud ...Show All

• Visual Studio Tools for Office Hide Table & Word 2003...

  Hello, how do I hide a table in Word 2003 document programtically Thanks, Dmitry ...Show All

• Windows Forms datareader

  hello is there is a method to count the number of rows in the datareader thank you for the time  You know, with limited experence with ADO.Net you might be better off just using a data adapter instead of a datareader. Basicly to&nb ...Show All

• Visual Basic Problem with Exitprocess

  I have a batch VB 6 program and to send return code in Dos consol, i use the command ExitProcess. when i excute in DOS prompt, batch program stay in memory. If i delete it in my program, it finish without problem. I don't understand why Hi, Can you not use the keyword END in your program instead Regards, S_DS ...Show All