Salman Maredia's Q&A profile

• SQL Server How to change the datasource view of a mining model.

  Hi, I created on model in Business Intelligence Development studio.I wants to change the datasourceview(dsv) assigned for that view.for e.g My mining Model is StudModel.dmm. The dsv for that model is StudDSV.dsv. I wants to change the dsv for that model to marksDSV.dsv. How to do that in Business Intelligence Development studio. Thanks, Karthik. The BI Dev Studio does not provide you with much support for this task. You can change the DSV manually. It may be very easy or more difficult, depending on how similar the new DSV is compared to the original DSV. Here is something you can do, manually: - close the Mining structure designer window - open the DMM file in BI Dev Studio (right click and select th ...Show All

• Visual Basic circular references between usercontrols and 'main' form in vb6->.net upgrade

  in upgrading from vb6 to vs2005 user controls are introducing a circular reference problem in the following way. In the vb6 solution, user controls could access methods in the 'Main Form' upon which the user controls are used. In VS2005, I create a separate Windows Control Library Project for each User Control. For composite controls I 'reference' any other controls as needed. However, there are controls which call methods/functions on the 'Main form' within a Windows Application project. That project includes the references to all the user controls ( which show up in the ToolBox.) Circular references have been introduced which didn't exist before. The Mainform references the User Control. The User Control calls MainForm methods. ...Show All

• .NET Development String and Like

  Is there a Like operator that can be used with the String class You can use the Regex class, for example (copied from MSDN): using System; using System.Text.RegularExpressions; public class Test { public static void Main () { // Define a regular expression for currency values. Regex rx = new Regex(@"^- \d+(\.\d{2}) $"); // Define some test strings. string[] tests = {"-42", "19.99", "0.001", "100 USD"}; // Check each test string against the regular expression. foreach (string test in tests) { if (rx.IsMat ...Show All

• Visual Studio Tools for Office Manage Scope For Commandbar buttons

  Hi, I have created three commandbar buttons for Sheet4 of the Excelworkbook. But when I run this application with Sheet3 as the starting sheet, I still getting these button on the toolbar on sheet3 even. As per my requirement I want these commandbar buttons should appear only when user starts sheet4, for other sheets it should be invisible. This problem get solved when I start application with sheet4 as startup sheet. Then there is no commandbar buttons on other sheet. It means only for when I start application with sheet4 not as startup. I have added code for creating commandbar buttons on sheet4_startup. Please assist me here. Thank you Prashant, Working with commandbars and scop ...Show All

• Software Development for Windows Vista Value of the OpacityMask attribute

  Hi, I'm just wondering what kind of values should be inputed for the OpacityMask attribute of the Path element. I've seen several examples of <Path.OpacityMask> and other <Element.OpacityMask> in the XPS documentation but I have never seen an example where the OpacityMask attribute was given a value. Does anybody here know what type of value is inputed under the OpacityMask attribute Thanks, av.arce If you're using the property=value syntax, the value can be a solid color brush or a reference to a brush in a resource dictionary. As you do not really need to use a solid color brush as OpacityMask (Opacity will just work), a brush is more meanful. Eg: OpacityMask = "# ...Show All

• Silverlight (formerly WPF/E) Support for Streaming Servers ?

  I am currently trying to find out if support for any streaming architecture has been implemented in the FEB2007 release; ideally the Windows Media Server WMS architecture. I would like to be able to access streaming content under any of streaming protocols ideally rtsp:// or mms://. Our architecture is setup on WMS and I am typically working with 45-90 minute recordings. Due to the limited support for WMP on Mac OS X as well as compatibility issues with the latest Intel based macs, I am very eager to be able to replace the embeded WMP with a WPF/E based player, however I need the ability to seek to random points in a file. Also in looking at the docs, WPF/E is said to support WM9, I was wondering if it will be suporting all WM9 codecs ( ...Show All

• Smart Device Development how to invoke a popup menu on menubar without clicking the softkey

  hi, I have a menubar "Done" and "Menu", Done is "button" and "Menu" is a popup menu with 2 items. I would like to popup the menu items when user press the action key but I have no idea what message to be sent to or to which window. Is there a way to accomplish that thanks in advance. Hi, I think sending the appropriate WM_HOTKEY message corresponding to the hardware button associated with the menu item should do the job of popping up the smartphone menu. In case you want to popup a new menu programatically all you need to open a new menu shall be to load the menu and use TrackPopupMenu API. You may find this interesting: http://www.codecomments.com/archive372- ...Show All

• Visual Studio Express Editions Adjusting audio levels

  Im wanting to adjust audio levels. Any hep please. (I have 3 slider controls; Master, Left and Right) Thanks. to run an external program look at the System.Diagnostics.Process class. you can also use its assistant the ProcessStartInfo class which you can customize how the process should run. System.Diagnostics.Process.Start("path\file.exe") 'example ProcessStartInfo class: http://msdn2.microsoft.com/en-us/library/system.diagnostics.processstartinfo.aspx ...Show All

• Visual Basic txt files

  How can I access text files in VS2005 and display them in Arrays   Any help or websites containing a "How to" would be greatly appreciated.   Thanks! Also, more information on split() method of the string class what exactly do you mean access text files and display them in arrays you can read textfiles using the My namespace, or directly accessing the System.IO namespace. But for simplicity, lets use the My namespace (but underneath the System.IO approach is used) Dim theOutput as String = My.Computer.FileSystem.ReadAllText(" path\file.txt ") and thats it! what do you want to know about the split method http://msdn2.microsoft.com/en-us/library/system.string ...Show All

• SQL Server SubQuery gives Incorrect syntax near ')'.

  Dim sql As String = "SELECT InvID, SomeData, (SELECT SUM(AmtPaid) AS Expr1 FROM (Test2) WHERE (Test1.InvID = InvID)) AS Expr1 FROM Test1" Using myConnection As New SqlConnection(ConfigurationManager.ConnectionStrings( "ASPNETDBConnectionString" ).ConnectionString) Dim myCommand As New SqlCommand(sql, myConnection) myConnection.Open() Dim reader As SqlDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection) When executed the above throws the error below. The strange thing is this query was built and works in the Visual Studio query builder but when I copy the sql to the page to use it, it fails. I have other query/subqueries that work fine, I cannot seem to find why ...Show All

• Visual C++ activeX control

  hello all, it's my first post here , and i think i'll start to visit here. anyway, i wrote an activeX control with some property page. in the prop pages, there are edit boxes. if the edit box is empty, and i click on the tab (property sheet), my activex is crashing. how can i catch this and prevent the crash thank you, c'ya no, there are two scenarios. 1. when the activex is compiled in Debug - then i got the "Debug assertion failed" window. 2. when the activex is compiled in Release - i got a blank msgbox, with the MB_ICONEXCLAMATION, and the software continue to work. again, it happens when one of the edit box in the control property page is left blank (this value of the editbox ...Show All

• Microsoft ISV Community Center Forums Protecting formulas in cells

  Hello, Other than coding formulas, is there a way to protect a cell in an excel spreadsheet, no mater, if the sheet is protected or not, so that formulas can not be erased or overwritten Thanks Chrstdvd Well Andy, I mean that I have a macro that has code like this Range("H22") = "=Sum("A5:A16")". I had the idea to just make a macro that repopulates the cells with the formulas prior to the Save command. That would at least have the formulas ready for the next days work. I will not go into why or how the store managers erase them. Most of the time all I hear is: "The computer just did it". thanks Chrstdvd ...Show All

• SQL Server AS2005 Performance issues

  Hi, We are currently looking into AS2005 performances for one of our client. For some reason the 'cubes' are not giving us the performance we were expecting. Her is some info about our environment. Server: 2 * Dual 2.8 GHz with 4 GB of memory The fact table has around 30 millions of records for three years worth of sales history, and we have created 1 partition per year. We are using MOLAP with aggregation level at around 40%. The biggest dimension (Product) has 45 000 members, with 2 manual hierarchy and many attributes hierarchy. Attribute relationships are setup properly in every dimension. They are using OWC11 to access the AS2005 server. Everything is running pretty smouth but as soon as we try to hit the lowest leve ...Show All

• Visual Studio VS 2005 Pro SQL Version

  Which Edition of SQL comes with VS 2005 Pro The VS 2005 Product Comparison shows it coming with SQL Server Developer Edition (which is what I need). But the Trial version I downloaded came with SQL Server Express, which doesn't include any of the BI tools I need. The product comparison here is incorrect then: http://msdn.microsoft.com/vstudio/products/compare ...Show All

• Visual Studio 2008 (Pre-release) Xaml Syntax Errors - Newbie

  Hello, I am new to WPF development so this should be easy for you pros. I am working with some of the June example projects but I get syntax errors on items that are valid according to the schema . Is this a bug / beta /ctp issue or do I have the wrong bits on my box. Most programs run fine but are these warnings keep appearing. Does everybody getting the same error Thanks !! < Grid.Resources > < Style TargetType = " {x:Type TextBlock} " > < Setter Property = " FontSize " Value = " 14 " /> < Setter Property = " FontFamily " Value = " Verdana " /> </ Style > < Style x ...Show All