Mervin Lobo's Q&A profile

• Architecture Windows Application Versus Web Site

  I need to develop an application that reads from and writes to a database housed in a SQL Server located in an Intranet. I am using Visual Studio 2005 (VB). I can see that there are two possible routes to the development - as a Windows Application or as a Web Site. I will be most grateful if some body out there could advise me on which option route to take and perhaps why. Regards. Nkenta Hi, I guess you should elaborate more than this, however, selecting between winforms and webforms is not a big deal since code is reusable for both technologies, away from UI, however you need to answer these questions : What is the operating System of your users ( supposedly it will be Windows ) W ...Show All

• SQL Server problems with sum()over(order by field) syntax

  Hello I'm experimenting with window functions and I'm having troubles with the sum()over() syntax. I've followed the syntax from many examples and i'm still getting this error. I can get it work with sum(field1) over (partition by field2) but every time i add order by i get an error I have the following query, this is from the adventureworks sample use adventureworksdw select *, sum ( scenariokey ) over ( order by amount ) as test1 from FactFinance and I get the following error Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'order'. Any suggestions. Thanks in Advance Daniel When you use aggregation you have to use Partition By instead of Order BY. select *, sum ( ...Show All

• Visual Studio 2008 (Pre-release) How to create WCF Web Service

  Hi All, I am new to WCF. I did one sample application and it is working fine. What I did is, I created a new WCF Service using File->new project->WCF service and wrote a class with service contract with members haveing operation contract attribute and I hosted this service in IIS and tried connecting a client to the service it is working. Now my doubt is what I have created is WCF Service, how will I create a WCF Web Service Should I use File->New Website->WCF Service If I do that also I haev to follow the same steps as I did it for WCFService, which is the unique thing which differentiate the WCF Service from WCF WebService Anyone please help me, if you can... regards, SanthaMind ...Show All

• Software Development for Windows Vista Test Case 18, ProductVersion constraint

  The test case 18 in the Certified for Windows Vista Test Cases document has a constraint which I only partially understand. My setup project (built with Visual Studio 2005) contains two rows in the Upgrade table, both with the same UpgradeCode , one having a null VersionMax , which makes sense: xxx 2.0.8 - - 258 - NEWERPRODUCTFOUND xxx 1.0.0.0 2.0.8 - 256 - PREVIOUSVERSIONINSTALLED The test case 18 requires that neither VersionMin nor VersionMax be null. However, the first row above seems perfectly legal: any version newer than 2.0.8 triggers the NEWERPRODUCTFOUND action and specifying a VersionMax there seems silly. Is the requirement of Test Case 18 broken or do I have to somehow specify a huge VersionMax to make the c ...Show All

• Visual Studio Express Editions How do I set the fontsize and color of body text using mailto:?

  -Visual Basic 2005 Express- I've searched the internet and forums for 2 hours looking for a way to 'programmatically' change an emails font and color in the body. I haven't found anything on either of these. The following code is what I have so far. It works fine but I'd like to change the font size and color. There must be a way... Process.Start( "mailto:" & clemail.Trim & " SUBJECT=Notification%20of%20payment%20recieved&BODY=Payment%20recieved%20" & temp2 & "%0D%0ADate:%20" & Date .Today & "%0D%0A%0D%0AThank%20you%20for%20your%20payment.%0D%0A%0D%0APlease%20retain%20this%20receipt%20for%20your%20records." ) clemail is the customers email address. Any ...Show All

• Visual Studio How to change FieldDelimiter in a reportviewer (export to CSV)?

  The field delimiter is a deviceinfo setting. You can't change the deviceinfo for the built-in export dropdown. But you can place a button on your form that performs the export manually using ReportViewer.ServerReport.Render(). That method does allow you to specify a custom deviceinfo setting. ...Show All

• Visual Studio Express Editions Linker error relating to RegCloseKey

  I am attempting to set up my machine to run Visual C++ Express Edition 2005. I have d/l the SDK (Microsoft Platform SDK for Windows Server 2003 R2). I have a basic application that includes windows.h and winreg.h. I am attempting to read the registry. However, every time I build, I get the following linker errors: test2.obj : error LNK2028: unresolved token (0A000010) "extern "C" long __stdcall RegCloseKey(struct test2::HKEY__ *)" ( RegCloseKey@@$$J14YGJPAUHKEY__@test2@@@Z) referenced in function "private: void __clrcall test2::Form1::anotherMethod(void)" ( anotherMethod@Form1@test2@@$$FA$AAMXXZ) test2.obj : error LNK2028: unresolved token (0A000012) "extern "C" long __stdcall RegQueryValueExW(s ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. xbox 360 controller

  Hello all. I have just puchased a Xbox 360 controller and try to figure out all the differerne possibilities. Right now i wonder about the button in the middle that looks like the xbox logo and with something that look like 4 lights around it. How can I program that one What do you call it And can I controll the lights Thanks Endre Thanks for the reply. I have never tried a real xbox 360 so i didnt know about the lights. Would have been fun to be able to use them in games. When it comes to the button I guess I have more than enught buttons to use. Endre ...Show All

• Smart Device Development hook Keyboard , to AlexY and any helper

  Hi, Could anybody tell me please how to use Alex Yakhnin hookkeys class. http://blog.opennetcf.org/ayakhnin/PermaLink.aspx guid=84b95802-76d7-499c-b266-e2251ab15706 i want my application to detect any key pressed in the keyboard, even if the application was in the background. thanks in advance. Could you explain a little bit more your requirements What your application supposed to do Do you need to get all key presses on the SIP or just some And why do you think you need to do that on a global level ...Show All

• Visual Basic Simple GDI Question

  At least I assume it's simple... I have a picture that needs to move. Using the KeyDown event and a timer I've managed to get that picture to move. The simple problem I am having is that the picture isn't clearing itself, so when it moves, the old picture is still there. Is there just some easy way to clear that old picture I've only been using GDI for 1 day now so I'm REALLY new to this. Here's my code in the timer control: Dim b As Integer Dim gr As Graphics = Me .CreateGraphics b += 2 gr.DrawImage(theimage, 200, b) gr.Dispose () gr.refresh does not work because refresh is not a member of image graphics. me.refresh causes a huge flicker on the screen and my image disappears immediately a ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. how to change the current stream input ( vertices )

  In the graphicdevice, they exist the property device.Vertices which is a collection, so we can put a lot of kind of vertex buffer in it. Very nice but ... How to say that the current stream is not the Zero but an other because the function drawnprimitive use the current stream and in my case it s always device.Vertices[0]. So if we cannot change the current stream what is the goal of the collection Vertices If you know how to change the current stream to take for example device.Vertices , can you explain it to me. PS : sorry but i am french and my english is not really perfect. ;) The vertex shader won't actually know where its vertices come from, it just has a set of input v ...Show All

• Software Development for Windows Vista Workflow with Team Foundation Server (TFS)

  Hello, I built a workflow with a WebServiceInput and I would like to subscribe the WebService to Team Foundation Server's WorkItemChanged event. I used, BisSubscribe.exe for subscription, the process worked smoothly. But, whenever the WorkItemChanged event fires, the workflow does not instantiate. The Event Viewer gives me the error: Detailed Message: System.Web.Services.Protocols.SoapException: Server did not recognize the value of HTTP Header SOAPAction: http://schemas.microsoft.com/TeamFoundation/2005/06/Services/Notification/03/Notify . I am out of ideas. The web service works fine when invoked through web browser. Anybody has ideas Can you please share the call stac ...Show All

• Visual Basic VB Control Arrays.

  Ok, there are many posts all over the net with possible solutions to this challenge, but none seem to suit my needs. in the 'good ol' days' (VB6 and Prior) you could simply copy/paste controls to a form and set Index properties to create an array of controls. These could then be manipulated individualy, for example: MyTextBox(1).Text ="I" MyTextBox(1).Text ="WOZ" MyTextBox(1).Text ="'ERE" But I can't find a simple solution to create an array of 132 picture boxes. I don't need anything fancy, just to be able to address each box individually using an index. Any help would be much appreciated, and keep my barber in business a bit longer! Thanks, MrMojo. Hello MrMojo. Basically what you can do is add your co ...Show All

• Windows Forms Efficiently Moving Multiple Controls

  I'm implementing a simple forms designer, and one of the things I need to be able to do is simultaneously move all selected controls.  Currently, I'm accomplishing this by looping through the list of selected controls and moving each one.  The problem is that when I have a bunch of controls selected, the move process gets pretty ugly (sluggish feeling, dirty or delayed painting, etc). I've tried using the WM_SETREDRAW windows API message to smooth the process up a bit, but it doesn't seem to help. Does anyone have any idea how to implement smooth, multi-control movement   Visual Studio manages to do this very effectively; what the frig are they doing Thanks in advance. ...Show All

• .NET Development Webservice consumes all the available bandwidth.

                   We are on the test phase of a windows-webservice-Oracle application.Clients would connect the webservice through VPN or VSAT. VPN users would directly connect with the webserver,where VSAT user will connect with the VSAT server which will be routed to the webserver. Now the VPN users have an average bandwidth of 512 kbps and VSAT users have an average of bandwidth 360 kbps.There would be an average of 30 users at a time whom would connect either through VSAT or VPN. Now,if we connect through VSAT environment it runs out of bandwidth.The transacted data may reach upto 1 MB for each user. The web server memory is 2GB.We haven't implemented cl ...Show All