Aamir Iqbal's Q&A profile

• SQL Server JOIN Excludes Records

  This join excludes records from the ticket database that do not have a customerID defined. How do I correct this Thanks. SELECT Ticket.TicketID, Ticket.TicketNumber, Ticket.TicketDate, Ticket.RRCNumber, Ticket.LeaseID, Ticket.Barrels, Ticket.StartTime, Ticket.StopTime, Ticket.LineNumber, Ticket.Status, Ticket.Invoiced, Ticket.SWDNumber, Ticket.CustomerID, Ticket.DriverNumber, Ticket.CompanyNumber, Ticket.ErrorDetected, Customer.[Customer Name] FROM (Ticket INNER JOIN Customer ON Ticket.CustomerID = Customer.CustomerID) WHERE (Ticket.ErrorDetected <> '0') AND (Ticket.ErrorDetected <> '1') AND (Ticket.ErrorDetected <> '2') AND (Ticket.SWDNumber = ) ORDER BY Ticket.TicketN ...Show All

• Visual C++ How to use CRect in DLL

  I have created a DLL using VS2005 and would like to use CRect and NormalizeRect() but I keep getting a unresolved external link error. I am just learning so it is probably something simple. Do you have any suggestions Thanks Here is the H and CPP files H #ifdef CLIPBOARDHELPER_EXPORTS #define CLIPBOARDHELPER_API __declspec ( dllexport ) #else #define CLIPBOARDHELPER_API __declspec ( dllimport ) #endif #include "atltypes.h" namespace ClipbrdHelper { // This class is exported from the ClipboardHelper.dll class CLIPBOARDHELPER_API CClipboardHelper { public : CClipboardHelper( void ); // TODO: add your methods here. }; extern CLIPBOARDHELPER_API int nClipboardH ...Show All

• Windows Forms DataGridView cell ReadOnly property not working

  Hi, I have added DataGridView runtime, where i am attaching dataset to this dgv of 3 columns (Check,Id,Text) with suppose three rows in it. and i want to make ReadOnly to 3 cells of Text Column only. user can add new row in it, but will not be able to edit rows. Thanks in advance. tats Thank you, lifa. Works for me. If e.ColumnIndex = 0 AndAlso e.RowIndex < dgvOpCodes.RowCount - 1 Then e.Cancel = True ...Show All

• Audio and Video Development Timer.enabled bug in MS ihdsim

  Hi guys, I think I found a bug in MS ihdsim. Lets discuss following JS example: var count = 0; function keydown_callback() { timer.enabled = false; timer.enabled = true; } function timer_callback() { count++; document.getElementById("TextLine1").state.value = count; } function main() { timer = createTimer("00:00:05:00", 1, timer_callback); timer.autoReset = true; timer.enabled = true; } setMarkupLoadedHandler(main); addEventListener("controller_key_down", keydown_callback, false); 1. I run this content in MS ihdsim; counter incremented with 5s period, its OK 2. Then I start pressing some buttons, for example '1' key, with ...Show All

• Windows Forms DataGridView Datasource property

  ArrayList Ips=c1.getIPs(); dataGridView1.DataSource = Ips; The getIps returns an arraylist with count 1 the content of arraylist 0th element is 'Pencil'. but in grid its displaying the length of string i.e 6 rather than displaying Pencil.What should i do to display the content of arraylist rather than the length. regards To simplify your code a bit: c1.registerServer( this .getHostName()); ArrayList Ips = c1.getIPs(); DataTable dt = new DataTable (); dt.Columns.Add( "UserID" ); foreach ( string user in Ips) { dt.Rows.Add(user); } dataGridView1.DataSource = dt; Andrej ...Show All

• Visual Studio 2008 (Pre-release) Binding TreeView to Relational DataSet

  alslamo alikom... i have a dataset with two tables..and they have a relation between them...which indecates the master table and the details table...the question is that i want to view those two tables in a tree view where the details table construct the leaf items...and the master table constructs the parent items...all that using code... i did the following and i don't know how to complete... -------------------------------------------------------------- TreeView MyTreeView = new TreeView(); GlobalDataSet.Tables.Add(ParentTable); GlobalDataSet.Tables.Add(ChildTable); GlobalDataSet.Relations.Add(ParentTable.Columns["ID"], ChildTable.Columns["ParentID"]) Bin ...Show All

• Software Development for Windows Vista Vista + IE7 -- OWA problem composing and replying to messages

  I have 2 Vista Ultiamte RTM machines with Office 2007 installed. When i open up IE7 on both machines and browse to OWA (Exchange Server 2003 SP2) and either compose a new message or reply to an existing message, all i get in the body of the message is a red cross in the top left and nothing else. It makes no difference if i add OWA to trusted sites and/or turn protected mode on or off. I cannot be the only one experiencing this problem and surely with a plain vanilla installation surely MS would have covered this in their pre-release testing Nick I think you will find more information and expertise in the TechNet forums - see the Exchange Server | Clients forum specifically: http://forums.micr ...Show All

• Software Development for Windows Vista Some sample about AcivityBind and WorkflowParameterBinding

  Can u give me some sample about the usage of WorkflowParameterBinding and ActivityBind I can't any theme about this A WorkflowParameterBinding is used to bind to named parameters like the properties of an invoked workflow. ActivityBind is used to bind an Activity’s property to a variable or another activity’s property. For examples of both do the following: · Create a new workflow library project. · Right click on the default workflow and choose View Code. · Add a property to the workflow like below: string paramOne = string .Empty; public string ParameterOne { get { return this .paramOne; } set { this .paramOne = value ; } } · Add a ...Show All

• SQL Server DB mirroring + load balancing

  Is it compatible to set up SQL DB mirroring on 2 different physical servers (High availbility + FULL transaction safety + Automatic failover with a third server as witness) and simultaneously set up network load balancing between these 2 servers (option with Windows Server 2003 Enterprise) If yes, which type of licenses do I need and how many (for SQL server 2005 and Windows Server 2003) with such a configuration - 4 physical servers in total : A, B, C and D - load balancing between A and B (same application) - load balancing between C and D (same application) - A hosts principal DB X, B hosts mirror of DB X - C hosts principal DB Y, D hosts mirror of DB Y - D is witness for A and B - B is ...Show All

• Visual Studio Team System Why does Rollback require copying all source files locally?

  Hello, I had to rollback a few incorrectly checked-in changesets, and I discovered that in order to do this I had to fetch the whole version control repository locally. I.e. all branches for all projects had to be copied on my machine before I could run a rollback. Is this necessary Why Think of a large source repository for a company with hundreds of developers. Second issue was that it was not possible to rollback several changesets at a time. And sometimes this is what is needed (several "wrong" check-ins in a row). Isn't it a good idea to support "composite" rollback, i.e. rollback that works on a multiple changesets Vagif Hello, I understand you are using PowerTool tfpt rollback. Tfpt rollback requires your workspace ...Show All

• Visual Studio Express Editions Visual Web Developer 2005 Express For ASP?

  I want to debug Classic ASP Apps using Visual Web Developer 2005 Express  . Can i and how to adjust it( Visual Web Developer 2005 Express ) Hello, I'm also interested in developing classic ASP solutions using Web Developer 2005 Express. Syntax highlightning works fine. However, I've got some questions 1) how can I jump to the declaration of a sub or function as known from Visual Basic's cursor menu "goto declaration" 2) intellisense works in case I have declared a class inside my source file, have created an instance and want to see the properties and methods by typing the name of the instance variable and the dot (.) But how about intellisense in case I ...Show All

• SQL Server Default vs Named instances

  I have a server computer named 'X' and I would like to install 2 instances of SQL Server 2005 1. SQLTEST 2. SQLDEV During installation. if I select Default instance then it will name my sql server instance X . I don't want that. I want to have essentially 2 named instances to make it clear to the users that they are using a test and dev sql server. Whats the best way to do this I am open to suggestions if there is a different way to do this. Is it required to have a default instance Can I have 2 named instances X\SQLDEV and X\SQLTEST Also, on the SQLTEST I will be installing reporting services. By not having a default instance will it cause issues for the SSRS installation. Please help! Thanks. ...Show All

• Visual C++ call wrappers and function addresses in DLL's

  Hi, I'm having trouble with C code that stores the addresses of functions that come from DLL's. The problem is I don't get the same value if I take the address of a particular function from two different DLL's. I can see that this is ultimately because the value my C code gets is actually an address in a jump table and my program has more than one one jump table. Here's my situation: .exe doesn't do much, just implicitly linked to DLL A which does all the work DLL A explicitly (calls LoadLibrary) on DLL B. Runs a routine in DLL B by calling GetProcAddress() etc, I'll call this initB() DLL B is implicitly linked to DLL A. When initB() is called it stores the address of a function inside DLL B in a list. I'll call that routine fu ...Show All

• Visual C++ WaitForMultipleObjects doesn't work

  Hello Everyone! Function WaitForMultipleObjects Requirements: Requires Windows Vista, Windows XP, Windows 2000 Professional, Windows NT Workstation, Windows Me, Windows 98, or Windows 95. But this function doesn't work in WinNT. Why Thanks in advance Vladimir   Viorel. wrote: Maybe you should replace this: LARGE_INTEGER check_elapse = {10000}; with this: LARGE_INTEGER check_elapse = {-10000};  Otherwise the second argument of SetWaitableTimer  is treated as an absolute time value, which is never reached, since it is in the past (1/1/1601).   I hope this helps. LARGE_INTEGER check_elapse = {-1 ...Show All

• SQL Server Declaring DataTable in script causes error?

  As discovered when trying to create a custom transformation for this question ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=899895&SiteID=1&mode=1 ) I tried creating an object of type DataTable and I get this error dim myTable as DataTable Reference required to assembly 'System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' containing the implemented interface 'System.Xml.Serialization.IXmlSerializable'. Add one to your project. dts://Scripts/ScriptComponent_3851bc3613714d2d904d79bc006234f9/ScriptMain 19 24 ScriptComponent_3851bc3613714d2d904d79bc006234f9 Even if I add "Imports System.XML" I get the same error. Isn't DataTable part of System.Data (which is imported by def ...Show All