Brain_Dead_Mind's Q&A profile
SQL Server Measure values for Invalid hierarchy memebers
Scenario ------------- A measure group is related to Time dimension at the Month level, has only the month_id column. The Time dimension also has levels defined below 'Month' like 'Week'. In the cube browser, when the measures of this measure group are viewed with the Time hierarchy below the Month level, values for week are copies of the Month values. How can this incorrect representation be avoided Can zero or n/a values be shown when we drill down to week values. It is like Sales Plan amounts are only defined at month level, the same amount being shown at the week level is incorrect. Regards mat There is a property associated with "Measure Groups" called "IgnoreUnrelatedDimensions". By default this ...Show All
Visual Basic Advanced Validation Control ?? HELP
Hi I am writing a large program ( Windows Application )where I am using three text boxes. I am performing validation controls on these text boxes however there are some conditions Names of textboxes x y z The conditions are x , y , z should be numeric. x and y can be blank ( x = “” , y = “”) at a time z can never be blank, it should always have a numeric value. if x has a value y cannot be blank and x should be non negative if y has a value x cannot be blank and y should not be non negative. if x and y have values y > x z should be non negative A message box should pop up each time the user clicks a button with the appropriate error ( eg : x canno ...Show All
SQL Server Login failed for user "David". Reason: Not associated with a trusted SQL Server connection.
I am very new to SQL Server Express, so I watched the video on how to create permissions in SQLSE. I did what I seen, and I still cannot connect to the specifed database. I did create a login account in the main part using SQL Auth., then I create a login account in the database, and set its role as dbowner. After all that I disconnected the object explorer and tried to use the account that I just made and it didnt work, I also went to VBE and tried to connect from within the database explorer and I got the same error above. I can go to a different pc and try to connect with the same result. I did watch the video again to make sure that I didnt miss up and what I did was right by the video. I did try to set another name and ...Show All
Visual Basic bitmap to Picturebox throught network
I have a System.Drawing.Bitmap and I want to display it to another program's picturebox throught a network (localy or internet). How can I do it ...Show All
Visual Studio Express Editions database and textbox question?
i have a problem regarding in textboxes... how can i retreive the data using textboxes instead of datagrid because my boss want to edit the details in textboxes....and also to move to the next items and previous items... like in a video(tutorial) i dont know how to use bindingnavigator and bindingsource using code...pls help me That's a large question. I don't know whether you are using Access or SQL. If you are you using Access, connect to the database using the namespace: Imports System.IO Imports System.Data Imports System.Data.OleDb Imports System.Data.Common If you are using SQL use SQLClient instead System.Data.OleDb. Connect to your database. and read a table in memory and learn about tables. Play w ...Show All
.NET Development How to know what exceptions a method can throw?
I was reading in some other posts that you only have to catch known exceptions. And that it is not allowed to catch Exception like this: private void CheckCancelEntryWeighingRecords() { try { mis.Transfer(data.CsvData); //Call to a third party dll } catch (Exception ex) { LogError("Error occured in CheckCancelEntryWeighingRecords", ex); } } How can I know what exceptions a method can throw So that i can decide on which situation i can recover and on which not I know that the Framework.NET has documented the most exceptions. But what about third party dll's with bad of no documentation I also know i could use reflector to look what the possible exceptions a ...Show All
Visual Studio Source Safe
Hi, I am using Visual Studio 2005 Team Edition for Software Developers. Everytime I open my project, its getting update from Source Safe, which I don't want everytime.. How can I disable this Thanks Tools -> Options -> Source Control -> Environment -> uncheck "get everything when a solution or project is opened" ...Show All
Visual Studio Express Editions visual web developer book
i registered visual web developer to get free book. when i will receive that book When you register the product you would use a hotmail account or some other passport account. Once done the system sends you an email to that account with the details to verify and log on to the connect site. The connect site is (connect.microsoft.com) a site where you can sign up for betas and other systems, one of these is the offer for the express products. But we have seen that once you get the email it can take up to 48 hours for the access to be granted to the user. I would wait till then if nothing has happened forward the email that you recieved with your registration to the support groups for the connect site (You can get there informatio ...Show All
Audio and Video Development Markup Performance
I wrote a complete menu (including scrolling chapter menu with rotating images) in pure markup. The XMU file has in total about 1500 lines. Unfortunately I notice that it runs quite slow on HDiSim and in Players. Are 1500 lines too much for xmu Hi DrumAllDay Can you please elaborate why the above improves performance. In my understanding , both options as presented should have same performance. thanks ...Show All
Visual Basic MP3s
How to run an mp3 file in the same window(NOT TO OPEN windows media player or real player etc...) by using a play click and how to stop it by clicking a stop button, and also a pause button. I need full code for who know. sure buddy. download the DirectX SDK: http://www.microsoft.com/downloads/details.aspx FamilyId=05DA7623-F2F9-4F57-91AA-6DB27FB8305F&displaylang=en install it and view sample codes with it also, as well as reading the documentation to add a reference to the assembly, simply right click on references in your project in solution explorer, go to "Add reference" and select Microsoft.DirectX and Microsoft.DirectX.AudioVideoPlayback ...Show All
Visual C# multithreading
I need to do multithreading. It is my fist attempt. It failed. This is the setup: There is a form with tabControl and a few pages. There is a progress bar on one of them. It is supposed to measure progress of file downloading. WIthout multhithreading it is dead while the files are downloaded and then in the end it jumps to 100%. This is what I did. Everything compiled but the progress never was activated even after the downloading was over. In other words my code actually made the things worse. In the main form I put in this code at the start of procedure that is handling the download: ThreadStart threadDelegate = new ThreadStart ( Work.DoWork ); Thread newThread = new Thread ( threadDelegate ); newThread.Start ( ); T ...Show All
Visual C# Internet Transfer Control
How can I find a source about ITC (Internet Transfer Control) with c#.net because all the sources with VB and I want just one with c# can any body help me (I am in a problem).... thank you in advance Hello Adorer. You do not really need to use the Internet Transfer Control anymore. It is a legacy control and if you are working with C# .NET then you have things such as WebClient (2.0) and httpWebRequest that can easily get/downloadweb pages, download files, and much more. Let us know what version of C#.NET you are using and what you are trying to do and somebody will be able to provide code. Thanks. ...Show All
Visual Studio Express Editions Reading 2 lines from a file
Hi all! It's me (again). I feel really frustrated, because I know that I'm so near to achieving my goal, and yet it seems so far! Problem: I have a text file with 2 lines (it will always be the same): - Line 1 defines the name of the "Plugin" - Line 2 defines the executable path of the "Plugin" A directory (sampledir1) contains an amount of files structured like this. Is there a way to add the names of these "Plugins" to a listbox, but also assign a value to that item, so that when the item is selected, the plugin will launch. Please don't get mad at me for asking so many questions - I'm still a newbie... Thanks! Johannes Hi Spotty Thanks - that helped me a lot, but now, I also want to put in a cas ...Show All
Visual Basic Converting a dll to a windows exe that will accept command line parameters
I have a dll in vb 2005 winforms, that has a gui interface, and accepts command line parameters. I need to convert the dll to an windows exe file, and still accept command line parameters. Any advice how to achieve this Thanks Change the project type to "Windows Application", and then change the startup object to "Sub Main". Your main method will then be called when the application is invoked. -Scott Wisniewski ...Show All
SQL Server sp_executesql From App's Dynamic SQL Causing Performance Problems vs. Query From SSMS
Okay, so I came across an odd performance issue that I'm wondering if some guru can help me out with. I have a query that uses a paging algorithm that uses a paging algorithm and a table variable, then gets a page of data based on a join to that table variable. Here's a simplified query using the algoritm: --declare table variable... not shown for brevity --make sure we only store the least amount of records possible SET ROWCOUNT ( @pageNumber + 1 ) * @pageSize --insert into table variable INSERT INTO @TableVariable( Key ) SELECT key FROM table WHERE whatever = @p1 --we only want one page of data SET ROWCOUNT @pageSize --now get the page of data from the table SELECT key FROM table WHERE whatever = @p1 AND [Table ...Show All
