brucef's Q&A profile

• SQL Server Running a package in C#

  Hello all. I am trying to run a package in C# and have come accross the help file of how to do it in Visual Basic ('Running an Existing Package using Visual Basic'). However, I cannot find a reference to anything relating to DTS in my reference dialog. In the help file it says to add a reference to Micorsoft.SQLServer.ManagedDTS.DLL, however, I cannot find this reference anywhere. Am I missing something Thanks, Mike   Tazzmann wrote: ...is there a way to install just the Business Intelligence without installing SQL Server ... Yes and I have it that way. While installing you have to select only the option to instal ...Show All

• Microsoft ISV Community Center Forums Serial Port communication from Excel 2003

  I am trying to write a simple VBA macro that reads Text data from a Serial port and puts it into an Excel 2003 spread sheet. The solution needs to work from a standard installation of Office 2003. I cannot use add-in modules since the envrioment has been locked by the SysAdmin. Can I make calls to windows API to communicate with the port from Excel Is there some sample VBA code that shows how to do this Hi, here's an article with a lot of code in it that demonstrates calling WinAPI from VB.NET to access the serial port. I know your looking for VBA but maybe there's something there you can work w ...Show All

• Windows Forms VB.NET2003 MouseWheel on a panel?

  How do I make the mouse wheel scroll a panel that scrolls I have more control than can fit, and AutoScroll set to true, so scrollbars do appear. But the mouse wheel doesn't scroll the contents up/down or left/right. I have seen that behavior before in Internet Explorer. If a div contains a scroll bar and you place the mouse wheel over the top and use it to scroll to the bottom of it, the page begins to scroll. However, I believe that this is custom behaviour. ...Show All

• Visual Studio Team System Issues with moving TFS to a new domain

  Hi Over the last month or so I've been trying to move our TFS from one W2K3 domain to a different one. Having followed the guides I always have problems and I think I know where these problems stem from but I don't know how to fix them. One of the first steps in moving domains after stopping the TFS services is to join the new domain. It is here I think the problems start. Once I have joined the new domain, I can no longer look at any TFS database properties in Sql management studio, I get an SMO error, saying the owner property is missing. Before moving domains I have noted that the database properties say the owner is <origi ...Show All

• .NET Development java.awt.EventQueue in .NET

  Hi All, The way we can hook into the EventQueue in Java to grab all the events being thrown by the application, is there an alternate to do the same in .NET Especially given that I need to trap the events thrown by a C++ application, which is running under context of a C# application. Any hint/help in this direction would be of immense help. Thanks, Rajiv From MSDN, Control class: protected virtual void WndProc ( ref Message m ) Processes Windows messages. All messages are sent to the WndProc method after getting filtered through the PreProcessMessage method. The WndProc method corres ...Show All

• Visual C++ .NET Double Queue ????

  Hey all, I am doing a high-speed acquisition system w/ some multithreaded callbacks. I need to push data of type Double[,] from a NIDaq card onto a queue with one thread, and write it out to disk with another. I was using a .net Queue for storing this data from the card with something like this. void callback() { for ( int i = 0; i < chanCounts[0]; ++i ) { for ( int j = 0; j < rates[0]; ++j ) { rawQ[0,i]->Enqueue(scanData[i,j].ToString()); } } callback(); } Once I started to bump up my sample rate, though, my program started to crawl. Well, I narrowed it down to converting the scanData from a Double to an actual 'O ...Show All

• Visual Basic Child forms

  I have an application that when a text box has a certain value then a differant child form needs to be displayed I have stored all the differant form name in a database example textbox1.text = "Parent" then the form "Frm_parent" will be the child form but if textbox1.text = "Single" then the form "Frm_Single" will be the child form there are 20 differant entries Can you help with how this should be coded I would normally use Dim frm_a as New frm_parent frm_parent.show() How do you make the New Frm_ a varialble Frm_single etc     You can use reflection to do that. Take a look ...Show All

• SQL Server Express Manager / Management Studio Express

  When will the express manager be available for the msdn version that is scheduled to ship later this month. If express manager isn't going to ship then what tool will allow me to create users in my express 2005 database. Thanks Steve. Is there any target date yet for the RTM version of Management Studio Express I need something very soon for a production system. ...Show All

• Visual Studio Silly answer [:D]

  I tried to export my one page report ( 8.5” X 11” ) to PDF file, and I got two pages. Some of the columns of my report go to another page. How can I export my one page to one page PDF file correctly Thanks in advance.   Long Actually the PDF file has its own margins on both sides, and that makes my report ugly :).My report needs a farely wide width. Is there anyway I can change the PDF left_margin and right_margin before I export the report Thanks in advance. Long ...Show All

• .NET Development Howto create a read/write application setting?

  Hi! I'm trying to create a writeable application setting with VS 2005 Express beta-2. When I open the Settings tab in the application properties I have a designer that allows to create a new setting (say "MySetting" of type String). I can specify a default value and I can use the properties window to enter a description etc. In the code file Settings.Designer.cs a property "public string MySetting .." is generated automatically. But this property does only have a getter method , no setter! Somewhere I found mentioned that only read/write properties would have a setter generated. But I did not find how I specifiy this!! Does an ...Show All

• SQL Server Query Runs Perfectly in SQL 2000 but not SQL 2005 (but runs fine in Query Analyzer for 2005)

  The following query: SELECT TOP 1 a1 . AccountType as 'OtherAcctType' , a1 . ListID as 'OtherAcctName' , a2 . ListID as 'AgCommAcctName' , a3 . ListID as 'AdminAcctName' , a4 . ListID AS 'InsAcctName' , v1 . ListID AS 'OtherAcctVendor' , v2 . ListID AS 'AgCommAcctVendor' , v3 . ListID AS 'InsAcctVendor' FROM tblCommissionStructure LEFT OUTER JOIN tblAccounts AS a1 ON a1 . ListID = tblCommissionStructure . OtherAcct LEFT OUTER JOIN tblAccounts as a2 ON a2 . ListID = tblCommissionStructure . AgCommAcct LEFT OUTER JOIN tblAccounts AS a3 ...Show All

• Visual Studio Express Editions Integrate PSDK documentation into VC 2005 Express?

  I downloaded and installed Visual C++ 2005 Express and Platform SDK. I integrated PSDK directories into Visual Studio. However, I haven't found a way to integrate PSDK Documentation into Visual Studio help. When I press F1, only MSDN Express opens, without PSDK documentation. I can open PSDK documenation as a separate tool, but there is no way to search for highlighted text automatically (or is there a switch to dexplore.exe ). So, my question: is there an easy way to integrate Platform SDK documentation into Visual Studio Express so that Win32 API help opens when F1 is pressed Hi The PSDK is not displayed ...Show All

• Visual C# DataSet

  Hi folks I'm trying to build an derived Class from System.Data.DataSet as public class MyDataSet : DataSet {    public MyDataSet()    {    } } My problem is that : 1) if i try to install my assembly as it is to toolbox nothing happens 2) if i add [tooboxitem[true] attribute to my class  then component installed to tollbox but  i lost all extra futures of dataset as Tables and Relations Any idea thanks Dimitris Thanks for your replay Simply thats say i want to add an String property wich is not exists on Base class System.data.dataSet and use ...Show All

• .NET Development SSLStream.AuthenticateAsClient not working without server certificate name

  Hi, I am trying to develope a TLS based server-client application. The client side sslstream has to be authenticated with AuthenticateAsClient with the server certificate name as input. My problem is that, from the client side, I don't know the name of the server certificate. I only know the hostname of the machine which is the server. In this scenario, how do I get the server certificate name to connect. Regards, Kuldeep. How about using ServicePointManager.RemoteCertificateValidationCallback to get a reference to an object that represents the remote certificate.  Then call the GetName() method on th ...Show All

• Windows Forms how to usercontrol with a dock property ?

  how do i make a user control with a dock property so that when i add it to my form when i set it to DockStyle.Top it goes to the top i did a public DockStyle Dock then in the  { set } i did position it to the top but what i want it something like panel.dock how i reserve the top x height so that when i dock another control it doesnt overlape the other controls when geting parent.clientrectangle should  have clientrectangle.Y-controldock.height so like Panel does Your user control already inherits the Dock property from Control, and you don't need to add any special code to support this behavior. ...Show All