ChrisHelt's Q&A profile

• Visual Studio Tools for Office functionalities in Excel Chart

  I am trying to programmitically add some functionality to excel chart that I am creating, one thing I am trying to do is to have the tool-tip/bubble show up for every time series being plotted by moving the mouse in the x-axis of the chart(line chart). Say I have 3 time series data and I created a line chart, so X-axis is a time line and say y-axis is share price, we will have three lines for 3 time series, if I place the mouse on any one time series, it gives me information about that point of that time series(with a pop-up or tool tip, I heard people are calling it bubble), it doesn't show me anything about the other 2 time series at the s ...Show All

• Visual Studio error: The device is not ready

  I am getting the error below on a particular pc at a client. Here's the background: - Winforms app written in VS.NET 2005. - The application runs, but fails when I attempt to launch the report. - Works fine on another pc at the client's site. - Have re-installed the crystal runtime. - Win2k pro Any suggestions Thanks. System.Exception: Load report failed. ---> System.Runtime.InteropServices.COMException (0x80004005): The device is not ready.    at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options)    at CrystalDecisions.ReportAppServer.ReportClient ...Show All

• SQL Server making two sums in one query

  Hi Im new in this forum so don't if this is the right place to post these kind of questions.. Im using vb2005 and have made a program that deals with customers and payments. I have a table called acount. Roughly it contains these columns Number, amount, type.. type can be a payment or a charge I would like to have a query that gives me this result: Number, sum(payments), sum(charges) (grouped by number) I think it is some type of merging these to querys select number, sum(amount) where type = 0 group by number and select number, sum(amount) where type <> 0 group by number Im using it to calc ...Show All

• Windows Forms How do I create a GridView/edit screen?

  Newbie question. I have DataGridView that has a list of records. I want to double click on one row and bring up a NEW form with a detailed edit form for that record. 1) How assign a KEY to the DataGridView 2) How to I access the key and pass it do the new form 3) How do I create all this on a row double click (not cell double click) Thanks. Any objections to using a global static field in the Program class to use as a global variable Rather than pass values from one form to the other, I have just created a static field. Thanks again for your help. ...Show All

• Visual Studio Express Editions SQL EXPRESS too sloooow...

  Could someone please help. I used to have a very smooth running SQL EXPRESS server. After I installed Beta 2, the server got very very slow with massive resource consumption. It can now take in and around 30 seconds just to login with massive use of the hard drive. Does anyone else have this problem I am using SQL EXPRESS version: 9.00.1116 Thank you, Hi, Thats correct and SQL Server Express does support all of those. In fact open up 2 or 3 instances of the Express Manager and it does not give you any errors if you try to open the same database. The issue comes when you try to directly access the .MDF file of the database ...Show All

• Windows Forms ControlDesigner class not found!!!

  I can't find ControlDesigner class in system.windows.forms.design namespace,but in MSDN refrences this class implemented in above mentioned  namespace.what can i do for finding this class in .NET namespaces I believe that's in the System.Design.dll.  Add a reference to that assembly and see if it can find it then. ...Show All

• Visual C# ExecuteReader error

  Hi all, apologies if this thread or a similar one has been covered in this forum already. I am a problem with my program and I need some urgent help. I have datagrid which read from a database. It worked very well the first time I created it and I tried to use the same code in another form then I started having problems. even though i have comment the codes in the other form out I still get this error "ExecuteReader requires an open and available connection. The connection's current state is open, fetching" on the line oleDbDataadapter1.Fill(dataTable1). trying to solve this error, I have put in a if statement to check the connection stat ...Show All

• SQL Server Remote messages not working – message vanishes

  I need some assistance with getting service broker to work across servers.   I have 2 separate servers and I am trying to send a message from one server to the other.   No error is generated when sending the message and I get no records in the transmission queue of the sending server, however the message does not arrive on the receiving server.   Where is the message going     Here is the code I use to create the service broker objects that are being used…   RUN THIS ON THE SENDING SERVER:   CREATE MESSAGE TYPE [MyMessage] VALIDATION = NONE CREATE MESSAGE TYPE [MyResp ...Show All

• SQL Server replication system stored procedures parameter defaults ?

  Hi there This is a pretty straight forward question. When using sp_droparticle or sp_changepublication etc, basically any replication system stored procedure. There are many parameters for these sp's basically all i want to know is if i provide the relavant paramaters,that is publication name, subscriber name , specific parameter i wish to change etc, are all the other paramters defaulted to the current publication/subscriber properties. In other words sometimes i really dont know what to provide for all the parameters i am pretty sure as long as i provide the necessary ones the other ones are defaulted correctly, BOL is not 100% clear on al ...Show All

• Visual Studio Express Editions Encryption of files on USB drive

  I am trying to create my own program that will encrypt files on my USB drive and decrypt them only when a password is entered, and only when logged on as certain users. Sorry if the code is a bit long. So far I have managed to achieve all but the encrytion / decryption. So can anyone out there help me with this My code so far is: Imports System Imports System.IO Public Class Form1 Dim allDrives() As DriveInfo = DriveInfo.GetDrives() Dim d As DriveInfo Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If TextBox1.Text = "-----" O ...Show All

• Visual Studio 2008 (Pre-release) Multiple threads, UI, and images

  I'm currently trying to write an application that dynamically loads images in a background process in order to eventually display them on the UI. Essentially, my background thread creates objects that inherit from System.Windows.Media.Brush or System.Windows.Media.Drawing so that my UI can redraw itself using these objects. When running my code, I receive an InvalidOperationException with the explanation of " The calling thread may not access this object because the object is owned by a different thread. ". This appears to be behavior for any class that derives from System.Windows.Threading.DispatcherObject. My question is, how can ...Show All

• Windows Forms video player

  Hi, what is the easiest way to play mpeg, avi using VS.NET 2003 I will create a folder which contains 001.mpeg, 002.mpeg, 003.avi, 004.avi ...etc. After that, I will load them one by one into the player. I have to make a full screen player (or minimize the borders). At the bottom of the player, there is a scrolling text bar to show some news. My platform is window XP. The easiest way would be DirectShow, but it also sucks ( managed Direct Show is full of bugs ). The next option would be the Windows Media player SDK, which works well. ...Show All

• Visual Studio Team System Work Item "Self" Transition

  Is transition from of work item from one state to the same state valid Something like this: <TRANSITION from="A" to="A" >      <REASONS>          <DEFAULTREASON value="Status Change"/>      </REASONS> </TRANSITION> Work Item Type with such transition is iported successfuly, but attempt to change WI state to "A" fails. Thanks, Leon Hi Leon,    I understand now, but I'm sorry to say that the ability to change reason outside of a state transition is a feature that was cut for version 1. This is being ...Show All

• Windows Forms Bug or By Design In UserControl

  The following is my test control.....I does not know why DesignMode propery alway got false, but on OnHandlerCreated Method I got True......Why public class TestControl:UserControl { public TestControl() { MessageBox.Show(this.DesignMode.ToString()); } protected override void OnHandleCreated(EventArgs e) { base.OnHandleCreated(e); MessageBox.Show(this.DesignMode.ToString()); } } Desginmode property is used i think for Visual Studio. Otherwise it has no purpose. Is it in your way Or are you just curious ...Show All

• Windows Forms C# Combobox ValueMember problem

  Hi all, I'm pretty new to the world of C# and .Net and enjoying it so far. I'm having trouble setting the index value in a combobox. I'm using MySQL connector/Net and because it doesn't provide certain tools/extensions to work with Visual Studio I have to do certain things manually (which isn't  problem because it helps me understand C# and .Net better). :^) My original intention was to take names and ids from a table and use the id as the index in the combobox list and the names as display. I get a full list of the names no problems. But the index is always the same, integers incremented with each item. As you can see I've tried crea ...Show All