Caioshin's Q&A profile

• Visual Basic PrintForm does not Install via ClickOnce Deployment

  PrintForm works on my development workstation in both IDE & the application EXE installed from ClickOnce site. However, on 2 client PCs, both running Windows XP, the EXE fails with "Could not load file or assembly 'Microsoft.VisualBasic.PowerPacks.Printing.PrintForm, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified." During ClickOnce install: No errors. In fact, I can find no install log in C:\WINDOWS\Temp\Temporary Internet Files afterwards. No signing. No elevated permissions. gacutil finds Microsoft.VisualBasic.PowerPacks.Printing.PrintForm on my development workstation, but does not find it on a client PC. the e ...Show All

• .NET Development Reading an Excel file from a WinForm application

  I need some help reading an Excel file from .NET application. I have an Excel file that has data starting from the 3rd row. The first row has some info about the file, second row has the column names and the 3rd row has data. @"Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strExcelFilePath + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1;\""; The application is reading the values and column names correctly when I delete the first row so that the new first row contains the column names and data from second row onwards. Is there a way to specify that the header row is the second row and data starts from the third row Or is there a better way to handle this I don't want the user to delete the first row for this to w ...Show All

• SQL Server Can a non-admin user generate a create database script?

  I am trying to generate the create database script using SMO. The issue is the user account which connects to SQL server is not SA, SMO fails to generate the "Create Database" script with error User ZZZ\User1 does not have permission to run DBCC SHOWFILESTATS. Is it possible to generate a "Create database" script using SMO when you are connecting to the SQL server using NON-ADMIN account The user login is a part of db_Datareader role on the database. I tried following grant permission to the concerned account at server level Grant view any database, grant view any definition and grant view server state. Still it fails. Any idea Allen, I would respectfully disagree with you. ...Show All

• Visual Studio Tools for Office VSTO 2005 SE Deployment Problem

  Hi, I am creating a Excel 2007 VSTO COM Add-In using VSTO 2005 SE . It runs perfectly fine when I build it and run the in development computer having VS 2005 . However, when I try to install the setup.exe or .msi file for the same addin in the client machine or Virtual PC having the following configuration: 1. VSTO Runtime 2. Office 2007 3. .NET 2.0 Framework it does not seems to load . I also did caspol settings to make it Fully Trusted . I get the following error " Not Loaded. A runtime error occurred during the loading of the COM Add-in ." Can someone please help me on this Thanks in advance hi, did you check that the PIAs are installed for the office 2007 if they are not - it wi ...Show All

• Visual Studio Bugs (?) in July version

  I have upgraded to the July DSL Factory and have the following errors/changes 1) Can no longer stop users resizing shapes 2) Can't create a new relationship shape (had to edit XML) 3) Can't create user types (used to use CLR attributes) 4) 2 instances of validate/validate all in menu 5) Error if adding item to validate menu Thanks you have answered nearly all my questions. The new external type answer needs some more clarification. I take it you mean a Domain Type What goes in the class definition to make it editable in the property box. I want a class that has an array/list of another custom type e.g. each member of the list is of type A which has 4 members (each is a string or an en ...Show All

• Visual Studio Express Editions How to Delete a File using VBX2005

  I have a problem on my program, In VB 6 I used "Kill" to delete a file that was previously from a picture box. When I used VBX 2005, i got an error, i cannot delete the file that i previously loaded in a picture box, it says "The file is being used by another application" Can u help me please:( I guessed that calling Dispose() would remove the lock but ran into lots of trouble making that work. This finally worked for me: Dim bmp1 As New Bitmap("c:\temp\test.bmp") Dim bmp2 As New Bitmap(bmp1) PictureBox1.Image = bmp2 bmp1.Dispose() Kill("c:\temp\test.bmp") Looks to me like Microsoft is forgetting to call Close or Dispose on their internal stream o ...Show All

• Visual Basic How should I develop a WindowsService that shares files with a WindowsApplication

  Hi, I am developing a WindowsService having three threads collecting information (such as event logs), storing information, settings and some actions in three XML files. I am also deveoping a WindowsApplication to display information in these XML files and to change settings. Assumptions: From what I understand there can exist no Forms in a WindowsService. The file path to the settings XML file must be hardcoded into both the WindowsApplication and the WindowsServices (The settings XML file contains path's to other XML files. Here are my questions: Does WindowsServices assemblies have a default location on the file system (I am deveoping for Windows 2003 Server). Should these XML files be stored there or Should the fi ...Show All

• Visual Studio Team System VCAdapter.processChangesets throws an Exception.

  I'm getting this error every time the Warehouse is trying to update. Can I do something to remedy this, like deleting the changeset Event Type: Error Event Source: TFS Warehouse Event Category: None Event ID: 3000 Date: 25-02-2007 Time: 00:35:01 User: N/A Computer: SYNDROME Description: TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff. Technical Information (for the administrative staff): Date (UTC): 24-02-2007 23:35:01 Machine: SYNDROME Application Domain: /LM/W3SVC/3/Root/Warehouse-3-128168330489652128 Assembly: Microsoft.TeamFoundation.Warehouse, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0 ...Show All

• SQL Server measure using calculated member

  I have fact and 2 dimensions. i have to create a mesure using calculated member. fact is having fkey ckey monthid hits responses CDIM is having Ckey ADateID MonthDim is having Monthid MonthName now i want a measure(XYZ) to be calculated using calculated member as Count of Ckey for AdateID = '20000101' for current member of monthdim. finally when i browse thru a cube it should display some thing like below. Monthid XYZ 200601 1000 200602 2000 Thanks in adv Lets take this offline. You can email me at stevepon@microsoft.com It would be helpful if you could send me a copy of your project files so I could better understand the relationships. Ste ...Show All

• Visual Studio Instalation of SP1 for VS2005 products hangs up a computer totaly

  Hi, A year ago I have installed VS2005 for SA. Everything have worked ok so far. Now I tried to apply SP1 to my VS2005. The update took about 4 hours and finally, when it claimed that 21 seconds left to finish, the computer hanged up totally. I tried to repeat the process once again but it ended up exactly the same way. So I decided to install VWD Express, but to my supprise it hanged up again during VWD Express instalation. I tried to install other Express products too but the results were always exactly the same - total computer hang up during instalation process. Other programs install/unistall perfectly. Computer is scanned against viruses. It is behind a firewall. Anyone has *any* idea to "shoot in the dark" - what's going ...Show All

• .NET Development FileStream running slow in Window's forms but not in a windows service

  Hi, I'm runnning the same piece of FileStream code (see below) in a simple windows form and in a service but the code in the windows form is running 50 odd seconds slower (7 seconds in the service, 59 seconds in the form) . The file that i'm running the test on has a size of '1.56 MB (1,641,874 bytes)'. using (FileStream s = new FileStream(@"c:\ss.drs", FileMode.Open, FileAccess.Read)) { DateTime start = DateTime.Now; while (s.Position != s.Length) { s.ReadByte(); } TimeSpan ts = DateTime.Now - start; Debug.WriteLine(ts.ToString()); } Any ideas anyone Thanks in advance JK Like Lucian suggested, it could be cache. The ...Show All

• Visual Studio Tools for Office VS.NET 2005 - Professional and Office Tools version..

  after looking over these two versions, i was wondering what the deal was w/ the Office Tools version. it looks like it's ~only~ the part of VS.NET that deals w/ MS Office. is this the case, or am i mistaken what does the Office Tools version deal with (when compared to the professional version). thanks :) :) :) The VS Tools for Office is a special Add-in to Visual Studio. It provides a substitute for embedded VBA code in Word and Excel documents, linking managed code DLLs to specific file solutions (as opposed to the concept of an Add-in, that's application-wide). At the same time, it simplifies or enables certain tasks in Word/Excel, such as data binding and custom task panes. It also facilitates creating Outlook Add-i ...Show All

• Windows Forms Context Menu In GridView

  How can I have context menu in Gridview upon right clicking at any where in gridview.Can any one plz help me up... Thanks in adavance.... With regards, mahender Hi, Mahender I recommend the ComponentArt.WebUI  for you.This 3rd part WebUI component is very powerful for developing ASP.NET applications. The ContextMenu component in it maybe the very thing you need. And moreover, for asp.net questions, you can post them at the ASP.NET Forum for better responses.  Best Regards. Ye. ...Show All

• Software Development for Windows Vista Adding a custom service to sharepoint hosted workflow runtime

  I have a custom service that I would like to add to the sharepoint hosted workflow runtime. I don't see a corresponding configuration section in the web.config file of the sharepoint website. Does anyone know how I could do this Thanks! Vignesh, If you want the workflowRuntime to read the "WorkflowRuntime" Configsection of your Web.config, you have to pass "WorkflowRuntime" as a parameter, it's not automatic ...new System.Workflow.Runtime.WorkflowRuntime("WorkflowRuntime") ; So it seems that (saddly) we (the users) cannot load WF services in sharepoint...despite the great architecture of WF. Serge ...Show All

• SQL Server Alternative to Merge Replication?

  Is there a simpler alternative to merge replication I am concerned about the splash of GUID across the DB, performance issues, and the complexity of the deployment. My scenerio is: Networked offices with 5-30 internal users, modifying a central DB in SQL Server 2005 1-6 Field workers who need to modify a subset of the tables in the field (disconnected) and then connect to the network and upload their changes. Low (though possible) change of conflicting changes between syncs, as field people tend to work in different areas. Field device might be away from the central DB for 1-10 days. Last-one-wins would be OK for conflicting changes. I've been considering a home-grown system that inserts new re ...Show All