dknapp's Q&A profile

• SQL Server USE MULTIPLE ROLES IN CUBE BROWSING

  Hi, I'm developing a cube browsing aspx application using the OWC11 controls, both Pivot and Chart, associated with Analysis Service on SQL2005. I did quite a bunch of that but now I'm having some troubles to solve the following problem. Using the SSAS IDE, I defined two Roles in a Cube and I defined a filtering function on the dimension in both of them. When I choose each one of them and I check the functionality they works because I can see what I expect to see, only one result from a dimension where the filter is acting in the role definition . But, if I choose both of the roles, and I can do that because it let me select the two checkbox instead of all (having more than two Roles), the filter doesn't work anymore, showing a ...Show All

• SQL Server Lookup Transformation question

    Hello, I have a table like this: Customer Group A 10 B 20 I need to do a translation of "group" to “local group”: Customer Group Local Group A 10 11 B 20 21  When a match is found, the group code should be replaced by the local group code ... but, when no match is found the group code should stay.   Is there any way to do this using Lookup I tried but when you set the error output to ignore it replaces the value that has no match with a NULL value. Maybe there is another way to get this done with or without the lookup component ...Show All

• .NET Development coarse exception granularity

  I'm struggling with what I perceive to be a very coarse level of exception definition in the framework. Even though my example is related to a database, I think it's probably more appropriately asked here, since I think the issue is wider than ADO. If not, I'll repost in the appropriate forum. Doing the following, the same exception is thrown, though the error is actually two very distinct things. dim sSql as string = "" dim DS as DataSet dim adaptor as OleDbAdaptor = new OleDbAdaptor(sSql, dbConnection) adaptor.Fill(DS) throws System.Data.OleDb.OleDbException, with a message that says " Command text was not set for the command object." However, sSql = "select * from foo" where table foo d ...Show All

• Windows Live Developer Forums Retrieving Lat & Lon from an address without a map

  I have a web form that enables users to enter an address, and is supposed to return a latitude and longitude for that address. Unfortunately, I've been unable to find any articles or code that can return these values. Any help is greatly appreciated. Thanks! Uauh.. this code is great. I need one link like http://local.live.com/search.ashx that retrive the distance between 2 points. Anyone knows if it possible Thanks ...Show All

• Visual Studio Macros not working in Vista

  Macros do not work in Vista. I'm using Vista Ultimate rtm. I can not find any threads here discussing this issue but found this link thru google: http://connectbeta.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=225977   Macro debugging does not work either. Is there any workaround of fix other than ditching Vista and going back to XP I've been running VS on Vista for quite a while, and I seem to recall having problems with macros at one point, though it doesn't appear to be a problem anymore. Did you by chance install SP1 for VS 2005 I do have VS2005 SP1 on my Vista machines too, so that may be why the macros aren't running. Sincerely, ...Show All

• SQL Server money format

  Hi. I have a money field and its value is greater than a thousand.For example its value = 32.885,60 I want to show the field's format like this (this number's format). I mean the thousand separator should be .(dot) and the decimal separator should be ,(comma) And I want two digit after the decimal separator.All these conditions matches with this number(32.885,60) Could you help me You can accomplish this by adjusting the Language property for the textbox, or the entire report to a language that uses this format. The language settings can be specific to just number formats when just setting the NumeralLanguage property on the textbox. After setting these properties, just use "N" as the format code. See t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. AnimationSet - where do I define what frame/bone this animates?

  Hi, I want to animate boned model in c#. I create KeyFramedAnimationSet, but I did not find, where to set in this animation, what bone/frame should this AnimationSet move/scale/transform Where the frame choice is   txs So after few weeks, I found how to solve this problem. I am creating application (c#, Direct3D), where user can animate a character model. So he loads his boned .x file model, creates few key frames, set bones position and save to .x file. I couldn't solve these two problems: 1) when I create AnimationController, where do I set, what mesh does it use solution: static method  Frame.RegisterNamedMatrices(rootFrame.FrameHierarchy, myAnimationController)   2) When I create Ani ...Show All

• SQL Server SQl server - Full Text Index and Search

  Hi, We have a scenario where a search is made to a table based on CONTAINS and hence the field is Full Text Indexed. But because the table size has grown over the years to a figure of more than 6 million records, at times during some conditional search on the full text indexed field the CPU and response time increases to quite high values. This in turn affects the other operations happening on the sql server. After going through some of the sites(for e.g. - http://www.sql-server-performance.com/full_text_search.asp ), I found that the allocated Virtual Memory in the sql server should be very high approximately 3 times the size of the avaliable RAM. Also, we have come up with some other steps that can be taken to better the performanc ...Show All

• .NET Development Setup project problem

  Hi, I have to create a Setup Project. My Project have some .dll files. In Setup i have to check one condition, If Oracle Client is installed in the client machines,I have to omit some .dll files.Otherwise i have to include those .dll files to bin folder. How can i create setup project . How can i launch conditions . Help me. Thanks in advance. Regards Nataraj.C The question should be asked in .NET Framework Setup , I moved it ...Show All

• SQL Server Select * & table name issue (Reserve world)

  Hi All, We are trying to read a table name Order through command line SQLcmd. But it is giving us an error. Order is an SQl2005 reserver word and app programmer created that table who left. No we have problem to read that table through sqlcmd. any ide a how we can do that. C:\>sqlcmd 1> use ACCMedford 2> select * from 'Order' 3> go Msg 102, Level 15, State 1, Server ACCMedford, Line 2 Incorrect syntax near 'Order'. 1> select * from "order" 2> go Msg 102, Level 15, State 1, Server ACCMedford,, Line 2 Incorrect syntax near 'order'. 1> select * from order 2> go Msg 156, Level 15, State 1, Server ACCMedford,, Line 1 Incorrect syntax near the keyword 'order'. Hi , Your Database might ...Show All

• Windows Forms splitContainer problem/bug in .NET 2

  Hello, I want to draw nice splitter in splitContainer. To do this, I call method below in splitContainer1_Paint event. private void splitContainer1_Paint( object sender, PaintEventArgs e) { ProfessionalColorTable pct = new ProfessionalColorTable (); Rectangle bounds = (sender as SplitContainer ).SplitterRectangle; // Make sure we need to do work if ((bounds.Width > 0) && (bounds.Height > 0)) { Graphics g = e.Graphics; // Setup colors from the provided renderer Color begin = pct.OverflowButtonGradientMiddle; Color end = pct.OverflowButtonGradientEnd; // Make sure we need to do work using ( Brush b = new LinearGradientBrush (bounds, begin, ...Show All

• Visual Studio Modifying File/Item Content Programmatically

  Hi All, I've posted this question some time ago along with another question. But because it is not answered yet, I repost it again. This question is about modifying the content of an item in the project. The item could be a C# file, or XML file, or text file etc. I found a DTE automation interface, EnvDTE::FileCodeModel, that has methods that do similar thing with what I want. The differences are: 1. I want to be able to not only modify source codes, but also other files (XML, text, etc). 2. I'm really trying to not use DTE automation. My scenario is, I find the item that I want to change with IVsRunningDocumentTable.FindAndLockDocument(), and then I want to modify its content with an event, for instance. Then the questions are: 1. Is the ...Show All

• Smart Device Development Dll Import from Regular C++ to C#

  Hello, I am developing a smart device application in VS.NET 2003 and want to import dll from C++ program. [DllImport("mydllimportTest.dll")] public static extern int GetInt(); While the import command works fine with normal windows application project, the following error is generated in smart device application. "An unhandled exception of type 'System.MissingMethodException' occurred in.." Can you please help me out Thanks Tijnars Hello, I installed vs.net 2005 and still at the same point. With VS.NET 2005, the error message is more descriptive. " COM object with CLSID '{2AF1578B-3628-49E8-B0FF-6C86A41C8F8A}' cannot be created due to the fo ...Show All

• Visual Studio 2008 (Pre-release) Use XAML control within another XAML?

  This should be easy. I have a XAML file and want to use another object I created (also in XAML) within that file. For example < UserControl x:Class = " UserControlTest.MDIUserControl " xmlns = " http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x = " http://schemas.microsoft.com/winfx/2006/xaml " xmlns:my = " clr-namespace:System;assembly=mscorlib " Width = " 836 " Height = " 495 " Opacity = " 1 " MinHeight = " 30 " MinWidth = " 30 " Background = " #00FFFFFF " " > <Grid> <MyControl> ..... </MyControl> </Grid> </Window> ...Show All

• Visual Studio 2008 (Pre-release) No master page?

  It seems that there is no mater page in WPF. And someone has advised to use Frame. But now I am developing several pages. These pages share a list of properties(These properties just belong to the pages, so I don't want to store them in Application Properties). When I extract them to a BasePage, and make those pages inherited from the BasePage, I get an error "Partial declarations of 'Page1' must not specify different base classes " I am afraid this can't not be solved use Frame. So, do I get a wrong way How to do that Thank you. Dear LeoXue, Try using ControlTemplates if you do not want frames. HTH, Suprotim Agarwal ...Show All