SQLChamp's Q&A profile

• Visual Studio ServerReport Export - password protect

  Is there a way to password protect the file that is being exported and saved to a users desktop This is a very important topic considering the nature of the data that is being viewed. Please help It's not clear what you mean by password protect. Do you want to encrypt the byte stream or use password protection that is built in to a particular export format You can always export manually by calling ReportViewer.ServerReport.Render or ReportViewer.LocalReport.Render and maniuplating the byte stream any way you want. ...Show All

• Visual Basic FileSystemWatcher - Created events fires too early

  I have been playing with a FileSystemWatcher, to start processing files as soon as one arrives in a folder. Specifically, I'm looking for a zip file, then unzip it. However, when I try to unzip a file as soon as I get the Created event, the file has often not finished being written, and therefore I get an error when I try to unzip it. This time period is very short, a tight loop without pauses trying to open it for write will return OK in 3 loops. Question ======= How do I get FileSystemWatcher to raise an event when a file has FINISHED being written, instead of START being written I just wanted to warn you that you can't depend on a particular number of Changed Events. The number of chan ...Show All

• SQL Server Why no stored procedures?

  We currently develop a large desktop application that uses Sql 2005 (standard edition). At present we use stored procedures extensively. Soon we will be starting a new project that will require offline functionality and again run on the desktop, so we are thinging of using Sql Everywhere. However, the thought of writing TSQL in code (c#) just seems a little uncomfortable at the moment. Why is there no stored prcedures in Sql Server Everywhere One of the great things about SP's is that you can make slight changes to your business rules without re-deploying your app. Thanks for your help Graham I think the biggest difference for me between Sql Server CE (compact edition) and Express is the installa ...Show All

• Visual C# ToolTab Have Gone Hay Wire

  HI all turned on VS2005 this morning and had a shock. My Tool Bar has gone hay wire The General tab has renamed itself #13119 and my Report Item Tab has replaced all the reporting controls with text boxes when I chose for a reset all it does is add another text box in the tab. So I reinstalled/repaired VS2005 and the problem has not been fixed does any one know what i have done to mess my system up and more importantly how to rectify the problem.Many thanks Run the repair for SQL Server to restore the reporting packages if /resetskippkgs doesn't work. Michael Taylor - 12/13/06 ...Show All

• Visual Studio Slow loading Guidance Navigator

  Has anyone run into an issue with a project taking for ever to load when using Guidance Packages (like Web Service Factory). I have a project that sites on the Guidance Navigator for ever (30+ minutes). I recreated the project and loaded in seconds ... then i went in and enabled the Web Services Factory (ASMX) & the DATA ACCESS the Guidance Navigator opens starts loading and never comes back. This issue is a killer ... any ideas on what to look for I ran into something very similar, and deleting my .suo file and letting VS regenerate it seemed to solve it. I was also getting unusual RecipeFramework failure errors at th same time, so these may not have been related. Worth a shot, though, perhaps ...Show All

• SQL Server Sorting Reports with ReportExecution2005 web service

  I've been banging my head against this for a while now and have searched through the documentation and google and posted to the newsgroups with no luck. The ReportExecution2005 namespace contains a sort method, but the documentation doesn't indicate how it's used. The method accepts a string for the sort item, but that string apparently has to be an integer. I've called the method and regardless of the input, the result is the same: * The sort method returns 1 and the report item passed in is the report item returned in the 'out' variable. * The sorting is not reflected in the output of the Render method. I can't simply use interactive sorting because, in our deployment, the SQL Server and Reporting Services are not accessible ...Show All

• Visual Studio 2008 (Pre-release) Implementing spesifications as expression trees

  Hello there, I was preparing a post in my blog about implementing spesifications as lambda expressions that take an object and return a bool, the first problem i got is that applying the "And" extension method to two lambda expression will return a boolean expression , and thats not what i needed. what i need is to be able to write this code Expression<Func<Student,bool>> exp1= s=> s.age>18; Expression<Func<Student,bool>> exp2= s=> s.age<26; Expression<Func<Student,bool>> exp3 = exp1.And(exp2); exp3.ToString(); // prints s => ((s.age > 18) And (s.age < 26 )) Student s1= new Student(); s1.age=20; exp3.Compile().Invoke(s1.ToString()); //prints tr ...Show All

• Visual C# Offsetting UserControl location...

  I am having this annoying problem that I do not understand. I have a UserControl and I am trying to change its Location . I want to say: this .Location.Offset(iAdjustX, iAdjustY); However the above does not work. It seems I need to do this: Point pt = this .Location; pt.Offset(iAdjustX, iAdjustY); this .Location = pt; I do not understand why I cannot just apply the Offset method to the the UserControls Location . Am I missing somthing here Thanks, Bob Markku Behm wrote: Hi We can't know how properties are doing, what is returned. Example Location could be something like this: return new Point(this.x, this.y); Yours Markku I see your point ...Show All

• Visual Studio Team System Unable to use methodology because work item queries have encoding information removed from the XML.

  I am loving this tool....absolutely loving it. However, I believe I've found an issue when performing some edits on the methodology with it. I can't always determine what causes this, but sometimes the editor removes the following line from all the work item queries: < xml version="1.0" encoding="utf-8" > ...so for example the AllWorkItems.wiq file is changed from this: < xml version="1.0" encoding="utf-8" > <WorkItemQuery Version="1">   <Wiql>SELECT [System.Id], [System.WorkItemType], [System.State], [System.AssignedTo], [System.Title] FROM WorkItems         WHERE [System.TeamProject] = @project         ORDER BY [System.WorkIt ...Show All

• Windows Forms how to add eventtab to propertygrid and compile code during runtime?

  hello! i am developing a formdesigner in vs.net2005,and i have some questions:how to add eventtab to propertygrid and display event for the selected component,and how to compile and excute code during runtime,someone can give me some advice,thanks! ...Show All

• SQL Server Error reading certain numeric values with VFPOLEDB driver

  It appears that the VFPOLEDB driver tries to convert numeric types in VFP to decimal types in .NET. In this case, it's a Numeric 9,3 in VFP and it's trying to put it into a decimal 8,3 in .NET. I know that VFP has this funny quirk where if you don't use all of the decimal places after the decimal point, it allows you to use extras in front of the decimal point. In our case, the number is 104895.83 and yes, VFP is happy storing this in a Numeric 9,3 column. When trying to read this in .NET, you get this message: System.InvalidOperationException The provider could not determine the decimal value. blah, blah, blah... The question then is - is there a work-around I can find no way to force .NET to use greater precision. About a ...Show All

• .NET Development Contrast Color

  Hi I currently have a windows form that has blocks of text. The background color of the text can be whatever the user wants. What I want to do is set the foreground color to White if the background color is dark, and to black if background color is light. Or I could just change the foreground color to whatever the contrast color of the background is. How would I go about these methods (Doesnt matter to me which one is used, whichever one is easier is fine) An obvious solution would be to let the user also choose the foreground color. One way to do it automatically is to transform the background color from RGB to HSL (Hue, Saturation and Luminosity). Picking a HSL color that has opposite hue or lumin ...Show All

• Visual C++ Marshal MSG Struct CopyMemory

       I have two projects one is a managed c#.NET application and the other is a win32 dll. I am trying to pass a MSG structure that was intercepted in global hook filter function in my unmanaged code, back to my managed code. ***Relavant code from managed project.           public IntPtr hMsg;           public MSG ThisMsg;            ...            // Pointer that will be sent to the unmanaged dll.             hMsg = Marshal.All ...Show All

• Visual C++ Dll linking error: 2019

  Hi, All I have a .dll file which exports a function called GetData(). The header file RegSys.h contains: __declspec ( dllexport ) int GetData(); The source file RegSys.cpp contains: int CRegSysApp::GetData() { return 100; // sample code to simply the question } The client application imports this function: The header file TestBench.h contains: __declspec ( dllimport ) int GetData(); The source file TestBench.cpp contains: BOOL CTestBenchApp::InitInstance(void) { int nData = GetData(); if (nData ==100) return TRUE; } I did include RegSys.lib, RegSys.dll and RegSys.h in the corresponding TestBench folders. It gave me the errors: TestBench error LNK2019: unresolved exter ...Show All

• Software Development for Windows Vista ExternalDataExchage object crosstalk

  I'm seeing some odd behavior with ExternalDataExchange and wondered if I was seeing the correct behavior or what. I have an app and workflow that share data objects (versus serialized XML or something). The objects, being reference types, are created on the heap and therefore are available to objects running in the same AppDomain. The issue is I expected to see the objects serialized when passing between app and workflow (or back again) such that I would have two different instances of the objects being passed. To me, this was the architectural point of ExternalDataExchange. But that's not what I'm seeing. The objects, being reference types, are merely being passed by reference, so that when they're updated in one location (say, t ...Show All