Chiwi's Q&A profile

• SQL Server Pagination

  Hi, I have recently moved into ms sql from mysql and having problems with finding a query to help paginate my search results. In mysql I would use: SELECT * FROM tablename WHERE something = something LIMIT 0,10 what would a similar query be in sql server From what I have experienced so far I know this is going to be a big query! Thanks in advance Steve 209 views and no replies!! ...Show All

• Software Development for Windows Vista The requested operation requires elevation.

  I am connected to wireless network in my city. The problem is that when I want to connect to city wireless I need to add a route in Command prompt. In XP it works fine, but when I type this in Vista: route -p add 10.0.0.0 mask 255.0.0.0 10.46.2.1 I recive this message: The requested operation requires elevation. I realy need to do that, otherwise I can't access any page on wireless except 10.46.2.*. ...Show All

• SQL Server How to use dynamic query parameter in RS?

  Hi All, I am trying to make my first report using dynamic parameter to query oracle database. The parameter list is list of several year. The report will diplay the data from the year the user choose in report parameter. This is no problem. But when I want to show data from all of the years which I add a item i parameter list with "All", So if user choose All, the report will show all data. Thanks for any help. Here is my quer ...Show All

• Visual Studio Team System Feature Request

  Surely it is not too late to ask for this incredibly nice feature. When I am in the Source Code Explorer and I navigate to a solution (SLN file). I should be able to open the solution from that dialog (right-click open Solution, or something). Thanks/ Well, I feel like an idiot. Why didn't I just double-click it and not (***)(u)(me) that clicking it would simply view the file in the text viewer. All these months of browsing to th ...Show All

• Visual Basic Totalling the hours of a column

  I am using vb.net express and fairly new to database programming. In my program, one of the columns shows the hours worked for each employee. How do I show in a datagridview control the total of all the hours in the column mentioned above. I tried using the following sql command but it doesn't work for me Select EmployeeID,LastName,FirstName,SUM(HoursWorked) AS TotalHours From Employees       ...Show All

• Visual C++ How to use the HeapWalk() function

  I use the HeapWalk() function to check the Committed and UnCommited Memory of a heap. But when the lpEntry.wFlags equals to 0, I don't konw the "0" is which status of the block. and how to know the true size of this block. Thank you reply this question. Now I know the "0" is what. But I run the statement "bytesFree = lpEntry.cbData;" the cbData show the size is "820&qu ...Show All

• Visual Studio VSS6 with VS.NET 2005 RTM

  We have been using the VS2005 Beta2 in conjunction with VSS 6.0d for about 6 weeks now, without problem. Everything was working very well, checking in/out, etc from the VS interface. I just installed the VS2005 RTM and when I start VS2005, it no longer recognizes that I have any Source Control. Furthermore, when I attempt to open the project we have been working on, it gives this message: "The project X:\NETPROJECTS\ProjectName appears ...Show All

• Visual Basic resizable form window and controls

  How can I make my VB.net form and all the objects within it resize to suit the window I wish to switch from full screen to tiled with other apps without having to scroll to get to buttons. Controls could either scale up and down or compress/stretch. Can you set the minimum window size Hi appolospb I am having trouble with the anchor property and liked your approach and wondered if you could help me too. I have also spent many hours ...Show All

• Visual Studio Tools for Office ItemAdd Event Problem

  Hi all, Currently i am doing development in VSTO for outlook. I have encounter this problem, where the ItemAdd event only trigger only once and subsequently the event is not trigger anymore. What could be the problem Below are some code which i have use: I have store the MAPI folder in a linkedlist on the application start i run this method to add it the event. private void addOtherFolderEvents() { try { LinkedList&l ...Show All

• Smart Device Development Serial Port DataReceived Event in .Net 2.0

  Hi there, This is driving me crazy, I cannot seem to get the DataRecieved event to work on the Pocket PC using the new serial port class in Visual Studio 2005 with C#. The DataRecieved event just never seems to be called. I can write data to the port just fine. Here is some very simple sample code that reproduces the error:. using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; u ...Show All

• Visual Studio Express Editions Error .exe is missing question

  I'm geting the error messege "Video Studio cannot start debugging because the debug target 'C:\\documents and settings\name\local setings\application data\temporary projects\ConsoleApplication1\bin\debug\consoleapplication1.exe is missing. Please build the project and retry or set the outpath and assembly name properties appropiately to point at the direct location for the target assembly." when i try to run a simple hello world progra ...Show All

• Visual Studio Error with MSBuild and Hatteras client

  Here's a chunk of my buildlob.log file.  Is anyone having problems like this Using "CreateWorkspaceTask" task from assembly "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.VisualStudio.Hatteras.MSBuild.dll". Task "CreateWorkspaceTask" C:\Program Files\MSBuild\Microsoft\VisualStudio\v8.0\TeamBuild\Microsoft.TeamBuild.targets(86,5): error MSB4018: The "CreateWorkspaceTask" task failed unexpectedly. Micros ...Show All

• Visual Studio Master-Detail Reports

  Is there anyway to do a Master-Detail report with a separate table for the Master data and one for the Detail Crystal Reports does this, as crappy as Crystal is I'd hate to lose something. Did you manage to find an example using a subreport I cant seem to find one, im trying to link my main report to the main table and a subreport to a details table but cant seem to get it to work The only examples i can fin ...Show All

• Visual Basic Accessing Public Function located in another Project referenced within the same Solution

  I've to a solution with two projects: Bungalow New Programs New Programs has a ref to Bungalow. Bungalow has a Module called Bungalow which has a Public Function (clone_control()) From within 'New Programs' I can not access Clone_Control. However, if I drag (wihin the Solution Explorer) the Bungalow module from Bungalow to New Programs, then it works OK. I thought that adding a reference was like lett ...Show All

• Visual Studio Team System GetLatest before checkin policy

  Hello, I'm using the following configuration: 1. One integration project 2. Each programmer has one or more workspace on the integration project I don't want a programmer to do checkin to an unchecked work (means he didn't checked what's going to be in the interation). I want to enfore the programmer to do GetLatest operation. In this operation he might be required to do merges. How can I enforce this methodology If there i ...Show All