SViking's Q&A profile

• SQL Server Calculating last non empty of measures that are not included in a month

  Hi! I have two tables. One is measures like this Product Measure Date Prod A 10 12, Jan 2006 Prod A 15 20, Jan 2006 Prod A 11 5, Mar 2006 The other is time dimension When I create a cube, I would like to see by months last value of measure. So in Feb I should get 15. My question is - should I create a query and run it on server to 1. Find which months are not icluded in measuers 2. Then find last value for each product 3. Write into new table measures, where February will have last non empty value from January Or can I do it cube in some way ...Show All

• Software Development for Windows Vista RichTx32 merge module

  I have an application that uses the RichTx32 control, installed via the richtx32_x86.msm. On some machines running Vista, there's no error that I can find but the application claims the control is not registered on the machine. The other odd thing is that the machines where the failure occurs are all virtual machines (so far, anyway, but I have a hard time believing that makes any difference). Is there an approved way to get this control installed on a Vista machine I have some follow-up from internal resources: How are you trying to install RichTx32 Have you tried regsrv32 from an elevated command prompt Are you able to provide the application for a repro A ...Show All

• SQL Server problem with job

  hy, i have made a package that fills a sql server 2005 database. when i run it locally it runs all the way, no errors. Now that i have deployed the package en work with a job that executes it every day i get these errors. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009. and component "Source - BU" (1) failed validation and returned error code 0xC020801C. the strange thing is i don't get an error on the first dft which uses the same connection. i have pressed the test connection button and it states connection succesfull. any help would be appreciated. Greetz, Jens Hi, I am using SQL 2005 Integra ...Show All

• Windows Forms How to: Webbrowser NewWindow and Navigating equivalent to axWebbrowser

  At first, I enjoyed the new webbrowser control but then I noticed that the args provided by the events NewWindow3 and BeforeNavigate of the axWebBrowser had not been implemented in the new control. Arg. Good news, the guys from Microsoft gave us the a workaround recently in C# and said they will publish a sample soon on MSDN. In the mean time, here is some VB.net code inspired from Microsoft's C# that will give you 2 new events and the args people like me were crying for. NavigatingExtended gives you the following args: - Url as string - Frame as string - Headers as string - Postdata as string - PostdataByte () as byte - Cancel as boolean (to cancel navigation) NewWindowExtended gives you the following args: - Url as s ...Show All

• Windows Forms DateTimePicker bind to DataGridView Issues On Displaying Blank Date

  hi, I got two (2) problems on this. 1. by reading alot on the forums/thread, I learned that to display blank date is by using CustomFormat = " ". At the same time I added code in ValueChanged to set value to mindate if text length is zero. My problem right now is that if the last value is min date and when I do a dropdown to select the date, the date choice is on the min date (eg. Jan 1901) which can cause trouble to get to the current year (need to click right arrow keys alot of times). Can I default it in a way that the calendar month that would be display on dropdown is current date I tried OnDropDown and change value to date.today but still doesn't work. 2. the datetimepicker is already displaying blank date, ...Show All

• Smart Device Development Playing MPG

  Hi, does WMP 10 in PPC support mpg files. If not howcan I play them is there any codecs to integrate in my application to play them. Thanks in advance WMP 10 Mobile does not use DirectShow and is unable to play MPEG files. Without discussing the wisdom of this decision, I suggest getting a 3rd party player such as PocketTV or similar. ...Show All

• SQL Server ODBC driver needed for Compact Edition

  I have the newest 'Everywhere' Compact Edition installed, and have created a new desktop database using VS 2005 after installing the VS 2005 SP1 Beta, all successfully. I have no need to use the Mobile components and no need to syncronize to a mobile device. I can connect to the database programatically in VB.NET no problem. Instead, I want to connect to the desktop database using MS Access. So far, I can't connect using the standard (old) SQLServer ODBC driver, and haven't found any new driver, either. Am I just premature and need to be patient Does anyone know if there's one in the works Or am I the only one to have thought of it Any help would be appreciated. Thanks Merle Nicholson ...Show All

• SQL Server config page.header style in css

  Which tag should i add to config the page.header style in the css file ...Show All

• .NET Development how to SPLIT an ADO recordset ?

  can anyone tell me how i can split an ado recordset for exmple if i have 1000 records in my recordset how can i split it into 2 recordsets of 500 records each Classic VB (ADO) question answered at DevX. http://forums.devx.com/showthread.php t=157286 ...Show All

• Visual Studio 2008 (Pre-release) How can I send message to special peernode not the whole mesh

  How can I send message to special peernode not the whole mesh I mean not broadcast message to whole mesh thanks Hi WindWang, It is currently not possible using a PeerChannel to directly send to a specific peer. However, an application can learn about endpoints of each peernode and choose to establish private communication between peers. Could you please elaborate on your design that required you to send direct messages thanks, -ram pamulapati ...Show All

• Audio and Video Development WinAudio sample problem - error code 0x88890008

  Hello, I'm not very sure this is the place to ask this, but please help - I've built the WinAudio sample from the Microsoft Vista SDK and tried to play a stream from the microphone. The function PlayCaptureStream is called but pClientOut->Initialize(...) fails with error code 0x88890008. Does anyone knows what code 0x88890008 means Thanks, Alex WinAudio isn't part of Media Foundation -- try posting your question here: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=351&SiteID=1 For what it's worth, I'm not familiar with that error code. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Fullscreen problems....

  EDIT: I am using Beta 2. I use this as the constructor method... public Game1() { graphics = new GraphicsDeviceManager(this); graphics.PreferredBackBufferWidth = 640; graphics.PreferredBackBufferHeight = 480; graphics.PreferMultiSampling = true; graphics.ToggleFullScreen(); content = new ContentManager(Services); } Works great. But when I change the resolution to 800x600, all I get is a black screen. The loop is still running because I can still quit the program. I have also tried 1024x768, that works too. Thought maybe it was an aspect ratio problem, but they are all the same, 1.3333... I have tried turning the multisampling off to no avail. Didnt think that would be it anyways, I play World of Warcraft at 800x60 ...Show All

• .NET Development Problem using Reflection

  I got a method like this private void Add() { string str="This is test" } Now if I want to display the  method name that contains the string "This is test" using reflection How do I doit Any suggestion or code snippet is highly apperciated Aneel ...Show All

• Visual C# Using Enum as Index

  If I have an enum such as public enum Test { One = 1, Two, Three } I want to be able to add a value based on the enumerated type such as: MyValue[Test.One] = 17; I would also like to keep ot strongly typesd so MyValue[1] = 17; is invalid. Is this possible within C# n0n4m3 is right about the cast. But if you want type safety you will have to program that in. I suggest you use a Dictionary object. I used int for the key but you could use the actual enumeration. In the example I show how to add to the array and enumerate it both as a dictionary and using the actual Enum object! public enum Enumbers { one = 1, next = 12, final = 100 }; public ...Show All

• Visual Basic How Do I Create Table Relationships?

  What is the best way to create relationships between SQL tables. (ex: relate Customers to Orders to Details in an IDE ) - Use the Dataset designer in VS 2005 - Use the Server Explorer's Table designer in VS 2005 (I'm not sure how to use the 'relationships' icon) - Use SQL Management Studio's Database diagram node and drag connections between tables - Something else I have tried using the DataSet designer but while it looks like it works, when I switch to SQL Management Studio Express and try to create a Database Diagram, all the relationship aren't there. However, if I use SQL's Database Diagram designer then all the relationship seem fine in VS. Is there a URL that can point me to best practices on relating SQL tables Thanks Richard ...Show All