xavito's Q&A profile

• SQL Server How to use coalesce function in derived column component?

  Hi all, You know the coalesce function is not offered in the derived column component. how can I use the coalesce function within the component And how can I use a user defined function within derived column component Would you be kind enough to give an example Thanks! Any reply or comment is highly appriciated. Robert You can simulate a simple coalesce by using the conditional operator. ISNULL(@[User::StringVar]) "Value is Null" : @[User::StringVar] You cannot add user defined functions to the expression syntax. ...Show All

• SQL Server Compact Edition DVD Standalone

  Is it possible to run SQL Server Compact Edition as a standalone application from a DVD i.e. it would not leave anything installed on the users computer after the DVD was ejected. Hi: For what it's worth, I am attempting the same thing: developing a product catalog that will enable users to browse products and configure order for printing. As my product is using Framework 2, I will simply have an autorun install the program since I have to check for the existence of the framework anyway. Please post back your findings. ...Show All

• Visual Studio ReportViewer Print Preview Problem?

  Has anyone experienced this I created a report that has multiple pages - in fact my tests were done with 2 pages. When I go to Print Preview mode, it usually only has 1 page. I have to click refresh (sometimes more than once) before it has all pages. Hi, I have a similar problem, though I am not sure if it is quite the same. I have report in landscape format, displayed on a windows Form by use of reportViewer. At first he tells me there is only one page (in the foot of the report by using totalPages and in the toolbar). If I select the preview, there are several pages (sometimes he gives the total number in the toolbar, sometimes no total number and sometimes there is still a one, but I can see, that there is data missing. typi ...Show All

• Visual Studio Team System VS2005, vista and custom mouse assignments

  Not sure exactly where this fits, so... I have an Intellimouse with CTRL+F4 assigned to one of the buttons on the left side of the mouse. I've always used this to quickly close a code file when I'm done with it. Under XP this worked perfectly. Under Vista it doesn't. The button assignment works fine in other programs like IE7 and Excel 2007, just not Visual Studio. Is there somewhere I can report this I would suggest reporting it as a bug on the Connect site: http://connect.microsoft.com/VisualStudio (you might need to Log in on the http://connect.microsoft.com site before you can go to the VS specific page). thanks, ...Show All

• Microsoft ISV Community Center Forums Copy text from textbox to clipboard?

  How to copy just the text from a textbox to the clipboard in VBA (MSO 2000 - Excel). I can copy the entire textbox but I only want the text (not the box). My brain has gone to sleep and I can't do it :( can in VB but do not want to reference VB components. Cheers. NM I have the same emergency. Could you post the code snippet you used please. I can't find any reference to " PutInClipboard" ...Show All

• Windows Forms Issue With Database Connections for Deployment

  Hello! I am not completely new to VB, but I am fairly new to Windows Forms and Applications. I typically do ASP.NET web programming. I have created a Windows Application in Visual Studio 2005. The Application uses a Microsoft Access Database for storing all the data. During the development of this application I used a specified file path for the location of the database. However, I am now experimenting with the deployment of this application and am finding it unexpectedly difficult to specify a location to be created on the end-user computer. Which means that I am having difficulty getting the app to connect to the DB after it has been installed. The only way I can find to deploy the site is through the Build menu using "Publish 'myap ...Show All

• Visual Basic error creating new connection string (VBexpress SQl Express)

  Hi I have finished developing a serial number DB with SQLexpress and VB express, and would like to publish/deploy the application to a shared network drive so colleagues can acces the DB. Before I publish the App.I want to move the DB (.mdf) to a shared network drive. So that when publishing th db. It will have a connection string that everyone can access. In VB I am tring to connect to the DB moved from my local machine to the network share(server), and keep getting errors. The error states" database1.mdf is on a network path that is not supported for database files. possible causes db with same name exists - have tried renaming the db specified file cannot be opened - have given everyone full access to the file o ...Show All

• Visual Basic MsgBox always return "no" regardless of what the user click

  I am using VS2005 and have a messagebox inside of an event that does not work properly. The code is below: If Microsoft.VisualBasic.MsgBox( "Do you want to save your changes" , MsgBoxStyle.YesNo) = MsgBoxResult.No Then Exit Sub End If The problem is regardless of whether the user clicks Yes or No, it always returns No. If I add another MsgBox in the code immediately before the if statement, then the if statement will always work properly. (see code below) Microsoft.VisualBasic.MsgBox( "Dummy MsgBox" ) If Microsoft.VisualBasic.MsgBox( "Do you want to save your changes" , MsgBoxStyle.YesNo) = MsgBoxResult.No Then Exit Sub End If I can't figure out what is wrong h ...Show All

• Visual Studio Express Editions Can C# read a concatanated string as a variable name?

  Hey, I have a list of variables (var1, var2, var3...etc.) each containing a string. I need to write a function that gives the value of one of the variables. i.e. function getValue(x) // where x is any integer { Console.WriteLine ("var" + x); } But when I do things along those lines it displays "var2" or whatever x was, but not the VALUE of var2. Can I make C# read the string "var2" as the variable name var2 I hope this post is clear enough for everyone to get what I'm trying to do. I only started programming last week so this all seems very complicated to me! Thanks in advance for your help, Mandir. ...Show All

• Visual Studio Express Editions ATL DLL Vs Win32 DLL - VC++

  Hi, What is the difference between the ATL DLL and Win32 DLL in VC++ I am not sure which one to select from the template wizard. IS COM dll different from this I appreciate any input. Thanks These are different technologies. I suggest reading on MSDN on the different topics. Also, ATL is not a supported technology under the Express edition. In addition, you won't find templates for such technologies in the Express version. Thanks, Ayman Shoukry VC++ Team ...Show All

• Visual C# C# Date Time Help

  Ok I am writing this program to log me into WoW at a sertain time set by the user, but right now it won't work. My question is how can I get it to continually check against the current time and then fire the process when they are equal right now the way it is I just get a Not responding error in Task manager with it. [code] using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; /* NoWait V1.0.0 by TRTwiggy * * Date: October 22, 2006 * * Author: TRTwiggy AKA Tyler Reid * * Description: This program was written for two reasons. The first is to help * develop my coding skills. The second is that I got so damn tired of get ...Show All

• Visual Basic Need help on call fx in a do loop

  I am trying to call 4 functions together in a loop With a 2s delay in between each fx However only the last fx is called What is goin on Timer2.Start() Do While Timer2.Enabled = True Call RLeg_Up() If Timer2.Enabled = False Then Call RLeg_Down() Timer2.Start() If Timer2.Enabled = False Then Call LLeg_Up() Timer2.Start() If Timer2.Enabled = False Then Call LLeg_Down() 'Only LLeg_Down is called Timer2.Start() End If End If End If Application.DoEvents() Loop Still a noob btw This is how i think the code should be The code looks weird as it was not VB Code. The following example requires a but ...Show All

• Windows Forms Getting files Advanced properties.

  Hi I am trying to get the audio file advanced summary information. which holds the information of the artist and album title, track no and other propery value. If someone know how to get these details please help me out. You see the properties by right click properties -> under summary Tab. and then click on the advanced mode. Thanks you Atheeque Theres a good example here http://www.codeproject.com/csharp/shellid3tagreader.asp on how to do this using shell functions. Alternatively you could research id3 tags (or whatever other tags it has) and how they are stored in the audio file and read them directly using the System.IO classes. ...Show All

• SQL Server Two Newbie Reports Questions

  Hi, I have a report with 3 parameters. One of which is Company name. To get the available list for this I use a query: select distinct name from companies, etc. However, I also want the user to be able to select "All" or an equivalent to get all the companies. I tried putting * and % in the default values (non-query), but the drop down list displays "<select a value>". Also I've enabled drill-down, is there a way to auto-expand the results Thanks, Dan Thats brilliant, thanks. Does anybody know how to auto-enable the items when using drill down I tried playing with some property settings which sounded right, but ultimately no success. The expand, etc settings, only changed t ...Show All

• Visual Studio Express Editions Web Broswer - Detect the Title of Website

  Ok, so I am creating a simple web browser, and I would like my window's Title to display {WEBSITES TITLE} + Web Express. For example, if I were at this site , I would like my browser's title to display "Visual C# Express Edition - MSDN Forums - Web Express". But the problem is, I dont know how to detect the Title of the websites :(. I dont even know if its possible, well...it must be if Interent Explorer can do it :), so i guess my question is: How do I detect the "Title" of Websites wait....actually that creates an error when i try to start the program. I have that code under a progressChanged function. ...Show All