Eric Kinateder's Q&A profile

• SQL Server SSIS Excel source read problem

  I have a problem with reading data from an Excel file in SSIS. I'm trying to read a column that mostly consists of decimal values, but there are couple places where column entry is 2 numbers separated by a slash (e.g. "100/6.0"). SSIS tries to be smart and identifies the column data type as decimal and when it reads the cell with the slash in it, it reads as NULL. I tried to make my excel source reader component to read that cell as a string, but it gives me an error. If anybody has come across something like this, I would highly appreciate some help -Erlan It seems like adding IMEX = 1 to the Excel connection string's extended properties solves this problem. For more information read http:// ...Show All

• Visual Studio Express Editions Deploying a CLR program to other pcs

  I have a fairly simple CLR C++ program that runs perfectly on the developing pc but how do i get it to work on other pcs I have read the other post on win32 deployment but that does not work can anyone help I appreciate it, Nick ...Show All

• Visual Studio 2008 (Pre-release) One Endpoint with Multiple Addresses on Same Port

  Is it possible to create a single endpoint with multiple addresses For example, I'd like to create a Web service and be able to access it with http://localhost:8000 http://127.0.0.1:8000 http://machine-dns-name:8000 If you try to open a ServiceHost specifying one of these as the base address and the others as alternate addresses, it immediately fails. Enable port-sharing doesn't seem to fix it. Thanks, \Steven I think it should just work if you are using the default NetTcpBinding or the default HostNameComparisonMode. Can you send out the exception you are getting ...Show All

• Visual Studio Express Editions form2 combobox

  Hi,i am new to programming i am having trouble with the following. i have a form with a splitcontainer i have added 2 usercontrols "usercontrol1" and "usercontrol2" i have set the usercontrols to fill splitcontainer panel2 i have a second form "form2" i have a combobox on form2 with collection items "conttrol 1" and "control 2" i am saving the selected text of the combobox to a user setting "startupcontrol" if i put the combobox on form1 on splitcontainer panel1 i get the results i want. But if i move it to form2 where belongs it does nothing. Please see the code below. The first part is working with the combobox on form1 splitcontainer panel1 T ...Show All

• Visual Studio Express Editions Memory Adress of Registry Hives

  Hi Is it possible to know where is the registry loaded into RAM I need to have read only access to the registry. I want to use the In-memory pages of regsitry for that purpose Can perfmon help in any way for this Any point of thought will be of great use. Thanks Sumit The registry is not loaded in RAM, it is stored on disk. The disk cache will keep the most recently accessed registry sectors in RAM but that is not accessible to a user mode program. Nor could you find out what portions are being cached. Or how disk sectors map to hives and keys. You have use the API, there are no shortcuts. ...Show All

• Windows Forms Treeview dragdrop event ignores exceptions! HELP

  Hi, I have a windows.forms application in C# using a treeview with dragdrop capability, however I have found when an exception occurs in the DragDrop event and is unhandled, .Net ignores it (instead of showing the exception dialog) Attached I have some test code where I explicitly throw an exception in the DragDrop event, nothing happens! Any ideas thanks Brian public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void treeView1_DragDrop( object sender, DragEventArgs e) { throw new ArgumentException (); } private void treeView1_ItemDrag( object sender, ItemDragEventArgs e) { DoDragDrop( "!" , DragDropEffec ...Show All

• Visual Basic Execute scripts using Internet transfer control ...?

  Can i execute scripts on a unix box using the internet transfer control To be more precise using the execute method of the control . i need to run scripts and get the results also .. please enlighten... sars.. ...Show All

• Windows Forms Need to see code samples of using an ActiveX control from a Windows Form.

  Are there any examples in MSDN (or anywhere else) that show using an ActiveX/C++ control from a Windows Form I'd like to see some non-trivial examples if possible. Tnx Mark ...Show All

• .NET Development How to use Process.OnExited()

  I am using processes in my code that I need to generate an event when they are finished.  I am assuming it has something to do with the System . Diagnostics . Process.OnExited() method, but the documentation on it is sparse.  I use code similar to the following: System . Diagnostics . Process proc = new System . Diagnostics . Process (); proc . EnableRaisingEvents = false; proc . StartInfo . FileName = "H:\pebld\wookie.bat" ; proc . StartInfo . Arguments = tbox1 . Text . ToString (); proc . StartInfo . WindowStyle = System . Diagnostics . ProcessWindowStyle . Hidden ; proc . Start (); How do I know when this process finishes I have reviewed that as well.  I tried to do #1 on your list what I have ...Show All

• SQL Server Failed to Open Rowset Error in Crystal Reports

  hello all, i have developed a desktop application(software) inwhich used Crystal Reports 9. I am using Microsoft Developement Environment 2003 (Visual Studio 2003).The reports in this software runs well on my own system where i developed the software but when I install this software on the computer(client computer), the report does not open when the Generate Report button is clicked. This button click event fills the data using a simple query from databse(SQL Server 2000) and this error is displayed: Failed to open Rowset. The .Net Framework 1.1 is installed on the client computer before the software is installed and run. I also include some merge modules in the setup of the project that I make. These merge modules are: Crys ...Show All

• Windows Forms working with dynamic listviews

  greetings, Im a bit confused as to how to get the multiple values that have been selected in a listbox that is dynamically created. (note - i have my own webcontrol that is a listview) basic scenario is - I have a static listbox which allows multiselect, shows a list of students, so when i click on any of the student (1-2 students), it dynamically creates another listview for each of the student select which shows the subjects they have selected... place in a dynamically created cell ...inturn add it in a row.. which will then add the row into the placeholder.()all done dynamically now i want to add a feature where in i can change the selected subjects in the dynamic list for each of the students and allow to save in the database. issue - ...Show All

• Visual C++ Can we export public static variables using AFX_EXT_CLASS?

  I am trying to export a class which has a static BOOL variable in a MFC extension DLL using AFX_EXT_CLASS . I find that when I try to access this variable from the client application I get a LNK2001-unresolved external error. But MSDN documentation clearly states that "If you are exporting the entire class rather than selected members of the class, static data members are automatically exported." So does the 'static data members' imply only functions If so, how do I export a static variable in an Extension DLL Probably you have to have a declaration in your executable which uses DLL, like this: declspec( __dllimport ) extern BOOL MyClass::myStaticVariable; If i ...Show All

• Visual Studio Express Editions Create popup menu "VB Express"

  HI How can i create a popup menu for RichTextBox For example, when i'm clicking with the right mouse button in any part of RichTextBox, That most dispaly a popup menu. I have written this code, but it's not working Private Sub RichTextBox1_MouseClick( ByVal sender As Object , ByVal e As System.Windows.Forms.MouseEventArgs) Handles RichTextBox1.MouseClick If e.Button = Windows.Forms.MouseButtons.Right Then MnuPopupToolStripMenuItem.ShowDropDown() End If End Sub If someone knows how to create this menu, I would appreciate. Thanks Drag a context menu strip from the toolbox onto the main form. (It will park itself underneath the form.) Go to the richtextbox properties ...Show All

• .NET Development How to use generics with web services

  Hi, Can i use generics on a web service class in C# I am trying to create the base class for the web service as shown below public class MyBaseWebService <T> : System.Web.Services. WebService where T : MyServiceBase , new () { ... } but its throwing compilation error. "Using the generic type 'MyServiceBase<T>' requires '1' type arguments" and the class MyServiceBase is having the following definition. public class MyServiceBase <T> where T : MyEntityBase, new () { ... } Can someone please help me with this You are getting the compile error, because your “where” clause reference the MyServiceBase without ...Show All

• Visual C# How to wait till all threads complete their job ?

  Hello friends, Kindly fo through the following code sample, In this code, i want to stop execution till all the threads have complited their job. and i dont know how can i do this. static ArrayList FarchedContent = new ArrayList(); public static string SearchContent(string KeyWord) { objThread = new Thread[20]; for (int i = 0; i < 20; i++) { objThread = new Thread(new ThreadStart(FatchContent)); objThread .Priority = ThreadPriority.AboveNormal; objThread .Start(); } //Here I want to use FarchedContent but i want to make sure that all the //above created threads have complited their job. // How can I do this } private static void FatchContent() { string ...Show All