jbanks27's Q&A profile

• SQL Server Synchronizing sql 2000 and sql 2005

  Im working on a project. This program will run off of a sql 2005 database. The company that we are selling this too uses sql 2000. They will end up using both. They will enter their data as usual, into the sql 2000, and then I need to get that data from 2000 to the 2005 database, anytime a transaction occurs, I need that transaction to also occur in the 2005 database. The 2000 DB has 4 tables. These 4 tables are split up into different ones in 2005, so I will need to map it just right. (This may sound dumb, but it is what they want so what are ya gonna do ) My question, is there an easy way for sql 2000 to communicate with 2005. I planned on ...Show All

• Visual Studio Team System VSTS and Excel integration

  VSTS agile process has a few Excel documents, which display the results of queries on Work Items. The Excel documents use VSTO code behind, which accesses Team Foundation Server using VSTS client API. In order to do the query, the URL indenfiying the Team Foundation Server has to be known. How does the VSTO code acquire the URL Is this configured some where Thanks, Yuhang.  Hi Yuhang, The spreadsheets are bound to queries as part of the process template specification. When you run the New Team Project wizard to create a new team project, any documents bound to queries are updated with the team ...Show All

• Visual Studio Team System Team Architect/Team Developer/Team Test oh my!

  In a small company I often wear serveral hats. I was wondering what I should install if I want it "all" In other words I want to install something that I can sign in as an architect for a while and later a developer and later a tester. The installations all seem separate right now. If I install the Architect version of Visual Studio will I also have the functionality of a developer and tester on the same machine Thank you. Kevin If you install Developer, or Test on top of Architect, then yes, they will share the functionaliy. However, if you want all of the functionality in one package, pick up Team Suite. T ...Show All

• Visual Studio Express Editions Error in running built programs on other drives

  Hi everyone, I am using Visual basic .NET 2005 express beta. I can build a project and then run the exe file in the same location as the installed VB but if I copy it to other drives in a server then I cannot run it there. Does anyone have ideas to fix this Cheers   LucaMauri wrote: Please try run '.NET Wizards' from 'Administrative Tool' group and run 'Trust and Assemply': a wizard will popup, you have just to complete it (I used it a few motnh ago, but I remember it was very easy) and I guess your software will then work. I believe I have the same problem. I can run my program local ...Show All

• Windows Forms DataGrid BUG for ColumnChanging event on boolean column?

  When I threw an exception for validation of of a boolean column and used 'TAB' to navigate from the column after I changed the value to throw the exception, microsoft form.dll throw an exception and the applicatoin closes down. Can anyone help me regarding this To understand the problem more clearly I used 'Products' table of the Northwind databse. I made a simple form that shows all the column of the table. There is a 'bit' field in the table called 'Disontinued'. I wrote the following code to incorporate some 'business logic' in the ColumnChanging event for the table. --------------------------- if (e.Column.ColumnName == "Discontinued" & ...Show All

• Visual C++ constructors help

  Alright, i'm working on a new application, in wich i need my own TreeNode Variants, with his own information. I made a new struct called InfoStruct in wich i hold my own Information. Next, i create this new class, VCNode wich is a inferred class from TreeNode. public value class InfoStruct { //TODO: Put all the nessesary info here. String^ Name; }; public ref class VCNode : public TreeNode { public : VCNode( String^ name, InfoStruct^ _InfoStruct, int _imageIndex, int _selectedImageIndex) : TreeNode( name, _imageIndex, _selectedImageIndex ); //Constructor private : InfoStruct^ Info; }; with this pease of ...Show All

• Visual Studio Team System Manage team projects for some separate groups

  Hi, We have some developers teams that want to connect to our Team Foundation (TFS) Server. We installed the TFS on 2 separate servers - application tier and database tier. My questions are: 1. How can I manage this configuration 2. Can I backup/restore only one team project at a time 3. Is it good enough to manage users and permission by adding groups to team project or there is something else - I want to make sure that every team see only it own team projects. 4. Has anybody have this configuration in his organization Best Regards, Irit 1. The Team Foundation Administrators Guid ...Show All

• Visual C# Can C# do the same things as Visual Basic

  Hello! I'm somewhat confused if C# can do the same things that VB can do Everytime i see a reference about C#, it always is in conjuction with the .NET framework, which leads me to think that C# can only be used on web What's driving me here is that i need to write some kind of utility to monitor a dedicated MSOutlook mailbox for incoming Adobe forms and when a new one comes in, i need to read the Adobe XML and upload it to an Oracle DB! And being mainly a Java, C++ programmer, i can definitely relate to C# alot more than VB, so if C# can be run on an individual PC like a VB program, that would music to my ears! Appreciate any clarifi ...Show All

• Visual Studio Team System GUI Change requires checkout of licenses.licx

  We are using a couple of 3rd party components that have information stored in the licenses.licx file. We have noticed that anytime you edit a GUI that has one of these 3rd party components, the IDE requires us to check out the licenses.licx file. The problem is that there is one licenses.licx file per project.  If I want to edit GUI-A, I have to check GUI-A and the licenses.licx file out.  If another develper wants to work on GUI-B in the same project they are unable to do so, because the IDE requires them to check out the licenses.licx file -- which I have previously checked out for my changes. Is this a problem with VS2005/Team o ...Show All

• Visual Studio 2008 (Pre-release) Font Issues February CTP

  I am seeing a number of issues with fonts in the February CTP. I cannot set certain font families. For example, I set Microsoft Sans Serif as the FontFamily of a MenuItem but the displayed FontFamily is Tahoma. FontSize is also always 11 no matter what I set. I cannot set the FontWeight and FontStyle properties. For example, in the aforementioned MenuItem the displayed font is always bold. When I set certain font families the display is corrupted. For example, Wingdings on GridViewColumnHeaders. Often the set column header text is absent. Other times painting of the column header is corrupted. Barry, Th ...Show All

• Smart Device Development Extremly Slow Performance in VS2005 B2!!

  I have two different systems that I installed VS2005 Beta 2 on. The main development machine is a P4 with a gig of ram, and plenty of disk space. The OS is XP Pro (SP2). I am trying to develop an app using Pocket PC 2003 (for right now), but the design process takes so long its almost not even worth trying! I place a grid control on the form, add a query, and then have it generate the data forms (Summary View & Edit Detail) and it takes almost 10 minutes to generate the screens. When I go to run the application in debug mode it takes almost 5 minutes to render the device emulator and deploy the app to the device emulator. I read ...Show All

• Visual Basic Generics and overriding

  I'm having trouble when overriding methods that contain parameters with generic types that are inherited from the base type.  Here is an example: Public Class BaseClass( Of T)     Public Class ItemData        Protected mValue As T        Public ReadOnly Property Value() As T           Get              Return mValue           End Get        End ...Show All

• .NET Development How to use wse2.0 + vs.net2005 beta2(C#) ?

  I create a webservice using wse2.0 and vs.net2003(C#) secussefully. But when I create that by using wse2.0 and vs.net2005 beta2(c#), I can't find the "reference.cs" file in the folder "Web References"  which appear in vs.net 2003. Who can help me to find the differences between vs.net 2005 beta2 and vs.net2003 at using wse2.0 ======================================================== The codes are as follow:  string Username = "kent";   string Password = "@#$$%999";   localhost.Service myservice1 = new localhost.Service();     UsernameToken token = new UsernameToken(Username, Passw ...Show All

• Microsoft ISV Community Center Forums Lack of mouse scroll wheel support in VBA

  Folks The mouse scroll wheel does not work in VBA.   This has always puzzled me as to why this support does not exist since Office 2000. This problem was originally caused by a MS Mouse driver change that I'm told was communicated long in advance to other MS folks. This problem has existed for several versions of Office.  As far as I'm concerned this should've been fixed in the Office SPs. And yes, I'm quite aware of the workarounds VBScroll and Freewheel. Tony GK you're the bomb. I was going crazy last night after I did a re-install. I can't code with no mouse wheel! THANKS. ...Show All

• Windows Forms Taking Data and Posting Data to Excel

  Dear All, I have to start to migrating my project from VB to VB.Net or C#.Net. For this I need to collect informatin regarding Taking Data from Excel Sheet and Porting Data to an Excel Sheet. I need techniques for Porting data to Excel Sheet from a DataGrid. The 3 methods that I have recognised are as follows: (1) Running the Whole Page again and displaying the data in Excel (2) Taking the Data from the Recordset and porting it to the Excel (3) Without going to the server, I take the data directly from the DataGrid and port it to the Excel. (This is the main point of concern as Not going to the Server again would be the bes ...Show All