iliketoeaticecream's Q&A profile

• SQL Server Data flow task multiple destinations

  Hi, The further i get with doing my current SSIS package the more i am starting to wonder about best practices and performance. My current package loops through CSV files in a specified location and extracts events from these files. Each file contains multiple events which are a mixture of different types. Depending on the event there are a different number of comma seperated values. In the package i firstly set each event to one column seperated by a comma delimeter. I then create an array for the event which is split by the delimeter. In a script i weed out all elements of the array that are common to all events and set the remaining events to another array. After some processing i come to my conditional split transformation which splits ...Show All

• SQL Server 1 million insert stored procedure or 1 million insert statements?

  I have a SQL statement that generates 1 million stored procedure calls (this sproc has the insert statement into tableA), on the other hand, i generated 1 million sql insert statements to insert into tableA, which method would be faster if i choose to run them in batches of say 1000 each Thanh: When you say "... generates 1 million stored procedures calls ...", how is that being done How are you generating these calls Dave ...Show All

• Visual Basic How Do I Print a Text File directly form a Button

  After hours wated I found out that the my.computer.printer.default printer has been rendered obsolete by microsoft. How can I print a Text File ; let's say : c:\MyTextFile.txt. ' I know this code does not work; but that's the idea i want to implement Private Sub Button7_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button7.Click Mytextfile.txt.print End Sub Thanks, Fernando Pena www.Latinsoft.net Im not sure rendered obsolete is an good description.   It was never actually in any production release version of the product.   It did make an appearance in some CTP/ Beta versions of the product but there were issues which caused problem ...Show All

• Visual Basic Regular Expression help needed...

  Is it possible to just capture the text before the (<number>) i tried few combination, but nothing works. for ex the following is the string : test string here (123456), test2 string here (987654), test3 string (2093849) I need to capture those maroon bold texts like : "test string here" and then "test2 string here" and "test3 string", ignoring the items inside brackets. \(( <number>[0-9]+)\)\, The above expression gets me the stuff within brackets. but I need to get the text as i mentioned above... thanks in adv. rgds If you changed from c# to vb, you might check that you update the strings. Unlike c#, vb does not do any escaping in st ...Show All

• Visual C# How to catch Exception that throw by timer

  I have a WinForm application and a timer inside. The timer will throw an Exception while event Elapsed. How can I catch this Exception in WinForm One thing that may be of help is to use the WinForms timer rather than the Timers timer or Threading timer. As memory serves, System.Windows.Forms.Timer raises its Tick event on the UI thread of the Form. There are two other Timer classes in the .NET Framework with different behaviors, one of which does in fact execute on the threadpool thread and unhandled exceptions on threadpool threads are as mentioned deadly. Anyway, the significance of using the Forms Timer is that when it throws an exception that goes unhandled it should bubble up to the System.Windows.Forms.Application.T ...Show All

• SQL Server Reissue restore statement

  I am trying to restore a database but i keep getting an eror message saying "reissue restore statement using with replace to overwrite existing files." How can I get around this problem to get my datatabsed restored I am abit of a novice as well so i could do with some easy to understand instructions. Thank you for your time Cheers for the help scott. Do i need to type that into a query Also this bithere RESTORE DATABASE MyDb FROM <insert info here> is this the destination of my backup for example mydocuments/testdb ...Show All

• Visual C# Copy/Reset btnClick

  I have a button that i have labeled Copy/Reset....I also have two bool flags...what i need this button to do when i click the button the first time i want it to copy textBox1.text to textbox2.text....and set my first bool flag to true...now since the bool flag is true when i click it the 2nd time it checks for this true value and reset the text in textbox2.text to it orignal object....this is how i got it right now i just dont know how to set up the boolean varibles for this too work...can anyone help me... when i click the button the first time it goes through all the lines of code when only I want it to sway the text then set the flag to true...when i click the same button the flag will be true and reset it back to the orignal object. ...Show All

• Visual Studio Express Editions which form event to use?

  Hi, I want to add a fading effect to the form before exit. What i did is i put a timer onto the form, set it to disable initially, after the user click the exit button on the top right coner of the form, it will be switched on to "enabled", and the effect code will be executed. But i don't know where to put this code (under which form event ), I have tried to put it under "form1_formclosing", but it didn't help. Can any one help thanks Answer provided in this thread . ...Show All

• Visual Studio Team System Work Item customization - How to authorize single TRANSITION for multile Groups like "Contributors", "Project Administrator"

  Once we defined Workflow Transitions in TFS like for e.g.: Consider the Workflow for Work Item Type “Task” New -> Assigned Assigned -> Resolved We specify the authorization for role that Transitions i.e. who (Login User) is going to complete this transition. That we can specify using XML tag mentioned below (Refer Line No. 1). Now the Problem here is that we can specify only one Group like "[project]\Contributors" or "[project]\Project Administrator" etc for each transition. Once we specify one group, the other users which are belonging to different group (other then this GP) will not be allowed to save this work Item because of Transistion authorization. Now if we add here “[project] Project Man ...Show All

• .NET Development XML and IO exception

  Hi : i have been developing a smartphone 2003 application on VS2005. I want to save the user settings in an XML file. I have used the code below : Dim XMLDataset As DataSet XMLDataset = New DataSet() XMLDataset.ReadXml( "..\Storage\Program Files\ohmled-2\secenekler.xml" ) But when i run it i get an "IO exception" and thats all. The document is not open when i am running the code and the property of the XML file is "system" Thanks for your helps Best Regards Could you try to provide XmlReader to DataSet's ReadXml method. And also check if your program has rights to read that file by opening it with a text reader and just reading the document. Thanks, Sinan ...Show All

• Visual Studio Express Editions need help displaying array values

  i have 150 values in an array and i want to display them in order of the highest first and the lowest last. i have no idea how to do this. Help will be appreciated. thanking in advance oli Have a look at the following which puts 150 random numbers into an array and then outputs them to a textbox in descending order. Dim A(150) As Integer Dim R As New Random For count As Integer = 0 To 149 A(count) = R.Next(0, 1000) Next Array.Sort(A) For count As Integer = 149 To 0 Step -1 TextBox1.AppendText(A(count).ToString & vbCrLf) Next ...Show All

• Visual Studio Express Editions Shutdown

  I am using this code in my applcation to shutdown my computer: Shell( "shutdown /s /t 0" ) I found that you cna change the message on the shutdown window by putting: c/"Message" but when i try this it doesn't shutdown. How can i incorporate it into the code thanks for your help everyone. Shell( "shutdown -s -t 05 -c """"Bye"""" -f" ) worked for me. Thanks Tall Dude. ...Show All

• Visual Studio ToolBox Items disappearing when deploy Example Components

  I was create setup proyect for each one Example.DesignerCustomizations in DSLTools, to know Example.ClassDiagrams Example.Components Example.TaskFlow Example.UseCases When I run setup for each one all it’s good, except for the Example.Components, that the ToolBox Items disappearing when I creating a new cmtp diagram. I don’t use exp hive, in exp hive all it’s good.   Any idea about it Thank you so much. It seems that the problem has resolved changed the name on DSL Explorer -> Editor -> Toolbox Tabs, the toolbox component to componentssss for example. It make that the toolbox not coinciding whit Components toolbox of .net toolbox (Pointer, backgroundworker, Eventlog.... all this controls on it) ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DrawableGameComponent: GraphicsDevice

  i could be being really dumb, however i have a DrawableGameComponent and i try to access the GraphicsDevice but i get not an instance of object error any help guys if somone has written a basic drawablegamecomponent if u could post it would be ace i work well from examples when im stuck :) thx Yes multiple sprite batches is inefficient - well unless you only need a total of 5 sprite batches for your particular game, in which case don't worry about it. You could make a spritebatch in your game class and set it as a property on your component - then call batch.begin/end eitehr side of the base.Draw() in Game.Draw(). That starts sounding a bit of a hack job though. In general I would think that one batch per compone ...Show All

• .NET Development Convert image to pure Black and white

  I want to convert a tif or jpg file into pure black and white after searching in internet, I find a way to convert a picture to gray scale http://www.bobpowell.net/grayscale.htm but could I modified it to convert to black and white I have no idea about anyone could me THX If you mean only the colours black and white, you can use the same code as the guy does in the article, but instead of: Color.FromArgb(luma, luma, luma) Just have something like: luma > 0.5 Colors.White : Colors.Black i.e. if the luminance is greater than 0.5 make it white, else make it black. ...Show All