Alessandro Camargo's Q&A profile

• SQL Server Can you implement web virtual directory in SQL2005 using ENDPOINT?

  In SQL2K you could implement web virtual directory (using IIS) that allowed you to query a stored procedure from any HTTP browser (e.g. IE, Netscape, Opera, ...) from anywhere in the world. For example: http://www.mywebsvr.com/WEB_VDN sql=exec%20Display_Info%20&contenttype=text/html would return a HTML page of information as defined in Display_Info stored procedure. This was very useful but a little slow due to IIS overhead! ENDPOINT & http.sys allow access SQL2005 without IIS which should be faster ( ). Hence I have been trying to configure ENDPOINT to do something similar without success. Furthermore there is little information on what you can do with the "FOR TSQL" option and how to use it. PS I don't ...Show All

• Windows Forms Slow re-draw of screen with background bitmap

  Hi, Can anyone explain how to stop my application slowing down with a background bitmap on my forms I am using a bitmap which has a gradual fade through colours, just to make it look less boring than plain windows colours. If there is a better way to do this, I'm open to suggestions. My application doesn't have too many controls on screen and when a form opens up, the re-draw is painfully slow! Thanks, Sean Check this project for a way to provide a gradient background without using a bitmap, it ought to be a *lot* faster. ...Show All

• Visual Basic FormClosing Event

  Hi there. I have an inherited form hierarchy where the root form captures the FormClosing event, which then invokes a overriden "FormClose" method. The overriden method correctly determines the value of the e.cancel attribute and passes it back to the root FormClosingEvent handler. However, when e.cancel = true the form closing event is not canceled and the form closes anyway. The root form, and all it's children, are children for a MDI form. Can anyone tell me why e.cancel = true in the case doesn't prevent the form from closing Thanks. Here is the declaration of the FormClosing Event handler: Private Sub StandardUIForm_FormClosing( ByVal sender As Object , ByVal e As System.Windows.Forms.FormClosingEve ...Show All

• Windows Forms Calling open another form

  Yet another question for you guys: I have created 2 forms in my application. I want a button on Form1 to "call open" Form2 without opening another window. AKA: Sort of like a "Next Page" option. What code would I put in the button event handler to perform that task I figured it out, thanks. By the way, here is the way I larned to do it: Form1.ActiveForm.Hide();     Form2 theSecondForm = new Form2();   theSecondForm.ShowDialog();     ...Show All

• Visual Studio Tools for Office Save as FILTERED html

  Is it possible to use VSTO to save a Word file as a filtered html document Also, before the file is saved I would like to manually mark the location of each page break (info which is normally lost when saved to filtered html). Thanks in advance for your replies. In C# they are never optional, always use the Type.Missing or the missing member variable, but I agree it's not always easy to find out what to use in these impressive parameter lists. -= Maarten =- ...Show All

• Windows Forms Formatting - Alingment Of Data In Cell Of DataGrid

  Is there a way I can align text in a cell for a datagrid control In one column I have a number and I would like to center it. The default is a left justification. I know this can be done on the label and other controls. Below is part of the formatting code that I am using. Thanks Dim grdColStyle3 As New DataGridTextBoxColumn With grdColStyle3 .HeaderText = "Time" .MappingName = "TimeSpent" .Width = 50 .ReadOnly = True End With Dim grdColStyle3 As New DataGridTextBoxColumn With grdColStyle3 .HeaderText = "Time" .MappingName = "TimeSpent" .Width = 50 .ReadOnly = True .Alignment = Ho ...Show All

• Visual Basic any way to NOT break on a very specific com exception

  Is there any way to NOT break on a very specific com exception Intel's CT ADE uses a caller's hang up an as exception to travers the call stack, and , overcourse, that is not a real exception in the VS05 world. I didn't see anyway to do it in the Debug, Exceptions. Any ideas Bob I am afraid I need some more guidance. The hangup produces the following error code System.Runtime.InteropServices.COMException was caught ErrorCode = -2147201494 Message = "Caller hangup" Source = "Envox.ADXVoice.9.1" Looking under debug, exceptions, add, there is not obvious place to add this. The only two that accept numbers are Native Run Time Checks and Win32 exceptons; both let me add the errorcode as user ...Show All

• Visual C++ load and time

  dears i need an axample how to get time and how to load numbers from file in the disk i found this in the help but it is not printing #include <stdio.h> #include <dos.h> int main(void) { struct time t; gettime(&t); printf("The current time is: %2d:%02d:%02d.%02d\n", t.ti_hour, t.ti_min, t.ti_sec, t.ti_hund); return 0; } i replace printf by cout then the statment is printed but the time no pls help thanks the time still not printed , only " the current time is" i want to see the time, i think they are empty , what is the problem thanks ...Show All

• Visual Studio Express Editions Overlaying two Panels, using button to select which to view

  Hi there, I have two panels which I want to place one on top of the other using a button to select which panel should be viewed, ie using the "visible property set to true/false etc. But I am finding that when I run my program the second panel wont appear, I have double checked that my click events on my buttons is set up correctly. Can this not be done with panels and if now can somebody suggest an alternative, would a control box have been better. My panels hold a selection of buttons and textboxes. Yep, I've got all the visable properties set properly, I've even offset the two panels at this stage to see whether that makes any difference but the second panel just will not show up. ...Show All

• SQL Server SQLEXPRESS Database Issue - Cannot open database ASPNETDB.MDF requested by the login, login failed

  Hello Guys This is my connection string <add name ="ASPNETDBConnectionString1" connectionString ="Data Source= .\SQLEXPRESS; Integrated Security = True; DataBase = ASPNETDB.MDF; User ID = MyWindowsUserName; Password = MyWindowsPassword; User Instance = False; Connect Timeout = 30" providerName ="System.Data.SqlClient"/> I tried to research on the internet and i got a solution on changing the permissions for this database to enable user SystemName/ASPNET, but iam not able to access this ASPNETDB.MDF from SqlServer and if i go to server explorer in vs2005, i dint know where to chage the permissions. Can anyone help me on this. Thanks a lot The ASPNET account needs to have access bo ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Bug based on on Project Directory.

  Bug right from the get-go: I created a new project, "Windows Game (XNA)" created as "WindowsGame1". It runs the debugger just fine, giving a cornflower blue window. Then, I saved the solution, as "WindowsGame1". No change in the code, I just saved it. Now, When I run the debugger it gives the following error: FileNotFound Exception was unhandled D:\DATA\DEVELOP\C THis is before doing the sprites or any other file loading. And it's pointing at the constructor, public Game1() The thing that may be causing it is that I save my projects in a directory on my D drive: D:\DATA\DEVELOP\C#\XNA I have been programming in C# for quite a while from that path just fine, so this does look li ...Show All

• Windows Forms How to check Modulus 23 in the field

  Any one please send or let me know the VB (.net) code for the following. I have a form – one of the ‘field’ in the form must be validated as follows. 1. The modulus check as contained in Appendix B to this document must be done. 2. All of the first nine characters must be numeric. 3. The 10 th of the 11 characters must always be ‘M’. 4. The last of the 11 characters must not be ‘I’ ‘O’ or ‘U’. 5. UTRN cannot start with 5. AppendixB Modulus Check required to ensure validity of a specific reference number MSD Reference Validation The format Modulus check is derived as follows: Character Position 1 2 ...Show All

• Visual Studio Tools for Office VSTA: How to handle non-public object which is not in the host

  Hi, I have a problem in my trial. The following is my case: [c#] In ALib.dll public class ACollectionClass : IEnumerable { IEnumerator GetEnumerator(); … } internal class ACollectionClassEnumerator : IEnumerator { … } In Application.exe public AcollectionClass aObject = new AcollectionClass() ; In Proxy.dll …. In AddInTest.cs AcollectionClass bReference = this.aObject; IEnumerator enu = bReference.GetEnumerator(); // Error raised. Because the type AcollectionClassEnumerator has no proxy. Please take attention on the internal keyword, the proxyGen.exe can’t make proxy for it. Maybe you will s ...Show All

• Smart Device Development Symbol MC70XX series physical assigned button

  Hi, I am working on Symbol MC70XX device. I assigned buttons from Start_Settings_Buttons to some programs but I can not find the right physical keys for these assigned keys to start the assigned programs. For example for Button 1, what key do I press on the device to start the assigned program Any advice would be appreciated. Thanks Bahman From Symbol documents I found to use Green or Red keys as APP key but I couldn't find the value of xx or yy , do you have any idea : For the Green key and Red key (no other key), create a registry file with the following entry, copy it to the \Platform folder, and then cold boot the unit. [HKEY_LOCAL_MACHINE\HARDWARE\DEVICEMAP\KEYBD] "Green ...Show All

• .NET Development Sending an email through a web service

  Hi, I need some help with the Web Service security. I have a web service that picks up a file from a folder (any folder, network, local etc) and sends it using SMTP to a mail recipient. When I browse to a file on my machine, example C:\Temp\File1.doc and invoke the web service call passing the file, the system is able to attach the selected file and the email is sent successfully. However, if I point to any file in C:\Document and Settings\... or on the network, say \\ServerName\ShareName\File.doc, the system is unable to attach the file to the mail message being created. The error message is 'Invalid attachment'. I have enabled Anonymous Access for the web service and cleared all the other checkboxes in the Authenticated acc ...Show All