ika's Q&A profile

• Visual Studio Team System VSSConverter for TFS Beta3

  Hi, I am trying to convert a VSS database to TFS Beta3 using VSSConverter but I'm stuck on the settings.xml file. Can anyone give me an example settings xml file that will work with TFS Beta 3 I have tried several things as suggested here http://blogs.msdn.com/akashmaheshwari/articles/386062.aspx  but I can't get the format right!! Regards Graham For deleting team project issues, see post http://forums.microsoft.com/msdn/ShowPost.aspx PostID=3978 . This might help you (see 3rd page). For using same team project name for converters, do not delete the team project. Instead move the files and folders under ...Show All

• Architecture a Common Form that hosts data/connections for other forms

  Hello, We are former Delphi developpers and are having a 'problem' to setup a kind of a datamodule. This could be an insible form that has a connection to a accouting system over dcom. Now we would like to call the procedures on that form from several other forms. We don't want to create a connection on each form (app is mdi). How could we do this, and mostly, how would we reference that 'common' form. Kids Regards Hi! Maybe "Component" could work as a DataModule for you... But I really recomend you to read: MicrosoftR .NET Distributed Applications: Integrating XML Web Services and .NE ...Show All

• Smart Device Development SQL Server 2000 Connection issue

  Hi, I have been trying to connect to an SQL Server 2000 table from my PDA over a Bluetooth network for the past few months but with no success! I am using the following string ( "Persist Security Info=False;Integrated Security=False;Server=169.254.2.185,1433;Initial Catalog=Products;User ID=Administrator;Password=admin;" ) , which as far as anyone has told me and as far as I can see should be working! The error I am getting is a timeout, which says the server does not exist (which it does) or I am not authorised to access it (I am trying to access it using Admin privilages)! I think perhaps that it might be to do with t ...Show All

• Windows Forms Designer Error when setting BindingSource.Datasource = SomeOtherBindingSource

  Hello Everybody! I get this designer error One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may require code changes. The designer loader did not provide a root component but has not indicated why. Hide      at System.ComponentModel.Design.DesignSurface.get_View() at Microsoft.VisualStudio.Shell.Design.WindowPaneProviderService.CreateWindowPane(DesignSurface surface) at Microsoft.VisualStudio.Design.Serialization.CodeDom.DeferrableWindowPaneProviderServic ...Show All

• SQL Server All tables and columns referenced by sql objects

  I'm trying to find all the tables and columns referenced by the sql objects (stored procs, UDFs, views, etc.) in a particular MSSQL2005 database. I can join the sys.objects, sys.sql_dependencies and sys.columns tables using object_id, referenced_major_id, referenced_minor_id, and column_id but I find that the more complex procs contain references to tables (sub selects, for example) that do not seem to appear in sys.sql_dependencies. I can always do string searches on the definition column in sys.sql_modules, but that won't reliably get me column+table combos. Anyone have any ideas Thanks! I actually wrote a blog on this ex ...Show All

• Microsoft ISV Community Center Forums Problem with VBA script

  Dear all, Can you please help me with the following problem I wrote a script to get the data out from the SQL Server and then format the cells. However, it seems it doesn't run the part B to format the cells. Any idea Thanks. 'Part A : Get the data from the SQL Server sqlstring ="select custid, custname from customer" connstring = "ODBC;UID=uid;PWD=p123;DATABASE=prod;DSN=HK0001" With ActiveSheet.QueryTables.Add(Connection:=connstring, Destination:=Range("B1"), Sql:=sqlstring) .Refresh End With 'Part B: Format the cells i = 1 Do While ActiveSheet.Cells(1 + i, 2) <> "" vals ...Show All

• Visual C# Strange prolem with Culture settings

  Hi, We are writing the .net application that should always work in en-US culture, regardless of the control panel settings. I was able to force the GUI culture to be en-US by the following code Thread.CurrentThread.CurrentUICulture = new CultureInfo("en-CA", true); Thread.CurrentThread.CurrentCulture = new CultureInfo("en-CA", true); After that the DateTimePicker components are always displayed in en-US culture, which is good. But the PROBLEM is that if I retrieve the the DateTimePicker value in the code, it comes in Control Panel settings again. To retrieve the value i use the following: pickerDate.Va ...Show All

• SQL Server Synchronization

  Hello, I'm having to build a smart client application that works with an offline sql express database on the client. And works with several types of databases - that may be configured to work as a central server. The list includes the sql server family including 2000, 2005 and express and also IBM DB2. I have to address some rather complex merge replication scenarios. By Merge I mean the ability to deal with handling and synchronization of bi-directional changes. More specifically changes to data may be made to any database in the system. either local or central. I'm afraid, I cannot use sql replication in a heterogenous mode for se ...Show All

• .NET Development ServicedComponent + generics

  Something I discovered AFTER I changed a huge amount of code: (Kind of my fault as the documentation states this limitation) Originally I had x number of components of a server COM+ application like this: public class Comp1 : ServicedComponent {   MyClass1 class; ..   // several methods working with class } public class Comp2 : ServicedComponent {   MyClass2 class; ..   // several methods working with class } ... As all of the methods are similar and only some of them are really custom to the serviced component itself, I wanted to use generics like this: public abstract class BaseComp<T> ...Show All

• Visual Studio Team System versioning of documents in team explorer

  HI does any one can tell me how to maintain versioning of documents in doument folder of the Team explorer Sharepoint has a document version control system. I believe that in TFS its is turned off by default, but you can turn it on easily. The version control does not allow for compares, but TFS doesn't have that capabilit for doc files anyway. Open up the TFS Sharepoint site. Go to a document library -> Modify Settings and columns -> Change General Settings and under there you should find a setting for Document Versions. As FYI, this is is not TFS's source control, this is Sharepoint's source control and its not as ...Show All

• Visual Basic Windows Media Player

  Where can I find a tutorial/information on using Windows Media Player in VB 2005 My particular question is with the URL - How do I code a "navigate" to an internet address and how do I "navigate" to an mp3 file that I want to include with the compiled application I can easily do this in VB6 but am lost with 2005. Thanks U can try with process.start(" http://www.msdn.com ") or process.start( http://www.xxxx.com/music1.mp3 ) ...Show All

• Windows Forms DataGrid in TabControl

  Hi, I have a tabControl (in a windows form) contains two tab pages. In the first tab page, there is a data grid. When I click and switch to the second tab page, I also want to see the same datagrid showing on this tab. How to do that  (I don't want to create datagrids for each individual tab page. What I want is a data gr ...Show All

• Windows Forms Suspending Paint Event

  In the paint event of a control I'm using at work, we end up drawing some rectangles with GDI+ calls. Unfortunately, each time the rectangle gets drawn the paint event ends up firing again, thus it get's repainted 20 times.  Is there a way to temporarily suppress paint events I guess you should try using the ControlStyles enumeration, and ...Show All

• Software Development for Windows Vista WinFX RTC December 2005 Not working with December Vista SDK

  There's a problem with the WinFx RTC download for December 2005.   The links on the page http://www.microsoft.com/downloads/details.aspx familyid=BD3BA2D5-6ADB-4FB2-A3AA-E16A9EA5603F&displaylang=en There's a link to download the entire WinFx RTC package instead of the "smart" installer. http://download.microsoft.com/download/9/4/9/949EEA41-364A-45DC-8F4E-47E7AC147D25/winfxrc.exe I checked the time/date stamp in the downloaded files from the WinFX RTC and the Dll's are all from 11/18/05. this is for the WinFX RTC that is linked on the downloads page indicating it was December 2005 WinFX RTC.   This happens wi ...Show All

• Visual Studio SqlConnection.Open - debugging problem

  Hi,    I'm trying to move my projects to .Net 2.0 with VS 2005.    I've got a problem trying to debug SQL related methods. At runtime sqlConnection.Open works fine (!) while under debugger it throws exception " The connection was not closed. The connection's current state is open ". What I do is:    1) create new SqlConnection object    2) assign connection string    3) assign the object to Connection property of newly created and set SqlCommand    4) call SqlConnection.Open.    Before step 4 I checked connection state ...Show All