Kamal Thakur's Q&A profile

• Visual Basic How to open 2000 Excel using VB.net 2003

  I can open 2003 Excel with window XP using VB.net 2003. However after creating a set-up, the excutable can not open 2000 Excel with window 2000. I have add Microsoft Excel 11.0 objext library.  The code is very simple. Should I add a Excel 9.0 library How to define which library to be used   Dim ExcelApp As Microsoft.Office.Interop.Excel.Application 'Excel.Application Dim wrkBook As Microsoft.Office.Interop.Excel.Workbook ExcelApp = CreateObject("excel.application") wrkBook = ExcelApp.Workbooks.Open(Application.StartupPath & "\test.xls", , , , , , , , , , , , , , ) Thank for any suggestion!! ...Show All

• Visual C# Using fields as parameters in a method

  I have a requirement in a project to build a history. No biggie, but there are dozens of bool fields and processing each one is very time consuming. My approach is to add a field name to an arraylist when the property is changed. OnSave() or Dispose() I look into the object and check to see if the field list is empty or not. If not, I process the list looking at each item comparing it to a clone of the original object so that only true changes are written to the child history collection: internal void WriteHistory(){      string changedValue = string.Empty;      originalValue=string.Empty;  &n ...Show All

• Windows Forms Changing checkbox selection from msiexec command line

    Hi All, My setup project has a checkbox dialog where the user can select to install different parts of the application. I set the Checkbox1Property to EXFUNC (default checked) and this works as expected with Condition (EXFUNC=1) on the exportfunction files. Now I need to make a silent installation, but still be able to select parts of the application from a script, I tried this: msiexec /quiet /i myapp.msi EXFUNC=0 This does not work, and in the logfile I found that the property still evaluated to 1 Property(S): CHECKBOXA1 = 1 Property(S): EXFUNC = 1 Whats wrong with this scenario How can I set v ...Show All

• Smart Device Development [Using Visual Studio 2005] Using a Class defined outside any project

  My question is quite simple : I've got two C# projects in a solution. with that i create a C# class outside any project, it's only a log class I want to use my logger into my two projects, how can i do that I try tu put my class in "Solution Items" but i can't use my logger In C++ i could include my class passing it's path but how i do that in a C# project Hi, The recommended way of doing this is to use a classlibrary and hence there is no way to *link* the file. Now you could just copy across the same source file to both projects but you will need to update the source code in both places in case ...Show All

• Windows Forms Datagrid with Arraylist

  Please give me a solution to customise DataGrid in Windows forms. My datasource is a class inherited from ArrayList. I had to format the datagrid column's Header Name and Visibility How to format datagrid with datagridTextStyle class What should be mapping name in the above case The code samples found in MSDn web site is not working... Hope i wil get a solution soon Hi Daniel Thank you very much .... for the help I had confusion with MappingName of DatagridTableStyle.. the problem is solved.. ...Show All

• Visual C# Visual Studio 2005 Beta 2 - Partial classes and files

  I like how the designer portion of a control class is in a different file as a subnode of the original. Is there a way to make partial class (that are not controls) files be subnodes of the 'original' class file For example, if I have MyController.cs MyController.AAA.cs MyController.BBB.cs MyController.CCC.cs all of which contain the partial class MyController. I would like AAA, BBB, and CCC to show up as subnodes of MyController.cs in the solution explorer, similar to .designer.cs. files. Is there a way to set up these dependancies from the IDE I couldn't find a way, other than manually editing the .csproj file. Thanks,  &nbs ...Show All

• Windows Forms Custom Button on PropertyGrid

  I'd like to have an additional button on the PropertyGrid and remove the PropertyPages button. I know that you can add a PropertyTab to it, but that seems to anticipate that a completely different set of properties will be displayed when the user clicks on this. I just want to have a button appear there, and to be notified when this button is clicked. But how just so the people that search on this topic see this, you can use the same method of iterating through the controls in the PropertyGrid to get an referance to the Property Pages button. It's Index 4 in the ToolStrip.Items collection after that y ...Show All

• Visual C# Speech Recognition

  Ok. I have a little code for Voice Recognition. But I cant get it to work. When I say a certain word or phrase, the character is supposed to respond. can someone help please. protected void button2_Click(object sender, System.EventArgs e) { if(textBox1.Text.Length == 0)  return;  Character.Speak(textBox1.Text, null); } protected void button1_Click(object sender, System.EventArgs e) { OpenFileDialog openFileDialog = new OpenFileDialog(); openFileDialog.AddExtension = true; openFileDialog.Filter = "Microsoft Agent Characters (*.acs)|*.acs"; openFileDialog.FilterIndex = 1 ; openFileDialog.RestoreDirectory = true ; if(openFileDialog ...Show All

• Windows Forms IEExec Loads, but no form appears...

  I'm playing with deploying my application via smart client.  I believe I have everything setup properly.  I gave .NET Framework Full Trust to the URL that calls the .exe, and it now seems to load my program, but I cannot see the form.  Every visit to the page loads a new IEExec, but nothing appears.  When I go to shutdown, windows&n ...Show All

• Visual Basic Program Won't Create New Directory

  I can't figure out why my program won't create new directories. My code looks like this: Public Sub CreateDirectory( ByVal directory As String ) My .Computer.FileSystem.CreateDirectory( "C:\Documents and Settings\Owner\My Documents\movdb" ) My .Computer.FileSystem.CreateDirectory( "C:\Documents and Settings\Owner\My Documents\movrat" ) End Sub I'm trying to have the program create the 2 directories "movdb" and "movrat" when it first starts, but it doesn't create them. I was wondering if anyone knows what could be wrong Thanks   1 - you're not calling this method ...Show All

• SQL Server 2 disturbing questions after SQL Express setup is completed.

  I got 2 questions to ask: 1. I choose Windows and SQL authentication during setup. Will this have any impact on my connection string in Dot net 2. If I want to host my db on my computer, what other protocols do I need to enable Currently I got shared memory on. 1. You'll want to set your connections to "trusted=yes". 2. Shared memory is fine for local use only, I recommend TCP/IP for remote connections. ...Show All

• Visual Studio Auto-layout collapses classes

  Class Designer has a nice automatic layout feature, but it always collapses all classes before doing its thing. Is there some way to auto-layout expanded classes (i.e. so that they stay expanded) Class Designer will auto-collapse only shapes which don't have lines connected to them. If you want to exclude those shapes from layout, just select the shapes you want to layout, right-click any shape within selection and choose "Layout Diagram" - this will only layout shapes which are selected and won't affect the other ones. HTH Regards Dmitriy ...Show All

• Visual Studio Team System Bug: DropDown FieldControl (Team Explorer client)

  The first time I click on a DropDown control in Team Explorer client (Beta 3 Refresh) it doesn't keep itself opened. I need to click again to show the available options. Regards, Max Andrade I'm sorry but I thnk you're going to have to wait for this one.  The cost for us to go back and release a patch is pretty high.  We are planning to have a Release Candidate out within a couple of months and it will be fixed in that release.  We'll be supporting data upgrades to the release candidate so I think that's your best bet for getting this fix. Brian ...Show All

• .NET Development FTP to IP address

  I need to send a text file on the local machine to a unix server. I know the IP address, username & password to connect. I have tried using the following line of code: My .Computer.Network.UploadFile( "c:\test.txt" , "10.2.2.10" , "username" , "password" ) This gives me the following error: '10.2.2.10' is not a valid remote file address. A valid address should include a protocol, a path and a file name. Parameter name: address Do I have to specify the destination path on the remote server If so how do I specify that with an IP address Maybe like this ... 10.2.2.10/foldername/su ...Show All

• Visual C# vs 2005 not responding

  I am using VS.Net2005. Whenever I open a project, the VS gets stuck. If I end the vshost process, the VS continues to respond (but I cannot debug the app). The same happens when I create a new project, so it is not a project specific issue. Does anyone know how to solve the problem thanks. Hi, Can you give more information on the issue you are seeing Like, -What language projects are you trying to open or create - What VS SKU (like express or Visual Studio Team System, Pro etc) and what OS are you using - What do you mean by VS getting stuck Does it become unresponsive or hangs If yes, can yo ...Show All