issarto's Q&A profile

• SQL Server ReportItems in Page Header

  I've added a hidden field to my report so I can show the value in the page header using ReportItems. However it only works for the first page - the value is blank on subsequent pages. Does the hidden field need to appear on all pages of the report Would I need to make it a hidden field in a repeated list or table Hammer, That may work if you only have one row in a dataset, but if you have more than one row, it only captures the first value in the dataset. ...Show All

• Community Chat I can't believe most Windows users don't know how to use toolbars, OMG.

  This is most irritating. Almost all of Windows users in my company don't know how toolbar works. They don't know they can enable toolbar, take out toolbar, customize toolbar, and not even the simplest of all, move toolbar around. Toolbar is so simple, standard, and flexible. And yet, they don't know how to use it. And now, I think that's the main reason why IE7 doesn't support moveable toolbar, and that pisses me off even more. Argh. Humm, yeah, that make sense. One of the biggest pain of reinstalling Windows and everything else is to configure stuff. I have turn on, show hidden file, show file extension, enable quick access bar, turn off window grouping, setup all my download paths to my own folder (hate ...Show All

• Windows Forms How to trap keyboard event. like Esc and Delete etc.

  in my case , i want the same ability like in VS IDE which is when on design surface, select a control and then press ESC ,the Selection Control will turn to it's parent control. i trying to add the messageFilter to handle the key event . but it will trap all key events in the application. Apperently this not meet my requirement, i just want the design surface handle the message. i have tried to handle Message Loop as well it doesn't work ; for example: System.Windows.Forms.Application.AddMessageFilter(_msgFilter); ...... public class MessageFilter:IMessageFilter { private BaseForm _owner; private const int WM_KEYDOWN = 0x0100; private const int WM_RBUTTONDOWN = 0x0204; public MessageFilter(BaseForm owner) { this._o ...Show All

• Internet Explorer Development IE7 webbrowser control Problem, VB6

  I am using wbcontrol.Document.parentWindow.frame.Navigate (Url) in the BeforeNavigate2 event the Url is "about:blank" This used to work untill we installed IE7 anybody got an idea regards ...Show All

• .NET Development AccessViolationException with C# Ping class

  I have a "watchdog" program, c# console application, coded with VS 2005. Program runs every 3 minutes. And one part of program checks pings to ~20 ip's. I'll give that function code: static private bool ping ( ref String ip) { bool success = false ; Ping pingSender = new Ping (); if (pingSender.Send(ip).Status.Equals( IPStatus .Success)) { success = true ; } else { success = false ; } return success; } Usually this works.. but sometimes (once a day on the average) it throws an exception and program crashes: Unhandled Exception: System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. I checke ...Show All

• Visual Studio Express Editions Video won't play correctly?

  I've been trying to play the tutorial videos, and they sort of...  Glitch out, like I don't have the correct codec or something.  I remember this from a Raknet (a network API mostly used for games) video a long time ago, had the same problem, but I can't remember what I did in order to fix it. Nevermind, I fired up DivX player and it works fine. Windows Media Player probably needs to be update or something... I will move the other half of this post into a new thread. ...Show All

• SQL Server One receipt number, query multiple tables gives multiple data.

  I have just taken over the job of sorting out a rather poorly designed database. It looks like it was 'upsized' from an access database to the SQL server. The SQL server is the 2000 version. Now I am trying to generate a report of what the students in the database are owing by referencing the Receipt table and then all the available payment methods and allocations. I was wondering if there was anyway to work out data being displayed twice (Let me demonstrate) Note1: All the tables are linked by a key of ReceiptNo. From what I can see there is a table for every payment type and allocation but no link between the two other then the receipt number. Using the query: SELECT T_Receipt.ReceiptNo, T_cheque.Amount AS Chq_Amount, T_credit.Amount A ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Can't deploy to Xbox 360 from GSE

  All Apologies but this is a repeat post from 31-Jan buried inside another thread that appears to have died. I can't push code to my Xbox 360 from GSE.  This issue has been reported by other people and their problems boil down to either having entered the 25-digit code incorrectly or, in one case, that their router didn't properly support UPnP. I've regenerated, accepted and reconfigured the key *many* times, making sure I don't have any 0's, 1's, 5's or 8's in the generated key to avoid confusion.  I understand this is a one-time key so I'm not reusing an old key.  I am most definitely getting the key right and choosing accept, not cancel. I have downloaded and installed Windows Media Connect (I'm running Windows ...Show All

• SQL Server SAP connection

  Hi everyone, We are trying to send data from SQL into SAP-BW as far as We are it look like every thing is set at SAP side but We can't send data. Does any one has information about what should I set in SQL side because all the information that SAP people konw is that I have to create a user in SQL but they don't know any thing about the security. Thanks. Hi, I'm using RFC via SAP DB Connector, I set the information at SAP side to connect to SQL and it's working fine I can see tables and it's data with in the SAP data source builder but when I try to upload data into an infoobject I can't read any data SAP sends the message no idoc read from source system. Thanks for your help. ...Show All

• SQL Server Impact of ALTER DATABASE GPx SET NEW_BROKER WITH ROLLBACK IMMEDIATE in production db

  System Configuration : OS : Windows 2003 latest SP SQL Server : Standard Edition, SP2 Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1) DownTime : This is not a 24x7 kind of machine. It can have downtime Reference : http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1198044&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1026884&SiteID=1 I have been discussing this Service Broker issues in this forum for quite sometimes and sorry to bother u all again… To make things more clearer before im ...Show All

• .NET Development selecting a child

  Hello, I want to find a single node by name. I'm using the SelectSingleNode method of the XmlDocument object the problem is that when the XML contains child elements of type comment this method does not work. Is there a way to find a node by name if there are comments node in the xml Thanks, You keep us intrigued. It's easy to say what's wrong with particular XPath expression then guess what can be in yours that forces it to behave this way. ...Show All

• SQL Server no luck w/ execute sql task and assigning variable

  Hello, I've asked this question before and I've read the answers before and I still cannot get it to work. My task is simple, I want to use the execute sql task container to grab a value from a database and put it in a variable. I've done all the preliminary stuff such as running profiler to make sure that the package is getting the call to the database, setting up the ResultSet to be "single row" in the general tab, mapped the Result Set correctly, but nothing works. I get the same error every time. This is my sql command: select output_location as output_location from script_master Result Set is set up like this: Result Name: output_location ; Variable Name: User::output_location Here is the error I get: ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Gaming groups or websites

  I'm looking for a good 2D gaming development group or website. For example, DeviantArt is where artists go to share their work with other artists. Is there a game dev equivalent I'm a 2D, RPG developer typically. If you know of any other great communitys out there (apart from this one, of course), please let me know. Thanx! *jinx Well the GarageGames have recently opened the Great Games Experiement - a social network for gamers, developers and publishers. I wrote a review of my experiences so far. ...Show All

• SQL Server Script Task, debugger stops and waits indefinitely

  Hello, I have MS SQL Server 2005 with SP1 installed, version 9.0.2047 I am trying to debug a Script Task in SSIS. I have break point on the first line of the code. SSIS runs and eventually launches MS Visual Studio for Applications. Line with the break point is highlighted in yellow. After that Visual Studio is frozen. F5, F11 or any other key press produces a popup which says the following: Delay notification. Microsoft Visual Studio for Applications is waiting for an operation to complete. If you regularly encounter this delay during normal usage please report this problem to Microsoft. Please include a description of the work you were doing in Microsoft Visual Studio for Applications and when possib ...Show All

• SQL Server DTS Package Migration Error

  I've been migrating SQL 2000 DTS packages into SQL 2005 using the Migrate DTS 2000 Package wizard in Visual Studio 2005. All packages migrate fine except one which throws out the following error: exception of type 'Microsoft.SQLServer.DTS.MigrationWizard.HelperUtility.DTSMWException was thrown No other supporting information is given to help diagnose the problem. Has anyone else come across this error before Looking at past threads, I've checked the DTS package for leading or trailing spaces which might cause an issue and there are none. Thanks. Hey i found the problem. if you are package is Incompleted take an example "doing the bulk insert from SQL Server Conn to Excel sheet but with ...Show All