Ravi Varma's Q&A profile

• SQL Server Left Outer Join

  Hi All Dudes and Dudesses Please help... I've got Two tables, Problem and Breach, in DB Support. The main Table (Problem) has a primary key on field Number and I retrieve most of my data from this table but the other fields are irellevant. The Breach Table includes fields: Number & Keyword. I use an Left Outer Join to connect from Problem.Number to Breach.Number and retrieve the Breach.Keyword if any. If there's no records in Breach it still retrieves all the Problem.Numbers and that's great but when there's more than one Breach.Keyword for the Problem.Number I retrieve more than one record at this stage but I would only like to retr ...Show All

• SQL Server MDX Question

  Hi,   Assume all of members are {NewYork, London, Chicago, Miami, LosAngeles} in a dimension.   I want the members which name is lead of 'L' as MDX axis(0). That mean I want {London, LosAngeles} be MDX axis(0).   In Sql, we can use "like L%".   How to do this in MDX thanks, You can use the MDX Filter() function in combination with various VBA functions such as Left(), Right(), Mid(): SELECT FILTER([Cities].members, VBA!Left([Cities].CurrentMember, 1) = "L")) ON 0 FROM [Cube] (I am reciting this from memory so the syntax might not be a 100% right, but you get the idea) ...Show All

• Software Development for Windows Vista SDK problem

  Hello, I had used november CTP more times without any notable problem. I will install february ctp version. I've uninstall previuous veersion, download runtime and sdk. I've install runtime and also sdk. But after, nothing work. old applicaion cannot b compiled. I don't found dll for .NET as presentationframework.dll. XAMLPad isn't installed. Only C++ library and help file is installed. What is the problem Thanks for your help. When i try to repair winfx runtime, i receive an error. Repot contain [05/25/06,12:45:46] setup.exe: [2] ISetupComponent::Pre/Post/Install() failed in ISetupManager::InstallManagerHe ...Show All

• Visual Studio Team System Unit Test Wizard in Visual Studio Team Suite doesn't generate tests for C++/CLI classes.

  Hi all, Is there a way to generate unit tests for projects written in C++/CLI I added a Unit Test project to a solution containing C++/CLI and C# projects.  All C++/CLI projects are compiled using clr/safe.  When I right click on the Unit Test project and select Add->Unit Test, a Generate Unit Tests dialog comes up displaying the projects in the solution. If I select a C# project, unit tests are generated and added to the Unit Test project. If I select a C++/CLI project, nothing happens. I've confirmed this behavior on two separate Team Suite installations.  I'm using Visual Studio 2005 Team Suite Beta 2. ...Show All

• .NET Development Timeout Problem when Calling GetResponse()

  Hello, I am trying to use the HttpWebResponse and HttpWebRequest to connect to a web address. I am expecting back XML from the address. I can access the web address and successfully get back XML when I connect to it using my web browser but when I try and access the address using the GetResponse method I get a timeout. Is there a setting I am missing that would cause a timeout Here is my code: HttpWebRequest restRequest = (HttpWebRequest)WebRequest.Create("http: //api.search.yahoo.com/WebSearchService/V1/webSearch results=10&start=1&appid=MY_ID&query=sony&format=html&language=en"); restRequest.Method = "POST"; ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Displaying Static Background with DirectX9 Example?

  Can someone help this poor DirectX newbie by pointing me to an example of how to display a static background from an image file using C++ (or C#). I've read that the way to do this is to create two triangles from vertices, load the image into a texture and map the texture to the surface. This sounds great but I can't figure out how to do it from the DirectX docs. Currently, I'm trying to do it by loading the image onto an offscreen surface and using UpdateSurface() to copy it to the back buffer. This works great, except when I switch to another application or point down at the task bar the background disappears! So I'm trying to do it anothe ...Show All

• Visual Studio Tools for Office Repeating data in Word - how to?

  What would be the best method for displaying a list of header and detail rows in a word document I am not sure I understand the problem correctly, but you can look at this article that describes a method for addng repeating data in Word. http://msdn.microsoft.com/library/default.asp url=/library/en-us/odc_wd2003_ta/html/OfficeVSTO_WordToImportXML.asp ...Show All

• Windows Forms DataGridView and DataSet

  Hello, i'm trying to connect DataSet to DataGridView in Whidbey beta 1, but no data are displayed. If i connect DataSet to old DataGrid, i see '+', then table and all rows. But DataGridView seems empty. Can anyone tell me, where is problem DataSet ds = new DataSet(); ds = ... Web Service Method dataGridView.DataSource = ds; That's not supported&nb ...Show All

• Windows Forms Enclose all Properties within #region directive

  Hai .....,          How can I enclose all of the following Members within a region directive; 1. Member variables 2. Properties 3. Methods Hai vbjunkie,                  Here is the listing: //start region title if this is the first property if (propertyIndex == 0) //indicates that this is first property member { property.StartDirectives.Add( new CodeRegionDirective ( CodeRegionMode .Start, "Title")); } //end region directive if this is the last property if (propertyIndex == Prope ...Show All

• Visual C# How do I change the text on a Command Button at run time?

  What I thought would be "straight forward" code has become something very much more so.  Can someone please enlighten me I'm getting a rather confusing error: "Cannot implicitly convert type 'string' to 'bool'" Where did the Boolean come from private void buttonAdd_Click ( object sender , System . EventArgs e ) {      if ( buttonAdd . Text = "&Add" )     {          ResetTextbox ();          buttonAdd . Text = "&Save" ;     }      else   & ...Show All

• Visual C++ DateTime format{ts 'YYYY-MM-DD '} used with SQL

  I am using instances of DateTime within my application and i need their values to be used as selection criteria in an SQL select clause. So i need them to return a literal string representation of themselves in the following format '{ts '1990-01-01 00:00:00'}' Where the date can be any valid date as contained in the DataTime instance. How can i get them to do this I Thanks Martin, that neally works, i did not know you could do that with the format string. Except that the it requires the {ts' '} characters as in {ts '2006-03-28 13:06:50'} else i get SQL error. When i include these ...Show All

• .NET Development Start IE with results of WebRequest

  Given certain WebResponse data returned from a WebRequest, we would like to start an IE instance using SHDocVw.InternetExplorer. It's understood how to make the request and start the IE instance. But what is not clear is what all do we need to set on an InternetExplorer instance in order to get establish it's state "as if" it had made the request via the Navigate method Just setting the InternetExplorer.Document.body content and/or innerHTML isn't sufficient because the InternetExplorer instance doesnt' seem to know the full path of the source resources in the response document. There is probably other state like cookies, etc... ...Show All

• Smart Device Development playback of a media file from a CEPC File and Web Server.

  We currently have an issue regarding playback of a media file from a CEPC File and Web Server. Here is the current setup:   sfas   CEPC File Server: fileserv Shared folder: media Website folder: /basiconly/temp Filename: chicken.wmv   CEPC Client: ce_client   WindowsXP Client: dev3 Shared folder: shared Filename: chicken.wmv       Scenario 1: ce_client <-> fileserv Steps to reproduce:   open Windows Explorer in ce_client then open \\fileserv\media\chicken.wmv or open Media Player in ce_cl ...Show All

• Windows Forms Why doesn't this event fire?

  Add a form. Add a tabcontrol to the form. Add some tabs to the tabcontrol. Add the following code to the form. Why doesn't the TabControl1.SelectedIndexChanged event fire when I *set* the selectedIndex  How do I make it so that the event *does* fire if the value is set through code Public Class Form1     Inherits System.Windows.Forms.Form ' Windows forms d ...Show All

• Software Development for Windows Vista WinFX RTC December 2005 Not working with December Vista SDK

  There's a problem with the WinFx RTC download for December 2005.   The links on the page http://www.microsoft.com/downloads/details.aspx familyid=BD3BA2D5-6ADB-4FB2-A3AA-E16A9EA5603F&displaylang=en There's a link to download the entire WinFx RTC package instead of the "smart" installer. http://download.microsoft.com/download/9/4/9/949EEA41-364A-45DC-8F4E-47E7AC147D25/winfxrc.exe I checked the time/date stamp in the downloaded files from the WinFX RTC and the Dll's are all from 11/18/05. this is for the WinFX RTC that is linked on the downloads page indicating it was December 2005 WinFX RTC.   This happens wi ...Show All