et381's Q&A profile

• SQL Server using DTS for reading Dynamic .CSV files from a Folder

  Hi All, I have a challenge i am trying to overcome, hopefully soneone would have come across this issue before.. I am creating a DTS package that will be scheduled to run at a certain time everyday. A source folder exists that get a set of new files everyday.The DTS Package will then read each file and copy the data into a load table in my database the challenge is this: I am trying to load files from a source folder into my load table, Within each file, the entires are in a specific format using pipes to seperate the data that goes into which column e.g example of a file entry: column1 | column2 | column3 data1 | data2 | data3 data1 | data2 | data3 data1 | data2 | data3 And now i am using DTS to ...Show All

• Visual Studio Team System Can I Add a Customized Field Type for Work Item?

  The following article decribes 8 field types for work item. http://msdn2.microsoft.com/en-us/library/ms194980.aspx Can I create a customized field type and register it in TFS Thks for you reply! Custom fields types will be available in SP1 of Team Foundation Server (a beta of whcih is due soon). See the following post from Brian Harry for more information:- http://blogs.msdn.com/bharry/archive/2006/06/15/632236.aspx Cheers, Martin. ...Show All

• Smart Device Development How To Define Global Variable?

  Hi, I want to define a global variable which can store information like Database Connection String and can be accessed accross all the forms and classes in my application. While loading the application, I would like to set this once and then use it throughout my application. How to do this Also, what is the use of Resources.resx and AssemblyInfo.cs files in the application Can they be of any use Regards, Suman I use structs for my defines and globals. Just declare a struct like this outside any existing class but still inside the namespace: public struct Global { public const int aDefine; public int aVar; } Then when you want to use that variable or define in any class you just write a line like this: Glo ...Show All

• Visual Basic Referring form objects

  Hi all, I'm converting a VB 6 exe project to a VB 2005 project. One main functionality in VB 6 that gives errors in VB 2005 project is as follows: In VB6, i have a initial form called frmApplication that loads up. There are two other forms Form1 and Form2. Based on the user settings, frmApplication then loads either Form1 or Form2. Form1 and Form2 differs only by appearance. What i mean, all the controls in both the forms are same including the name except there position of the control on the respective forms. When frmApplication is loaded, it creates a object of Form1 or Form2 depends on the setting and assigns to frmObject. Now in VB6, i access the controls in Form1 or Form2 in runtime using frmObject.lblName.Caption = ...Show All

• SQL Server Keep group rows together

  Hi, Is it possible to keep a group in a table report on the one page if this group could be fitted into the rest of the page and start new page otherwise Thanks, Igor This is taken from here http://www.microsoft.com/technet/prodtechnol/sql/2005/rsdesign.mspx Using Rectangles to Keep Objects Together Rectangles in Reporting Services can be used either as graphical elements or as containers of objects. As object containers, they keep objects together on a page and control how objects move and push each other. To keep multiple objects together on a page, put the objects within a rectangle. You can then put a page break before or after the rectangle by using the PageBreakAtStart or PageBreakAtEnd ...Show All

• .NET Development How to handle data in different tables?

  I was wondering if someone could point me to a tutorial that might help me I have an application that I'm developing that will display a tabbed form which needs to contain data from different tables. For example, my database has a contact table with typicall information and then it also has a lead table which contains information if the contact is a sales lead. They are linked together by a common contactID column. There are a few other normalized tables also like an AlternateAddress table. My first problem was that I could only get the binding source to connect to a particular table. This was a problem cause the data that I need to modify is normalized across a few different tables. My solution to that problem was to create a view ...Show All

• SQL Server BizTalk and SQL Server 2000

  We're running BizTalk 2004 on top of SQL Server 2000. Due to the fact that BizTalk uses Distributed Transactions BizTalk requires a customized backup solution that uses the BEGIN TRANSACTION ... WITH MARK syntax. How does the WITH MARK work We run a couple of very large transaction loads at various times during the week. These loads ran the BizTalkMsgBoxDb transaction log up to 18 Gig (the data file was only at 360 Meg). As the transaction log got bigger and bigger the server got slower and slower. Finally the custom backup job started erroring out on a memory error. Eventually the backup jobs stopped running due to an out of memory condition and then my users got locked out due to an out of memory condition. After I did some research (I ...Show All

• Visual Studio Express Editions Save As animated gif impossible?

  I am working on an image editing application and am on the final step, which is the user saves the 3 images they have edited as one animated gif. I have done a lot of web searches trying to find some code that will accomplish this, but have come up empty. Is it possible If so, how is it done On this line of code: Dim e As New AnimatedGifEncoder() I get this error: Type 'AnimatedGifEncoder' is not defined. On this line of code: Dim gifDecoder As New GifDecoder I get this error: Type 'GifDecoder' is not defined. On this line of code: Frame.Save(outputPath + Guid.NewGuid().ToString() + ".png", ImageFormat.Png) I get this error: 'ImageFormat' is not delared. Public Class Form1 Pri ...Show All

• Audio and Video Development Need some code samples (Fast Forward, Rew and other)

  Please, I need samples of JavaScript code (some strings) and some comments for following operations: Fast Forward Rew Go To Next Chapter Go To Previous Chapter P.S. I tried to use Player.playlist.fastForward(4); and seen JS error (iHDScript API fastForward: HDDVD_E_ARGUMENT) on this string. Why is "4" incorrect argument I think that 4 is: (normal speed) * 4. I mistaken For Player.playlist.stepForward(); I see following error: iHDScript API stepForward: HDDVD_E_NOTSUPPORTED P.P.S. Sorry, I known that my question is RTFM but I don't have specefication. :( 1) As per spec, speed::=[0-9]+("."[0-9]+) Sorry, I wanted to ask: Why the "Rew" speed ...Show All

• Visual Basic IDE, compiling, copy and paste, debug are all slow

  Any tips on what is making the project so slow. I have about 5 report server projects, and about 3 other projects. One for My Generation and another Base Class project with one form. My machine is a 2.0 Intel with 1 gig of ram. Some times hitting enter causes a huge delay or selecting a chunk of code (10 - 20 lines) and doing a ctrl-c causes a huge lag and then again when I do a paste. Trying to debug by step thru no longer lets me do edit and continue. I get the error "Cannot currently modify this text in the editor. It is read only" Compiling a 6 meg project after simple changes takes a minute or two to come up. Is it a sourcesafe issue References Mcafee Anti virus Thanks, Phil ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Installation with Visual C # 2005

  Hello all I tried to install the XNA Express but it asked me to have Visual C # 2005 Express. The problem is that I have the Visual Studio .NET 2005 installed in my PC. Is there a problem with that how i can Install it to Try It Battlekiller wrote: you will have to remove the C# part of visual study, then you can install the visual C# express edition, and then you can install XNA. This is what i had to do. You should not have to uninstall the C# portion from your existing Visual Studio 2005 install. C# Express and Visual Studio 2005 will live side-by-side with each other. ...Show All

• Visual FoxPro System resolution

  Hi. How can I find out what the system resolution is, and how can I change it via FoxPro Thanks Misiacik7 wrote: You mean the right way how to do that is to resize the form I tried, it works but if I want to run this form on 640X480 I have to degrease the font size of all of the controls some to value of 6. You do not say which version of VFP you are using, but you could always set the ScrollBars property of the form (if the version you are woking in is recent enough to have scrollable forms) to .T. Then, if someone prefers to have their screen resolution set to 640 x 480, you can still use a reasonable font size. Misiacik7 wrote: Please do not solve why to do that, if an ...Show All

• Visual Studio How to select particluar data from the database and how will i display it in crystal reports

  Hi I'm developing an application which has around 20 reports. I have created the reports using CRYSTAL REPORTS WITH VISUAL STUDIO. I know how to group reports and also has a vague idea about the selection formula. The client when he click on the report title from the DOT.NET Application, he should be able to see a search box like which further allows him to filter the data and display the reports according to his selection. For e.g : if the client need to see the projects details between the September and October, he will select the months from the drop down box. and when he click ENTER, it should display the reports containing the projects details from September till October. Can anyone tell me how to do it Please. ...Show All

• Visual Studio Team System Custom rule to validate the value of a string literal

  Hi, guys. I have methods that takes a string argument that is utlimately passed to String.Format. Stuff like "{0} has value {1}". I've written an FxCop rule that can ascertain when these methods are called but I'm stumped on how to actually extract the contents of the string literal in order to analyse its contents. Any clues It must be possible as Reflector.exe can display the strings. Guess I'm just missing the correct API. Whilst I'm at it, do you know of an existing rule to analyse a format string Kind regards, Angus ps. If there's a way to improve my "TraceMethodTakesStringFormatter" so that I don't have to do a string comparison on "System.String()", I'm all ears ;-) public override ...Show All

• Visual Studio Express Editions Using an animated GIF instead of busy cursor

  I am trying to use an animated gif in my form to indicate that it is in a busy state, but I am having trouble doing so. I first try adding an animated gif to a PictureBox and make it visible when the work is being done, like this... private void btn_ADOTest_Click( object sender, EventArgs e) { pb_Working.Visible = true; //My PictureBox containing an animated GIF - make it appear ... //Do some work here - in this case reading from and writing to an Access DB ... pb_Working.Visible = false; //Make the image disapper } The trouble here is that the animated gif does not animate. I then tried to put the animated gif on a different thread, but had no luck. Any ideas would be very helpful. Apologies i ...Show All