LouArnold's Q&A profile

• SQL Server Exporting Dates to Excel as date format

  Hi, I'm currently having problems exporting formatted dates from reporting services 2005 to excel. Basically what I require is a way to format a date in reporting services so that it only shows the date without the time (preferably british format) and when it is exported to excel it is still formatted as a date. This is so the user can sort the data file via date, I appreciate it is easy to select the column and format the cells but i would prefer to have a 'cleaner' solution to this problem which avoids the need for users to be formatting exported reports. Originally I was formatting the dates as convert(varchar,@date,103) in the SP which converts it to a character string and excel picks this up as a character as would be expe ...Show All

• Visual Studio Team System How to differentiate the Constructor which generated by Compiler or writen by user

  How to differentiate the Constructor which generated by Compiler or writen by user: I have overrided the check method: public override ProblemCollection Check(TypeNode type) { if (type.NodeType == NodeType.Class) { int memberCount = type.Members.Length; int constructorCount = 0; for (int i = 0; i < memberCount; i++) { Here: What can I do to differentiate the constructor which generated by Compiler or writen by user if (type.Members .NodeType == NodeType.InstanceInitializer) { { constructorCount++; } } } Problems.Add(new Problem(GetResolution(constructorCount.ToString() + NodeType.InstanceIni ...Show All

• .NET Development Saving...

  first of all i will declare that i'm fairly new to programming. especially with data. i'm working on writing a check book program and i'm not sure how to save the data. i want to make the program distrubutable. now, from what i read, unless i mis understood. i can't just pass around a program that uses a database. like right now i've created a SQL database in visual studio and its a local database (i belive) and if i take this to a computer and install it, if they don't have a SQL server running then the program wouldn't be able to connect to the database. correct so anyways, all i know of is just SQL database. i heard that there are Microsoft Jet Databases that you don't need sql for, but this is a microsoft access database. i' ...Show All

• Visual C# Method Description

  Hi i was wondering how to create a method on my class so when u call it u can see a brief description of what that method do. for example when u call System.Console.WriteLine u can see that it say "Writes the representation of the array objects........................" and after that also say what expcetions could be thrown by calling this method,, and i was wondering how to add this description and alos how to add the exception list.. i allready tried the System.ComponentModel.Description and put it right before the method, but no results.. mig16 mmm, thanks again, so it loks that something is wrong with my solution. look i have 2 projects in my solution.. i have a project with my class and a pr ...Show All

• Visual Studio Express Editions How do I: add favorites? History?

  Hello all I have another question. I would like to know how to add favorites to a Menu strip item (like in Internet Explorer, how it has favorites). Right now I have one similar to IE, with an Item called Add To Favorites. Here is my code: Private Sub AddToFavoritesToolStripMenuItem_Click_1( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles AddToFavoritesToolStripMenuItem.Click favorites.DropDownItems.Add(WebBrowser.Url.ToString) End Sub As you can see, I can add items but not be able to click on them and go to the page. I would like to know if it is possible to add a custom name for each one with the icon of the website (once again like IE). And I want to be able to click them t ...Show All

• Visual Studio Team System New Team Foundation Server MSSCCI Provider Available Now!

  I am happy to report we have released an updated TFS MSSCCI provider here . We have been able to address a number of requests (keep them coming) in this release including the following: PowerBuilder support Enterprise Architect support Improved Open from SCC experience Work items can now be modified in the checkinwindow Get latest on checkout support Check-in lock is treated as exclusive Setup works on x64 This is an unsupported "powertoy" like tool. There have been some discussions about the possibility of supporting it, but nothing yet. Keep reporting issues and comments to the forum or by e-mail . Hi, Yes. 1. uninstall MSSCCI from Add-remove programs. 2. reinstall VSS6.0d or ...Show All

• SQL Server Having Problem with Report Parameters

  i am trying to generate a report based on 3 parameters age, location, ethnciity every thing works fine in data and layout tab, when i run the preview tab, it give me the option to input paramaters and then when i hit veiw report, it shows processing report.... (indefinite) time. i tried executing the query in data tab, it takes less than a sec. any ideas am i doing somethign wrong in parameters its some weard problem. its hitting the dbase and i double checked it in the profiler. i dont knows what happening. i deleted the data cache files in the folder and tried rerun again.. nothing works. data tab works 1000 times fine. ...Show All

• Internet Explorer Development window.open and <a> with named target always opens new window

  Hi there, We are having some problems with reloading named windows. We use in our applications two kind of methods: java scripting: window.open("../Company/SelectDerde.aspx","SEARCHCOMP", "height=600, width=750px, menubar=0, location=0, resizable=0, status=0); html: <a href="../Company/SelectDerde.aspx" target="SEARCHCOMP">Search Company</a> Before IE7 the webbrowser reloaded the window (if already loaded) with the name 'SEARCHCOMP' with the new page. With IE7 it always opens a new tab or window (depending on the IE7 Settings) Does anyone know of named targets are no longer supported with IE7 Thanks in advance Patrick Marelis ...Show All

• Visual Studio Tools for Office Change Word formfield checkbox value

  I have a checkbox in word and i've made a bookmark for it. How do I check or uncheck the box using C# in .net 2.0 I have done this in asp using vb here is the code. If (form1.bitJoint.Value = "True") Then .formfields("Check7").CheckBox.Value = True Else .formfields("Check6").CheckBox.Value = True End If Hi RajDas I've separated this to its own thread, since it's a different topic than your original thread. As you'd marked that as an answer, the chances of getting a reply were smaller than if you posted a new thread. object ffldIndex_Check1 = "Check1"; this.InnerObject.FormFields.get_Item(ref ffldIndex_Check1).CheckBox.Value = true; (If you're not using VSTO ...Show All

• Windows Forms app.openforms: can I get forms' public properties not knowing form type

  Hello: I need to look at public properties of my open forms(all forms have been given the same set of properties. But these are not visible when I do a loop of open forms unless I know the form type, like: For Each f In Application.OpenForms If TypeOf f Is frmShip Then X = CType (f, frmShip).myproperty next Can I get the property of the form without knowing the form type in order to do something like this, i.e for each f in application.openforms debug.writeline(f.myproperty.tostring) Next OR if I need to get a particular property, can I pass a variable of the form type, i.e dim frm as frmShip, id as 100 GetpropertyofForm(frm,100) Sub Getpropertyof form ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How do you handle exceptions?

  I took my free-look camera project to work to show my colleagues and when I tried to run it I get an InvalidCallException in my Program.cs on game.Run(); I don't have a 3D card in my work machine but other projects I've created on it have worked fine so I started a new project and copied the game components across and ran it.\ Now I get the same expection when I call DrawUserPrimitives, can anyone tell me what might be happening And how are you supposed to handle exceptions either in Game Components (which you might not have built) or in code OK, I use graphics.GraphicsDevice.GraphicsDeviceCapabilities.PixelShaderVersion and graphics.GraphicsDevice.GraphicsDeviceCapabilities.VertexShaderVersion to check for compatibility on my work ...Show All

• Windows Forms GraphicsPath.IsVisible(): Unexpected Results

  GraphicsPath.IsVisible() gives unexpected results. I fill a System.Drawing.Drawing2D.GraphicsPath-object with PointF-structures that define the unit-square (0,0), (1,0), (1,1) and (0,1). Then I test 3 different PointF-structures to see if they fall inside the unit- square and the results are clearly incorrect: Point(-0.2, -0.2) falls inside the unit square... WRONG!!! Point(0.2, 0.2) falls inside the unit square... Point(0.7, 0.7) falls outside the unit square... WRONG!!! It seems that the float numbers get rounded to the nearest integer, but that is not what I expect. //class TestGraphicsPath class TestGraphicsPath {  //data member graphicspath  System ...Show All

• Visual Studio Team System VSTS Suite Integration Support for VS2003 / .Net 1.1 Fraoework

  Whether Visual Studio Team System (latest version) would support for an existing product code base which runs on VS 2003 IDE with .Net 1.1 framework. We require the features such as Developers, Testers, architest and Designers. ...Show All

• Visual Studio 2008 (Pre-release) Button as drop down menu? (should be easy!)

  I've looked at examples but can't get this quite right... I want a button (not a split button) to act just like a drop down menu (like File, Edit, etc.). When I left click on the button it should bring up a context menu below it... suggestions http://blogs.msdn.com/llobo/archive/2006/10/25/Split-Button-in-WPF.aspx ...Show All

• Windows Forms Host a Website

  Dear All, Please tell me how i will host/ publish a website to all my local network through IIS Thanks & Regards Muddasir Meraj ...Show All