sean_kirkpatrick's Q&A profile

• SQL Server Rounding Problem in total

  In a cell I have the following: =iif(Parameters!VOLREV.Value= "Volume" ,sum(math.Round(Fields!ADMINSRV_SLS.Value)),sum(math.Round(Fields!ADMINSRV_FEES.Value))) Depending on parameter I am either rounding the sum of sales or the sum of fees. This works beautifully. Problem is when I copy this to the total row it is not the total of the column. They are slightly off. I even tried naming the cell and then creating a calculated field in the total line to make sure that I am adding the values of that cell. =sum(ReportItems!MyNamedCell.value) But this crashes VS everytime and it has to restart. Does anyone have a suggestion please. In the total cell, is the expression rounding and then summing the values, like in the data c ...Show All

• Windows Forms Adding a New Object

  Hello. I'm trying to add a new textbox. I have a tabControl and i want to add the new text box in another tab inside a group box. ... case 1: TextBox txtNomeModulo2 = new TextBox(); txtNomeModulo2.Location = new Point(8,IncCase+=24); Controls.Add(txtNomeModulo2); break; ... The groupbox should be directly accessible from the form/user control. this.groupBox1.Controls.Add(txtNomeModulo2);  ...Show All

• Software Development for Windows Vista Tracking query does not return any workflow.

  All, I succefully extract and wrote a variable value in tracking database using custome profile but when I try to query the database it does not give me any workflow back. Here is my tracking profile and code to get the value from DB. < xml version="1.0" encoding="utf-16" standalone="yes" > <TrackingProfile xmlns=" http://schemas.microsoft.com/winfx/2006/workflow/trackingprofile " version="3.0.0.0"> <TrackPoints> <WorkflowTrackPoint> <MatchingLocation> <WorkflowTrackingLocation> <TrackingWorkflowEvents> <TrackingWorkflowEvent>Created</TrackingWorkflowEvent> <Tracki ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Layering Problem, and Keyboard problem

  So, in mdx in order to achieve a Layering effect In my 2d engine, i was drawing my first textured background layer using drawprimitives, then i would draw my player sprite, then draw the rest of the layers that would overlap the player with drawprimitives. In xna, this seems to just draw the sprite above all the layers no matter what. Second issue is with the Keys enum, When i try to do if(Keyboard .GetState().IsKeyDown( Keys .Alt) && Keyboard .GetState().IsKeyDown( Keys .Enter)) I get a index out of bounds exception on my home machine, and at work Any clue about either problem guys I know I could just make my own sprite drawing functions, but I'd like to use spritebatch if there's a workaround. ...Show All

• Visual Studio 2008 (Pre-release) MessageSecurityException when security mode is on

  Hi, I have a very simple client/server testing program using net.tcp, everything is working fine until I set the security mode (i.e. <security mode="Message"). Once I enabled the security setting I got the following error on the client side (server running on a different machine): Unhandled Exception: System.ServiceModel.Security.MessageSecurityException: Identity check failed for outgoing message. The expected DNS identity of the remote endpoint was '172.16.2.2' but the remote endpoint provided DNS claim 'localhost'. If this is a legitimate remote endpoint, you can fix the problem by explicitly specifying DNS identity 'localhost' as the Identity property of EndpointAddress when creating channel proxy. Would this b ...Show All

• Visual Studio 2008 (Pre-release) Computer needed to develop WPF applications

  Hi! I'm curious what computer do you think is needed to properly develop a WPF application under Vista and run them. What processor, graphics card and how much Ram. Currently I have a P4 3Ghz, 1GB Ram and an (old) Geforce FX 5700LE graphics card, and Expression Blend works very slow for me. Also many applications don't work slow too (programs like Nostalgia, Denounce form Thirteen32 and UniveRRS). I have an 2.1 Aero experience index in Vista. Perhaps the graphics card is giving you a low experience index. The overall index is the lowest of the individual indexes. I have a Pentium 4 2.8 Ghz with 2 Gb Ram that I bought over 2 years ago. It originally used the on board video so when I installed Vista I bought ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Is Boo a viable option for Scripting for both PC and XBox360?

  I'm just wondering if anyone has tried getting Boo to work for scripting on the XBox360, or is there some feature that Boo takes advantage of on the PC that isn't available on the console I've been reading that IronPython isn't an option, and LuaInterface wouldn't work either, since P/Invoke doesn't seem to be supported for security reasons. Can anyone shed some light It would be greatly appreciated. Thanks, Kevin Jim Perry wrote: I'd be very surprised at this point if any scripting capability was available for XNA. One more question to add to my list. Lua2IL works, which means you have to pre-compile lua into assemblies... I'm just finishing up some work on this (see another question about the ...Show All

• .NET Development How to update data based on dataset entries

  I have a xml < xml version="1.0" > <Amazonbooks> <Mybook> <MyBooktitle>Astronomy</title> <booknumber>b121</booknumber> <city>SHILLINGTON</city> <state>PA</state> <description>Astronomy b121 Description on 19 dec</description> </Mybook> <Mybook> <MyBooktitle>Geology</title> <booknumber>b212</booknumber> <city>West Palm Beach</city> <state>FL</state> <description>Geology b212 Description on 19 dec</description> </Mybook> <Mybook> <MyBooktitle>Astrology </ ...Show All

• Smart Device Development how to build a custom user control?

  Hi All, I am trying to build a numeric keypad of my .NET CF application, the keypad is built based on user control template, the keypad will be added to another form and using this keypad it will enter numeric numbers into the form's textbox. I have problem of carrying the value from the control to the form's textbox..Please someone help me..Thanks     We built a number input pad, and when it was made visible and activated, the acive control (a TextBox in your case) was assigned to a proprty of the number pad control. When the number was entered we simply assigned the value to the Text property of the passed in control. When the control was close, the value appeared in the textbox. ...Show All

• Visual C# Getting the executable path from another class then the Form.

  Hello everyone! Is it a bad thing to get the path of the program with Application.ExecutablePath from another class then the MainForm I've got a class which gets some data from an xml file and to know where to get it I thought I could use Application.ExecutablePath. I'm getting a bad feeling when doing it, don't know why, just wanted to know what you thought Thanks in advance! -Martin no it should be fine. Why would it be a bad thing if you are worried then you could make a static class which holds the typical application settings/properties including the Application StartupPath and use this class to access it from any other classes in your application. Generally the Application class is ...Show All

• SQL Server Sql Connection errors

  I dont know why but.. I keep getting an sql error here.. private void button1_Click(object sender, EventArgs e) { SqlConnection sqlcon = new SqlConnection( @"Server=(local)\sqlexpress;Integrated Security=True;" + "Database=mydb" ); sqlcon.Open(); } this is the erro that I keep getting.... {"Cannot open database \"mydb\" requested by the login. The login failed.\r\nLogin failed for user 'XLORDT\\xlordt'."} now.. Im using sqlexpress the one that comes with visual studio.. what do i need to do to fix this well what type of authentication are you using SQL or Windows try this connection string: "data source=.\SQLExpress;initial catalog= databaseName ;Trusted ...Show All

• Windows Forms Bootstrapper localization for turkish

  Hello everyone, I have completed a shared-addin extensibility project for office. The project comes with a setup project in Visual Studio 2005. I have some prerequisites and I have clarified them. The output of setup project is a msi for my project and setup.exe for the bootstrapper. I can change the language of msi by WiLangId.vbs and Orca but the problem is for the language of the UI's in the bootstrapper. I found that the label strings are read from C:\Program Files\Microsoft.Net\SDK\v2.0\Bootstrapper\Engine\en\setup.xml. I changed some strings in setup.xml as including turkish characters , , but I can't see them when I rebuild and started setup.exe. They seem as I,S,G. I have made some changes to try in setup.xml as Font to Arial MS ...Show All

• SQL Server Configure connection strings for deployment to different servers

  Hi, We currently have a test and development environment for our data warehouse which is using SSIS packages to build (SSIS packages call stored procedures). We have multiple connections accross the different packages. The problem that we are having is when we deploy the packages to the development environment, the connection strings in the packages are still pointing to the live server! Hence, when we run these packages in the test environment, they actually execute the stored procedures in our live server. I have tried to use package configurations and the deployment utility to assist us in this regard but have still come up with a few problems: - When running the deployment utility, I still have to go and manually type ...Show All

• SQL Server Data transfer from ODBC to Sql Server

  Hi Can Anybody tell me the different ways of transfering data from ODBC Layer to SQL Server using C#. I want to transfer using Threads,means by running 4 threads, I need to transfer 4 tables at a time. Though we have SQLBulk copy Object in .NET it's not useful in multi threader env. Can anybody help me in this. My Vizai wrote: Thanks for the reply Duane . I'm also looking for that , how to . There are probably several ways to do it. One way is to implement a call back when a row is inserted. There would need to be a sql server trigger that fires each time a row is inserted. The call back would notify the client each time the trigger fires. Exactly how you would structure the call back is up t ...Show All

• Visual Basic rich text box control cannot paste.

  rich text box control cannot paste when i select any thing(it may be image or text from internet explorer) and paste it in a msword it has got pasted including image and text when i do the same copy paste in my application which contain the richtextbox control i am unable to paste the images and i can paste only the links of the images can any one help me in pasting the images and text Assume RT1 is my richtext box. You'd have to download the file from the link to a temp dir. From there load the image into a control, and add the control to the rtf Dim img As New PictureBox img.BackgroundImage = Image.FromFile( "c:\pic2.bmp" ) 'replace with your downloaded file. ...Show All