SisMng's Q&A profile

• .NET Development Best Practice for C# App and SQL Connection

  Good evening, I am new to developing application in C# and Visual Studio 2005. I am an ASP guy, so I am finally moving to .net. I am writing a Windows application in C# and I need to use SQL as my backend to check usernames, passwords, and settings. What is the best practice for connecting to SQL for an application that is constantly hitting SQL up for some data In ASP, I open connection, get data (or update) and then close the connection. Is it done the same way in a Windows application in C# Since it is going to be constantly getting information from SQL, I want to write it so it is pretty efficient. I appreciate any feedback. Michael C. Gates Yes, you can use connection pooling (used by default, unless otherwise specified ...Show All

• Visual Studio ReportDocument.Load operation slow when moving to production server - suggestions?

  Hi. I am building an asp.net web application that uses crystal reports (the bundled version) in VS 2005. The reports are developed using my development machines at the office. The logon information and parameter data are supplied dynamically to the reports by the asp.net application. I have noticed that the reports load slowly on the production machine where the web application is run. I tracked down the problem to the row where I load the requested report crReport.Load ( pathToReportAndReportName ); This load-operation takes 1 second on my development machine and about 20 seconds on the production server. I then set up another database machine at the office and set the reports to get the data from it. This alone did not slow d ...Show All

• .NET Development Error Message "There is no source code available for current location" ..

  Hi, Error while debug on bRet = SetupDiEnumDeviceInterfaces(hDevInfo, NULL, guid, dwIndex, &devInterfaceData); The Error Message is " There is no source code available for current location " .. I am using VC++ .Net VS2003 What is it, and how i can solve this problem. Thank You. -------------------------------------------------------------------------------------------------------------------------------------------------- source file --------------------------------------------------------------------------------------------------------------------------------------------------- #include "stdafx.h" #include <stdio.h> #include <windows.h> #include <Setupapi.h> #inclu ...Show All

• Visual C# Switch statement

  Hi, all: [I guess this could be considered a rant, but I'm still curious if anyone shares my opinion on this] I am still wondering why the switch statement is not more flexible. For example, I feel that a switch statement using objects makes sense. I'll give a more visual example for ease of understanding more than anything else, so picture this: I have three buttons on my form, button1, button2, button3. I set the click event to the same event handler, button_ButtonClick. Inside the button_ButtonClick method I want to check the sender to see which button was clicked, so I do this: switch (sender) // or even (sender as Button) { case button1: // do something here break ; case button2: // do somethi ...Show All

• Visual C++ Using Window XP API

  Hi all, I am writing a program that need to make a network connection through dialing. So i thought of using the API used in windows for that purpose Is there an API which can be used for making a Dialup connection If so how can i use it Thanks. You could use the RAS API. See http://windowssdk.msdn.microsoft.com/en-us/library/ms715511.aspx ...Show All

• Internet Explorer Development How to grey out POP-up blocker checkbox

  Does anyone know how to grey out the POP-up blocker checkbox for the end user in Windows XP SP2 I assume this is a registry value somewhere, but have not found the answer in my research. Thanks! ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. What's the competition like?

  Hello everyone, I was just wondering if there is a list anywhere of the people and/or teams that are competing in the Dream-Build-Play contest   Does anyone else wonder what the competition is like and what games are being worked on for this Thanks, jay e Yup, I've got a lot of things done already, and a lot more to do. I hit the site several times a day. Of course, an entry will go in my blog ASAP. ...Show All

• Visual C++ default destructor and list iterator

  I came across a problem with a default destructor. The problem has been distilled down in the code at the end. I have an Iterator class that is used to access std::list<>'s. The original design was that a pure abstract base class was used to provide an interface. But if I define a pure abstract base class, bad things happen. From what I can see, the default destructor does the wrong thing and delete's the pointer to the std::list<> used by the subclass. Here is where it gets truely odd: only if the std::list<>::iterator in the object is initialized, does the destructor do something bad. Simply creating and deleting the object does not create a problem. If I implement destructors that do nothing, all is well. But my dest ...Show All

• Windows Forms How to scroll into view in Splitcontainer for desired controls?

  Some controls might be invisible because of size of application or position of splitter in Splitcontainer. How to bring controls in to viewable region of control runtime How will i know the control is in which panel (Panel1/Panel2) If we change the orientation of Splitcontainer control, will the layout of controls change in any application Is it possible Thanks for the reply, but requirement is different. I have Splitcontainer applications and I am automating the actions performed on them, so after recording the actions, i need to repeat/playback the actions on them. Sometimes when i am repeating actions on them, the controls are not visible as they are hidden because of splitter position or scrollbar pos ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. how to get input from various keyboards with directinput

  First sorry for my bad english... I want to get input from various USB keyboard, and I need to know from which keyboard I get the keystroke, I prove the directinput objects in VB 2005. This are the code that I use in the declaration section (in this case I use 2 USB Keyboard) Implements DirectXEvent8 Private MiDirectX As New DirectX8 Private MiDirectInput As DirectInput8 'the object to my first keyboard Private diDev As DirectInputDevice8 'the object to my second keyboard Private diDev2 As DirectInputDevice8 ' Private keyState As DIKEYBOARDSTATE Private keyState2 As DIKEYBOARDSTATE Private ManejaEvento As Long Private ManejaEvento2 As Long ------------- ...Show All

• Visual Studio How to set a specific font (not family) of a report element ?

  Hi all, I wonder if we can set font of a report element to a specific font, rather than a font family. Like, Arial TUR instead of Arial ...Show All

• SQL Server ProcessInput method kept a reference to the buffer

  Hi I have written a custom data flow component that counts the rows coming through the pipeline and adds the counts to an object stored in a package variable. The component sometimes generates warnings with the following message - "A call to the ProcessInput method for input 358 on component "<Component Name>" (354) unexpectedly kept a reference to the buffer it was passed. The refcount on that buffer was 4 before the call, and 5 after the call returned.". The component is used several times throughout ~60 packages. It does not always occur on the same instance, or even in the same package, from one occasion to another. When all the packages are executed (from a master package - some in parallel and some ...Show All

• Visual Studio Team System View all checked out files

  I am looking for a way to view all the files that are currently checked out in TFS, either by user or everyone. Equivalent of status search in VSS. So far I’ve not found a way to do this, is there a way Thanks Wayne You can do it from the command line or with the client API. It's not exposed in Source Control Explorer, if that's what you mean. ...Show All

• SQL Server SQL Database connection set up in Global.asax.vb for multiple users

  We have an application where users log in and set up a ConnectionString based on the login-info. As to now, we have used Application.Contents("conn") = (strConnectionString) in Global.asax.vb (Application_Start section) and then in the in the webforms we use Dim con As New SqlClient.SqlConnection con = New SqlClient.SqlConnection(Application("conn")) con.Open() ...... ...... con.close() (Each user has their own sql database that they connect to using the same scripts.) The question is: When many users are logged on at the same time, will the use of Application.Contents be a safe way to connect to each users own database or is there a possibility that users suddenly will try to establish a connection to a databa ...Show All

• Visual Studio Tools for Office Problem deploying Excel 2003 add-in

  Hello, I successfully created an Excel 2003 add-in using VSTO SE on VS2k5. When I run the app in debug mode, the add-in displays properly within Excel. When I run the installer, the add-in does not appear (even on the same machine as the development environment. I ran the client troubleshooter tool and everything seems to be there. For some reason I can only get the add-in to activate when run in vs2k5 debug mode. Any help would be appreciated Thanks, Richard looks good. I think the solution is in those docs. Let me take some time and go through them and get back to this thread. Thanks for the help so far -Richard. ...Show All