LPXO's Q&A profile

• SQL Server Row numbers on export

  HI I have written a script to export data from customer table to another crm package, on the export they require the first column to be numbered 1 - .... say 1000 or how ever many rows there will be. Is it possible Thanks Rich Are you talking about a batch count Or does every row have to have a number If it's batch count then use DTS add a global variable, assign the count, then use the file syst ...Show All

• Windows Forms NullReferenceException using CodeDomComponentSerializationService

  I'm seeing a NullReferenceException when calling Deserialize on an instance of CodeDomComponentSerializationService in my custom designer.   I am trying to implement cut/copy/paste functionality.  I have already successfully implemented Undo/Redo using the same class to perform serialization. Using the default Windows Forms implementation for the Paste command (in the private CommandSet class from what I can see), the components ...Show All

• Windows Forms Completed what I wanted

  Hi I'm trying to test a Menu control that is developed in C# using NUnit and I need a way to have the menu dropped down thru code because the testing should not involve any manual operations. I used the following code that highlights the&n ...Show All

• Software Development for Windows Vista WorkflowInstance.EnqueueItem Method

  Can I use this method to raise an External Event after an CallExternalMethodActivity has been finished and been persisted and the ListenActivity is waiting The question goes back to this entry ... If yes what would be expected as the second parameter public void EnqueueItem( IComparable queueName , object item , IPendingWork pendingWork , object workItem ); You really can't - as the sec ...Show All

• SQL Server VARCHAR equivalent for FLOAT

  Hi I have a variable defined as float data type. I would like to convert this to a varchar datatype without causing any overflow or any errors. How do I define it for varchar data type VARCHAR(53) VARCHAR(40) Regards Imtiaz Assuming the variable can have any value within the range of float.min or max values..what shud be my best bet for varchar length... ...Show All

• Windows Forms Word Viewer

  Not sure if this is the right forum for this but here goes; I was wondering if anyone knew how(if possible) I could store bits and peaces of a word document(including images, in a blob for example) in a database and then fetch it from there and view/edit in a winform, not in ms word. Hello, I am using Visual C++.Net 2003. I would like to run Msword 2003 as a part of the windows form. I added a reference ...Show All

• Visual Studio Team System I really miss the report "Work Items By Owner". How can I get it back?

  Hi, One of the most used reports "Work Items By Owner" has been cut in the TFS RC. How can I get it back Is there any chans it will reappear in the RTM Can I create one my self in any easy way Regards, Kristofer RTM will not include such a report however I will recommend creating a pivot chart using Microsoft excel or using the report builder to create such a report. Check out this link ht ...Show All

• Windows Forms VB.Net Newbie Design Layout Question

      I'm new to VB.Net so please bear with me.      I have a desktop form that takes one 800X600 screen. Half of the form is a an active checklist of steps that the computer has validated. The other half of the  ...Show All

• Visual J# InetAddress.getByAddress() missing?

  Hi, I'm using Visual J# 2005 Beta 2 and when I try to use InetAddress, I only get 3 available methods: getAllByName(), getByName(), and getLocalHost(), but getByAddress() is missing. Does anyone know why this is How else can I retrieve an InetAddress object with just an IP address Thanks, Yaron Hi, I'm able to get InetAddress object for given IP address by getByName() method. InetAddress ina = InetAddre ...Show All

• .NET Development Exception with System.Type.GetType(...) function

  Hello all, I have a strange problem with the System.Type.GetType(...) function. When I do : try {    string maChaine = "System.Windows.Forms.Button";    Type ty = Type.GetType(maChaine, true); } catch (Exception ex) {    label1.Text = ex.Message; } An exception raises ; the message is (I translate ...) "Impossible to load the type System.Windows.Forms.Button from the assembly WindowsApplicationXXX, Version xxx, .. ...Show All

• SQL Server Failed to generate a user instance of SQL Server

  I am trying to create an SQLExpress database file (mdf) in VS2005 but I get the following error: "Failed to generate a user instance of SQL Server due to a failure in making a connection to the user interface. The connection will be closed.” I also get this same error if I try to open an existing database from the VS samples. Any Ideas Thanks, Dave T Ok got this much figured out, still having other problems, b ...Show All

• Visual Basic Manipulating an object

  I’m wondering if it’s a reasonable approach to manipulating an object where I store some data by passing it as a reference to another object that displays the data and enables me to modify the data as needed, rather then putting all of the code to store, display, and modify the data all in the first object. I’m also puzzled as to how to pass the reference within the second object. I can use ByRef to get the “address” of the data object into t ...Show All

• Smart Device Development Debugging a SqlDataSource Insert Statement

  In ASP.net, using a FormView control, I am having problems on execution of the Insert Statement associated with a SqlDataSource control. The error states that null value cannot be inserted in a given column. I have set the default for that column within the table design to be a string value. Therefore, I do not understand the error. Thanks. Off topic. Please post to ASP.Net forums: http://forums.asp.net/ ...Show All

• .NET Development Recursive searches with Regex Class.

  Hi! How can I do recursive searches with the Regex class. I know the Sample with the matching Parantheses ()*, but I need it with BEGIN/END blocks e.g. some text begin    more text    begin       even more text    end end second part begin    text end So the expression should match the outermost begin/end blocks. How can this be done *) \(   ...Show All

• Visual Basic menu dropdown list with check marks

  I am populating a dropdown list for a context menu at runtime. How can I place a check mark next to some of the items I tried (amongs others) Dim list As ToolStripItemCollection = ContextMenuSelectLine.DropDownItems list.Item(i).Checked = value This gives a compiler eror that "Checked is not a member of System.Windows.F...... ToolStripMenuItem". I can cludge it by declaring each item a " ToolStripMenuItem" ...Show All