Antonio Neeves's Q&A profile

• Microsoft ISV Community Center Forums Code Snippet Manager for VBA

  I am, for the moment, still writing my VBA code in Excel (and possibly soon word). I find that I use some code repeatedly. Is there any free code snippet manager for the VBA IDE I'd like to recommend mz-tools for vba editor. It support a lot of features including user's code template. plz refer to http://www.mztools.com/index.htm best regards, sjoo ...Show All

• Visual Studio Team System Load test performance after IE 7 Beta 3 install

  I'm noticing that load tests for web-services are noticeably slower when IE 7 Beta 3 is installed. Before I installed IE 7 B3 I was noticing an average response time in my test of about 5 seconds, with multiple tests. After I installed IE 7 B3 the average response time more than doubled to 11 seconds with multiple tests. After un-installing IE 7 B3 the response time seems to have returned to about 5 seconds. This is by no means scientific; but certainly not ignorable. Has this already been observed Right, I wouldn't think IE7 beta 3 would affect anything on the client or the server, but it appears that the "default" proxy setting is the problem. Try blanking that property out since "default" will cause ho ...Show All

• SQL Server Can I get a Query from a Fetch_cursor in SQL2000

  Hi, The main application we used uses prepared cursors when running statments against the database. This makes it very hard to debug the querys as if you get an error or lock on the database all you can see is the Fetch_curror statement and the number of the statment. If you know the lock is coming that's fine as you can run up the profiler but if you don't know it will happen then the profiler doesn't help as the cursor has already been prepared. Is there a way of using the cursor number to query the SQL engine and find out what statment was prepared If your app is doing server side cursors and names them then you may be able to use sp_cursorlist, sp_describe_cursor_tables and sp_describe_cursor_c ...Show All

• Visual Basic Hotkey

  Hello all, I have made an application and I want my user(s) to access it using a hotkey. How exactly do I go about doing this Do I do this during program installation and have some sorta script install the hotkey into window. or can I include some code into my application Thanks! I think a better question is: is this possible to do without a window listener application waiting for the WH_HOTKEY message thanks again ...Show All

• Visual C# Need a copy of an Object from a Object Hierarchy, but references to the Object Hierarchy remain when I copy

  Hi all, I have a Object Hierarchy of Question Objects that have the following structure... QuestionForm ->Group (Contains a Collection of Questions) ->Question1 ->Question2 ->Question3 ->Group (Contains a Collection of Questions) ->Question1 ->Question2 ->Question3 ->ActionQuestion ->ActionQuestion All these Question Objects are of the same type, but have a property on them that states whether the Object is of type QuestionForm, Group, Question, or ActionQuestion. When my application loads, it builds up this Question Object Hierarchy. So what I want to do is to get a copy of the ActionQuestion Object from this Hierarchy, save data to its Properties and do other processing, (the ActionQuestions ...Show All

• Visual Studio Team System Problem with running Continuous Integration

  I am going to be running CI, and I forsee some problems that are going to arise. I am going to be having approximately 26 team build projects that are going to be running on CI. If each of those are run say 3 times a day - that will leave me with almost 80 entries in the "integration build", "found in build", "resolved in build" fields. I would like to have these builds ignored, as I have a main build which will "sweep up" all of the work items and change sets. What is the best way to do this fyi, I tried to rename my build to CI but you can't overwrite one with the same name once it has built... Hi Johnny, I just finished a blog post that provides a simple filt ...Show All

• .NET Development Broadcast sample using UDPClient

  Hi, I just came across the UDPClient as I need my program to broadcast messages among all connected workstations on the local network. Based on Help I created the following class and its working fine on my computer but I don't have a network to test it on. For those interested in my class, could you please test it on your LAN and let me know if it works. I would also appreciate if you have any comments to improve it. I'm posting the BroadcastMSG class and also a test application. For the test application just create a new windows form application and add 3 buttons and 1 list box. Then copy the form1 class below to it. Also add the BroadcastMSG class to it. Button1: Will start the listener on port 1030 Button2: Will send a test ...Show All

• Visual Basic Generating text around an arc in an image file

  I am new to this, so please, if I am in the wrong place, tell me the proper place for this question. I am trying to generate a graphic programmatically with dynamic text. The graphic should display text written around a circle, as if on an arc, and the text itself should be angled so that if you underlined each letter, the underline is perpendicular to the center of the circle. I had code that did this in VB6, using a LOGFONT and it works really well. However, the VB6 code printed directly to a printer. I am upgrading the code to VB.NET 2005, and because of outside constraints, I need to output directly to an image file which will be printed later. I had problems using LOGFONT, namely that it did not "tilt" any of the ch ...Show All

• Visual Studio 2008 (Pre-release) Resize Notification Missing ?- Repost

  This is a repost of something I apparently did not explain well enough. Given a Grid with 2 columns and a Splitter in between, if I bind a TextBox to the 2 ColumnDefinitions Width properties, then as you move the Splitter, the text boxes update correctly to reflect the change. But if I resize the Window containing the Grid, the TextBoxes do not update. The Grid columns DO UPDATE their physical size but I get no notification of this when the Window size changes. Since the 2 Grid columns are my 2 client areas of interest I feel that I should get this notification. There are workarounds of course but they include adding more elements and per MS performance guidlines - keep your element count as low as possible. Our app can contain ma ...Show All

• Visual C# Can not edit cell in DataTable

  I have a DataTable with two columns...I can edit my name column but my cost column will not let me put in my own values...is there something i am doing wrong when adding the 2nd column public void MakeOrderTotalTable() { System.Data.DataColumn _column1 = new System.Data.DataColumn("Name", typeof ( string ),_name); System.Data.DataColumn _column2 = new System.Data.DataColumn("Cost", typeof ( decimal ),_cost.ToString()); System.Data.DataRow CostRow = OrderTotalTable.NewRow(); OrderTotalTable.Columns.Add(_column1); OrderTotalTable.Columns.Add(_column2); OrderTotalTable.Rows.Add(CostRow); this ._dsRatesOnOrder.Tables.Add(OrderTotalTable); this .dgOrderRates.DataSource = this ._dsRatesOn ...Show All

• Architecture architecture guidance.

  hi everyone, iam planning to do a project and iam in analysis phase of the project. desc: it is a very simple project. lang: asp.net ,C#,oracle9i. i completed all the ui related parts.the project is very simple get the datas from the database,update those data or insert new data.uploading and downloading of files.excel uploads and downloads.user administration. now iam going to design the business logic and data access logic. i need to implement form based authentication. can any one provide me guidance for desiging the data access logic ,security logic thanks for your valuable information baskark wrote: i need to create a common package that supports oracle,ms sql, ms access and it shou ...Show All

• SQL Server Data Viewer does not show any data

  Hi all, I have a recurrent problem with Data Viewers, it happens quite often that the Data Viewer does not shows any data altought I can see that some rows have passed through as there is a "XX Rows" on the data path where the Data Viewer has been added. Sometimes it shows up sometimes not, I can't figure out why. Any idea Well, apparently not, I've just been executing the same package without any change on the data flow and what shows up is that when I have more than one Data Viewer, the first one shows the data but not the second one, and when I delete the first data viewer the second one shows the data. Very strange. ...Show All

• Visual Studio Class diagram

  how can i have class diagram for my project in VS 2003. Is there any feature for that.. There's a product from Visual Paradigm that claims VS2003 integration. This is not a recommendation, and I have nothing todo with Visual Paradigm. Rather than investing money and time in a 3rd party product why dont you migrate to VS2005 and get the integrated diagrammer therein. ...Show All

• SQL Server Support for SQL DTS packages post upgrade to SQL 2005

  Hi, I am unclear on Microsofts policy regarding support for DTS and packages that have been imported (but not migrated) to SQL 2005. The upgrade advisor states SQL Server 2000 Data Transformation Services     Advisory     SQL Server 2000 Data Transformation Services is deprecated   You must completely migrate existing SQL Server 2000 Data Transformation Services (DTS) packages to SQL Server 2005 Integration Services packages before support is withdrawn.     Source Type: MSDB Package   What does this really mean   What will happen to the importing of legacy packages and this whole area within Management Studio Will these 2005 features no longer be ...Show All

• SQL Server Transfering data from one database to another in Visual Studio 2005

  How could I transfer database data from from one databast to another in SQL Server 2005 because I had 4 databases in my application and I want to merge all database data into one database. Thanks in advance. Review information from SQL Server 2005 Books online and also from http://aspalliance.com/947_Building_a_SQL_Server_2005_Integration_Services_Package_Using_Visual_Studio_2005 here. renz2k7 wrote: How could I access the SSIS package through Visual Studio 2005 if possible Thanks. If this is one-off requirement then you might think about import the tables into one database and then merge the requirement information using TSQL queries on the destination database. ...Show All