rafidheen's Q&A profile

• SQL Server I need a CONNECTION GURU to explain what is going on.

  I have a application that uses a connection that is always active until the application is closed, and many other connections that are opened and closed as different data is requested. I DO close and dispose these connections, datasets, and data readers after requesting data to release the resources. BUT they still show in SQL Server 2005 Express Edition. I believe they are NOT active and are part of the Pooling system. The problem is the connections don't seem to be reused, the Pooling system just makes more, so I end up with hundreds of them until no more connections can be created but SQL Server; hence timing out on some attempt to ope ...Show All

• Visual Studio Tools for Office Accessing a Control on a Outlook Custom Form in VSTO 2005

  i've added a Combobox to a Custom Form, based on the Appointment Form. Now i would like to be able to access this control from my VSTO 2005 code (C#) but i'm not sure how - anybody tried this The result should be a populated Combobox with data from a Web Service. Hope anybody can give me a pointer to a solution! Martin, Are you talking about a custom Outlook form or a custom .NET Windows form If you are talking about the former, then you are pretty limited. The ActiveX controls on a standard Outlook form (or one based on that standard form) are not available to your .NET code without ...Show All

• Visual Studio Express Editions "DataView" that "Joins" two tables from a dataset?

  Is it possible to create something like a "DataView" that "Joins" two tables from a dataset If Yes then how hi, dataview use one table only, if you want to join 2 tables you have 2 things to do , write your connection to the database manualy and in your sqlstring to use Inner Join or to build a query\view in your database and to request this query\view to iterate through your table records and to build a new table (which is not recomended) hope this heps ...Show All

• Visual Studio Express Editions Command line error D8016 : '/MT' and '/clr' command-line options are incompatible

  I am an advanced level programmer of Borland C++Builder. Interested to try Visual C++ and hence evaluated VC++ Express. Honestly I am both pleased and disappointed. Pleased: For a programmer with zero experience using VC++ product, I managed to get my introductory project saved and compiled simply by way of self exploration. This shows despite VC++ is much more complicated than Borland C++ Builder in interface, it is still manageable. Disappointment: The subject error corped up and there is no way I can get rid of it. All settings change in the IDE seemed transparent to the command line options. I have already tried all permutat ...Show All

• Software Development for Windows Vista Error when trying to see the designer of a Workflow!

  Hi all! Does any one here had the error message: COULD NOT LOAD FILE OR ASSEMBLY 'Microsoft.VisualStudio.Designer.Interfaces, Version=2.0.0.0, culture=Neutral, PublicToken=b03f5f7f11d500a3a' or one of its dependencies. The system could not find the specified file. And then, I can not start design Workflows... Any idea See ya!@! Chila, In order to help need an answer to following questions: 1. Can you open designer for a Windows Form 2. What version of Visual Studio do you use 3. Did you have previous Visual Studio Beta installation on this machine 4. What version of Microsoft.VisualStudio.Designer.Interfaces do you have installed in GA ...Show All

• Windows Forms Custom Scrolling

  I have built a control & now I want to be able to scroll a multipage text in it freely  without inheriting TextBox , RichTextBox , TextBoxBase , because of extra features . please help me , thank you . Check out the http://www.windowsforms.net/Forums/ShowPost.aspx tabIndex=1&tabId=41&PostID=11274. To implement scrolling you need to: a) calculate size of the  ...Show All

• Software Development for Windows Vista Creating ActivityExecutionContext

  Hi,     I am trying to execute a sequence that I have created in my custom activity.    The problem is that I have loaded the execution code in a different AppDomain and cannot serialize the ActivityExecutionContext to my execution code.  Therefore I do not have a context instance to start in my Execution method. In my constructor, I do the following. this .sequence = new Sequence (); // SequenceTestActivity is derived from Activity this .sequence.Activities.Add( new SequenceTestActivity ());  this .context = new ActivityExecutionContext ( this .sequence); In my Execute ...Show All

• Software Development for Windows Vista Beta2 - can't find system.workflow.* assemblies

  I have installed the January CTP, on a clean XP machine that had only VS 2005 RTM installed in the specified order: winfx runtime, Winfx SDK, VS ext for Winfx, then "Visual Studio 2005 Extensions for Windows Workflow Foundation Beta 2(EN).exe" When I create and compile an empty WF project, I get these errors: Metadata file 'System.Workflow.ComponentModel.dll' could not be found. Metadata file 'System.Workflow.Runtime.dll' could not be found. Metadata file 'System.Workflow.Activities.dll' could not be found Looking in gacutil /l, I find these entries are there: System.Workflow.Activities, Version=3.0.0.0, Cultur ...Show All

• Software Development for Windows Vista Asp.NET & WF- Performance issue when number users increases

  Hi, My query is regarding the performance in the following scenario. User is creating a Ticket from asp.Net page which may or may not be sent for approval before processing. The Admin user can view/process the ticket, or can send for approval if required. Whenever the ticket is created , I want to invoke the workFlow runtime to save the state of the ticket and when the Admin user logs , I again want to get the ticket from its latest state using the WorkFlow Runtime. Now , 1) If suppose 1000-2000 users are accessing the Site to create/view their tickets then how many WorkFlow runtime Instances will be created 2) Will it affe ...Show All

• SQL Server Using a trigger to insert committed rows into a table following SQL Server's tran log order

  Here's another fun one ... I have a series of tables in the Sales database (Customer, Order, LineItem). I will create an insert/update/delete trigger(s) on each of these Sales tables. I will have a multi-user system, with interleaved transactions from each user going on simultaneously, all running different INS, UPD and DEL transactions against these Sales tables. As changes are made to each of my three Sales tables, I would like the table's associated trigger(s) to record the changes made in a single common "Change" table.  The Change table would contain information such as the table name, columns_updated() and perhaps s ...Show All

• Windows Forms Binding ComboBox and DataTable including a None entry.

  Hello. We would like our customers to select a country, but it is not required. Thus, the top-most entry shall be "<None>". We read the countries from our database and bind the DataTable to the ComboBox. How do we go about adding a None entry to the ComboBox We can't add a None row to the DataTable or DataView. Is there a property on the ComboBox I'm missing or something Cheers, Chris I use unions queries and LookupDataTables: suppose I have possible values of - CarMake ID Make 1 Ford 2 Chevy 3 Chrysler I will fill a Lookup table with Select * from ( select ID, Make fro ...Show All

• Visual C++ Problem with decimal representation on German OS !!

  Hi, I am facing a problem which I think is very generic and I can find a prompt answer from my fellow programmers around. I am doing some calculation like: int original_scale_factor = 1; float temp = original_scale_factor / 1000.0; which if I output in a file using: fprintf(out_file, "Matrix Value [%9.7f] ", temp); dumps string like : Matrix Value [0.001] The problem arises in German OS where the same value is dumped like: Matrix Value [0,001] which renders my processing of the output file invalid later. I found that its the issue with German OS decimal point representation format where comma is used in place of decimal. ...Show All

• SQL Server 1 GB memory limitation for SQL 2005 Express edition

  Question: Can the SQL 2005 express edition can be installed on a machine that has more than 1 GB memory If so, is the SQL 2005 express edition will be using memory upto 1 GB     Yes, you can install SQL Express on a computer with as much memory as you want, but SQL Express will only use 1 GB of that memory. Mike ...Show All

• Visual Studio Express Editions Using ListView SelectedIndexChanged Event to Show Forms

  I'm really hoping somone can help me with the below problem. I posted it originally in the Windows Forms forum, but so far haven't gotten a reply. I truly would be grateful for any help!! I have a ListView called TrainingListView that has a collection of 12 items. Each item represents another form that I would like to show if the user clicks on it. My problem is that the items in the collection don't appear to have a click event, so I need to use the SelectedIndexChanged event as workaround to get the same functionality. I've been struggling for the last several days on the code to get the SelectedIndexChanged event to open the app ...Show All

• .NET Development Why mouse API not working on longhorn machine??

  I am trying to send mouse right click event thru "SendInput" API. ( Even I tried using mouse_event API ) Its working on XP but not on longhorn. Can anybody tell me why so Is there any other way to simulate mouse right click event on longhorn using win32 APIs or .net freamework classes Please Help !!! Following is the code: [code language="c#"]  struct MOUSE_INPUT { public uint dx; public uint dy; public uint mouseData; public uint dwFlags; public uint time; public uint dwExtraInfo; } struct KEYBD_INPUT { public ushort wVk; public ushort wScan ; public uint dwFlags; public uint ti ...Show All