R-man's Q&A profile

• Windows Forms can i map the content at form to the printdocument

  i m making a Retail management system, and the bill is been prepared to be shown in a datagrid, now printing this grid alone is being critical, is there any way to map a control directly to a printdocument. plz help brijesh ...Show All

• SQL Server MySQL OLEDB Driver

  Hi! I have a small question, there are OLEDB drivers availible for .NET on the MYSQL download site. But when I install them I'm not able to see them inside SQLIS, I've tried them inside Visual Studio and they work fine. Is there a way to get them "registred" or add them as a reference inside SQLIS so that I may choose them when setting up an OLEDB Source / Destination You say OLEDB drivers for .NET but that doesn't make sense to me.  OLEDB is not a .NET provider instead it would be ADO.NET.  Are the drivers OLEDB or are they .NET.  If they are .NET then they wouldn't be available from our OLEDB source but from our DataR ...Show All

• Visual Basic running cmd.exe using System.Diagnostics.Process

  Hi guys, I am running cmd.exe to start a executable from a web application.Howvever, i need to input 2 more parameters for the account and pwd as shown below. CMD.EXE c:\Documents and setting\desktop>perl scriptest.pl test.txt account(domain/user): xxx password:xxxx 'User enter perl scriptest.pl test.txt, then cmd.exe will prompt for account and password for user to enter.  How do i let the web application enter the account and password. My program is such    Dim proc As System.Diagnostics.Process         proc = New System.Diagnostics.Process       &n ...Show All

• SQL Server copying table in a database

  Hi good day to everybody, Can we copy a table from a database and saved it into a diskette Because i did not find or maybe i miss or doesn't know how to do it from EXPORT/IMPORT tools.  The computer to where I attach the table is not connected on d'same network, and if I backup & then reinstall the whole database into that PC, all records in their will be overwritten by the new one which is not I wanted to be. Hi, To import data from Access to SQL. You could use DTS ( Data Transfer Service not sure on the acronym ). Its a wizard that migrates data from other sources to SQLServer... cheers, Paul June A. D ...Show All

• .NET Development Session dropping at random and always prematurely

  I've developed an application for our in-house use and it works nicely, except that the session are dropped by the server prematurely at random and no reason is given. This is a problem since most of the time users spend in the admin and I need the sessions there. - There are no entries on the server in the application logs or other logs. - The bin folder is not being updated or written to. - As far as I know the application is not recompiled by the server. (guess) So my question is, how to find out the reason for the problem Though it might not be necessary, I've also attached a sample application that ...Show All

• Software Development for Windows Vista Fast User Switching while Domain Member?

  I tried searching for an answer to this question, but couldn't find it. Does anyone know if Fast User Switching will be possible in Windows Vista while the OS is a member of a domain Prior versions of Windows didn't allow this. Thanks It seems to - I've only just installed vista, but after joining it to our domain (which was a bit of a faff finding the option!) I can still "switch user" from the Start menu. ...Show All

• SQL Server SQL Commands Suspended

  Whenever I execute the command Select count(*) from any_table to get a count of the rows in the table, 9 processes get created and each one of them is listed as being Suspended. The first process has a wait type of CXPACKET with no resource listed and the other 8 all have a wait type of PAGEIOLATCH_SH with a resource of 8:1:nnnnnnnn. The command will sit in this state for 3 - 5 minutes and then return the result. I am seeing this type of wait in other commands from time to time but the select count will cause it every time. What is causing the command to be suspended How do I find out what the resource is that it is waiting on Any informatio ...Show All

• Visual Studio VS IDE crashes when debugging in managed or mixed mode

  I have a c++ project that uses a .NET 1.1 assembly as a com object. It is loaded with CoCreateInstance. If I debug in native mode it looks like everything works okey, in managed mode the application crashes with no errors or anything, and in mixed mode Visual Studio crashes. Something that looks somewhat suspisous to me is that it looks like .NET framework 2.0 assemblies and debug symbols are loaded. For example: 'MyApp.exe': Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50215\fusion.dll', No symbols loaded. 'MyApp.exe': Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50215\msvcr80.dll', PDB format is obsolete. 'MyApp.exe': Loaded 'C:\WI ...Show All

• Visual C++ MFC/ATL CString error?

  I am trying to update a number of libraries dating back to 1980 which were developed using basic 'char' strings. I am trying to use CString as a replacement basic type. However, I have an unexplained error that I can't track down. When compiled with the Unicode character option, my code fails when I try to assign a TCHAR* to a CString. However, the same code compiles and runs properly when the MBCS character option is selected. This is probably obvious to someone who has been dealing with multi-byte characters for a while, but I am stumped. Code: m_csName.Empty(); TCHAR szPathName[MAX_PATH], *pszFilePart=NULL; DWORD dwCount = ...Show All

• Visual C++ Inheritance in enum

  I have a base class which uses a set values in an enum. I have a derived class which uses some additional values for the same enum. Is there any way to capture this relationship in a more concrete way I know that C++ doesnt provide any mechanism for inheritance among enums. What I want is that, in all places where base class enum is used, I want to be able to use the sub class enum. Thanks KarthikR An enum in C++ is not a type at all, it's just a bunch of defines, really. The way to do this I would think would be to create a class that contains public static int values, which represent the enum. That's something you can der ...Show All

• SQL Server How To Avoid Table Scan

  Hello All, Is their any way I can avoid a Table Scan by modifying the follow WHERE clause WHERE tbl_mis_Dashboard.loan_active_flg = 1 AND [tbl_mis_Dashboard].[loan_create_dt] between DATEADD(dd, DATEDIFF(dd,0,dateadd(mm,-13,getdate())), 0) And getdate() The field loan_create_dt is indexed on the table tbl_mis_Dashboard. The query returns approximately 256K records which is appropriate and necessary. Thanks all, Orlanzo First, Show Execution Plan shows actual execution rather than estimated. It shows a graphical form of statistics profile. ( http://www.microsoft.com/technet/community/chats/trans/sql/chat0503.mspx ) Secon ...Show All

• SQL Server Lookup Transformation: How can I join tables in different databases

  I want to join tables that reside in different databases (same instance).  The Lookup object only lets me select from one data source.  Is there anyway to lookup using more than one data source   I can write a SQL query to lookup across databases. Is this a feature that is being added to future releases I appreciate your help -Marcus What about MS Access using DAO In DAO you use something like this. CDaoRecordset rset(&db); rset.Open(dbOpenSnapshot, SQLquery, dbReadOnly); This does not allow for binding to more than one database at the time. Therefore, how can you do a join query betwe ...Show All

• Windows Forms DataGridView CurrentCellChanged event problem when populating...

  Hello, I have a DataTable with 11 columns and 9 rows. I use a DataGridView for displaying that, and I generate manually its columns. I have some problems when I populate my DataGridView : the CurrentCellChanged event is raised 3 times consecutively : the first time, the DataGridViewCurrentCell exist (and Columns.Count == 1 and Rows.Count == 1), the second it's Nothing (and Columns.Count == 11 and Rows.Count == 9) and the third it exist again (and Columns.Count == 11 and Rows.Count == 1). I don't want these three states... It seems the first case corresponds to a first populating (and it assign a currentcell), the second an unpopulating (and ...Show All

• Visual C# Creating a reference to a value type

  I need to create a variable that holds a reference to a value type so that something like the following will work: int i = 0; int x = i; i = 2;  // i need: i == 2 AND x == 2   This obviously works with reference types: DataSet ds = new DataSet(); DataSet ds2 = ds; ds.Tables.Add("Table1");  // now ds AND ds2 have 1 table (they reference the same object).   I thought that boxing a value type would create a reference, but it doesn't: int i = 0; object o = i; o = 4; // But: i != 4 i = 8; // But: o != 8   So, how can I create a reference (NOT a pointer) to a value type EDIT: I'm not sure it ...Show All

• Visual Studio Team System Build machine is not reachable

  I'm having trouble getting a Team Build type to run.  The error message that I receive is "Build machine is not reachable". I have defined the Build Machine as 'teamfoundation' in my build type, which is the name of the Team Foundation server (creative, I know).  I've tried various combinations of this, including the IP address, the FQN, and I've tried all of these from remote machines and on the server itself. Everything appears to be working except this feature.  I'm able to add work items, check things in and out of source control, and run reports.  I'm also able to browse to all of the web service pages that are in th ...Show All