JD Prasad's Q&A profile

• Microsoft ISV Community Center Forums Order by in select statement not working

  Hi there - i have a select statement that runs on form load that allows selection of appropriate company names from a combo box based on if the user is the owner of a company, which works great, syntax is below; Me.companyname.RowSource = "SELECT [companyname] FROM [qryactivity] WHERE [active] = Yes AND [leadofficer] ='" & loginname & "'" However i want to sort them alphabetically by name but cannot get it to work, i keep getting syntax errors, i have added the following code but it does not like it: Me.companyname.RowSource = "SELECT [companyname] FROM [qryactivity] ORDER BY [companyname]ASC WHERE [active] = Yes AND [leadofficer] ='" & loginname & "'" any help would be greatly appreciated. Rhys. ...Show All

• Visual C++ Native C++ : Report on what the optimizer has done?

  I've recently fixed a problem in my code where the optimizer "optimized out" a variable assignment, causing problems. The assignment happened in one module and any reading happens in other modules, my guess is the compiler thought the assignment was useless and discarded it. Is there any way to get a report on what the optimizer has found / changed after doing a compile/link If you can post the function that uses the the global variable where the assignment to it gets optimized away, then Microsoft can investigate this issue and come up with a fix in a future version. This is a necessary next step in getting closure on this issue. Also, if this is a local variable, then using the volatile m ...Show All

• Smart Device Development Cursor in TextBox

  I want to make the cursor active in the textbox in a form. Hovewer when I clicked to a button the cursor disappers. I sometimes use the button to add or delete characters.How can I always make the cursor stable in the text box I tried this. Hovewer, it selects all the text in the text box. I only want to make cursor active not select. Thank you ...Show All

• Visual Studio Express Editions Number of lines in a text file

  Hi I need to determine the number of lines in a file, and then assign the value to an integer. Here's my structure: Do while [the filereader is not at the end of the file] -> filereader should now read line -> for each line add 1 to variable (integer) "testinteger" Loop Does anyone understand my structure Thanks! Johannes You should NOT use peek or is nothing to determine if it is at the end of the file.....you should use the method supplied by the streamreader: EndOfStream Dim theFile As New StreamReader ( "file.txt" ) Dim NumberOfLines As Integer = 0 While Not theFile . EndOfStream theFile . ReadLine () NumberOfLines += 1 End While ...Show All

• .NET Development timeout expired failed to start instance

  I have a C# windows app created with vs2005 on windows xp pro with sql 2005 server express installed ( it uses a database ) I create a deployment project then install the app on the machine Every so often - quite rarely but enough to worry about - usually just after a restart - when I start the application I get a timeout expired - something about failing to connect to an instance - I am assuming it is because the database engine has to start up and then it has to creat an instance and all this just exceeds so time limit - I tried putting "Connection Timeout=300" in the connection string in the app.config file - it did change the sqlcmd.connection.connectiontimeout to 300 but it did not get rid of this intermitant probl ...Show All

• Gadgets "Access is Deined" error on IE7, but works fine on IE6

  My gadget needs to contact two URLs to retrieve XML content (not SOAP, just URLs that return XML). The first one is internal URL (not accessible from public) and I used {proxy:"none"} when creating network request; the second URL is public and I used {proxy:"generic"}. The gadgets is uploaded onlto galleryd.live-int.com, During test, everything seems fine when I use IE6 on an internal PC (of course with the trusted site and cross-domain settings changed). However, when I switch to an IE7 (on Vista) internal machine, even after changing the settings, it kept giving "Access is denied" error. I also tried adding the regedit trick found on the old forum, but it didn't help: [HKEY_CURRENT_USER\Software\M ...Show All

• Visual Studio Crystal report shows only one row from custom OLE DB Provider

  I am trying to develop an OLE DB Provider using the ATL template “UpdatePV Sample”. I have a problem that crystal report shows only one row of a table from this provider. Where as the same provider is returning complete table in a C# application. Can someone please help me to identify the problem or implementation I need in provider to get complete table in Crystal Report   Also the server explorer in Visual Studio 2003 doesn’t fetch any record from the provide at all, although it shows the structure of the table in it s Connections Tree view. When I select to “Retrieve Data from Table” it shows an error message as               ...Show All

• Visual Basic Open form by caption

  I am wanting to create a "My Favorites" Form to store the top 10 forms/reports the users uses the most. I have got 10 fields in each users record that stores the name of the form I made a form with the following;10 command buttons, labels The labels are bound to the users record which shows what the name of the form/report is. How do I take the labels caption and open the form Davids Learning There are a lot of details but as long as all your forms are in one assembly, this might be helpful: Imports System.Reflection Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim frmname As String = "Form1& ...Show All

• Windows Forms Adding images to DesignerVerbs

  Hello everyone, I have a custom forms designer. I want to add an image to my controls designer verbs menu that comes up in the designer but can't find where to do it. For example, in my designer, I've added copy paste and some custom designer verbs for the menu's that pop up when the control is right clicked. I want to add pictures next to the menu items. Anyone know how to do this Ken Thanks, but that wasn't quite what I needed. I actually needed to modify my MenuService class to have an additional method that when I added verbs, I passed in a bitmap that I loaded from the assembly for each verb. I got it working. Thanks for the response. Ken ...Show All

• SQL Server SSIS FTP File Size Limit Restriction

  Hi Does any body know how much is the maximum file size(For ex : A Single file contains 10 MB 0r 20 MB) can transfer to a Remote server using SSIS FTP Task. Regards Deepu M.I ...Show All

• Visual C# need help with code

  I am trying to write a program kinda like a receipt and I am having trouble with this. What I need it to do is look like this: Please enter the price of the item: Please enter the quantity of the item: Please enter the total of the item: It needs to continue until you want to end it with like(-1) or something. Any suggestions It would be greatly appreciated. Thanks it says cannot convert the decimal to an int It also says cannot convert decimal to double. In each of them It asks if I am missing a cast.... ...Show All

• Visual Studio 2008 (Pre-release) Using PropertyPath to obtain property value procedurally

  I have been using PropertyPath fairly extensively in some code to set the Storyboard.TargetPropertyProperty on animations. However, I have reached a scenario where all I need to do is use a PropertyPath to obtain the current value of that property from an object. To help demonstrate my situation: Rectangle lRectangle = new Rectangle ( ); TransformGroup lTransformGroup = new TransformGroup ( ); lTransformGroup.Children.Add( new ScaleTransform ( 6, 8 ) ); lRectangle.RenderTransform = lTransformGroup; PropertyPath lFullPathToScaleX = new PropertyPath ( "(0).(1)[0].(2)" , UIElement .RenderTransformProperty, TransformGroup .ChildrenProperty, ScaleTransform .ScaleXProperty ); PropertyPath lFul ...Show All

• Software Development for Windows Vista How to design on WF the back to activity?

  Hi, I have Act01 -> Act02 -> Act03 -> Act04 -> Act05 After Act03 there are a IF that if false I need to return to Act01. With while I resolve this, but after Act04 I have other IF that if false I need to return to Act02. How to resolve this on design of WF without StateMachineWorkflow Serge's answer is the only way without switching to the state machine style. The sequential workflow style does not generally allow for going back up in the manner that you require. Regards, Paul ...Show All

• Visual Basic Disabling sound for a control and/or application?

  Greetings. I'm writing a vb.net 2005 application which has hidden webbrowser controls in it, in order to retreive data from a website. The problem is that these websites have flash advertisments with music and sound, and I need to disable that sound so that people don't suddenly start hearing noises and not understand where they come from. Is there any way I can disable sound for the webbrowser control, the form, or the application - without completely muting off the computer Thanks in advance, -Elad not entirely, I guess you would have to strip out the tags and what not when the document has been completely loaded using the Body inner and outertext The webbrowser control is based on the core of IE so any settings i ...Show All

• Visual Basic changing filenames

  Hello I need a lot of help. I am new at coding with VB6 and am not sure of what I'm doing. I have been creating bitmaps to transfer into a resizing program that has the dimensions set for each bitmap. now, since i have 580 bitmaps per folder and 16 folders, to change the dimensions would be crazy and to attemp to change the filenames manually would take forever. I recently found a commandline program that converts filenames in whichever folder you put the program in. For example: file01 file02 file03 are contained in the folder. When the .exe is executed, the commandline opens and copys each file in the folder to a specific value and then places the newly copied files into another folder. so file01 would be copied, renamed to file04, and p ...Show All