Uwe Lesta's Q&A profile

• SQL Server help with transaction

  I need to subtract qty in one table from qty in another table. can someone help get me started ok I think I need some step by step help with this if you don't mind. 1. I'm creating this as a stored procedure (tableadapter) 2.When I do the above how do I specify the args for the parameters Sorry, very new to this. Thanks ...Show All

• Visual Studio Express Editions Is there a way to compact a database through VB Express?

  I have an application with an Access database as the source of the data for my application. I know that within Access you can compact a database. But is there a way programmatically within VB Express to compact the database If possible, I would like to avoid calling an Access command as some of my users might not have Access installed on their computers. Also, what about a routine that when a user clicks on a button it will allow the user to save a backup copy of the database Thanks, John I haven't tried this yet, but in your example, you rename the file to something else. Is it possible to compact it to the same name If not, then I will need some way to replace the old file so the program reco ...Show All

• Windows Forms hierarchical dataviewgrids

  Hello All, I am new to VS 2005 and VB, my experience is Excel and Access VBA. I am trying to create three hierarchical datagridviews on a single form. In Access this is easily achieved using subforms. I have found several peices of code that show me how to set a dataset, add the data adapters, add the relationships and then bind the data sources. All very well and I am prepred to code along these lines if necessary. Since I will be using teh same data tables in a few places in teh Windows App I have already defined my dataset in the VS2005 Data Sources Window. Within that dataset the relationships between the three tables are defined. If I then drag and drop the individual tables from the datasources win ...Show All

• Software Development for Windows Vista Showstopping Bug in WF Persistence?

  We have been struggling through an error for some time and as yet have found no resolution. We would like to persist a workflow that contains activities that have subactivities (like subtasks). The problem is that we get a SerializationException when the app tries to load the persisted workflow (on SqlWorkflowPersistenceService.LoadWorkflowsWithExpiredTimers). The specific message is "The object with ID XXX implements the IObjectReference interface for which all dependencies cannot be resolved. The likely cause is two instances of IObjectReference that have a mutual dependency on each other." If we take out the "subtask" concept, or take out persistence, our code works perfectly. Here is the code with the issue. //The Custom Acti ...Show All

• Visual Studio Run BuildProject for particular solution configuration + platform

  I've got the following problem using VS2005 Extensibility. I have a solution with several projects for Smart Devices. It means that there are two solution configurations: - Debug - Release and four solution platforms: - Pocket PC 2003 (ARMV4) - Smartphone 2003 (ARMV4) - Windows Mobile 5.0 Pocket PC SDK (ARMV4I) - Windows Mobile 5.0 Smartphone SDK (ARMV4I) In my automation I would like to call DTE.Solution.SolutionBuild.BuildProject method against some of my projects and Release configuration for "Windows Mobile 5.0 Smartphone SDK (ARMV4I" platform. dte.Solution.SolutionBuild.BuildProject("Release", "MyProject.vddproj", true); Unfortunately, it does not work because VS internall ...Show All

• Visual Studio Error installing

  When installing " Microsoft Visual Studio Code Name “Orcas” Community Technology Preview – Development Tools for .NET Framework 3.0 " (vsextwfx.msi) from 7/17/2006, I get an error message: Setup has detected that a prerequisite is missing. To use Microsoft Visual Studio Code Name "Orcas" Community Technology P...0 you must have the .NET Framework 3.0 runtime installed. Please install the .NET Framework 3.0 runtime and restart setup." ( See screenshot here ) Then, the setup must be exited. Before this Orcas, I successfully installed the following components, as described here : " Microsoft Pre-Release Software Microsoft .NET Framework 3.0 - Release Candidate ", " MicrosoftR WindowsR Software Devel ...Show All

• Visual Studio 2008 (Pre-release) Dockable windows tool for WPF

  Hi all, does anyone know if someone has written a docking tool for WPF Like Visual Studio, where you can just drag & drop your windows and dock them left, right and center. Thanks, Frances Just found: http://www.codeproject.com/WPF/WPFdockinglib.asp With best regards, OldDino ...Show All

• Windows Forms Finding controls inside a region ?

  Hi there, I have a problem which I expect to solve here.. Here is what I want to do : I have got 5 sub panels and 1 main panel (all of them containing various controls) .. I want to do simple drag&drop operations on them. To be more clear I will drag the main panel over one of the sub panels. Now, where I stuck is that when I drop the main panel anywhere in the Form a method should check wether there is a sub panel in the region of the main panel. If yes the main panel will transfer its controls to that sub panel. If no the main panel will return to its original position. But also, in the region there may be two panels. In this case the main panel will transfer its contents to the closest one. How can I do such region checks and also ...Show All

• SQL Server Error executing Parse in SSMS

  Executing Parse in Sql Server 2005 Management Studio I get the following error: .Net SqlClient Data Provider: Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded. Reading SP1 fixes, I found a similar problem but despite I installed latest hotfix (sql version is now 9.0.2153) I can't able to execute Parse to check T-SQL statements... Thanks, Giulio I'm not sure but I would have a customer with same problem... 3 machines with 3 different SQL Server 2005 (all standard edition, 2 english and 1 italian) and same problem: it doesn't seem to be a coincidence... Giulio ...Show All

• Visual Studio Express Editions Problem with PictureBox >? Not Working ! Why ?

   I want this photo Usa.jpg to show in picturebox .              if TextBox1.Text = "Usa" then           PictureBox.Show This --> Usa.jpg How  ::In Visual Basic 2005 Express Edition:: Dr.Virusi wrote: Look! Just i have 1folder and all my photos i have in this folder. Yes, but which folder is it It's important for your application to know in which folder to look for the files to function correctly. If you don't know which folder is that or you want the user to pick a folder, implement something like Tall Dude has posted. Andrej ...Show All

• Visual FoxPro Please help

  Any suggestion why the record not disappearing from the grid of Form when I press the delete (it indicates the deletion by black sign but not disappearing) Thanks # DEFINE MSGBOX_YES 6 # DEFINE C_MSGBOX1 36 # DEFINE C_DELETE_LOC "Are you sure you want to delete this record " IF MESSAGEBOX (C_DELETE_LOC,C_MSGBOX1) = MSGBOX_YES DELETE IF ! EOF () SKIP 1 ENDIF IF EOF () AND ! BOF () SKIP -1 ENDIF THISFORM . Refresh ENDIF Thank you very much all of you I thought it works perfect, but it's not. Because the deleted record appears with blak mark when form run's next t ...Show All

• .NET Development String.ToUpper(CultureInfo.InvariantCulture) vs. String.ToUpperInvariant()

  What is the actual difference between String.ToUpper(CultureInfo.InvariantCulture) and String.ToUpperInvariant() Exactly the same. The framework code for String.ToUpperInvariant() is: return this.ToUpper(CultureInfo.InvariantCulture); ...Show All

• Visual Studio Toolbar disappear after some actions

  I've noticed that the toolbar disappear after some action. For exemple if i enter a word to search in the report then click on search right after this the toolbar disapear and i don't know why. I only have this problem when i'm using the Reportcontrol. When i'm using de \ReportServer\ control i don't have this problem. When trying to find the problem i've found something. When the toolbar disappear if i Zoom OUT using IE7 i can see that the toolbar is there. I've tried to add in my pageLoad ShowToolbar = true but i still have the problem. ...Show All

• SharePoint Products and Technologies Unable to edit in datasheet - WSS 3.0

  When I try to edit a list in datasheet view I receive the following error: The list cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Windows SharePoint Services is not installed, your browser does not support ActiveX controls, or support for ActiveX controls is disabled. This worked as of 2 or 3 weeks ago ( I do not remember the last time I tried it), and I cannot think of anything that has really changed locally or on the server. Other users have no issues. I have office 2003 with the SP parts installed. It is in my trusted site list and security is set to custom off a low template. All activeX controls are set to "allow" for the zone. I am also running IE 7 ...Show All

• Smart Device Development Access command prompt in the emulator

  Can any way we can go to the command prompt in the emulator. I want's to start one service using services.exe on the command prompt After more reseach I found out you can load your service through the command prompt. See here: http://msdn.microsoft.com/library/default.asp url=/library/en-us/wcecomm5/html/wce50conusingservicesexefromthecommandline.asp This is for the argument list for the previous code I gave you. It has several examples on what the arguments should look like. If you have used DLLImport then you should know how to DLLImport ActivateService so that option should be open to you as well. ...Show All