Kallex's Q&A profile

• SQL Server set and member variables in calculated set/members?

  Is there a way to store a reference to a set or member into a variable (or rather, a 'reference') so that it does not have to be repeated in name or in the case of a call to a .net assembly, not be repeated in execution here's the : case when mylib.CalcFunction(<value1>) > 10 then mylib.CalcFunction(<value1>) else null end I'd want to put the result of CalcFunction into a variable and then check that variable. The same could be said if a function returned a set. Put the following inside the MDX Script CREATE HIDDEN CalcFunctionResult = mylib.CalcFunction(value1); and then you can reference CalcFunctionResult in your expressions. Alternatively, you could code the logic of ch ...Show All

• Windows Live Developer Forums WLM Addin: the event handlers don't work

  Hello, I'm trying to implement a simple addin with the help of this doc: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnlive/html/messengeraddin_sdk.asp I made this code: namespace WLMAddin { public class TestAddin1 : IMessengerAddIn { MessengerClient client; public void Initialize(MessengerClient messenger) { client = messenger; client.IncomingTextMessage += new EventHandler<IncomingTextMessageEventArgs>(this.client_IncomingTextMessage); MessageBox.Show("Initialize:\r\n" + "\r\nemail: " + client.LocalUser.Email); } void client_IncomingTextMessage(object sender, IncomingTextMessageEventArgs e) { MessageBox.Show("incoming text"); } } } So, when I load the addin ...Show All

• .NET Development Binary stream '0' does not contain a valid BinaryHeader Exception

  Hi, I'm having trouble using the BinaryFormatter class. When I call Deserialize (see below for code sample), I get this exception: System.Runtime.Serialization.SerializationException: Binary stream '0' does not contain a valid BinaryHeader. Possible causes are invalid stream or object version change between serialization and deserialization.     Public Overrides Sub WriteXml( ByVal writer As System.Xml.XmlWriter)         writer.WriteStartElement(XmlConstants.NamespaceQualifier, XmlConstants.ObjectElementName, XmlConstants.XmlNamespace)                 If m_Formatter Is Nothing Then      & ...Show All

• Windows Forms How Do I Display a "Name" Using a "NameID" in a DatagridTextboxColumn

  Using a datagrid with a "Name" column and a "ID" column I'm using a DatagridComboboxColumn and I have it set to a DataSource, the problem is I want to display a "Name" using the "ID" in the same row and be able to change the "ID" in the row while displaying only the name. and here is an online convert web for c# and VB for you :) http://www.kamalpatel.net/ConvertCSharp2VB.aspx best regards! ...Show All

• .NET Development Problem with databindings after removing a row from a DataTable

  I have a DataSet containing 2 DataTables: A and B. The tables are related through a common ‘id’ column, which is a unique column. Table A which is the main table, is displayed by a DataGrid. Table B is displayed by a checkbox and 2 textboxs. (Each control is connected to its matching column through the ‘DataBindings’ property. Everything works fine when I move through rows in the DataGrid, or add a new row. (I see the data of the checkbox and the textboxes is changed properly.) But, when I remove a row from table A, the data I see in the checkbox and the textboxes does not represent the actual data. I don’t know what is wrong, since everything works fine until I delete a row. Can someone help please Table ...Show All

• Microsoft ISV Community Center Forums Gantt Chart component/library

  Hi, I am looking for a component or a library or a framework to draw Gantt Charts much like MS Project. Either a free or a paid solution will do. I need to be able to incorporate it with my .Net application (written in C# 2005). I have searched around and found several solutions which more or less come close to what I am looking for. But I would like to hear from someone who might have researched it in the past and know about some good components or libraries out there. Basically, I would like to simulate MS Project's project management charting solution, but in a simplified version. Thanks in advance for any pointers. Mehdi There are many companies providing .NET controls for charting and I woul ...Show All

• SQL Server SSAS Security in an enterprise network scenario

  Our company operates a public, internet-facing website. To support this, our network is divided into three domains: Production <- this is where our live website operates DataWarehouse <- This is where our datawarehouse is located, and takes data feeds from the Production domain. Our analysis services instances live here as well. Local <- This is where all all our development, etc takes place, and is the domain all users have access to. For security reasons and to ensure the safety of private information the Local domain can only access the DMZ domain, and the number of ports open between the two domains are limited. Currently, the AS port (1444, I believe) is not open between the two domains, and we are facing an issue because lo ...Show All

• SQL Server Hiding table contents without sacrificing too much on performance?

  An application uses a database table having proprietary information. We do not want our customer to be able to look at that. This being a real-time application, performance can not be sacrificed. What is the best way to keep the table data non-viewable without sacrificing the performance The easiest way to do this without sacrificing performance is to use permissions and deny select or view permissions on the table in question. Create a special group and only grant that one group access to the table. This, of course, only protects against an online attack (i.e. the server is running). To protect your database against an offline attack (i.e. someone steals your hard drive), you will need to use some form of encryption. U ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How in XNA Game Studio Express correctly to include a full-screen mode?

  How in XNA Game Studio Express correctly to include a full-screen mode I write a code: graphics.PreferredBackBufferWidth = 1024; graphics.PreferredBackBufferHeight = 768; graphics.PreferMultiSampling = false ; graphics.ToggleFullScreen(); Then I draw on the screen 2D the sprite and I move it on the screen. During the moment of moving of the sprite on the screen, he brakes and twitches, such impression that copying of the sprite occurs on without usage Z-buffer. How correctly to customize in project XNA Game Studio Express using class Game1 a full-screen mode In DirectX earlier, it was so: D3DDISPLAYMODE Display; if( FAILED( pd3d9->GetAdapterDisplay ...Show All

• Windows Forms validating edit box(very urgent)

  hi, I have an editbox...........which will be accepting.........string to create a folder in tree........but wen user doesnt give any name ..or.......just gives spaces...........i should not allow him to create a folder............can anyone give logic for this. Thnx in advance, bye, Sudhakar. Hi, when reading/validating this editbox, check for trimmed text length, like in the following example: string folderName = folderNameEditBox.Text.Trim(); if (folderName.Length == 0) { MessageBox .Show( "You should enter a valid name." ); } Hope this helps, Andrej ...Show All

• Visual Basic Selecting a TreeNode by RIGHT CLICKING on it, I m using VB.Net, VS2003

  causing the AfterSelect() TreeView event by right CLICKING the TreeNode I m using VB.Net, VS2003 The AfterSelect event [say, Private Sub TreeView _AfterSelect() ] is called when we first time LEFT CLICKS a tree node in the treeView, right clicking the node doesn't selects the desired node. How can we cause the system to select the desired node when we RIGHT CLICK on it Also can we create a Node_Click event for treenodes / treeview in VB.Net [like there was one in VB6]   Also if this post is not relevant to the thread topic, please guide me where should i ask questions about configuring various controls You will have to to it yourself: Private Sub TreeView1_MouseDown( ByVal sender As Objec ...Show All

• SQL Server Interesting Problem/Bug with Logos in the page header

  Scenario: I have a report with a logo in the page header. This report has 2 parameters: 1) Date 2) Boolean to Show/Hide detail. When I put in the date and show the report, everything is fine. If I then change the boolean parameter to show or hide the detail, the logo file cannot be found (Displays a red X) If I export the report like this, the red X is rendered in the export. The logo is not there. Has anyone else experienced this issue Anyone know how to resolve it Thanks! BobP ...Show All

• Microsoft ISV Community Center Forums use inputbox to choose cells for plots in excel

  Hi all, The below code would I like to change so I can use the inputbox arrays 'usr_choice_x' and 'usr_choice_y' (instead of the range "A68:B89" as it is now) for the plot. How do I do that Grateful for ideas usr_choice_x = Application.InputBox(Prompt:="Select x cells ", Type:=64) usr_choice_y = Application.InputBox(Prompt:="Select y cells ", Type:=64) Charts.Add ActiveChart.ChartType = xlXYScatterSmoothNoMarkers ActiveChart.SetSourceData Source:=Sheets("MDO_061013_LHS_HP").Range( _ "A68:B89"), PlotBy:=xlColumns ActiveChart.Location Where:=xlLocationAsObject, Name:= _ "MDO_061013_LHS_HP" With ActiveChart .HasTitle = False .Axes(xlCategory, xlP ...Show All

• Architecture Network Load Balancing vs. Hardware Load Balancing (CISCO Arrowpoint)

    Hi Have a query regarding using the Windows 2003 Network Load Balancing Service. My ISP provides Load Balancing functionality via there CISCO (Arrowpoint) Device. We were experiencing some problems with the Arrowpoint so during testing I installed the NLB service and got all my websites working to a tee I decided that this is perhaps the best way forward anyway as I had more control over adding and removing servers to the cluster, but none the less I decided to ask my ISP's advice as to which solution was the best. Their response was... "Microsoft's implementation of NLB is not a particularly network friendly application of load balancing. It operates by spoofing the source MAC address in ARP replies. This causes all switches ...Show All

• Visual C# Calling methods of a class without creating an instance of it

  Hi, I'm sure this probably has been answered before, but somehow I couldn't find it, so really sorry about that. But how do you call methods of a class without having to create an instance of it I mean, in my project I have something like: public class FileOperations{ public void read_config_file(...) { (...) } } And I want to call the read_config_file(who doesn't depend on anything but the filename and a property where it'll write the config values) without having to do: FileOperations fileOp = new FileOperations(); fileOp.read_config_file(); I was a poor (poor like in noob) Java programmer but I used humm I believe it were static methods in abstract classes, something like that, don't re ...Show All