AratiR's Q&A profile

• Visual Studio Tools for Office How to update Excel CommandBar via Events from C#.NET Addin

  Hi there, I have created a C#.NET (2.0) Excel 2003 Addin. It creates two commandbars. One of the command displays the status of several external components in the form of icons. The C#.NET addin receives information about the status of these components and raises events to update the Excel command bar icons. The events are received and processed ok, however in the processing code I update the icons that are displayed in the command bar and this does not work although the code does execute correctly. I am assuming that this is because that GUI update event is not happening on the main Excel GUI thread. In WinForms I use the PIn ...Show All

• Visual Basic Unsecured Textbox Passwordchar

  There is a software which you can see the hidden characters typed in a password textbox. Using the Snadboy Revelation, you may see whats behind the * characters. But i tested the login of SQL server and snadboy cant reveal the password. Is there any idea how to avoid this software Hi Henry... I think I've got just what you're looking for. Check out: http://www.codeproject.com/cs/miscctrl/passwordbox.asp We implemented something similar in the login dialogs at my former employer and it worked like a charm... Christopher ...Show All

• Windows Forms Size of MDI Children after unmaximize

  Hi There,    I'm having a problem when I unmaximize a mdi children, I have several forms with exactly the same size and minimum size, but when I unmaximize them (I don't know if this is the correct term to describe it) they get different sizes, the 1st that I open stays with the excepted size, but there are always one that gets bigg ...Show All

• Visual Basic vb, access, multiuser passwords

  Hi, I wan to have different users and passwords accessing an access database through my program. Should I manage the users and passwords through my program and use one database level password Workgroup files only work with a fixed path database. My database can be anywhere. Is there some other way of doing this Any ideas ...Show All

• Visual Basic Problem with CStr in VB .net

  Hello! I have a question about using CSTr.Everytime I do it in my decimal number it adds 0 at the decimal part. How can I make it get the true value( no excess zeros) of my number Thanks guys! The following code should produce the same results for you. Public Class Form1     Private Sub Form1_Load( ByVal sender As System. Object , ByVal e As System.EventArgs) Handles MyBase .Load         Dim s_string As String         Dim int1 As Integer         Dim int2 As Integer   ...Show All

• SQL Server SQL Mobile performance/size problems with WM5 device

  I just upgraded our application from SSCE 2.0 to SQL Mobile. Our app is written in C++, and we use OLE DB for most of our queries, including the routine the downloads and inserts our lookup table data. This application is running on a Dell Axim X51. Using SSCE 2.0, this routine takes 236 seconds, with most time spent inserting data into various tables (using OLE DB). The resultant database size is 15.1 MB. Using SQL Mobile, this routine now takes 675 seconds, with a resultant database size of 27.9 MB!! There is a noticable increase in time when the downloaded data is being inserted into the database. What would be the reason(s) for the slowe ...Show All

• Visual Studio Express Editions VB Newbie - Database Application

  I'm a beginner with VB alltogether, and I'm in need of some direction please.  I've worked the VB Data Access samples, but they don't provide me with the information I'm needing. I have a MDB with two tables.  The City Table contains the following columns: ZipCode, CityName, State, Latitude, Longitude The FCC table contains a list of FM Antennas across the United States along with the Latitude and Longitude of each. I want my VB form to show a grid with a user input box that allows them to type in their ZipCode.  The app would then show the users current City and State, and then display a list of FM Stations within ...Show All

• SQL Server Single-threading within a Data Flow

  When moving data from a legacy system into a new database, I must "seed" ID's in destination tables, and then push those values back to the old system. This can be done within a control flow sequence container with the following steps: 1. truncate destination staging table 2. data flow to retrieve data from old system, and insert into staging table using an OLE DB Destination task 3. Execute SQL task that calls a stored procedure to seed the new ID's and update the staging table 4. data flow to read the staging table and update the old, source database Alternatively, if the first data flow (step 2 above) uses an OLE DB Command to populat ...Show All

• Visual C++ template extremly implicit instantiation

  MS VC 7.1++ Here is the code, that using typeof implementation by Bill Gibbons ( http://www.accu-usa.org/2000-05-Main.html  ): [code] #include <ostream> using namespace std; //for typeof template<int N> struct typeof_c; // No definition, only specializations /**/ #define REGISTER_TYPE(N,T) \     template<> struct typeof_c<N> { typedef T RET; }; \   typedef char CharArrayOf ## N ## [ ## N ## ]; \   typedef CharArrayOf ## N *PtrCharArrayOf ## N ## ; \   PtrCharArrayOf ## N typeof_f( T ); \ /**/ #define register_type( n, type ) REGISTER_TYPE( n, type ) /**/ #define t ...Show All

• SQL Server Can't connect w/Visual Studio 2005

  I'm right-clicking on Data Connections in Server Explorer, and selecting Create New SQL Server Database. I've turned on the SQL Browser, so I'm able to select the instance from the combo box. I select Use Windows Authentication, type the database name to create, and click OK. I'm getting this error: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)" I've followed ...Show All

• SQL Server Joins with XQuery

  Hello, I have a very simple data table: CREATE TABLE [ALMPayloads]([ID] [int] NOT NULL,[OutputPayload] [xml] NOT NULL) with the following content: ID = 1 OutputPayload: <ReportDocument>   <ALMSimulationResult>     <selectedModelAssets>       <modelAsset ID="8bc798ae-cc15-4807-8805-61ecfc8f3c01" description="Global Bond" internationalCode="            " minimumLimit="0" maximumLimit="1" annualManagementFee="0" annualPerformanceFee="0" initialCostUpFront="0.02" regularCostUpFront="0.015" withdrawingCommission="0" swi ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Force Feedback not working with Feb2006 SDK

  Hi there, I just went out and bought a new Logitech "Rumblepad2" gamepad. I've installed the most recent drivers for it, and the Feb2006 DirectX SDK. In the control panel -> Game Controllers I can get it to rumble without a problem, so it does work. In there its possible to test at least 10 different rumble effects. I'm developing in VS2005/WinXP Pro. When I tried the MSDN example of force feedback (located here: http://msdn.microsoft.com/archive/default.asp url=/archive/en-us/directx9_m_Oct_2004/directx/input/directinput_forcefeedback.asp) it flops. First problem with that example is you need a "force feedback effect file& ...Show All

• Windows Forms C# and VB.NET in same app... Possible?

  Hi all,      I'm in a job surrounded by C# people, and I'm a VB.NET guy.  To avoid learning C# (which is one messy language to a VB guy LOL) - can .NET, let's say, have one form/module/class using VB.NET and another C# within the same application If not, I'm off to the books again - and I'll probably be posting A LOT of&n ...Show All

• SQL Server accessing report server database

  Hi friends how can i access report server database I've C# application and i want to develop a screen with a grid that loads all reports created on report server. i know what stored proc to call in Reportserver database to get list of reports but I read a msdn article that says we should not be writing applications that run queries against the report server database. "The report server database is not a public schema. The table structure might change from one release to the next. Always use the Reporting Services APIs to access the report server database." my question is how can i use reporting service API to get list of reports any example ...Show All

• Visual Studio Tools for Office Outlook 2003: catch right-click over a mail item in explorer view

  Hi, the way to catch a click over a mail item in explorer view is using " Explorer_SelectionChange" event but I don't know how to catch right-click over a mail item in explorer view Thanks for your help, Mauricio. Ok, thanks for the quick answer. Mauricio. PD: when you have time explain me about this "big hack" ;) ...Show All