bes7252's Q&A profile

• SQL Server No ADO type command for Data Flow?

  I'm probably not looking in the right place, but all I could find when creating a data flow task was OLE DB Commands.  I was trying to utilize a dataaccesslayer piece of code that we use every where in our projects, but because it uses ADO and not OLE DB, it caused an issue between the column data types. Is there an ADO command object available   Or are we forced to use the OLE DB command object   All I was looking to do was to Execute a SQL command.  There's an object on the Control Flow level to do that, but not on the Data Flow level---not sure why that is. Thanks, Jeff Tolman E&M Electric It's not necessarily a particular command. It's using ADO vs. OLE DB. Our DataAcc ...Show All

• Windows Forms DataGridView

  I have a DataGridView on a form and I want the user to be able to edit several different fields in any of the rows displayed. After editing the fields (in possibly many rows) I want to find which rows in the DataGridView have been edited. How do I find out which rows in my DGV have been edited Thanks, Dave alternatively Private Sub ToolStripButton1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ToolStripButton1.Click Dim r() As DataRow r = Me .CostingDataSet.Bill_CostTypes.Select( "" , "" , _ DataViewRowState.ModifiedCurrent) End Sub ...Show All

• Visual C++ wchar redefinition in ODBCSS.h

  Hi, I get the following errors when i convert to Visual Studio 2005. Inclusion of ODBCSS.h causes the problem. -- Start Error Message 1>C:\Program Files\Microsoft Visual Studio 8\VC\PlatformSDK\include\ODBCSS.h(430) : error C2371: 'WCHAR' : redefinition; different basic types 1> C:\Program Files\Microsoft Visual Studio 8\VC\PlatformSDK\include\winnt.h(266) : see declaration of 'WCHAR' -- End Error Message Can you please tell me what is wrong Any help is appreciated. Regards, Venkat Make sure windows.h or afxwin.h( if its MFC app) is included before this include. Ideal sequence would be. #include <afxcmn.h> //if MFC #include <sql.h> #includ ...Show All

• Visual Basic disabling some keyboard key

  Hello, I created a VB8-Access program, im using ADODB as my connection. now i want to disable the " quote and ' single quote this is my vb6 code Dim keyascii As Short = Asc(e.KeyChar) If keyascii = 34 Or keyascii = 39 Then If keyascii <> 13 And keyascii <> 8 Then keyascii = 0 End If End If and my vb8 code, im missing some part (or maybe my codes are really wrong) If e.KeyCode = Keys.OemQuotes Or e.KeyCode = Keys.______ Then If e.KeyCode <> Keys.Enter And e.KeyCode <> Keys.Escape Then _________ = Keys.OemClear End If End If the first blank is i can't find the single quote then the second one, if i use the textbox unto it, it also didnt work t ...Show All

• Visual Studio 2008 (Pre-release) Manually modify SOAP message to talk to TIBCO server

  Hi, Sorry, I do have three more questions. At every step one more questions raises... :-|. I tried a few attribute setting, but unfortunately none solved my problems... 1.) The first is concerning the produced SOAP message. The message starts with: <s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"> Is it possible to insert a line ( < xml version="1.0" encoding="UTF-8" > ) before that I already reat this: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1138584&SiteID=1 It seems to be very complicated. Unfortunately, the server side expects this. 2) Is it possible to edit the SOAP envelope/body The client creates something like <s:body> and the server side possibly expects <SOAP-ENV:Envelope> ...Show All

• SQL Server another n00b question

  Man am I ever being thick this week. M'kay, I've been banging my head against the wall for the last few hours trying to do what conceptually seems quite easy. Basically I've got an input variable to an SP (in SQL Express 2005) set as type xml. The XML being passed accross looks like this: <i:items xmlns:i="http://www.mydn.co.uk/schema/boxcheck/list"> <i:item number="12345" /> <i:item number="12346" /> <i:item number="11223" /> </i:items> I also have a table which has a field called Id which contains, for now at least, the same values as the @number attribute in the above XML. All I wish to do is to extract the @number value from the XML above ...Show All

• Visual Studio Team System solution as the topLevel of

  I was wondering if i could create a pure 'folder' in team system version control in which to throw documents, schemas, workflows, etc. My current understanding is that you need to create an empty solution file, then a folder containing the documents underneath. -- is this correct is there way to do this w/o creating the solution file if not, i'm leaning toward using sharepoint for these sorts of items, which may be what the designers intended thanks! Hello, top level entities in the version control must be Team Projects. They are really croase grain and you want create a new one only if for new customer (if they are the top level dividers) you want to have new checkin notes, work item queries, another policies etc Under the t ...Show All

• SQL Server Date out of range?!

  Greetings! I have a data source that gets generated based on a variable with the following SQL : "select * from result where deletion_ind = 1 and when_deleted >= '" + (dt_str, 50, 1252) @[User::Last_Run_Date] + "'" But when I run my package I get an error message saying: The conversion of CHAR to DATETIME resulted in a DATETIME value out of range The Last_Run_Date variable is set to '2006-06-25 14:35:05.450' When I run the code in a QA session it works, but in the package it complains! What am I doing wrong Thanks for your help in advance. Hi Jamie, I am not quite sure how to use profiler for this problem. I have a data source coming from SQL Server 6.5. The data source i ...Show All

• .NET Development Communication between apps via sockets.

  I am trying to set up a communication channel between two Windows apps. Actually there should be 3 of them. One form is local, another form is located on the same machine, the third form is on a different PC connected via a LAN. My first attempt is to send a few strings of bytes from one form to the other locally. On the server side. This code is working : listenSocket = new Socket ( AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp ); int port = Convert.ToInt32 ( "19001" ); IPAddress hostIP = (Dns.Resolve ( IPAddress.Any.ToString ( ) )).AddressList[0]; IPEndPoint ep = new IPEndPoint ( hostIP, port ); listenSocket.Bind ( ep ); int backlog = 2; listenSocket.Listen ( backlog ); StateObjec ...Show All

• Windows Forms how to convert number to word format in crystal reports

  Hi i am rakesh ,i want to answer of above subject ...Show All

• Visual Studio Team System Merging Labels

  I have a label that touches several files in two different changesets. I want to use that label for a merge. The VS IDE gives me an error message "No items match $<path> in the label myLabel@$/<path >". So then I figured this could only be handled with the command line merge. I tried this: tf merge /recursive /version:LmyLabel /preview /noprompt $<frompath> $<topath> And it gives me essentially the same error. If I ask TFS about the label "myLabel," it gives me a nice description of the files that are in it. Then I decided to try the command line merge using a changeset spec that is synonimous with that label (e.g. C305~C306). This worked. So is the final conclusion that TFS can't ...Show All

• Visual C++ performance Comparison between C++, C# and COBOL

  Hi everyone, Currently our company is in the process of converting from a mainframe environment to PCs. As a pilot we took an application that processses about 5 million rows with about a record length of 7000 bytes the stats were amazing C# it took 3 minutes 17 seconds, C++ (native and not .net) 1 minute 28 seconds and believe it or not the COBOL program took only 45 seconds. The program has a simple read of a record, process few business rules and replace certain bytes in the string and write back to a new file. I expected C++ to perform better. does anyone has any idea why the COBOL program performed better than the C++ program. The data files were the same, the logic were the same, the machine it was executed was t ...Show All

• .NET Development starting winxp app before user loggs into winxp

  any idea on how i can start an app before the user actually logs in I have a number of computers that just sit there for about 10 minutes before the user actually logs in and throughout the day the users constantly log in and out. I need my app to stay running as is needs to keep a tcplistener connection open. i fixed my problem, which was i had code to run after i started my worker thread in the OnStart method. When i moved it all to the worker thread everything worked out fine. ...Show All

• SharePoint Products and Technologies what does the basic 30mb download provide

  when you install the 30mb download from the microsoft website for sharepoint services 3.0, what do you get on the interface Which download for WSS is only 30MB The one I found is around 78MB: http://www.microsoft.com/downloads/details.aspx familyid=D51730B5-48FC-4CA2-B454-8DC2CAF93951&displaylang=en ...Show All

• .NET Development Optimizing performance when enqueuing and dequeuing data

  In an application I have the need to enqueue data from one thread while simultaneously dequeuing it from another thread. I have already implemented it using the Collections::Queue class but I am experiencing performance problems, which I believe are caused by the constant allocation of memory on the managed heap (when enqueueing) and deallocation by the garbage collector (occasionally when dequeuing). I currently have around 1200 enqueues and dequeues per second (around 6 of each every 5 ms) but I sometimes see glitches of up to 20-30 milliseconds between enqueues (and that's with an asymmetric process - the dequeues are of lower priority than the enqueues). My current approach is as expected - I allocate an object, store data in it, an ...Show All