CinoV's Q&A profile

• Internet Explorer Development Does IE 7 require .NET 2.0 runtime?

  The subject says it all. I did a quick search here and found nothing. I looked on the MS site and found nothing. ANY help / information would be greatly appreciated. Stephen, Um, you just did. :-) Seriously, I have just verified with the dev team that there are no dependencies on any version of the .NET runtime. Hope this helps... -- Lance ...Show All

• SQL Server How to write a query

  Please help me to get this result   Bellow is my requirement I have employee table which stored employee information And I have reference table which holds information for that employee reference   I need to count from the reference table like how many reference made for male Employee and female depending on their age range       I have a selection list: Gender: Male                                                     Female  &n ...Show All

• Software Development for Windows Vista Old WinPE and BootMGR

  I'm trying to load my old Customized WinPE (2005 i think) into WDS. I've tried simply making a BOOT WIM out of it and also inserting BCD store. On both i've gotten errors about Winload missing. What is the correct method of creating a BOOT WIM from and old WinPE (With I386 and stuff) Thanks. Or ...Show All

• SQL Server How can I use regular expressions in WHERE clause directly?

  How can I use regular expressions in WHERE clause directly select * from mytbl where myfld like '[0-9] * key' SQL Server doesn't directly support regular expressions. But it's easy to add them: just create a User Defined Function (UDF) which maps onto a .Net method. And >net does support regular expressions out of the box. To get an idea of how to do this, check this article: http://www.u2u.be/Article.aspx ART=RegExp ...Show All

• Windows Forms Window shrinking on restore.

  I'm using Visual C# 2005 Express to make a windows forms application. The application works fine but when I added some user settings to keep track of the window size and position, the window shrinks to no size when the window is restored. If I start the application, resize the window, and close it, it will remember its size and position on restart. When I minimize the window and then restore it, however, it briefly returns to it's original size (a fraction of a second) and then resizes itself to have no client area at all. I can then manually resize it to it's original size. What is going on Thanks for any help. Bob Don't you have code in the form's resize event like Properties. Settings .Default.ClientSize = t ...Show All

• SQL Server front end for cubes

  currently i use MSInsight as my cubes front end. its an asp page that users can build reports from cubes. its pretty old, and since ive started upgrading to AS2005, it doesnt work properly, leading me to think that it is not compatiable with AS2005 cubes. so im wondering, whats a good front end that can be used by many users this rules excel out, as i need a front end that can be used my many users. There's a lot out there to choose from; see http://www.mosha.com/msolap/util.htm as a good starting point. What kind of front end are you after You should also check out what's coming in the medium term with PerformancePoint, which is based in part on the technology that Microsoft acquired from Proclar ...Show All

• Visual Studio 2008 (Pre-release) MouseEnter + grid row + animation problem

  Hello. I've a little problem and may be you can help me. I've a grid and in the last row there's a part of an Image, when the mouse is over than the Image goes up, like a bar that appear and disappear. The problem is that the mouse enter and leave events only occurs in the small grid part and not in all the image taht I move. So the quiestion is: Is there any form to set the grid row height by a trigger : I have a trigger like this to the animation, can I attach some code to set the grid height < EventTrigger RoutedEvent = " Mouse.MouseLeave " SourceName = " foot_Bar " > < BeginStoryboard Storyboard = " {StaticResource Anim_Foot_Bar_Close} " /> </ EventTrigger > I ...Show All

• SQL Server Doing a keyword search inside the contents of the stored procedures of a database

  Is there a way in sql to do this: To get all the stored procedures of a given database, then either - (1) put all the stored procedures contents (all the scripts inside the SPs) in a single file or - (2) Put all the scripts that constitute all the SPs in a single big string. Then search that file (if case 1) or that big string (in case 2) and check if it includes a given input pattern (for example check if includes: mySearchedKeyword) Thanks a lot This is fairly straight-forward. Here is one method: SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '% mySearchedKeyword%' ...Show All

• SQL Server Mdx Expressing for Calculated Measures

  Hi, I am new to SSAS and MDX; I am trying to create a calculated measure with CREATE MEMBER CURRENTCUBE.[MEASURES].[Consensus Forecast - FCDT] AS IIF( ISEMPTY([Demand Forecast .[Forecast Type] ) OR [Demand Forecast].[Forecast Type] = 'CONSENSUS' OR ISEMPTY([Measures].[Forecasted Qty - FCDT] ),0,[Measures].[Forecasted Qty - FCDT] ), This calculated measure is always giving me zero, Is this a valid query which will return me the Forecasted Qty Can anyone Please point me to the issues here about the Dimension Attribute Checking Thankyou Vidya I am sorry...it was a typing mistake , and the expression parsed correctly and it doesn't give any errors. I would like to know if the expression wrote above will rea ...Show All

• SQL Server Primary Key Question

  I have been developing a .NET Web app with an SQL Server 2005 Express database. Since I've been testing insert and delete code with a large data source, the Primary Key column which is also an autoincrement integer column is now at very large numbers (starting at over 40,000 now). I've tried doing a shrink on the database, but other then reducing the database size, it has done nothing to reduce the Primary Key numbers. Is there a command way to reduce the starting number back to 1 or do I need to completely reconstruct the database from scratch TIA Thank you, Sir. Yes, it did work and in the process I've learned more about SQL Express and T-SQ, important for a relative newbieL.  Not onl ...Show All

• Smart Device Development Emulator load time

  It takes several minutes to load my emulator image in Platform Builder. If I am working on a single dll, is there a way to speed the cycle time and only load my dll as I change it Unfortunately, no, there is no straightforward way to speed up this cycle. There is a hacky way though... use RELFSD ( http://msdn.microsoft.com/library/default.asp url=/library/en-us/wcedata5/html/wce51conReleaseDirectoryFileSystem.asp ). The idea here is to build an emulator image where your DLL is *not* listed in any .bib file, so the DLL is not present in ROM. But leave the registry settings and any other references to the DLL in the image. Whenever an app tries to open your DLL from \Windows, the ROM filesystem will fail ...Show All

• Visual Studio 2008 (Pre-release) Pixel manipulation

  How do I change pixels in a bitmap I've only seen examples of creating new bitmaps from an array of values, but I need to be able to set pixels in an existing bitmap without the overhead of re-creating it from scratch every time. Can I lock bitmaps like with System.Drawing.Bitmap and manipulate memory directly Not in XBAPs of course, but for desktop apps I think you want System.Windows.Media.Imaging.WriteableBitmap I've never personally used it so I can't give you much more advice than that. David ...Show All

• SQL Server Call ReportBuilder from Access

  Hi, I have created a report with ReportBuilder for WIndows and now I would like to call and run the report from MS Access. Anyone knows how to do it Your help/suggestion is appreciated. Thank you ...Show All

• SQL Server How to display money type data with commas every 3 digits?

  How to display money type data with commas every 3 digits I tried : CONVERT (money, ProjectCost, 1) AS ProjectCost but it gives me the type as 1234.56 no commas in it can anyone help me with that thanks! SELECT CONVERT ( varchar ( 20 ), CAST ( ProjectCost AS Money ), 1 ) AS ProjectCost, CONVERT ( varchar ( 20 ), ProjectCost , 1 ) AS projectCostInMoneyDataType FROM yourTable ...Show All

• Visual Studio 2008 (Pre-release) Hints on implementing a custom control for histogram needed

  I want to create a custom control that just displays a histogram and has events when I move the mouse over it in order to display the value in a tooltip or in a status bar. So I need some advise as what would be the best way to do this At the moment I have a class derived from Control (to use it in the main window xaml file and for easy databinding of the real histogram) that contains a child that is derived from FrameworkElement which then contains the VisualCollection with the histogram lines. Is this OK I think I need a canvas in my control so do I put the canvas in the XAML template of the control or create it completely in the code behind file As the histogram can contain up to 4096 columns I wonder if I can just put so many lines the ...Show All