PhrankBooth's Q&A profile

• .NET Development How can I retreive my REMOTE IP address?

  How can I retreive my REMOTE IP address and display it as a string Thanks, Your question is somewhat ambiguous. When you say "my", what computer are you referring to The one on which your program would be running or a remote computer to which your program wishes to connect ...Show All

• SQL Server expressions in layout view of Reporting Services

  ok Using MS Visual Studio / Reporting Services Table = calllog Field 1 = RecvdDate Field 2=RecvdTime in my layout view I have combined these two - Txt header CallRecvd (Value=Fields!RecvdDate.Value & " " & Fields!RecvdTime.Value) I have a txt box called [Today] Value =Today() (I am showing this in a box but it actually doesn't have to show at all last txt box - I need to do the following =DateDiff([ CallRecvd] ,[Today]) (error CallRecvd is not declared) not sure where I do this thanks please advise Jewel thanks Robert but when I do as you suggested this is the error I receive Error 1 [rsCompilerErrorInExpression] The Value expression for t ...Show All

• Visual Studio Tools for Office Outlook property page does not show correct

  Hi all, i added a new property page to Outlook (developed with VSTO in C#). This page shows up, but it has a little bug. There is a small part which is not shown correct. I’ve added a picture which shows the problem. http://img.langalaxy.de/ppage.png What can I do, that the property page looks like "Outlook" property page Thanks Hi, you see the small bar at the bottom in standard control color. This belongs not to my user control. My control is actually bigger than the displayed part, but only the part with the "light color" is shown. For any reason my control is cut off at the bottom. thanks for helping ...Show All

• SQL Server SSIS Transactions 101

  I want to truncate a table (remove all of its data) using an "Execute SQL task" and then populate that table using a Data Flow task. In case of failure, I want to "rollback" the table to its state prior to its truncation. Can this be done using SSIS Transaction support or is that support aimed exclusively at sql-based flows TIA, barkingdog >>> This method does NOT require MSDTC. Now, the message got through. (The ears were listening but the mind was not .) Thanks, Barkingdog ...Show All

• Visual Studio Team System TFS Fills up disk?

  Not sure if anyone else has seen this issue. Didn't have a chance to reproduct, but I think TFS source control will dump at certain intervals if you have a deleted SID in one of your security groups that could be used. Our disk/temp directory kept getting filled, the event log mentioned something about an invalid id, I had to search through all the groups to find it and remove it. Anyone else seen this Seems like this is something where it should not dump just because of an old deleted SID. It wasn't SQL it was doing a process dump each time every few hours which would eventually fill the disk due to the exception that was caused. ...Show All

• .NET Development How can I parse an SQL statement into a canonical form ?

  Is there any class available (either in the framework or external and in that case preferably open source) that can be used to test whether two sql statements are equivalent or not (equivalent regarding irrelevant white space, parentheses, and upper/lowercase for keywords) Basically, what I would like to do is to find a class (below called SqlParser)that I can use like this: string sql1 = SqlParser.getSqlStatementInCanonicalForm("SELECT mycol1 FROM mytable where mycol2=1 and mycol3='abc'"); string sql2 = SqlParser.getSqlStatementInCanonicalForm(" sEleCT mycol1 frOM mytable where ( mycol2 = 1 ) and ( mycol3 = 'abc' ) "); NUnit.Framework.Assert.AreEqual(sql1, sql2); / Tomas   To ...Show All

• Visual Basic Fix The Startup Location Of Form

  May i know how to fix a startup location of form when i dim and show the form I don't really want to specify the x,y. i want it to be bounded always to the left of form providing the form can be dragged and moved to the other place. Thank you. You can set a startup position via the form's .StartPosition property. Set it to CenterScreen or Manual or whatever you want. If the form needs to be stuck onto the left side of the screen, then only specify the y and not the x Public Class Form1 Private Sub Form1_Move(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Move Me.Location = New Point(0, Me.Location.Y) End Sub End Class ...Show All

• Visual Studio Team System Team Data CTP 5 Refresh

  Team Data CTP 5 Refresh This patch significantly improves the performance of Team Data CTP5 and I’d encourage everyone to get it. Find out all the details here: https://blogs.msdn.com/camerons/archive/2006/09/15/756593.aspx I applied the patach and changed the service account to use my domian name login. I have also granted the rights to sp_deptach to public and I still recieve an error message: -------------------------- Microsoft Visual Studio --------------------------- Could not locate entry in sysdatabases for database 'Catalog_MillenaUS_DB_3a8f0cd8-0108-4409-a5fd-3ae20dce67b6'. No entry found with that name. Make sure that the name is entered correctly. --------------------------- ...Show All

• Visual Studio Team System Build fails as the DLLs are in separate directory.

  Hi, I am trying to do a team build but it fails while local build happens successfully. Teh reason is perhaps because in the build I am trying to copy the files(DLLs) in a separate directory so in team build, it gives error that error while copying ABC.DLL to the location, access is denied. My directory where DLLs are stored is also added in Source control. How can I tackle such a situation in TFS. Thanks, Ekta Ekta, I'm not sure I fully understand what you're saying but if you're stating that the Team Build process can't copy the DLLs to a specific folder (or set of folders) then you should give the user account that Team Build runs under permissions to the destination folder(s). Y ...Show All

• Visual Studio Visual Studio 2005 refuses to use Try-Catch block

  I have a section of code surrounded by a Try-Catch block and the catch is just for a System.Exception, so it should catch everything + the kitchen sink, however, Visual Studio is still breaking into the code at the line causing the problem and showing me the dialog box I have the checkboxes cleared on the Exceptions list so it should not break on CLR exceptions, Native Exceptions, etc, yet it breaks in and shows me an argument exception at the line causing the problem I don't have a funky machine.config or app.config file either that has anything in it that would affect the behavior of the debugger. Why does visual studio refuse to go to the catch block Are you sure that you cleared everything in the exception dialog box ...Show All

• SQL Server Report Model Wizard

  I created a data soure view that has tables from two data sources (both sql databases). when I try to generate a report model using this data source view, I get an "invalid object name" error for the first table it encounters that is not from the "primary" data source for the view. Is there something I need to do so the report model retrieves the connection strings for both data sources Any help is greatly appreciated. Thank you in advance! I actually have both cases ... But I can't even get the view to work for two databases on the same server .. can you shed some light on that scenario ...Show All

• Windows Forms docking problem in panels/split containers

  I have put a text box and a datagridview control in one panel of a split container. The text box is docked to the top, because it is the title bar for the datagridview. The datagridview is anchored to the bottom and right. The problem is when the form is resized, the top of the datagridview moves away from or into the text box (depending on the sizing direction. but if I set it to Fill, the label covers up the column headings of the datagrid. Is there a way to anchor the top of the datagridview control to the bottom of the text box If not, how to deal with this situation Ah, the problem is, I am already using both panels of the splitter, each of which has a label anchored to the top and sides, a ...Show All

• Software Development for Windows Vista Type initializer exception when displaying Workflow/sequential activity in designer

  Hi, I have created a number of custom activites which are defined in a single .cs file. I can add these activities to a workflow or sequential activity without any problems. If I build the code there are now build errors generated bur if I exit the designer view of the workflow/sequential activity and re-enter it I get an error saying that the type initialisr for the cutom activities are throwing exceptions. I have used the .net samples as a template for my custom activities. Has anyone seen this behaviour before. I have included an example of a custom activity I am using. [ ToolboxItemAttribute(typeof(ActivityToolboxItem))] public partial class ExampleActivity : System.Workflow.ComponentModel.Activity { public ExampleActivity ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. EffectPool with content pipeline

  I make a lot of use of the EffectPool class to share parameters between shaders. Using the content pipeline, how can I still do this There is only a getter on the compiled Effect's EffectPool as far as I can tell. Could/Should there be a: Effect fx = Content.Load< Effect >("MyEffect",EffectPool); Cheers, Trev. ...Show All

• Visual Studio Express Editions A bit of Help Please

  In some code that I am doing i have the following in place to keep users from inputing text. However, i want to make sure that following code also allows me to use "." to seperate dollars and cents. I want to use the following code if possible. Private Sub txtPurchase1_KeyPress( ByVal sender As Object , _ ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtPurchase1.KeyPress ' textbox1 just accept numeric data If Char .IsNumber(e.KeyChar) Then e.Handled = False Else MessageBox.Show( "Please enter correct format. (i.e. 20.00)" ) e.Handled = True End If End Sub Thanks in advance. I would totally recommend th ...Show All