Paul Lowther's Q&A profile

• SQL Server dynamic query

  hi, i'm using dynamic query in the dataset because i wanted the result to group by the particular parameter selected. however, another parameter requires the data to be taken from another table. is the following syntax acceptable =if (Parameters!rev_data = 'A') begin "select a,b,c.... from tableA" end else begin "select d,e,f.... from tableB" end i encounter this error : 'Expression expected'... is the ...Show All

• Visual Studio 2008 (Pre-release) Logging

  Hi, I'm trying to see the actual bytes sent across the wire by my WCF services. I've turned on full diagnostics but I'm not sure whether that logs in its own custom XML format so that the trace viewer can use it. What I want to see is the actual bits and bytes sent across the wire so I can verify that things are encrypted / encoded as I expect. How do I do this I tried using the SOAP Toolkit's trace utility but that doesn't seem to work ...Show All

• Visual C# C# .NET Naming Conventions

  Does anyone know where I can find a list of naming conventions for UI elements.  I found a bunch of places where they have variable, property, method, event handler, formatting style, etc. conventions.  But I am having a hard time finding naming conventions other than the Visual Basic 6.0 Naming Conventions on Microsoft's website. As the programming world is rapidly moving away from hungarian notation, ...Show All

• SQL Server Why can I not read VARCHAR(MAX)?

  Hi there. Can Anyone help We have recently started to use SQL Server 2005 Express for a client. We have to accommodate some fields which exceed the 8000 character size for a VARCHAR, and all the advice says to use VARCHAR(MAX). If we do, we can place data there, but seem unable to read it back. We are interrogating via ODBC (SQL Native Client) using ASP (not .NET) on a windows 2003 server via IIS. We can find nothing at all on the web to h ...Show All

• .NET Development How do I insert new related rows with a Dataset?

  I can use a trigger to automatically insert new rows into related tables when the Master table creates a new row. That works fine at the table level. Something along the line of MasterId (Identity)= ChildId. What is the best way to do this with a Dataset Example: Working with a bound DataGridView; adding, editing, and deleting multiple rows within a Dataset and then automatically inserting the correct number of rows for the ...Show All

• Smart Device Development Is any message sent to a program when I stop it in Start->Setting->Memory->Stop Running Programs?

  Hi All, I have some resource to release when quit the program, so can I receive any Message when someone stop the program by killing the thread Thanks~ Thank you , I have tried that if I stop the dialog program, the dialog can receive the OnDestroy() message( also OnClose() ), but if I DoModal another dialog based on that, then I stop the program in ..->Memory->Stop Programs , I receive no message . ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Matching view to world - help!

  1. I have a number of meshes placed in world space. 2. Each mesh is being rendered using three vectors: scale, rotation and position. 3. I am calculating the world matrix with SCALE_VECTOR * ROTATION_VECTOR * POSITION_VECTOR . 4. One of these meshes represents the camera. So, when rendering this mesh I also set the view matrix. 5. The view matrix is calculated using LOOKATLH using the POSITION_VECTOR as the eye and POSITION_VECT ...Show All

• .NET Development 64Bit Compiler?

  According to: http://lab.msdn.microsoft.com/vs2005/productinfo/productline/default.aspx It seems like its only Pro version, and up, that has 64bit compiler.. Is this true Will this mean, that if i buys another verison of Visual Studio 2005, a express version for instance, i wont be able to compile to a 64bit I tried compiling to a 32bit application with the beta of Team system, im running right now, it wasn't able to run a 32bit application(Im r ...Show All

• Architecture good C# 2.0 architecture book for Window application

  Hello, can anybody recommand a good C# 2.0 architecture book for Window application I moved from VB6 to C#. Need a intrduction book for clear writing, not high level with samples. Some samples on N-tier design is better. Thanks. the patterns and practices books are a good start. http://msdn.microsoft.com/practices/ ...Show All

• .NET Development Configuration Sections

  Hi, I've just started playing with VS2005.  We currently have a VB.NET application which uses a custom config section implemented by declaring a class which implements the IConfigurationSectionHandler interface and which was invoked by declaring it in the <configSections> section of app.config. The section handler so defined parsed a 'systems' configuration section in app.config and returned a collection of objects from its Creat ...Show All

• .NET Development IIS Problem (URGENT-PLEASE HELP!)

  Hi, I've two application server and one database server, on of the application servers shows the following error : Server Error in '/rzvHIS' Application. -------------------------------------------------------------------------------- Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. Description: An u ...Show All

• Visual Basic Binding TSQL Procedure to ListBox

  I am attempting to bind the output of a TSQL procedure (that takes 1 parameter) to a ListBox on a windows form. I had thought this may be easy, but have come to a dead end after searching for hours on this. So in simple, I have a TSQL procedure (let's call it GET_DATA) and it takes a single parameter (say @recordId) and it returns 2 columns (name & Identifier). Now I wish to have a List Box populated so that it displays the name field and ha ...Show All

• Visual Studio Express Editions Getting data from a query into variables

  I have a table that I want to query based on a Selected Record in a gridView.  I have the Record Number (that is the actual key field name) in GridView.SelectedValue but  I have no idea how to set up a query in here much less run it.  I need to know OldLine and oldItem from a table called items I mean I know "Select OldItem, OldLine from Items where RecordNumber = " + GridValue.SelectedValue"   Sure hoped that wor ...Show All

• Audio and Video Development Finding Total time of Encoding process

  In my project i need to find the total time taken by the encoding process (while using wmencoder) how can i find it. and how can i find the total samples available in a video file. Hello Venkatesh, Media Foundation is the new multimedia platform that we are shipping in Vista . It consists of the new audio and video pipeline, Protected Media Path, and DXVA 2.0. This forum has been created to answer qu ...Show All

• SQL Server Strange out of memory error on 2005

  Hi, I am getting the following: spid53,Unknown,Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 262144 spid53,Unknown,Memory Manager <nl/> VM Reserved = 1662084 KB<nl/> VM Committed = 954940 KB <nl/> AWE Allocated = 0 KB <nl/> Reserved Memory = 1024 KB <nl/> Reserved Memory In Use = 0 KB ... <lots of memoryclerk/cachestore stuff) ... Followed by loads of 701s (There is insufficient sy ...Show All