GunaChinna's Q&A profile

• SQL Server SQL Question

  Hi there, I have these tables: Students student_id (PK) student_name Courses course_id (PK) course_name StudentCourse student_id (PK) course_id (PK) If I want to select a student that has 'course1' and 'course2', how do I write this statement This didn't work: SELECT DISTINCT Students.* FROM Courses INNER JOIN (Students INNER JOIN StudentCourse ON Students.student_id = StudentCourse .student_id) ON Courses.course_id = StudentCourse .course_id WHERE Courses.course_name LIKE '%course1%' AND Courses.course_name LIKE '%course2%' The problem is 'AND'. it concate the two course_name(s) to be like this condition: WHERE Courses.course_name LIKE '%course1course2%' Any idea Thanks SELECT Students.stud ...Show All

• SQL Server Best Protocol?

  What is the best protocol (Named Pipes, TCP/IP or VIA) to use when connecting to a SQL Server 2005 on: a) LAN (100MBps+) b) VPN (via Internet) c) Internet And why I do not believe the article about choosing a connection type to the server answers the question. In my opinion it is ovbious that the LAN is the best just because of the TCP/IP connection method being able to take advantage of low overhead, hi bandwidth connections. VPN is guaranteed to be slower than the LAN because the protocol is sitting on top of TCP/IP and will inherently add more overhead. As far as Internet goes, I am not sure what the difference b/w LAN and Internet is going to be as far as which protocol to us ...Show All

• Visual Studio SandcastleGUI

  I have been using Microsofts Sandcastle for some time now and it's xml-schemas have driven me nuts.... so I made a small userinterface for Sandcastle. The program is freeware and includes the following features: - Support for online MSDN-links. - Documenting of specified namespaces instead of entire assemblies. - Multiple outputtypes (website and/or .CHM-file). - Custom copyright line. - Custom company logo. - Custom product information. View my website for more information and a download-link: http://www.inchl.nl View generated output using SandcastleGUI: http://www.inchl.nl/help/ Kind regards, Stephan Smetsers stephansmetsers@hotmail.com Hi Dave, I need some more input to solve t ...Show All

• Windows Live Developer Forums How to deactivate an order item?

  Hello, Let's suppose I would like to deactivate a certain order item vs. deleting it from the order. (for it to be there in case I decide to reactivate it!) Does anyone now if this is possible Thank you, Orest Hi, I don't think it is possible as there is no such method as "PauseResumeOrderItem" in the doc. Julien ps: oups, didn't see someone answered already. :) ...Show All

• .NET Development Running multiple frameworks...

  We are currently developing asp.net applications in the 1.1 framework, but I want to get my company to make the move to 2.0. But our server guys are saying that they have major concerns running 1.1 asp apps along side 2.0 apps. So much so that they think the only way forward is to run the new 2.0 app (which I want to develop) on to a seperate production server. There issue is that if 1.1 apps and 2.0 apps are running together then the servers performance will suffer due to running multiple frameworks. Is there any truth in this I suspect not, but I need to find some more information on the subject ahead of a meeting I will be having with them next week. Can anyone help and shed some light on the matter. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Performance of sprites for a 2d game

  How is the performance of the DirectX.Direct3d.Sprite class for a 2d game I use it to draw al the tiles, objects, etc. This compared to using trianglestrips. Unless your set of sprites is constant and never changes the Sprite interface will be almost exactly the same as anything you can write. If you look with PIX you will see that it builds up dynamic vertex buffers as you drraw the sprites and then uses as few batches as possible (depending on the sort flags and how many texture maps you use) to actually render them. Its unlikely you will do better without a lot of work on your part and its also unlikley that this will be a performance blocker for a 2d app. ...Show All

• SQL Server An unknown error occurred in the WMI provider. Error Code 8000000A

  Hi, I just installed SQL Server 2005 on Windows Vista. I am getting an error "An unknown error occurred in the WMI provider. Error Code 8000000A" when connecting to a web server. The reporting services is running. Is there any other installation that is missing. Please help. Reporting Services is not supported on Windows Vista until SP2 of SQL Server 2005 is available. It is due out early next year. If you are an SP2 preview customer, you can try it before then. You can find out about this program at: http://www.microsoft.com/sql/ctp.mspx ...Show All

• Visual Studio 2008 (Pre-release) BasicHttpBinding and .NET comparison

  I wrote a .NET 2.0 service and client and a WCF BasicaHttpBinding Service and client, and found that the BasicHttpBinding was faster than the old .NET service and client I was expecting more of the same speed. Why would BasicHttpBinding be faster ...Show All

• Windows Forms How to let application override event handler in User Control?

  Hi, I have created a User Control that contains (among other things) a standard button control called "Start". I have placed my User Control in a Windows Form in my application. Now, I want the Windows Form to handle the event from the "Start" button, rather than the User Control itself. However, I can't figure out how to override the Start button event handler built into the User Control. Any ideas how to do this, or if it's possible Thanks, Leah. You can't have the form "override" the user control's handling of the button, but you can react to it:   In your user control you need to add an event for the start button click by putting a line such as this in the usercontrol ...Show All

• Visual C++ CreateThread vs _beginthreadex

  Hello. There is a hot discussion on one Russian developers forum about correct threads creation. _beginthreadex is more correct way because it initializes CRT for the newly created thread. But there is one great "BUT"!!! For example we have any callback function which uses CRT (like an exported function from dll). This function could be invoked from any thread including threads, that was created via CreateThread (i.e. CRT was not initialized for this thread). So this call can cause an undefined behaviour! But there is not way to determine CRT initialization status and initialize CRT manually It looks like a potential source of great troubles. Brian Kramer wrote: I think that statement is a bit silly, ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. State management nightmare

  I'm in C++ and I have many different shape to draw Each of them come with different state : Render States Texture Stage States Sampler States Some are transparent, some use light, others use alpha test They can be call from function that I can place in any order in my code My problem is that I need to go back to the default state or undo what the previous state setting changed...before setting only the state I need I'm at a point where I will have to use 2 functions : SetAlphaON() and SetAlphaOFF() So I can immediatly remove any state change before I draw something else Is there a better way to undo any state change ID3DXEffectStateManager seems to do this for Fx files... One thing I ...Show All

• Software Development for Windows Vista Hide the header and footer of SequentialWorkflowRootDesigner

  Hello, I am trying to hide either the header and footer of the SequentialWorkflowDesigner. I inherited my designer from SequentialWorkflowRootDesigner and set the Header property to null: protected override SequentialWorkflowHeaderFooter Header { get { return null; } } Doing that the start icon disappear. It is like the content of the workflow is pushed up to the designer. If I do the same with the Footer protected override SequentialWorkflowHeaderFooter Footer { get { return null; } } I get an "Object not reference exception". How can I hide both header and footer Thanks Have you tried creating your own header and footer (derived from SequentialWorkflowHeaderFooter) and re ...Show All

• Smart Device Development Webrowser and drawing lines

  Hi, I have a project that includes a webbrowser. I pull up a map (image) from a site and display it. This is on a windows mobile 2003 se box. I would like to draw crosshairs (or two lines) on the screen and cannot seem to associate the drawn lines with the browser or bring the drawn lines to the front of the screen. I cannot seem to do it. Help Thanks Rob It's not possble to draw on a top of the WebBrowser control. What you can do though is to create a custom control that draws image of the map and then crosshairs on a top. You will also need to write code to get the html using System.Net.WebRequest class, parse the html to find the url for the image and download it for drawing in your custom co ...Show All

• Visual Studio Tools for Office Mo Actions Pane in Word 2003 - newbie question.

  Hi. I've been developing Office solutions int .Net for about a year now. My company had some proprietary code that was letting us place user controls in Word (Document Map) but it's time to phase that hack out with Office 2007 coming. So I downloaded VSTO (the version currently distributed) and installed it. Then I started looking around for code samples how to attach a custom Actions Pane. It appears that if I start an Word 2007 project in VS2005 there is ActionsPane but if the project is for Word 2003 - there is no such property and no obvious way of getting a public property that would do. I'm not sure if I'm doing something incorrectly and it seems more and more frustrating after 3 days of digging around. After initial atte ...Show All

• Visual Studio Tools for Office MAPI property tags in Outlook

  Hi, I'm developing an Outlook addin which utilized synchronized SharePoint lists. In order to identify these lists, the addin tries to find the guid of the list in the Outlook folder's MAPI properties. To do so, I call: fields.get_Item(<propTag>, missing) Unfortionately, Outlook seems to use different property tags for the same property on different installations (could some one confirm this, please). For example, on my local machine (windows XP) the property tag is 0x804A001E, on a test machine (Server 2003) it is 0x8041001E. How can I find out which property tag I must use to get the guid of the SharePoint list Thank you in advance, Munir Husseini Outlook has many un-published fields which could ...Show All