Johanvh's Q&A profile

• .NET Development DateTime interpretation between ADO.Net and SQL Server

  In my application I write to a table in a database a DateTime field (which happens to be a primary key) by executing a SQL command, e.g. INSERT INTO MyTable (MyDateCol) VALUES ('8/22/2006 4:20:21 PM'). Then, I insert the same value into another table (in which that same field is a foreign key) by using ADO.Net's SqlAdapter->Update(), where in a DataTable in a DataSet I had stored that same System::DateTime object. I am getting a failure - foreign key constraint violation - when trying to do that last write. When inspecting the value of that field in the DataSet from within the debugger, the date looks like this: "22/8/2006 16:20:21" (same thing, just different representation). This is all on the same computer so the culture is the same ...Show All

• Windows Forms ClickOnce API Memory Leak

  Hi,   Has anyone noticed a memory leak when using the ClickOnce API calls.   Each time I call the CheckForUpdates method, my application's memory increases my 300K.   This memory is only released when the application stops   I think that it's a bug within the  System.Deployment.Application assemble Regards, I have the same problem. My application inceases to 300M in a week. James,have you find a solution Thanks for any reply! ...Show All

• Windows Forms Response.Redirect dont work with a Treeview

  I'm using VS2005/C# I have a treeview, and I'm using SQL to pump date to it (treenodes), I have a view pages that have a Response.Redirect, problem is when I click on it it dosnt remember the highlighted node, or expand to the correct node. ...Show All

• Visual Studio Express Editions compiler cannot find windows.h

  I tried to compile an existing program (which I want to modify). The program is written in C++. So I downloaded Microsoft's Visual C++ Express edition and I tried to compile the program. It failed to compile, and the error I got was that "windows.h" could not be found. I did a search in my computer for windows.h, and it was in the Microsoft Platform SDK\include directory and I looked at my compiler 'directories' menu option and saw that I had added that directory. Furthermore I had modified various files that the compiler uses as specified in msdn instructions. But still the compiler cannot find Windows.h. Here's the error message: ------ Build started: Project: FullDuplexFilter, Configuration: Debug Win32 ------ Compiling... dx ...Show All

• SQL Server Installing Report Service in Window XP - Report Builder and other option are not displaying

  hi I have installed SQL Server Reporting Service on window xp. everything working fine except one thing. I have installed sql server with my a/c. my a/c have admin rights. when i giving http://dineshpatel/reports it is displaying page but Report Builder and other option are not displaying. I hope i don't have admin rights. I have checked with local administrator login also but same problem. what additional setting are require for admin rights Dinesh Patel Report Manager will display the Report Builder button if the current user has permission to the Execute Report Definitions task. This is included in the Report Builder system role by default. In Report Manager, go to Site Settings, Confi ...Show All

• Visual C# Private constructor

  What is the use of a private constructor as it is not getting called with an object creation in .net/c# I would greatly appriciate if anybody could clear my confusion here. Thanks in Advance..................... Private constructor exists for the same reason as private fields or methods. That means that you want to hide it from the outside users of the class. If your next question is "How then to create object " the answer is: one way is through the static method of your class which uses the private constructor (it can access this constructor). There are many examples in the .NET class librrary. of classes where you cannot explicitly call the constructor. (OleDbTransaction object, for example, has not public cons ...Show All

• Windows Forms Adding nodes in AfterLabelEdit event handler of treeview control

  Hi! In my windows application I need to add some nodes to a node of a treeview, which number depends on what user enters in the node label. For example: if user edits the label of a node and digits "1-1000", I have to add 1000 nodes to the parent nodes. To do this, I read the label, calculate the number of nodes and then add them to the parent node. This is a part of code: e.Node.TreeView.BeginUpdate(); for ( int i = 0; i < 3000; i++) e.Node.Nodes.Add(i.ToString()); e.Node.TreeView.EndUpdate(); The treeview repainting was very slow, so I have tried to do the same thing, but out of AfterLabelEdit event handler (I created the nodes after a DoubleClick over a node). The result is that treeview repainting i ...Show All

• Visual C++ much confused by KB on MSVCPRT.LIB

  http://support.microsoft.com/kb/154753/en-us Import Library Linked With DLLs Used (Visual C++ 5.0|6.0) DLLs Used (Visual C++ 4.2) DLLs Used (Visual C++ .NET 2002| Visual C++ .NET 2003) MSVCRT.LIB MSVCRT.DLL MSVCRT.DLL MSVCRT.DLL MSVCRTD.LIB MSVCRTD.DLL MSVCRTD.DLL MSVCRTD.DLL MSVCPRT.LIB MSVCP(5|6)0.DLL MSVCP7(0|1).DLL MSVCPRTD.LIB MSVCP(5|6)0D.DLL MSVCP7(0|1)D.DLL MSVCIRT.LIB MSVCIRT.DLL MSVCIRT.DLL MSVCIRTD.LIB MSVCIRTD.DLL MSVCIRTD.DLL then, http://support.microsoft.com/kb/154419/en-us * NOTE: MSVCPRT.lib and MSVCPRTD.lib are static libraries and do not have any dynamic link libraries (DLLs) directly related to ...Show All

• Visual Studio Express Editions PictureBox does not draw while within the form load.

  We have a requirement where we must draw various lines and points within multiple picture boxes on a form. I cannot get the following code to work within a form's load event but I can get it to work if I put it within a button. Unfornately I must have it work so that when the form loads, it executes the code to draw within the load event. The following code is from a simple form named form1 with a picturebox on it that we want to draw a line within. Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Dim eg1 As System.Drawing.Graphics eg1 = PictureBox1.CreateGraphics eg1.DrawLine(Pens.Black, 0, 0, 110, 114) End Sub ...Show All

• Visual Studio Tools for Office VSTO Excel add-in only working in development machine

  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 installed: 1. VSTO Runtime - Shipped with VSTO 2005SE 2. Office 2007 3. .NET 2.0 Framework it does not seems to load . I have done : 1. caspol settings to make it Fully Trusted . 2. set vsto_suppressdisplayalert=0 and run excel.exe from cmd ......Same Results .... I get the following error " Not Loaded. A runtime error occurred during the loading of the COM Add-in." It has been over a week now that I am str ...Show All

• Visual Studio Express Editions how can i populate a combobox from multiple textboxes and save

  Hi i would like to know how i can add the text in multiple textboxes to the drop down list of 1 combobox and save the list to a user setting so when the program is restarted the list will still be there. Thanks Or alternatively If My.Computer.FileSystem.FileExists("test.txt") Then My.Computer.FileSystem.DeleteFile("test.txt") For Each c As Control In Me.Controls If TypeOf c Is TextBox Then Me.ComboBox1.Items.Add(c.Text) My.Computer.FileSystem.WriteAllText("test.txt", c.Text, True) End If Next ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Flickering MDX Window/Form

  Here is what I'm trying to do: 1) WinForm that has some combo boxes and a MDX device created in a WinForm panel. 2) Press a button to go into "fullscreen mode", MDX device is now fullscreen. 3) Press ESC to go back to initial mode with combo boxes and small MDX panel. Here are my problems: 1) When it enters fullscreen mode the background (my desktop) flickers in and out if my move the mouse. For example moving the mouse to the taskbar the taskbar windows will pop-up. 2) The ESC button handler for fullscreen mode I created is never fired, which leads me to think the form is going in and out of focus. Relevant info: 1) Using PresentationInterval.Immediate. 2) Device is created initially with panel.Handle, then ...Show All

• SQL Server Page Restoring

  In SQL Server 2005 Book on Line, it mentioned that you can restore a database by pages instead of to restore the whole database. But, it also says "Page restore is supported only for read/write filegroups." If this is true, then how about most of the database files are not designed as filegroup (or just primary filegroup only)   Can they enjoy this convenience too Also, when you find a suspect page in suspect_pages table in msdb, how you find out in which log_backup file that contains this bad page Thanks, Charley Hi Kevin, Thanks so much for your quick response and excellent explanation. You also answered my next question about the the online restoring. Thanks, Charley ...Show All

• SQL Server Copy Table and Data from one database to another

  I am working on a migration project. Doing the standard processing, taking source data in a staging database, where I then create the new target tables, transform the source data into the new target table structure, and load the data. However, having created the new target tables in my staging database, I cannot accurately migrate these tables into the new database. An example table. The following is the script created by SQL Management Studio if I right click and script the table as CREATE. CREATE TABLE [dbo].[tbPRO_Package]( [PRO_PackageID] [int] IDENTITY(1,1) NOT NULL, [CreatedDate] [datetime] NOT NULL CONSTRAINT [DF_tbPRO_Package_CreatedDate] DEFAULT (getdate()), [CreatedBy] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS ...Show All

• Visual Studio Express Editions Where have all the files gone?

  Once I have published a project and run the 'Setup' file created where exactly have my application files been installed to. I found an *.exe in the Main Projects debug folder, but cannot find where files are installed to if an application is installed via the aforementioned 'Setup' file. Are you using clickonce to deploy the application, if so it creates a temp directory for the application (From memory, havent used it much) and each time you start the exe it re checks the setup file for the latest version and then runs from there. You will have to look at how the click once system works and go from there. ...Show All