nkh121's Q&A profile

• Visual C++ If I use the#import to add type libray,how can I use _application and selection object?

   If I use the following code to add type libray,how can I use  _application,_document,selection object #import "C:\Program Files\Microsoft Office\Office\MSO9.DLL" #import "C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB" #import "C:\Program Files\Microsoft Office\Office\MSWORD9.OLB" \  rename("ExitWindows","_ExitWindows") #import "C:\Program Files\Microsoft Office\Office\EXCEL9.OLB" \  rename("DialogBox","_DialogBox") \  rename("RGB","_RGB") \  exclude("IFont","IPicture")   Thank you very much. Please see http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=179044&Si ...Show All

• SQL Server Report Builder: Is there a way to filter a filter?

  Dear Anyone, We have a report model that connects to a single table. Some of the columns of the table contains blank values which is regarded as a valid value in our reports. We have a requirement that the filter selection should not contain any blank values. They do not want to include a blank value for the users to choose but if the users decide not to use a filter, those blank values should still be included in the report. Does anyone have any suggestions on how to do this in RB We already made this work in RS2k5 but we can't seem to find any way to do this in RB. Thanks, Joseph No, there is no way to control the list of values prese ...Show All

• Visual Basic shared member and inheritance : how to ?

  Hi I have 3 classes : Base, Child1, Child2 Class MustInherit  Base      Shared Stuff As ...      Sub DoStuff          for each x in stuff             ...          next      End Sub End Class Class Child1      Inherits Base End Class Class Child2      Inherits Base End Class For now the Child1 and Child2 instances share the same "stuff" parameter. But i want only the C ...Show All

• SQL Server Can not connect to SQL Server 2005 Developer edition remotely

  I setup a SQL Server 2005 Developer edition, which is bundled with Visual Studio .NET 2005 Professional edition. The SQL Server authentication mode is enabled in this database server. But when I try to connect it from another PC using SQL Server authentication, it failed. Is it a limitation on the developer edition Hi, although you didn’t post the erro rmessage, I assume that remote connectivity is not enabled, change the remote flag which can be see in this screen: http://www.sqlserver2005.de/SharedFiles/Remoteconnection.jpg HTH, jens suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Team System Is TFS included in Whidbey Beta2 DVD?

   I could not see the Team Foundation Server install option when install Whidbey Beta2 on a WinXP machine. Should I install Whidbey Beta2 on Win2003 to install TSF Server, or is it included in another installtion package Thanks!   Yes, TFS is included in the Beta 2 kit that you can order online. ...Show All

• SQL Server Spaces in Column names

  Hi all, Is it a bad practice to create column names with spaces. like [Last Modified On] If yes, y It is certainly not a good practice, but not sure I would elevate it to bad exactly. It is a pain to always have to use the [ ] (or " " with quoted identifiers turned on). If you really want to space out names like this I would use underscores between the name like last_modified_on. ...Show All

• SQL Server permissions for developers not working after 2005 upgrade

  Prior to our move to 2005...permissions were granted to developers by adding them to the following fixed database roles...db_ddladmin, db_datareader, db_datawriter, and db_securityadmin. They created their objects using 'dbo' as the owner. After upgrading to 2005, suddently they are having difficulty accessing their objects with this same security. Do they need permissions on the dbo schema Can you please elaborate on the access difficulty Are you encountering errors and, if yes, what are those errors It would help if you could give us an example of some action that used to work and now doesn't, and of w ...Show All

• Visual C# writeing to file

  Im trying to write a hole *** load of arrays to a file est. 200,000,000 arrays actualy the problem im running to is that i dont know how to write a array to a file and retrive the content if the file. like i have a method that returns a array public int[] genArray() { generate random array return array } so how would i like do something like this public bool writeArray(int[] array) { writearray array to file return true; } any tips on how to write 200,000,000 arrays to a file and retrive them A BinaryFormatter is a good option (found in System.Runtime.Serialization.Formatters.Binary). There is a nice sa ...Show All

• Windows Forms UserControl default design time settings?

  I've created a UserControl for use in my form that has numerous properties. One of the properties is of a custom reference type that I've made. Now, whenever I put this UserControl into a form, it sets a silly value for that reference type property, to the effect of: this.testUserControl1.MyProperty = ((MyPropertyType)(resources.GetObject("testUserControl1.MyProperty"))); Now, the net effect of this is that the designer ends up complaining that it can't convert MyPropertyType to MyPropertyType (no idea why, it's referencing the exact same namespace), and it shouldn't even be trying to pull the default value from the resources anywa ...Show All

• .NET Development Calling the GC.Collect method

  I have a code like this : public void SetFrmLoginNull() { frmLogin = null ; GC.Collect(); } This method is in FrmMain. But when i run a code analyzer from some tools i have, it's said that i shouldn't explicitly call GC.Collect(); b'cos it had side effect. I just need some comment from you all regarding this topic. Any Comment You should not call GC.Collect() yourself, because it has indeed a negative impact on performance. I think you should only call it, if you know that you've allocated a lot of memory that is not used / referenced any more at the time you call gc.collect, ...Show All

• Visual C# Help on Lagging File Seek

  I am running a windows 2000 server, and run a C# program that writes to an excel file. The folder that contains all my finalized excel documents exceeds 5gigs, and when not seeked within the last 5 minutes, lags for up to a minute. So when someone tries to download a recent report, if no one has run a report within the last 5 minutes (guessing lost from cache,) they must wait 1 minute for windows to open that folder. Any ideas on a method possibly run on a timer every 3 minutes to keep that directory listing in cache no luck.. I created a method that searched through all the directories and reported files that contain the letter e in ...Show All

• Visual C++ changing "licensed to" information

  im trying to create a setup and deployment project to create an install for my app it creates the msi/exe files fine BUT: when i run them i get this error: "the folder path 'julius/ryan abella' contains an invalid character this is the licensed to information that can be found in help-> about microsoft visual studio in the top right. how can i change this info to be so that it doesnt complain about the '/' which is what i think is causing the problem ...Show All

• .NET Development Installation of VS and SQL Server 2005

  I am trying to install Visual Studio and SQL Server. I started out by installing the AMD x64 version of SQL Server 2005. It installed a version of the 64-bit CLR (.NET Framework). Then I went to install Visual Stdio. Immediately Visual Stdio complained that there was an incompatible version of the framework and in order to continue I had to uninstall it. So I did. Visual Studio installed just fine (the additional Test Center installations failed but that is another story). When I rebooted SQL services claimed that they could not find entry points. I tried to uninstall SQL server and it couldn't uninstall because it claimed the .NET 2.0 was n ...Show All

• Windows Forms ListView MultiSelect property issue

  Hello, When switching the MultiSelect to true, and then you start selecting a row it de-selects the previous selected row, if I hold the CTL or SHIFT key then it keeps the previous selection. I want to be able to just click on the row and for it to select/deselect depending if already selected. Can you let me know if this can be done, an ...Show All

• SQL Server SSIS error listing

  Is there a list of all the SSIS Error codes and what they mean Ex. -1071607778 is an error code output when a lookup task fails to find a match. I haven't been able to find any information on the different error codes. Is there a description file or enumeration file that exists somewhere I think it's still hex, the L at the end is usually included in literals to denote the size of the integer - i.e. L = long, whatever that may be for the platform, 32bits in this case I'd imagine. -S ...Show All