Peter Homberger's Q&A profile

• SQL Server Interactive sort not working on snapshot reports

  Interactive sorting works just fine on my report until I set the execution property to render from snapshot. When viewing a snapshot, clicking on the column sort arrows will not sort the data I'm viewing. If I turn the snapshot feature off, then I get the interactive sort functionality back. Is this by design or am I missing something fundamental here Using SQL 2005, RS 2005, VS 2005. Thanks. Ron Kaps wrote: Interactive sorting works just fine on my report until I set the execution property to render from snapshot. When viewing a snapshot, clicking on the column sort arrows will not ...Show All

• SQL Server How to write Store procedure

  Hi, I am new to using store procedures Can anyone please check and tell me whats wrong in it   create procedure Poll_Grid @top int, @ofset int, @orderby varchar(50) as if (@orderby = "question")  select top @ofset substring(question,1,50) question, startdate, username,categoryname from polls  join users on polls.userid= users.userid  join category on polls.categoryid= category.categoryid  where pollid not in (select top @top pollid from polls order by Substring(@orderby,1,50))  order by substring(@orderby,1,50) else  select top @ofset substring(question,1,50) question, startdate, username,catego ...Show All

• Windows Forms Is it possible to create a desktop icon using ClickOnce

  I found only one article about creating desktop icons, but that article (MSDN) ruled out creating desktop icons. Is this possible with ClickOnce or not I know windows installer will, but we have a Smart Client and want to provide a way to create a shortcut to the app on the desktop so people could get to it quickly. Any suggestions Thanks   In regards to auto-starting a ClickOnce app, I have written a funtion that utilized the registry to replace the Explorer shell with my own application. My application takes the place of the windows explorer shell (Start Menu, Desktop and all) and is ...Show All

• Visual FoxPro about a project in VFP9

  Please tell me, is a diferent if I create a project (with Project manager) after I have all elements of my aplication (data base, tables, forms, reports, menu, etc) and I will include them in new project, or I must create a project, before I will start to create any componets of aplication Thank you. You can do it in either order. If you write the code first and then create the project, just add the main program to the project and build the project to have all the others pulled in. Tamar ...Show All

• Visual Studio Supported projects

  I'm doing a brown bag on MSBuild in a week or so and I wanted to make sure I had this info right.  VS uses MSBuild for C#, VB and J# (I never install this so I'm not sure) projects.  SLN files aren't MSBuild files but MSBuild can parse them and build the SLN as long as it only contains projects of type: C#, VB, C++ and J#   C++ works because MSBuild just invokes VCBuild on the C++ project file.  Running MSBuild on a SLN file never invokes Visual Studio.  If your solution contains a project type not supported by MSBuild e.g. Setup projects, then you can always fallback to running devenv /build on the solution wh ...Show All

• SQL Server The SQL Top Command

  Hello, Say you have a table listing all the state\counties in the world with the country they are in. What I would like to to is get the top 10 counties by country. I can get the the top 10 counties, but I cannot go that extra step to get it by country, so I get something like: For USA: Coutries 1 - 10 For UK: Coutries 1 - 10 For Spain Coutries 1 - 10 Thanks for your help, Tyrone Hello, What I was trying to do was almost a recursive top command on the same table... I have managed to battle my way through it all now with the aid of some help and cursors. Thank you for trying to help me... For peop ...Show All

• SQL Server Using variable in Web Services Task

  Hi all, I would like to ask how I can use the variable as the input parameter of web services task. In microsoft 's document, http://msdn2.microsoft.com/en-us/library/ms187617.aspx , It suggests the for the value, If the Variable check-boxes are selected, select the variables in the list to provide the inputs; otherwise, type the values to use in the inputs. but I cannot find such Variable check-boxes. It just want to know how I can check the Variable check-boxes. Many Thanks Spencer ...Show All

• Windows Forms app.path ?

  Hi, What's the alternate of App.Path in VB.NET  Here is the VB 6.0 example of App.Path.  fileName = App.Path & "\Debtors.INI"  Thanks in advance:-)  Kash Application.StartupPath is the same in VB.NET as it is in C# Also AppDomain.Current.BaseDirectory should work ...Show All

• .NET Development Exactly when does a runtime callable wrapper call QueryInterface?

  Hello all, we are using a COM component written in ATL that answers queries for interfaces depending on the capabilities of connected hardware. Either it returns E_NOINTERFACE or the corresponding interface. This is implementied with the following entries in the COM MAP: BEGIN_COM_MAP(CController) ... COM_INTERFACE_ENTRY_FUNC( __uuidof (IOptional), 0, &QueryOptionalInteraface) END_COM_MAP() We are currently writing a C# client for this component. The code looks something like this: ControllerClass controller = new ControllerClass(); IOptional optional = controller as IOptional; if (optional != null) { // ...Show All

• SQL Server cannot open a jscript file

  SQL Server CTP Sept 2005. In Microsoft Visual Studio 8 after starting an Integration Services Project I tried to create a jscript file. A file was created but the browser was completely messed up. First I was never able to open it (right after it was created but not yet saved). The file name "jscript1.js" would appear as a separate tab on top of the window next to the "start page" but when you click on it the the file does not appear in the editor window as I assume it should. Instead the same object browset or start page would stay under the tab name "jscript.js file." Sometimes strange vertical stipes appear next to the tool box or instea ...Show All

• Visual Basic MenuStrip shortcuts

  Hi, I have a normal form with a menustrip docked at the top and also a richtextbox. The problem is whenever the richtextbox is in focus, some of the menustrip shortcuts don't work (Ctrl+R for example). The richttextbox seems to be "stealing" certain key events so the menustrip doesn't process them. Could someone please tell me how to correct this. Thanks, Alex Alright, so if I override it in the form but still call base.ProcessCommandKey, shouldn't the base method return true if it was handled by it   It isn't though, so that means the culprit is still elsewhere Thanks, Nick ...Show All

• Visual Basic Invokemember method - Method not found

  While reading Microsoft's .net programmers cookbook I came across the invokemember method. It looks useful - but the example isn't really complete. When I try to impliment it, I get a method not found error. My code is as follows. Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim operation As New Operations Dim typeInfo As Type = operation.GetType Dim args() As Object = {10, 20} Dim answer As Double answer = CDbl(typeInfo.InvokeMember("AddNumbers", Reflection.BindingFlags.Public Or _ Reflection.BindingFlags.InvokeMethod, Nothing, o ...Show All

• .NET Development File is used but i dont know why.

  Hi, i wrote a static class to load my config and save back one attribute to a xml file. Below is my source. When calling the method saveSettings my app stops at the last line and says file is in use...but i dont see how to fix this. Please help. static class configLoader { private static String configFileName = "config.xml"; private static XmlTextReader reader; public static String folderName; public static String folderVariable; public static Boolean logState; public static String emailLink; public static String websiteLink; public static String logfileName; private static void createReader( ...Show All

• Visual Studio 2008 (Pre-release) MSBuild Target Redirection (Alternative to install/uninstall Linq to VS)

  Jomo (etc): I'm guessing the same technique to get .NET 1.1 targets in VS2k5 would work for getting a Linq target   Am I missing anything tricky about how the preview compiler operates Someone should make an app to automatically generate a new C#-like target definition for MSBuild, I suppose.  Feed it compiler and framework locations, and optionally where to store the new VS template... Hmm... I do like that, in general, though it may be more useful for retargetting frameworks, to deal with People Who Refuse To Upgrade, so that you can downgrade to broken logic, or use third-party bits. ...Show All

• Visual Studio Team System name of the super class

  Which is the sentence that returns the name of the super class. I wanna know the name of the class that ihnerits it (his father). Rodrigo Harambure wrote: I wanna know the name of the class that ihnerits it (his father). Do you actually mean, the name of the class that it inherits To retrieve that, use the BaseType property. ...Show All