TomJ72's Q&A profile

• SQL Server How to sort a table with a parameter

  I have a "Sales shipments" report with several colums. I want a parameter for the user so he choose how to sort. I have two colums in my report I want to sort on: ItemNumber and DeliveryDate. I added a Report Parameter UserSort with two labels (and values): Item (ItemNumer) and Date (DeliveryDate). Then I tried to set the sorting I tried with the CASE statement but no result. Maybe I didn't use the right code. For that reason I post the code: SELECT [DatabaseName$Sales Shipment Header].[Order No_], [DatabaseName$Sales Shipment Header].[Requested Delivery Date], [DatabaseName$Sales Shipment Header].[Sell-to Customer Name], [DatabaseName$Sales Shipment He ...Show All

• SQL Server I've installed SQL express, now what?

  This may be a stupid question, but I've installed SQL Express and I don't know what to do next. I went to my program files/Microsft SQL... and the only folder present is a configuration folder. Next I went to my control panel/admin tools/ODBC and succussfully created a user data source. (With the help of the forum!) Obviously, I've never used SQL before, but I've read a couple of books and other stuff online, and I want to teach myself. So I decided to install this. Basically, I'm looking for answers on how to access the database. I know it's installed, it's in the Add/Remove programs list. I just don't know how to connect/access it. Sorry for the dumb question. Stacey I think I figured it ...Show All

• SQL Server Changing network packet size doesn;t work

  Hi. I have querry that exuecuted time is 4 seconds on server and 22 sec. on client computer. I trace communication beteew client and servere. There are about 9000 packed sent in both directions. To resolve problem I change network packet size from deault 4096 to max (32767). After this still there are 9000 connections .... Where is the problem ..... I have 100Mbit network between server and client computers Regards, Walter Also, the underlying transport protocol (most likely TCP/IP or Windows named pipes) is free to break of SQL Server network packets into smaller pieces. This means that when you're looking at network traffic you'll likely see packets in the size that the transport proto ...Show All

• SQL Server Two tables, one dataset. Performance?

  If I create a report with one dataset referenced in two tables, will the dataset be queried twice, or once, and copied to both tables (preferred). I am trying to create a report with a summary report and then summarized detail report, both using the same data. ...Show All

• SQL Server Default parameter value is no longer part of cascading parameter in SSRS 2005?

  Hi, I need "conditional" cascading parameters: In Report Manager when one changes parameter 1, parameter 2 get changed based on parameter 1. Optionally, one can also enter values to parameter 2 directly. I was able to achieve this in SSRS 2000 (SP2) with the following setups. SSRS 2005 and SP1 no longer works - Parameter 2 always shows its default value regardless whether one select a value in Parameter 1 or not. Parameter 1 available values: from query default values: non query (specify a value "<None>") Parameter 2 available values: Non query (no value specified) default values: from query (based on Parameter 1) It seems to me that the default value in SSRS 2000 is considered as cascading paramet ...Show All

• Visual Basic JIT Debugger Error message caused by filelistbox

  I have been working on a program and testing it on another computer that has the .Net framework installed. My program works fine on my computer with .Net installed. However, when I run it on the other computer (with only the framework installed) I get a random error: MyApp.exe - Common Language Runtime Debugging Services Application has generated an exception that could not be handled. Process id=0xf3c (3900), Thread id=0xf64 (3940). [The numbers in this error line are different everytime] When I hit cancel to debug it displays MyApp.exe - No debugger found. Registered HIT debugger is not available. An attempt to launch a JIT debugger with the following command resuled in an error code of 0x2 (2). Please check co ...Show All

• Visual Studio Express Editions Help with "Concentration" Game

  I am a student studying VB for the first time and I've run into a snag programming as assignment. It's a matching game consisting of 8 pairs of matching words randomly assigned to 16 labels. When a label is clicked, the word currently assigned to it will display. If two labels are clicked and the words match, the labels are disabled and change their color. This is done until all 8 pairs of words are found, after which a message box is displayed indicating the game is over. I am confused as to how I can randomize the list of words and assign them to the labels, as well as how to check for matching. Any help would be appreciated. sure, well like i said that was an example which you need to modify to your nee ...Show All

• Windows Forms c# Insert Text into Textbox

  I have a series of textboxes on a Windows Form and a Series of buttons aswell. What I am trying to achieve sounds quite simple but I cannot figure out how to do it. Basically all Im trying to achieve is each button has some predefined text associated with it and when the user clicks the button, it inserts that text into the textbox which has the focus. The problem with this is that when you click on the button you lose the focus from the Textbox. The only way I have figured out is to save which control has focus before the button is clicked. This works but when you have 32 textboxes on a form, surely there is a better way than creating an On_Enter Method or similar to set the value of the Control which needs the text. Any help would be ...Show All

• .NET Development Decimal separator/Decimal places

  Hi, I'm creating a VB 2005 Express application. I'm new at programming. I've Bind controls to a DataSet. How can I know what is the Decimal separator In the windows settings we can define "," or "." as the decimal separator. When I get user input from a textbox and perform calculations, if the user enters "0,5" or "0.5" the result will not be the same. How can I prevent this and guarantee the input of only the decimal separator defined in windows Other question is how can I show the number in a text box with the decimal places defined by me For example, how can I show the number "2,00" in a text box (or label) (assuming 2 decimals). As I wrote, this controls ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DRAW simple 3D CUBE - InvalidCallExeption

  Hi guys, I was able to succesfully complete the 3D Cube tutorial, The build was succesfull,but It throws an Exception at this line: graphics.GraphicsDevice.DrawUserPrimitives< VertexPositionColor > ( PrimitiveType .TriangleList, 12,nonIndexedCube); Does anyone have the complete code and if you guys do could you please copy and paste it.If some one from the XNA Team could please check this Exception I would realy appreciate it. Also i would love to know where to place, the folowing lines of code : VertexPositionColor[] nonIndexedCube = new VertexPositionColor[36]; Vector3 topLeftFront = new Vector3( -1.0f, 1.0f, 1.0f ); Vector3 bottomLeftFront = new Vector3( -1.0f, -1.0f, 1.0f ); Vector3 topRightFront = new Vect ...Show All

• SQL Server Can connect to 'ServerName' but not to its IP address

  I'm using SQL Manager from my Enterprise server to connect to my SQL Express server that will act as a witness to a db mirroring system. If I try to connect to the SQL Express server using its IP address, I get a "named pipes error 53." If I connect by browsing the network and connect to the Name of the Server "Machinename\SQLExpress", I am successful. I would like to be able to connect to the IP directly as it's not dependant upon certain services to be started or configured a certain way. Thank you, Chad Try Data Source=tcp:192.168.0.3,1433 in your connection string using applicable IP and port number (remember to setup port number in SQL Configuration Manager on the SQL Express machine). ...Show All

• Visual C# typeof permissions

  hello, I've been getting an error in my code, that I think occurs when I try to get the typeof my created object: System.Resources.ResourceManager resources = new System.Resources.ResourceManager( typeof (Control_object)); Are there security permissions needed for this to work properly, without getting a security error Thanks for any help. From what I can see in the stack trace, the error seems to be occuring on the next line, where you call MyClass myobj = resource.GetObject("MyName"); The exact syntax of how you wrote that line would be helpful. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Dynamic Effects while Playing Direct Sound Buffer

  Hi, I'm playing a Direct Sound Secondary Buffer on my sound card. I'd now like to apply effects to this buffer and control these effects in real-time using sliders. The problem is that SetFX only works on non-playing buffers- http://msdn.microsoft.com/library/default.asp url=/library/en-us/directx9_c/IDirectSoundBuffer8__SetFX.asp I have tried stopping the buffer, changing the effect, and then playing the buffer again, but I get glitches when I do so. Even if I comment out the setFX function I still get glitches. How should I be doing this Thanks for your help, Barry. Hi, To enable/disable an effect you must stop the buffer, but to change parameters of an effect you don't. See the example SoundFX of ...Show All

• .NET Development C# SerialPort System.ObjectDisposedException, safe handle has been closed in System.DLL

  I have an application in which at start up I need to do a port discovery process to determine whether instruments are attached to the end of any number of PC com ports. These com ports could be Bluetooth enumerated or, using FTDI USB to serial line convertor drivers, a USB connection. At start up I determine which ports are being used for this session by interogating all the ports stored in a list. I do this by opeing the port and then using a synchronous write and read (using timeouts of 500ms). I put try and catch around the port open to capture the case where the port has been disconnected (USB) or is not currently accessible (Bluetooth) and create a list of instrument objects each of which will have its own serial port object. Before g ...Show All

• Windows Forms print panel

  How can I print a panel in windows form which include many other controls regards Isn't there a printpage dialog in the toolbox Try it. How more you try, how better you get ...Show All