DennisCIS's Q&A profile

• SQL Server Place Unsorted row at end of detail

  Hi There I have a row returned from my stored procedure called 'Total', I would like it to appear at the bottom of the detail section rows. I have placed the below expression on the sort on the table, trouble is now that 'Total' is not being sorted it appears at the top. Is there a way to get it to the bottom =iif(Fields!Item.Value <> "Total", true ,false) Thanks in advance Dave several possible options reverse the true and false part of your expression change sort direction ASC / DESC use an integer instead of a boolean personally I prefer to derive a sort order column in my source query and just use the field in my sort expression ...Show All

• Visual Basic new at this...compiling my app

  Hi everybody~ I have a dumb question… I am using VB.Net 2005 Express, and relatively new at it. So far, I have “published” an app and given it to two people. I noticed right off that it was not what I expected, it was a few files (including an exe) and a folder. Anyway, both times it was installed, the user had to download and install the .net 2.0 framework which took as much as an hour to download and install. Is this right Is there another way to compile instead of publish Will all of my users have to go through this lengthy preparation Would it be different with VS 2005 Standard or Pro Please enlighten me! Thanks, Mike I had the same problem ...Show All

• Visual Studio can't installing

  I am follow " Extensibility Guided Tour" article to make my msi file. But, when setup it then have messagebox " This is a VsPackage and Requires Visual Studio to be installed". Please help me.. thanks.. PS: I have PLK. Hi Dmitry Pavlov: Excuse me... I can package my VsPackage using this file named Product.wxs to xxx.msi. But, after installed it on other machine, the open VS.NET IDE no see my VsPackage.. Can you help me... Thank you... My Product.wxs is : ---------------------------------------------------------------------------------------- < xml version="1.0" encoding="UTF-8" > < define ProductShortName = "NPXmlTree" > < ...Show All

• Visual Studio 2008 (Pre-release) Extending DataContext?

  Is it or will it be possible to override the internals of the DataContext I want to alter the object creation implementation in the datacontext to create subclass proxies instead of just instancing the entity types directly. However DataContext seems very black boxish. Im well aware of the claims that non virtuals execute faster than virtual methods etc.. but in this kind of scenario where big chunks of data is fetched from some sort of datasource , those few nano seconds will be impossible to notice.. so that will hardly be a valid argument. Ive seen that there is a "services" collection inside the datacontext , but that also seems impossible to access from the outside. it would be really really lovely if such things were expo ...Show All

• Smart Device Development I want to have a button navigating to My Documents

  I want to have Buttons in a VB Form navigating to places like,My Documents, Network Places, My Pictures etc. Does anone know code for me to be able to do this... Thanks you shouldnt need to access the registry. You will have problems eventually such as security issues.  Nor should you need to create a batch file :-) Best thing to do is spin up a process of the MyDocuments using the Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) the SpecialFolder enumerator gives you a list of standard user folders you can access. This would be the best way ...Show All

• Visual Studio Team System Cannot access the 'Reports' folder in Team Explorer

  Hello, I cannot access the 'Reports' folder in Team Explorer; it has a red cross on it. I'm a Project admin, Team admin, and Reporting Services admin (as set in the Reporting Services Site Settings, site-wide security settings). This doesn't happen for users that are local admins on the server OS (which is Server 2003), but surely there must a better way best regards, /Tomas Check out in from Client side in Team explorer...... if you are getting "Permissions are unsufficient..." means definetly it is the problem with permissions in accessing Repoting services.. can you please log in as tfsreports id in the server or RUN AS "TFSREPORTS" id and run the following URL: http://< ...Show All

• SQL Server Cannot bulk load because the file could not be opened. Operating system error code 5(Access is denied.).

  I am facing a issue with bulk upload on Test Server. Issue: When running Openrowset command from SQL server other that Test Server query runs fine when trying to run the same command from Test Server it gives error. Msg 4861, Level 16, State 1, Line 1 Cannot bulk load because the file " \\ServerName\input\FileName.csv " could not be opened. Operating system error code 5(Access is denied.). For example: If the command is run from System A connecting to SQL Server instance on Test Server Test Server it gives this error. If the same command with same rights is run from any other SQL server instance say Dev1 its running fine. If the command is run from Test Server connecting to any SQL Server instance includin ...Show All

• .NET Development Passing login information to remote windows file share

  I have looked all over the net for information on how to do this and am still lost. I want to copy files from a remote server that has file sharing enabled, however the login information does not match the local domain. So when I try a File.Copy on the remote file I get a error unless I first launch iexplore to the URL of the site ( \\10.100.1.1 for instance) and then it will allow the user to manually authenticate and after that it works. Is there any way to automate this and pass the login info Since no one ever really gave me a answer, I'll answer it myself. The above method was the solution to getting logged into the remote server on a different domain. The problem with my call to mapnetworkdrive() wa ...Show All

• Smart Device Development Creating Smart Device CAB Project Help!

  I created a Smart Device CAB Proyect, but h ow can I relate this new empty proyect with my existing windows ce application, so I can load the necessary files into it Please Help What version of the framework/Visual Studio are you using If you are using VS.NET 2005, there is a Smart Cab Project Setup in the setup & deployment project solution, which you can use and create a deployment cab for your project. Make sure you open up your actual application project solution and add the new setup & deployment project (Smart Cab Project) in this solution. Simply from this on the project, add the files you wish or create the shortcuts you want the application setup to create on the clients' mob ...Show All

• Microsoft ISV Community Center Forums Office 2003 and 2007 Primary Interop Assemblies (PIAs)

  Microsoft has an MSI for installing the Office 2003 PIA and a different MSI for installing the Office 2007 MSI. The web site says that the 2007 MSI is for Office 2007. Will it support 2003 VSTO routines Will it install with Office 2003 Will it provid a return code if it doesn't install Will VSTO routines written for Office 2003 work with Office 2007 with the 2003 Interop installed Will the 2003 Interop even install in an Office 2007 machine. Yes, we can set up virtual machines and spend hours figuring it out, but shouldn't Microsoft have thought of thi an published it in MSDN or, butter yet, put it on the site that has the MSI's Why not do it right and release an MSI that installs the right PIA regardless of which version of O ...Show All

• Software Development for Windows Vista Vihang's Re-hosting Workflow Designer example errors

  Vihang, I am receiving the following message when using your Re-hosting example code: Property value is not valid. The Service 'System.Workflow.ComponentModel.Design.IExtendedUIService' musy be installed for this operation to succeed. Ensure that this service is available. Have you seen this before Is there a reason I cannot view the Invoked handler in the properties windows I look forward to hearing from you soon. Thanks in advance, John P. Jon, I am still getting the same errors. This template causes error when running my code. I commented out certain things in this template so that I can run the code, but I get the same errors when trying to access properties via the UI designer. Let me know if y ...Show All

• Smart Device Development Compact Framework 2.0 / Web Service Performance

  Hi all, I want to connect to my sql server 2005 database from a device (there is compact framework 2.0 on it). But i can do this by connecting to database directly or by using web services. I want to ask you that which one will show better performance Regards.. Direct connection will show best performance, naturally. . ...Show All

• .NET Development Access problem - query returns some empty rows and some with data

  Hi, I am running a query that returns rows with data and rows that are empty (e.g. 5 first rows empty, next 2 have data, next 3 are empty, next 10 have data - when all rows should have data). Has anyone ever dealt with something similar Any advise A. Are you doing this in MS Access An Access query When you create tables in access, you can set the 'Required' property of a field to 'Yes'. You can also set this field to accept a zero length string (""). This prevents it from having a Null value. So you could have a row of mostly empty fields, none of which are Null and therefore returned by your query if there is no criteria to prevent it. Steve ...Show All

• Visual C# Thread Form issue

  I have a form "MDIMainForm" where i am starting a new Thread so check some data in a database. This Thread loops infinetily and opens up a new form "popUpMsg" if relevant data is found. The problem is that the "popUpMsg" form is not visible when it is created in the Thread. However everything works fine if i create the new "popUpMsg" form in the same thread from the "MDIMainForm". However i can not do this because my application pauses until the "popUpMsg" form is closed I am not sure why i can not see it. but i know it is there. (i print a line in the Console to know this) Any ideas I would appreciate any help you may also wish t ...Show All

• SQL Server New file notification

  Hi All, I am vey new to NS and here is what I am trying to achive: User creates/copies over a file on the network. When this happens, I want to start an existing Job (SQL stored procedure) in SQL Server Agent. Any lead (existing sample applications etc.) for me to start is apprecitated. Thank you. Thank you Ragas. I looked at some online examples and worked it out. This article was quite helpfull: http://www.devx.com/dbzone/Article/28522 ...Show All