warble's Q&A profile

• Visual Studio Tools for Office custom command bar menu disappears off one sheet but appears on another

  I have added a custom button to my vsto excel project. Here is the code: Public Sub CheckIfMenuBarExists() Try Dim foundMenu As Office.CommandBarPopup = _ Me .Application.CommandBars.ActiveMenuBar.FindControl( _ Office.MsoControlType.msoControlPopup, System.Type.Missing, menuTag, True , True ) If foundMenu IsNot Nothing Then foundMenu.Delete( True ) Else AddMenuBar() End If Catch ex As Exception MessageBox.Show(ex.Message) End Try End Sub ----------------------------------------------------------------------------------------- Public Sub AddMenuBar() ...Show All

• Visual C++ Handling exceptions thrown from a DLL compiled with /clr within a pure C++ host application

  Greetings! I have an application that needed to be compiled in pure C++ to support some statically linked libraries that my company has written, but I wanted to take advantage of the ease of C# programming with VS2005 and .Net 2.0. My application has three components then: a managed assembly with the bulk of the application code, a DLL used for marshalling the few calls that the application will make, and the host executable itself. The problem I'm having is with regards to how to throw exceptions from code within the managed DLL to be caught by pure unmanaged code in my application. Every time I try to do this, I get the following message: "An unhandled exception of type 'System.Runtime.InteropServices.SEHException' occurred in (my m ...Show All

• SQL Server Dynamic Stored Procedures

  Hi everyone, My question is how can i set a var with a table name to use it in a SELECT statement for example. EX: Declare @table varchar Set @table = 'mytable' Select * From @table I've got 1 stored procedure wich i want to use to get and update 2 tables. For that reason i want to know how to do this because having 2 stored procedures when the only difference are table names its not a good solution. Thanks :) Tiago: You can do what you ask with something like: exec ( 'select * from ' + @table ) A safer method is something that does not potentially incur problems from hacking is something like: if @table = 'A' select * from A else select * from B The other comment I have ...Show All

• Software Development for Windows Vista What Windows Workflow Foundation can do?

  Hi all, We are currently in the phase of comparing different WFMS's like JBPM, K2.Net, Ultimus etc. Came to know about microsoft own WWF, and we are really interested in this. Just downloaded the beta pluggin for VS 2005 and the labs, now I'll try them out. I have three questions: 1. We can orchestrate ASP.net web pages using WWF alright, but can we orchestrate webpages developed in any Non-.Net language using WWF like JSP 2. Does WWF support importing of Business process from MS -Visio , if yes then how 3. It is said that we should not go for WWF in the case of EAI or integration scenario, but from WWF we can call web services and can reach outside systems from that, In a scenario where all the systems which need to be ...Show All

• Visual Studio Express Editions Buttons on Form disabled when using SQL Database

  Ok, I've tried de-bugging this and I can't figure out how to rectify my problem. So far I have a simple application with a simple database. (I'm getting back into programming after 20 years.) I have a list box with names of historical figures. When you click on the name a picturebox on the form changes to that person's picture and there is a 'summary' text box which says a little about them. The list box is bound to the database. It works pretty slick actually. The only problem is that once I click on the list box (and the event ListBox1_SelectedIndexChanged takes place) all of the buttons on the form are unresponsive. Apparently the program goes into a loop where it checks to see if the listbox has changed and continues to do ...Show All

• SQL Server Connectivity Issue

  I recently posted a few columns on how to connect. I figured a way, through a mapped network drive. Although this has to be temporary for the extreme nature of connecting this way. It will have to do for now. But, I couldn't get around the issue of connecting my Access 2003 to SQL Server 05. My new question is this: What do I need to do in order for the tables I created on the server side to show in the link tables window It gives me all of the other database library mumbo jumbo, but I don't see the two tables I created... Another question is this: What about when I create other tables on the server side, will I have to repeat the connection process so I can see those tables as well About the first issue, even with SQL Serv ...Show All

• Visual Basic Getting current selected index of a datagrid

  I have beed reading for a few hours and trying different things and got hung. I am trying to get the current selected index name in a datagrid what I have found so far throws an error of "not a member" below is a partial of my code Private Sub DataGridView1_CellClick( ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellDoubleClick Dim EDFRow As 102ADataSet.EDFRow Dim a As String Dim b As String Dim c As String Dim d As String d = DataGridView1. <<<<<here is where I am having problems EDFRow = 102ADataSet.EDF.FindByEName(d) a = EDFRow.EES1 b = EDFRow.EES2 c = EDFRow.EE ...Show All

• Visual Studio Team System Visual Studio does not replay check box Javascript actions

  Is there a known issue with VS2005 not playing back HTTP requests correctly, if the pages have checkboxes that were enabled during the initial recording Using Fiddler, I caputured and copied the javascript type axd requests into Visual studio. This did not make any difference. ...Show All

• Microsoft ISV Community Center Forums Using FindWindow API to Get Focus and Send keys to a window

  I have put together some code in VBA to naviate to a webpage in IE, wait for it to load, find a hyptertext link on the page named "spreadsheet", click it, wait for the "download file" window to load and the go through the process of saving the file into a specific directory using send keys. The problem is, I am constantly losing focus on the windows. My code actually repeats itself 21 times for different webpages I am downloading this spreadsheet from. I need help finding the windows that I need to send keys to. Below is a sample piece of the code to navigate to one webpage: I have put notes to reflect where I am having issues. They are throughout this code and in red Function import_atl_aspec() '(Button As In ...Show All

• Visual Studio Express Editions What controls do you suggest i use for displaying......

  Hi, what controls do you suggest i use for displaying fairly large amount of text ...Show All

• Windows Forms Format columns in the .NET Winforms Datagrid

  Hello, I used a tableStyle to format my columns in my datagrid. DataGridTextBoxColumn dcFinalDate = new DataGridTextBoxColumn(); dcFinalDate.HeaderText = "Final date"; dcFinalDate.MappingName = "UGFNDT"; dcFinalDate.Width=100; dcFinalDate.NullText=""; dcFinalDate.Format="####/##/##"; tableStyle.GridColumnStyles.Add(dcFinalDate); It works good if there is a string entered, fe: 20060202, it will be 2006/02/02. But when there is no string (because the field is not required), then I'll get // .... How can I get rid of that Greets, Dirk if ( this .MappingName == "pubDate") { etc.... } ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Question: 2D development for both widescreen and standard on 360

  If you want a 2D game to run on 360 for both widescreen and standard TV sets, would the easiest solution be to 'center' your game to fit a standard TV and have verticle bars on either side for people using widescreen What resolution should you develop your game in so it doesn't end up being stretched when running on a 360 Thank You. Something to be aware of when targetting HDTV resolutions is that at 1280x720 you can fit a whole 32 bit rendertarget and depth buffer into the Xbox embedded framebuffer memory, which is 10 megabytes. 1920x1080 requires 16 megabytes, so you have to render your scene in parts. This is generally easy to do (there's lots of magic in the drivers that takes care of things for you) but can cause complicat ...Show All

• SQL Server How would you set up boolean with SQL server 2005 express and vb2005

  Im used to using access and now im gonna switch to sql server 2005 express. My program is coded in Visual basic 2005 where all connection is made to the access database by oledb. Now when im creating the database in management studio express, ive noticed that there is no boolean datatype, but instead there is a bit datatype. Is this the one to use, and would the bit datatype accept true/false values when sending sql commands In visual basic2005 i think that it uses 0 for true and -1 for false or something like that, so when switchin database i would have to recode quite a bit. Or is simpler than this First, you are right, the equivalent for boolean is bit, it is derived from INT with the contrain ...Show All

• Software Development for Windows Vista Instance-wide Event-Listener - Not container of other Activities

  Is it possible to have an Instance-wide Event-Listener Activity capable of handling external events I want such Instance-wide Event-Listener NOT to contain any of workflow child activities (to avoid Spawned Contexts issues that I still do not know how to avoid). In other words, can WF support something like, the First Activity in the WF is ListenForExternalEvents (keep the Listner ON) and move on with the execution of other activities. If an event occurs the Listener get the control-back at hand and does something (like dynamic update of the WF instance) and then the WF execution can continue. The scenario I want to support is, if I have a long running WF and I want to have a Listener for CustomerCancel Event to be able to cancel so ...Show All

• Visual C# Command Line Arguments

  I'm writing a console program in C#. I'm attempting to see if the user sets a command line argument using code like this: static void Main(string[] args) { if ( args[0] == "nogui") { //start in quiet mode } } The only problem with the above approach is if there isn't a command line argument, it throws an exception because it exceeds the boundry of args. Does anyone know of a better way to check for command line arguments Try: static void Main(string[] args) { switch(args.Length) { case 0: // code for no arguments break; case 1: // code for one argument break; case 2: //code for two argument break; // etc.. etc.. etc.. default: //code for unrecognized number ...Show All