laboremus's Q&A profile

• SQL Server Bulk Insert Task - Where Does The First Row Begin?

  Hi, I am using the Bulk Insert Task to bulk copy data from a flat file to a SQL Server 2005 table. The flat file contains pipe ( | ) delimited columns and several thousand records which are {CR}{LF} delimited. The file also contains a header record and trailer record, which contain several words but also contains a ( | ) symbol among those words. E.g.: HEDR | yadi yadi yada 500 | Data Data | More Data | 600 460 | Datum | More More | 705 550 | Data | Data | 603 FOOTR | yadi yadi yada I need to ignore the header and trailer records and just pickup the proper records. But even though I manually set the First Row property to 2 and the Last Row property to 4, It does not pickup the first true record i.e. the record which begins wit ...Show All

• Visual Studio 2008 (Pre-release) DLinq where parameter order

  Hi can anyone explain how DLinq determines the order that where clauses appear in the SQL that is generated. I was under the impression that the order in which clauses are placed can have a real effect on the speed at which records are filtered and returned. For example if I select a record that is mapped to another table and then take the IQueryable result and say .Where(x=>x.blah == blah) then the primary key of the second table appears to be placed after the where blah = blah in the SQL. Is there any way to control this order Thanks Steve You do not have any explicit control over how DLINQ presents SQL to the server, some re-arranging is done during translation. The query translator is not designed ...Show All

• Visual Studio Express Editions Read some text

  Hello guys .. I am making a kind of calender/note/remember ting. I want to place a date in the top of the my text i wright in my richtextbox. Thats not the problem, the problem is that it is adding an date every time i save it. My.Computer.FileSystem.WriteAllText(path & "Calender", "To the:" & datepicker.Text & Environment.NewLine & hehe12.Text, False) It will look like To the: XX-XX-XXXX So what i want to do is to make it read the first few charterers so that if it finds fx "to the:" in the first line it will not apply the date - i have tried with the steamreader, but i just cant figure out how to make it only read the first part of the text. No sorry you got ...Show All

• .NET Development Session across different web sites

  Hi, I'm trying to create a shared session across 2 different web sites/application. How can i retrieve the session (details) from the first application, and then replace it with the session of the second application I'm using state server to store my session details. Regards Danny Dear Danny, In order to share Session across 2 different web applications, you have to store session state in an ASP.NET application with out-of-process method, When you use this option, session state is stored in the Aspnet_state.exe process; this process runs as a service and may be located on a separate state server. Using a state server allows applications running in a Web farm to access shared state inform ...Show All

• Windows Forms unable to install wsus

  When I tried to install wsus. I got an error and unable to continue. part of the log file as follow: 2005-08-02 08:12:00  Error     MWUSSetup          InstallMSUS failed (Error 0x80070641: The Windows Installer service could not be accessed.  Contact your support personnel to verify that the Windows Installer service is properly registered.) 2005-08-02 08:12:00  Error     MWUSSetup          MWUS installation failed (Error 0x80070641: The Windows Installer service could not be accessed.  Contact your support personnel to verify that the Windows Installer service is properly registered.) 2005-0 ...Show All

• Visual C# Count the files in a directory?

  Is there a way to count the number of files in a specified directory Thanks, Why not ;-) Try this: int fileCount = System.IO.Directory.GetFiles(directoryPath).Length; // 1 Level int fileCount = System.IO.Directory.GetFiles(directoryPath, "*.*").Length; // 1 Level but with a Search Pattern int fileCount = System.IO.Directory.GetFiles(directoryPath, "*.*", SearchOption.AllDirectories).Length; // Include all inner Directories too with a Search Pattern int fileCount = System.IO.Directory.GetFiles(directoryPath, "*.*", SearchOption.TopDirectoryOnly).Length; // 1 Level with only top level Directory with a Search Pattern (Same as Second Command) I hope it'll help you ;-) ...Show All

• Visual Basic serialport regex match

  Sometimes I feel so stupid. I am trying to import data from the serial port to my computer. The data will be coming from an alarm system via COM1. What I want to do is, as the data is coming in, capture a line with the word "ALARM" in it and write some text after that word to a textbox. Below is the simple code I am trying to use. If I pull the data in using textbox1.appendtext(serialport1.readexisting), it pulls all the data in fine. But, using the code below, I get the results: ** ***** ** ***** ** ***** ** ***** ** ***** Imports System.Text.RegularExpressions Public Class Form1 Dim strIncoming As String = "" Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Try Se ...Show All

• SQL Server SSIS data Convertion ??

  Hello all Ho can i convert Integer to String in SSIS Derived column. Thanks in Advance Raj Lakamana MoonRiver000 wrote: When using 'Data Convertion' between 'Source table' and 'Destination table' by SSIS. Some data could not be transfered to 'Int' or char(1) from Varchar(200). In fact, 98% of them should be int or char(1) or null. I tried to 'redirect row' the rest 5% to a wrong table. However, all data went to the wrong table during 'Data Convertion' and nothing went to the destination table. I checked the ErrorCode is : 0xC020907F -1071607681 DTS_E_TXDATACONVERTSTATIC _CANTCONVERTVALUE The data value cannot be converted for reasons other than sign mismatch or data ...Show All

• SQL Server Variable Mapping and Resultset Questions

  I'm just getting started with SSIS and have a couple basic questions. I have a Foreach Loop that iterates over a collection of database names. The collection must include only database names that match a substring. I haven't found a way to filter the SMO Enumerator collection so, instead, I feed the resultset of an Execute SQL Task into the Foreach Variable Enumerator.  Of course this variable (oDBnames) is object type so in Foreach Variable Mapping a string variable (sDBname) is mapped to the only value in the collection (database name). Now sDBname should be available for an Execute SQL Task inside the container. But I keep getting the following errors: Error: 0xC001 ...Show All

• Visual Studio Express Editions Visual C++ 2005 express edition SDK info needed.

  I've just downloaded the visual C++ 2005 express edition. The downloads say I needed to also download the Platform Software Development Kit for Windows Server 2003 SP1, so I did. My question is when I run the PSDK-FULL.exe it asks me where I want to extract the files to...before I did this I wanted to know if all its going to do is extract like a regular RAR, meaning once extracted there will be another exe to install it, or will do I have to extract it to were its going permanently If I have to extract it to a specific place please let me know, as I don't want to waste my time. Any info would be appreciated! Thanks in advance. Have a look at the following link, it will take you to a site that ...Show All

• Software Development for Windows Vista Is July CTP working on XP Pro?

  Mybe not, my installation ran into no error(XP Pro+WinFX+WWF +VS 2005 Extension) But when I tried to follow the first sequential workflow example of the "virtual labs", there were only 7 activities in the toolbox namely: "Compensate", "FaultHandler", "Suspend", "SynchronizationScope", "Terminate", "Throw" and "TransactionScope".  The "Code" activity is nowhere to be found.  In the screenshot inside the virtuallab manual, there were tens of activities we can choose from. What could I've missed Thanks for the information.   Thanks Serge, you reminded me a problem one of my friend ran into and how he fixed it. I followed the steps on this page: http://aspa ...Show All

• .NET Development reading file size, date, name from the internet

  i'm using ftp to transfer all of my html, asp file to the server. Now what i would like to do is to write an asp file using vbscript or aspx or vb.net to have a webpage that basically read all of the file in that directory and give me the name, size, date of each file like this Name size date file1 7kb 07/25/2006 file2........................................................... coudl anyone help me with this ty is this not the similar question to your previous thread Well this is easily done again in ASP.NET assuming if the files are local then you just use the same methods I described in your previous thread: http://forums.microsoft.com/MSDN/ShowPost.a ...Show All

• Visual C++ "archive member will be inaccessible".. but it is accessible!

  Hi All! I have a header managedobject.h containing among others this class template: template< class tManagedObject > class DeletedAtShutDown { typedef ManagedPointerAdapter<tManagedObject> mt_Adapter; public: DeletedAtShutDown(); protected: virtual ~DeletedAtShutDown(); private: mt_Adapter* m_pAdapter; }; #include "managedobject.cpp" this is part of managedobject.cpp with the implementation: template< class tManagedObject > DeletedAtShutDown<tManagedObject>::DeletedAtShutDown() { //... } template< class tManagedObject > DeletedAtShutDown<tManagedObject>::~DeletedAtShutDown() { //... } This gets compiled into a static library, resulting in this warning: warning L ...Show All

• Windows Forms combobox question

  Hi I want to display in my combobox data from two columns in my database. If ComboBox1.SelectedValue.ToString = "100015" Then ComboBox1.DataSource = New DataView(MaintenanceDatabaseDataSet.RDTable) End If ComboBox1.DisplayMember = "Machine name" ComboBox1.ValueMember = "Machine Number" should i change something in displaymember I usually add a data column which uses an expression to my data table to show more than one column at a time in a combobox. Imports System.Data.SqlClient Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim strConn As S ...Show All

• Smart Device Development OS does not support encryption error

  Hi All, Iam using HP iPAq hw6500 series PDA. My application in installed in the PDA and when i try to open the application by taping on the application icon, Iam getting the following error. Can anyone help to figure out the possible reason for this error Error: 0x80004005 E_FAIL Native Error: (25080) Description: The operating system does not support encryption. [,,,,,] Interface defining error: IID_IDBInitialize Param. 0: 0 Param. 1: 0 Param. 2: 0 Param. 3: Param. 4: Param. 5: Thanks & Regards Rajeev Hi , This forum is primarily monitored by Visual Studio for devices group. Please check this link for more appropriate forums for this type of queries. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=2 ...Show All