Babax's Q&A profile

• Windows Forms help - can dataview filter out columns as well as rows?

  hi, i have a datatable with 60 columns but i only need 2 columns to be put into a dataview, can this be done How would i do this Thanks. AFAIK you can't directly filter the returned columns. However you can use ToTable to get a DataTable that contains only the columns you want. This will cause a duplicate copy of the data to be created (or maybe not, you should check) though so it might be better just to return all the columns. And just to cover the bases most people will tell you that you shouldn't return 60 columns if you only return 2 anyway. This is more data than is needed. Create a separate sproc or select statement to return only the data you want. Michael Taylor - 11/10/06 ...Show All

• Visual Studio Team System Notification - Closed task

  Hi, is there a way to get notifications, if someone close the task regards Simon Simon, You can create custom subscriptions using BisSubscribe.exe tool and give a custom filter to do it. If you search for bissubscribe in net you can get lots of info on it. To get the schema for WorkItemChangedEvent and to build filter, check http://blogs.vertigosoftware.com/teamsystem/archive/2006/07/03/Subscribing_to_Team_Foundation_Server_Events.aspx Pete's blog has much details on creating subscriptions & troubleshooting: http://blogs.msdn.com/psheill/ I hope this helps. Below is the event filter we use in UI for "mail when my items changed by others" - if you need an example: "PortfolioProject& ...Show All

• SQL Server KPI Visualisers

  Hi there, We would like very much to define and manage our KPIs through AS2005's KPI repository. We would like those KPIs to be visualised with some sort of sweet looking gagues, like the ones available from Dundas. http://www.dundas.com/Products/Gauge/RS/index.aspx However, I can't see any reference to using this product to connect to KPIs that have been centrally defined. Instead, it looks to me like you have to do all the " If actual > budget then 1" sort of logic all over again, within the gague - i.e. at the presentation layer, which seems fundamentally flawed to me. Am I missing something Has anyone used any of these sort of visualisation tools to connect direct to AS2005 KPIs ...Show All

• SQL Server HTTPS access to SQL 2005 cubes

  Hi there I have two machines one 64bit machine with SQl 2005 on it and another 32 bit machine which I use as my web server both running win2003. I have followed the knowledgebase article from Microsoft ( http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx) and also researched postings on this site but can't seem to access the cubes remotely. I have changed to msmdpump.ini file to have the <ServerName>mycomputername</ServerName> which points to the SQL box. I can connect to the cubes from the 32 bit machine using somethign like crystal reports and connecting directly to the server name but can't connect to https://localhost/olap/msmdpump.dll I get an error about could not connect to the computer name or the ...Show All

• Windows Forms Programatically pressing keys or moving the mouse?

  Hello I am not sure if this is the right forum for this question, apologies. Is there a way by which I can programmatically move the mouse or press certain keys on the keyboard Regards, ...Show All

• Visual Basic Standard Deviation

  Try as I might i cannot figure out how to code the Mean & Standard Deviation HELP!! Actually, you need to square each distance from the mean (which not only makes it correct, but as a bonus even makes each term non-negative). :) See http://forums.microsoft.com/MSDN/showpost.aspx postid=510627&siteid=1 . ...Show All

• Smart Device Development can pda program to function like 3G phone with video conference throught WiFi or BT

  can the PDAs communicate with others by the program like 3G phone, with video and voice Yes, it could. There are applications like that on the market already, e.g. from Skype. Of course, it takes a lot of time, effort, experience and expertise to write such an application. I would say team of 10 developers (5+years C++ experience) could do it in a year or so. ...Show All

• Visual Studio Express Editions Output to Textbox adds zeros

  Here is the code Private Sub Receiver(ByVal sender As Object, ByVal e As SerialDataReceivedEventArgs) Handles COMPort.DataReceived Dim RXByte, Nibble As Byte Dim RXArray(2047) As Char Dim I As Integer = 0 Dim J As Integer = 0 While COMPort.BytesToRead > 0 RXByte = COMPort.ReadByte Nibble = (RXByte >> 4) + 48 ' Convert received byte to Hex If Nibble > 57 Then Nibble = Nibble + 7 End If RXArray(I) = Chr(Nibble) I = I + 1 Nibble = (RXByte And 15) + 48 If Nibble > 57 Then Nibble = Nibble + 7 End If RXArray(I) = Chr(Nibble) I = I + 1 End While Dim RxString2 As New String(RXArray, 13, 7) TextBox1.AppendTe ...Show All

• Community Chat Can you rate this code please

  Following is a custom thread pool class that I attempted to write. Would you please take a look at the code and see what design issues (or coding ) issues does it have using System; using System.Collections.Generic; using System.Text; using System.Threading; namespace Gemini.Threading.ThreadPool { public delegate void CallBackHandler(object context); public sealed class CustomThreadPool : IDisposable { #region private memebers... private readonly int _CurrentPoolCount; private List<ThreadData> _Threads = new List<ThreadData>(); private ManualResetEvent _ItemsInQueueEvent = new ManualResetEvent(false); private SynchQueue _QueueWorkList; private static void OnThreadStart(object o) ...Show All

• SQL Server cannot connect again after 15 minutes

  Hi, I have SQL 2005 full version installed a remote server and when I start my computer I can connect to the database from SQL Managment Studio and a program I'm making. After about 15 minutes I find that I cannot connect using both programs, but if I enter the servers IP address using Managment Studio I can connect (this does not happen with the program I'm making). I have to log of my computer before I can connect again. Anyone having the same problem or how to fix it Thanks PQSIK ...Show All

• Visual Studio Problem with vsdrfCOMSelfReg and multiple Primary Outputs (VS2005)

  I'm encountering the following problem: I have two projects in my VS Solution (well, actually I have about 30 interdependent projects in the Solution, but I'm trying to keep it simple!): The first project, MYAX, is a C++ ActiveX control library project (which builds the library MYAX.dll). The second project, MYAXMSM, is a deployment project, that builds a merge module from a number of sources , one of which is the project output ("primary output") of the MYAX project. In MYAXMSM, the properties of the Project Output for MYAX are set to vsdrfCOMSelfReg -- because MYAX is a self-registering COM library. Up until recently, everything was working fine, until I decided to enhance MYAX with the following custom build ru ...Show All

• SQL Server Creating Local cube Using SQL Server / Analysis Services 2005

  I am creating a local cube through a web page and everything is working properly when I am debugging but if I am not debugging, the following exception is returned: x= Exception:File system error: Error opening file; \\ \C:\Program Files\Common Files\System\Ole DB\MDTempStore_1088_1_fm3by.tmp is not a disk file or file is not accessible.   StackTrace:   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.HandleCreateLocalCube(AdomdErrorResponseException ex)     at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.Execute(ICommandContentProvider contentProvider, AdomdPropertyCollection commandProper ...Show All

• Visual C# C# Project generation

  Hi I'm working on an app that generates C# source code. I've been using the CodeDOM namespace to handle most of the actual generation of the individual source files and its worked out fine. However, now I'm ready to start generating the CSPROJ files that will contain those source files. I realize that these files are simply XML files and I could just create them myself on the fly but before I go down that path I wanted to make sure that there wasn't a similar abstraction for them somewhere in the .NET framework that will generate the proper project files for me. Does anyone know of such an object Thanks! Jeremy I would probably start here: http://msdn2.microsoft.com/en-us/library/aa406241.aspx The stuff you need is in the Microsoft. ...Show All

• Visual Basic How to Rotate Text in RTF

  Hi Folks, Any RTF experts out there I want to insert a text object that is rotated like what you can do in Powerpoint's text box or Word's Word Art. Unfortunately, when either is saved in RTF, the text content is lost in the raw code, so I cannot do a search and replace on the rotated text. Word only saves the text content if the text box is used with the alignment changed to vertical. Is there any way to create rotated text that is visible in the RTF code I am prepared to insert all the required positioning code myself, if I only knew what was required. Any ideas would be greatly appreciated. The problem isn't rotating the text...that can be done relativly easy either by painting the ...Show All

• Visual Studio Team System Calling TFS Client APIs from Web Service

  I have a web service that is using the TFS Client APIs. I have identity impersonation set to true in the config. If I run the web service under the ASP.NET Development Server, all goes fine. I log that the web service is running under my domain account, the current thread is running under my account, and I am logged onto the TFS server using my account. If I run the service under IIS, nothing works. I have windows authentication turned on and anonymous access turned off. I log that the web service is running under my domain account and the current thread is running under my domain accout. I see a logon error on the TFS server for the ASPNET account from my PC. The offending call is GetChangeset, althoug I imagine it would fail on ...Show All