Shanewho's Q&A profile

• SQL Server Return Excel Worksheet Name

  Currently my package contains an Excel Source with a contraint to a SQL Table.  The Excel Connection Manager currently has an expression attached to it which allows it to read the variable value and this in turn loads the correct file.  This all works fine. The problem I am having is that if the Worksheet name is different to what was previously set a error is thrown. Is there anyway in SSIS I can retrieve the name of the excel worksheet and pass it into a variable to be used. Thanks Kismet123 My colleague had a similar problem. The workaround we used was to copy the sheet (whose name can vary) ...Show All

• Software Development for Windows Vista closing after fullscreen video

  Ive got fullscreen video's playing quite nicely with the directx Video class. However, when the video finishes it just freezes on the last frame. I know I can bind to the Video.Ending delegate, but I dont know what to call to leave the fullscreen video mode. Thanks in advance   So what do you mean by finishing the video I asume that you mean destroying the whole application, so do you release the d3ddevice and d3d Also do you destroy your window  For example using : DestroyWindow(hWnd); PostQuitMessage(0); To make it easier, set windowed mode and enable dxdebugger, it will provide ...Show All

• .NET Development System.Net.Sockets.Socket bad design?

  hey, why Socket Class, in System.Net.Sockets.Socket, does't support events like OnConnect, OnClose, OnReceive why do i need to send data to server to check connection state how about performance thanks. P.S. Who designed this text editor it's bad.        We do support that. If you call BeginCOnnect BeginReceive BeginSend a callback is called when the connect, receive or send succeeds performance is comparable to any managed api. There is always the overhead of CLR and managed code. Your perf numbers depend on what you are really doing. If you want to complain a ...Show All

• .NET Development 32-bit compiled trying to run on x64?

  We have a 32-bit .NET application that works fine on standard Windows XP 32-bit. Recently purchased a x64 Dual XEON Intel system. Installed Windows XP x64 and all the updates including 64-bit .NET 2.0 framework. The application splash screen comes up and then immediately crashes. Before I look deeper, does the 64-bit version of .NET 2.0 run 32.bit .NET 2.0 applications Thanks. JR JR: Can you give a little more detail about why your application is failing Ken is correct that .Net 2.0 X64 will run MSIL ("agnostic") assemblies. However there are a few caveots. If you application P/Invokes i ...Show All

• Windows Forms DateTimeFormatInfo and MaskedTextBox

  I want to have an editbox with a mask for the time of the current culture. I thought this could be achieved by getting the pattern from DateTimeFormatInfo. CurrentInfo.ShortTimePattern and giving it to MaskedTextBox.Mask. But the mask has another format, it does not recognizes the "mm dd yyyy" characters. Any idea is highly respected. Thanks: Greg ...Show All

• Visual Studio Unistallation help required

  I am unable to complete the uninstall process of visual studio 2005 beta 2. can any of you give me some guidence to complete the process of the same. i have uninstalled all the products from my control panel other than the visual studio 2005 beta 2 english version. i used some of the utilities which i found in the same site to complete the process even though i am not able to complete the process. some one please guide me to complete this. Thank you. You can also try the updated clean up tool at: http://go.microsoft.com/fwlink/ LinkID=47598 ...Show All

• Visual Basic Freezing Header of the Data Grid.

  I want to freez the header of the DataGrid, I have manage to do this with the the CSS styles. but it is working only with the IE, but i want to work with Netscape as well. Hey pls if any body have an idea pls Help me As soon as possible. Can you explain a little further what you are trying to achieve here. Are we talking datagrid or datagridview control Are we developing using VB 2005/Express or VB 2003 Is this a windows or web based application I assume web based because we are talking CSS and IE/Netscape. ...Show All

• Visual Basic VB.net 2003 application not install under .net framework 2.0

  Hi everyone, I developed an application using vb.net 2003(.net framework 1.1) and build the setup package as well. It installs and runs no problem on the machines have .net framework 1.1. When I tried to install on a machine only has .net framework 2.0, it says .net framework 1.1 is needed to carry on the installation. If I install .net framework 1.1 to that machine, everything is ok. But MSDN said "the .NET Framework provides a high degree of support for backwards compatibility. For example, most applications created using version 1.0 will run on version 1.1 and applications created using version 1.1 will run on version 2.0." I'm j ...Show All

• Windows Live Developer Forums Add-In consume web services ?

  Are the add-ins allowed to consume web services Haven't had much success so far. I have tried to call a method from at a webservice through the addin, but it throws an WebPermission-exception. So, this is also not allowed. It is also not possible to download information through a tcp or http session. (I've tried this using the WebClient-class). It is also not possible to read information from files. (I've tried this with the File.OpenRead method) That makes me thinking: is there any way to retrieve any information from the outside The only useful addin I can think of at the moment is an awnsering machine... ...Show All

• Visual Basic validating-event

  Hello,   Can somebody tell me if it’s possible to get the name of the control (not the container !) that causes validation during the validating-event of a control that I’m leaving.   Thanks,     About the name of the control, see in the good book: http://msdn.microsoft.com/vbrun/staythepath/additionalresources/IntroTo2005/default.aspx Free Book – Introducing Visual Basic 2005 for Developers In Chapter 1 – Framework Class Librasry - Namespaces The author says: Unless other information is provided for the compiler to resolve a class n ...Show All

• .NET Development Understanding the role of form="unqualified"

  I roundly dislike the prefixing of attributes in XML files that won't go outside my application. (They are so thoroughly encrypted they won't do other much good:-)) And I much prefer to store info as attributes rathr than elements when I can get away with it. So I have discovered the value of setting form="unqualified" in the schema. The question is "where should I be doing this." If I get things exactly right I can have things like <tag attribute="value"/> that read into a datatable aok. If i don't get things exactly correct then to get the data loaded in to a datatable i have to code <t ...Show All

• Software Development for Windows Vista How to use Overlay Mixer

  Hi, guys, can you provide a example for me thank you very much. I use gradedit.exe, I can add the overlay mixer to the graph, but i can't set the video size to 640*480 with 24bits. It said: Can't support this format.  i delete the overlay mixer from the graph, then i can set the video size to 640*480 with 24bits. why Did you try the various renderers available Also it may need some color space conversion filter. What do you need the overlay mixer for Why the VMR doesn't suit your need If your application does not target Windows 2000 or older you should go with VMR. ...Show All

• Visual Studio 2008 (Pre-release) Mobile 5 development questions

  First of all, thanks for the great information. I am in the process of developing a Windows Mobile 5 app. I have a few questions: 1) From what I've read, WPF/e is not available yet. Any idea when something will be available for developers 2) Without WPF/e, can I still work toward the goal of a WPF UI I'm pretty sure I could use Interactive Designer to begin the UI, and I have some classes written, but at what point will I hit a brick wall I probably will not be able to build the app. 3) Currently, I've been building a Windows Forms application to test the "engine". If I encapsulate my classes well enough, outside of the ...Show All

• Windows Forms ListView Control Problems

  I am using a listview control. MultiSelect, CheckBoxes and FullRow properties are set to True. View is set to Details. 1. When I check the checkbox of a list item, I want it also selected. I placed this code in the ItemCheck event: Me.MyLVControl.Items.Item(e.Index).Selected = Me.MyLVControl.Items.Item(e.Index).Checked. It does not work....but if I change the right hand side to Not(..), then it does work, exactly the opposite of what one would expect; but, if I set a listviewitem checked property to True in code, this does work the way one would expect. What to do 2. By checking the checkboxes, one can select as many items as one ...Show All

• Visual Studio Express Editions How do I press enter to activate a button click?

  I have a login form and what I want to be able to do is press the enter key to click my "okbutton" without having the button selected like it is in nearly every login screen you've ever seen.   Thanks.   I find it for a long long time  But i have other question can you help me man   http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=485816&SiteID=1 Thanks. ...Show All