jschroeder's Q&A profile

• SQL Server Reference dimensions are creating too many joins

  I have orders fact; customer, location and age dimensions. I am using age and location as reference dimensions through customer dimension. If I don't use reference dimension cube processing SQL would be like following select * from factOrders If I use reference dimensions SQL would be like following select * from factOrders, dimCustomer as customer1, dimCustomer as customer2 where factOrders.customerid = customer1.customerid and factorders.customerid = customer2.customerid If I have 6 reference dimensions through customer there will be 6 joins. Is there any way I can eliminate these joins as I need only one join to get all the information I can create a view between factOrders and dimCustomer and use the reference dime ...Show All

• Visual C++ readind files

  i need to read a file, line by line, EG: ------------test.txt------------ #1 0,1 #2 0,10 #3 0, 20 ------------end file------------ and it would move a picture depending on the chords. i know how to move the picture and parse the text, but how do i get the text line by line If you are using .NET 2.0 then you have the nice convenience of being able to use File.ReadAllLines a static method that lets you specify a filename to read and returns a String[] of the lines read. http://msdn2.microsoft.com/en-us/library/system.io.file.readalllines.aspx Hope this helps. Let us know if you have any further questions ...Show All

• Architecture critique requested on thin Data Access Layer

  I have devised a way to save tons of code by calling stored procs with a single web service method, which takes a DataSet parameter, containing a DataTable with the name of the stored procedure and column names matching the parameter names, and row(0) contents matching the values to be passed. I have further simplified matters by making all parameters varchar, so a call from my client looks like: Dim paramVals As String() = { myString1, myString2 } Dim ds As DataSet = oneWsMethod("storedProcName", "param1,param2", paramVals) ... Dim params As String() = { this1String, thisOtherstring, thirdString } ds = oneWsMethod("anotherProc", "p1,p2,p3", params, usingTransaction:=True) My o ...Show All

• Windows Forms How to change splitter border color.

  Hello. When I use split container controls and select border style to fixed single, always appear black. Anybody know how to specify a new color Thanks. It didn't work when I had a tool strip container in the panel. I will try to handle the tool strip container's paint and draw a border. Maybe that will work. Thanks. ...Show All

• Smart Device Development Breakpoints causing connection loss on debug

  What started out as a random problem has become a full-time issue. Attempting to run a WM 5.0 app causes a "The Connection to the Device has been lost, blah, blah, blah" error. Deleting ALL breakpoints allows the app to deploy and run perfectly. Breakpoints can then be set for debugging. Setting a SINGLE breakpoint before deploying, however, will now cause this problem. The larger the app became, the more prevalent the problem became until some critical point was reached...now it happens every time. VS2005 and ActiveSync have been removed/reinstalled. I've tried VS SP1 Beta and ActiveSync 2.5 Beta. I've tried several different devices along with the emulators. No change. Has anyone heard confirmation of this ...Show All

• .NET Development DateTime Issue of Two Timezone!

  Frist, I will introduce my trouble. I deploy the WS in one Timezone, and UI in another Timezone. UI gets the datetime info by WS, but UI can't get the right Time that equals to database. For example the WS Timezone is UTC+1, and UI Timezone is UTC+6, the Time received by UI is always add 5 hours. Is anyone can help me out Thanks! Thanks, Can I add some configsettings in WS to stop the automatic DateTime Change, and how to ...Show All

• Windows Live Developer Forums How to programmatically add pushpin layer (without GeoRSS feed or Live Maps)?

  I was disappointed to learn I can't (easily) create my own pushpin layer without having to reference an external (to my webpage) URL. Say I want to prompt the user to enter 5 addresses and then plot the 5 together all at once. I'd imagine being able to Find() the right lat/long for each person, add a corresponding pushpin to an array for each user, and then add the array of pushpins as a layer. I don't want to copy the data out to a separate URL for privacy reasons. Besides, I already have the data in memory, I just want to display it all at once as a pushpin layer! Right now I'm just having to sequentially add a new pushpin for each person. The map flashes around as I add each point. I can't group various pushpins together. Why isn't ther ...Show All

• Smart Device Development FileIOPermission issue

  Hi, I'm trying tot write an App that runs through the system just reading files and producing a hash of each file. The problem is that certain files in the CE file system are protected and I can't seem to read from them. The Exception occured in these lines; private string GetHash( BinaryReader br, int SizeOfFile) { byte [] hash; ASCIIEncoding enc = new ASCIIEncoding (); byte [] buffer = new byte [SizeOfFile]; br.Read(buffer, 0, SizeOfFile); }   From what I was getting from Visual studio suggeted I did something like the following: using System.Security; using System.Security.Permissions; [assembly:FileIOPermission(SecurityAction.RequestOptional, Unrestricted = true )] ...Show All

• SQL Server Managing PK/FK Relationships with the Tools

  Ah, why doesn't SQL Server Management Studio (SSMS) or Visual Studio's Server Explorer permit me to set PK/FK constraints on the tables They're supported in SQL Everywhere (SQL Ev), but I don't see a way to set them up. Why don't these tools support scripting the database tables to SQL Is this planned Bill, Obviously Microsoft will have to address the why, but in terms of the how, there is a nice third party tool that might help you out. See www.primeworks.pt . You are correct though, the degree to which you can manage constraints on SQL Mobile databases in SQL Server 2005 Management Studio is limited unless you write the DDL yourself. VS2005 is even more limited. Darren ...Show All

• Visual Studio 2008 (Pre-release) .Net Remoting two times faster than WCF!

  In our healthcare enterprise multitier application the .Net Remoting transports are two times faster then WCF(we have plugable client/server transports): Measuring results for the same couple of client server requests: -> Tcp Remoting: 3.4 seconds -> Http Remoting (IIS-Hosted): 3.5 seconds -> Tcp WCF: 6.5 seconds -> Http WCF (IIS-Hosted): 7.3 seconds -> Http WCF (IIS-Hosted) with MTOM: 10.3 seconds Security: We just use authentication by NTLM Serialization: We use the NetDataContractSerializer, and not the DataContractSerializer (RPC style) Can WCF be tuned to be as fast as remoting The use of MTOM which replaces text by binary data makes the communication slower. Why ...Show All

• Visual Basic EMAIL

  I am using this code in vb.net 2005 to sent an email but an error FAILURE SENDING MAIL is allways appearing. Can someone show me where I am duing wrong. Try Dim SmtpClient As New System.Net.Mail.SmtpClient SmtpClient.Host = "localhost" SmtpClient.Port = 25 SmtpClient.UseDefaultCredentials = True SmtpClient.Send("glennzarb@gmail.com", "glenn_zarb@hotmail.com", "Test", "hi") MsgBox("sent") Catch ex As Exception MsgBox("Send failure:" & ex.Message) End Try I haven't installed any other programs or smpt's Again, it does not matter about the email service that a person is using but rath ...Show All

• Windows Live Developer Forums WEIRD Route Instructions

  hmmm, this is really weird, i just noticed that if i get a route several times, sometimes it contains (North-East), sometimes (Northeast), the same rule goes for other directions. Sometimes it contains (North), sometimes (north). So i guess they have some little chimpys in a wooden box typing the instructions on the fly, and if cheetah doesnt get his banana, he starts making mistakes... ...Show All

• Visual Studio 2008 (Pre-release) Problems with multiple ObjectDataProviders - Attn: Binding gurus

  Ok, here's the resource declaration of the ObjectDataProviders (ODPs) in question (may look familair to some of you) <ObjectDataProvider x:Key="PreOpen" ObjectType="{x:Type src:SingleValueBinder}" /> <ObjectDataProvider ObjectInstance="{StaticResource PreOpen}" MethodName="set_SettingName" x:Key="PreOpenInstance"> <ObjectDataProvider.MethodParameters> <sys:String>PreOpen</sys:String> </ObjectDataProvider.MethodParameters> </ObjectDataProvider> Here is the XAML that binds to the control <CheckBox Margin="10,10,10,10" Content="Pre-Open"> <CheckBox.IsChecked> <Binding Path="Value" So ...Show All

• .NET Development Proxy- design

  Hi i am developing a packet relay kind of stuff ie assume that 3 pc's are there in ur netwrok client n <--->proxy <------>server n the proxy is the one i have to develop. I have used async socket communication.the proxy will be listening to a specific port.the client will frequently send some bytes to proxy and the proxy have to fwd it to the server and vise versa(server->proxy->client) when ever a client connects to my proxy this code will be executed. objSocket.m_currentSocket.BeginReceive (objSocket.dataBuffer, 0,objSocket.dataBuffer.Length,SocketFlags.None,pfnWorkerCallBack, objSocket); Now my question is what if 20 differnet clients connects to my proxy. will there be ...Show All

• Visual Studio Express Editions LIFE SAVER !

  hi its a simple lil thing all i need is when a picture or button is clicked an double clicked the volume of the computer is muted Simple as :) i've searched and cant figure this out not using windows media player or anything just the computers Master volume to = 0 :) You need to place the call within a method body. So the example above was within a button.click event method. My.Computer.Keyboard.SendKeys(Keys.VolumeMute) so a simple form with a single button on the form Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click My.Computer.Keyboard.SendKeys(Keys.VolumeMute) End Sub End Class Can you show us you code you have written. ...Show All