Eric Harmon's Q&A profile

• SQL Server Matrix with 2 subtotal

  Hi All, I wish to have a report with 2 subtotal using matrix control given by reporting service. CD DVD Total Price Total Qty 2.00 5.00 JOHN 5 25.00 5 JOLIN 5 10.00 5 Total Price 10.00 25.00 Total Qty 5 5 I only can came out total price(subtotal) which provided by matrix control. Does the matrix control able to come out as table above with 2 subtotal Thanks Kendy That sounds very messy. ...Show All

• .NET Development XSD Types derived from XML Elements/Attributes

  Hello, I am using the MSXML 6.0 DOM and have written an XSD which describes how my XML should be formatted etc. (as expected). I load the schema into the a schema cache and associate it with a DOMDocument object. I then load my XML file into the DOMDocument and it is validated as expected. My question is this: in my XSD schema my elements and attributes have XSD type specifiers (unsignedByte, unsignedLong, etc.), is there any way of ascertaining the XSD type of an element, or retrieving this type from the schema in some way After validation I need to process the file. I was hoping to make the processor generic such that it would know what to do with the XSD types - it doesn't need to know how to process a specific element. I will ...Show All

• SQL Server Merge Replication downloading rows immediately after uploading SQL 2005

  Hi I have noticed that four out of the 145 tables being replicated in my topology perform a mysterious update. If I insert data at the subscriber then synchronise the upload is completed followed by immediate downloading of the same identical set of rows as updates. Has anyone seen anything like this. I cannot see any difference in the filter joins or article settings compared to any other table in the system but these four consistently do this. Publisher/Distributor: SQL 2005 SP1 on Win 2003 Server Subscriber: SQL Express 2005 SP1 on Win XP SP2 Cheers Rab Yes the newly inserted rows at the subscriber are uploaded and then downloaded as updates during the same session. Partition Options = 0 Data can overl ...Show All

• SQL Server where are store Proc & Functions and so on in 2005?

  In 2000 you could look at templates and find templates for global or system functions where are they in 05 If you want to see the definition of the system stored procedure and function, you can open Management Studio, connect to the sql2005 instance and click Databases -> System Databases -> master -> Programmability -> Stored Procedure -> System Stored Procedure. ...Show All

• .NET Development .NET Framework 2.0 Event Viewer error

  Since .NET Framework 2.0 x86 was installed on my computer, this event is recorded periodically: Event Type: Error Event Source: .NET Runtime Event Category: None Event ID: 0 Date:  11/13/2005 Time:  1:52:45 AM User:  N/A Computer: Description: The description for Event ID ( 0 ) in Source ( .NET Runtime ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Unable to open shim database version registry key - v2.0.50727.00000. I use XP SP2 ...Show All

• Visual Studio 2008 (Pre-release) How to create AppBar without SHAppBarMessage?

  Hi all, I am currently developing a "Windows Application" project. I need to create an Application Desktop ToolBar (AppBar) with WPF (using C#) without using the System API (to be more precise, without importing SHAppBarMessage API). Is It possible And, if so, how Thanks in advance, Null Massimiliano, I understand. But I think in many cases any program is a source of ideas. May be, Genghis can give a direction. My best regards, OldDino ...Show All

• SQL Server SQL Server Session State - using a 1.1 database schema for 2.0 session state storage

  The 2.0 version of ASPSTATE is slightly different than the 1.1 version in that one table has one additional column and another table uses a different data type and size for the key. The 2.0 version also has a couple additional stored procedures. We'd like to manage just one session state database if possible so we're trying to figure out if Microsoft supports using the new schema for 1.1 session state access (it seems to work, but our testing has been very light). Is there any official support line on this If not, can anyone comment on whether or not you'd expect it to work and why Thanks. You can use the 2.0 ASPState database schema for both 2.0 and 1.1 ASP.NET applications. "Some o ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA compiled programs crashing

  Hi, i downloaded XNA Game Studio express Beta an hour ago. The application itself works pretty well, but when i compile an application (like the Spacewar starter kit or a new project), the exe that i find in *project folder*/bin/Release/ won't launch : it crashes and asks me if i want to send a report to microsoft. I know it's kinda normal since it's a beta software, but if anyone knows an issue to this problem, it would be very helpful ;) Thanks in advance. have you tried this in the spacewars app a few people have run into an issue with multisampling. Add the following to line 20 in SpacewarGame.Designer.cs graphics.AllowMultiSampling = false; and change line 109 in SpacewarGame.cs from ...Show All

• Smart Device Development Using encryption in Client-Server Model

  Hello, My application works in client-server model. It contacts frequently to server in the form of request, which is built in the form of XML, and server responds with proper reply, which is again in XML form. Now for making this communication secure, I want to encrypt-decrypt request and response. My question is that my application already heavily uses bandwidth of GPRS and making this communication secure adds one more layer and will affect performance. I want to ask which third party API I should use so that performance is not degraded to great extent. I am using CF 1.1. I cannot use 2.0 for cryptography namespace. -Viral What about using the OpenNETCF SDF 1.4 Mich ...Show All

• Visual Basic Interop UserControl : problem with VB6 usercontrol

  Hello, When I use the Interop UserControl for VB2005 with a form in Visual Basic 6 that function great... But when I want to put this control in an usercontrol in VB6 that does not function. I don't know why... Can you explain me please Yes we're still looking at some issues around hosting an Interop Control inside an ActiveX control...for now this is unsupported but if you really want to try it here's what you should know: 1. the first time you drag a VB6 ActiveX control that contains an Interop UserControl onto a VB6 form you'll see an error. The second time this should work. 2. This will only work if your not trying to hook any of the events exposed by the Interop UserControl (i.e. by adding t ...Show All

• Visual C++ File Upload/Download using HTTP

  Hi All, I want to upload and download file using HTTP. plz help me how to do this one. in my code when i trying to connect with a device in wired network it will work without any problem. at the same time when i try to connect with a device in a wireless network it wont work i dont know whats the problem(with error no 12152). any one plz help me out. 1 more thing, when i upload to a wired device in the http header i saw 1 authentication tag but this tag missed in uploading a file to wireless device. Thanks and Regards -Amjath Hello Re: File Upload/Download using HTTP ...Show All

• SQL Server Rollup with distinct -- why?

  I have a group of lastnames with counts of distinct records per lastname. I need a summary at the bottom of the query which tells me how many records I have total. Rollup or cube seems like the way to go, but I can't find any info on using this with distinct records. Thanks for your help. More information is needed. Do you mean you a grouping by LastName USE AdventureWorks ; GO SELECT LastName , Count (*) AS CountByLastName FROM Person . Contact GROUP BY LastName ORDER BY LastName; ROLLUP will add nothing to the query above. CUBE will add a grand total: USE AdventureWorks ; GO SELECT LastName , Count (*) AS CntLN FROM Person . Contac ...Show All

• Visual Studio 2008 (Pre-release) XmlDataSource + path set to 'Name' = what's going on?

  Hi. Something's happening that I don't understand, and I wondered if any of you guys could shed some light on the situation. Consider a simple textbox, with a binding set as follows: < TextBlock Grid.Column = " 0 " Grid.Row = " 2 " x:Name = " TestText " Width = " 400 " Text = " {Binding Path=Name} " /> The data context is set to an XmlDataProvider defined in the code, into which I load some XML All pretty standard stuff. On running, the text box contains the name of the element the XmlDataProvider's Path is set to. How does it do this My understanding is that the "Path=Name" binding should bind the text attribute of the text box to an attribute of t ...Show All

• .NET Development Dedicated thread calls GUI thread directly

  In an app I'm debugging I've come across some code in which a method called from a dedicated thread directly accesses a property on a GUI control, created on the main thread. It has, so far, not caused any problems but I am told that this is bad. Before I fix it, could someone provide, or point me in the direction of, an explanation of why this is bad, and what kind of problems it can cause. Also, is there some kind of profiling tool I can use to monitor method calls across the threads and make sure that what I think is happening is actually happening Any help appreciated. Andrew. Control.Invoke() is the built-in way to marshal the delegate call to the UI thread. Use Control.BeginInvoke() t ...Show All

• Visual Studio Team System Query check-ins by work item

  If at checkin a work item is associated to the changeset, afterwards how can I query the checkin (changeset) by the work item (aiming to use this to find the code to review for a work item - task). Thanks Dani Daniel, the changesets for a given workitem will be present in Links property of WorkItem object. The links collection will have links of type ExternalLink to changesets. From UI it is easy to see changesets by clicking on Links tab. If you want to programmatically get the changesets, see the code at: http://blogs.msdn.com/jmanning/archive/2005/09/21/472524.aspx ...Show All