mfauziii's Q&A profile

• Visual Studio Team System Changing field type on a COPY?

  I am working on migrating data from our old bug tracking system into TFS. The id fields from our old system are alpha-numeric (e.g. "DEF999"). I would like to create a Company.ChangeRequest.Id string field which will hold the migrated id for old bugs, and the System.Id for new bugs, so that we only have to use one field when searching for bug by number. However, I cannot create a COPY rule which copies the System.Id into Company.ChangeRequest.Id, as the two are different types. Is there any way I can do this The purpose of the new field was to be a repository for ids of migrated defects (which people still think of by their old id, e.g. "DEF999") AND ids of new defects (System.Id). So MyC ...Show All

• SQL Server Get The Last Record by Grouping (SSIS with ORA)

  I have a view listing tickets and reports for those tickets. I want to query LAST REPORT's OPERATOR SELECT OPERATOR AS EXPR2, NUMBERPRGN, IS_BITIS AS EXPR1 FROM SCADMIN.V_ESKALASYON_2 WHERE (NUMBERPRGN = 'IM1289657') ORDER BY NUMBERPRGN, IS_BITIS DESC That query brings the resultset IM1289657 OGUZY 04.12.2006 14:01:09 IM1289657 MUJDEO 01.12.2006 10:42:30 IM1289657 MUJDEO 28.11.2006 10:58:22 IM1289657 ILKERD 20.11.2006 14:36:12 IM1289657 ILKERD 13.11.2006 16:02:27 IM1289657 ILKERD 07.11.2006 14:02:21 IM1289657 ILKERD 31.10.2006 15:47:56 IM1289657 SINANK 19.10.2006 13:00:00 IM1289657 OGUZY 18.10.2006 1 ...Show All

• .NET Development .net OLEDB provider for Access 2007 ?

  hi, How to access the New Access 2007 Database using OLEDB Providers in .net When tried with the the current OLEDB PROVIDER with .net framework 2.0 it does not work. thanks n regards. Barath Hmmm...looks like that's exactly what I need, except that it doesn't appear to be redistributable. (Lord, I searched everywhere for that, and couldn't find it.) Doesn't look like it will populate into VS 2005 as an available prerequisite for publishing. Ah well, this'll do for now! Thanks!! ...Show All

• Visual Studio Express Editions format function

  How can I format the data in textboxes (or Richtextboxes) to numeric (so they can be added together in the program) all at once, or is this possible Hi, you can use the Cint(expression) function to convert textbox.text values to integers, there are other conversion functions if you wish to have larger numbers. Dim result as Integer = Cint(textbox1.text) + Cint(textbox2.text) so on and so forth. ...Show All

• Visual C++ Drawing outside of the application window.

  Is it possible to draw patterns outside of application window I'm trying to make a partial screen capture, and befor the capturing I waht to give the user an abbility to select the region he wants to capture. How can I do it This feature is implemented in the CamStudio program: http://sourceforge.net/projects/camstudio/ ...Show All

• Visual Studio Express Editions Formatting and Advanced Binding Dialog Box

  How do I use this section to bind a textbox to a specific point in the database. The intent is to use a textbox to display and update a specific database value Wow, does anyone know the proper use of this binding. I set up boxes and when i go back viewing the result at run time they represent a figure 74.44 as 1. Is this binding (advanced) any use at all.. how is it used PLEASE. Shihan ...Show All

• SQL Server How do set send mail task?

  Hi There, I have a task to send mail when the source file contains null values against id column. I have set conditional split to split the null value rows to the different destination.Please help me how do i achieve this task when the source file contains null values against id column . Thanks in Advance. Hi Savera, The RowCount transformation uses a variable. This variable needs to be visible at the Data Flow Task scope and at the Control Flow scope, so make sure it is a package scoped variable. You create a package-scoped variable by right-clicking any unoccupied space in the Control Flow, and then selecting Variables. The variable has many configurable columns, but scope is not one of them - it is dete ...Show All

• SQL Server Hours/minutes in the Calendar date time prompt

  Is there any way to get teh date time prompt to display hours & minutes For example, if I default the field to '=Today', I would like to see '8/10/2006 9:04 AM' instead of '8/10/2006' Similarly, when I pick a date using the date picker control that is displayed by default, I would like it to also display the time, which I guess would default to 12:00 AM. Thanks in advance! Hi, I encountered the same situation once and this is what I did: in the report parameter --> default values, write the following expression =today().addseconds(1). This will display the data and time when you run the report. The only thing is that for the default value it will add 1 second. --Amde ...Show All

• Software Development for Windows Vista No audio - using USB TV tuner and ms video control.

  My development environment, OS: WinXP Professional (SP2) TV Tuner: PCTV Pro USB Direct show sample: Samples\C++\DirectShow\VideoControl\HTML\viewtv.htm Once after installing neccessary drivers, a new audio mixer device in the name of "PCTV usb2 2821 audio" installed under category "sound recording" of my system. After installation i ran the sample html page, but ms video control delivers video output without audio. I tried retrieving name & audio renderers device available in the system using below mentioned property and method of ms video control, got following output, #1. MSVidCtl.AudioRendererActive.Name - Output: audio renderer #2. MSVidCtl.AudioRenderersAvailable.Count - Output: 1 How to set audio render as "PCTV u ...Show All

• Visual Basic Updating Records

  Hi I am new to Vb.Net and so far things have been working ok except for the updat/insert command. It's been preventing my program from proceeding for 5 days now. I've tried different stuff but either the code is completley wrong or there is an error which is hard to find......... Can someone verify this code and let me know why the program wouldn't update the table Thanks... Here's the code Conn=New OleDbConnection(".............................") Comm=new OleDbCommand("Update tablename Set field1=' " & List1.SelectedIndex &" ' where glnx= ' " & (TxtGlnx.text) & ' "," conn) r= Comm.ExecuteNonQuery Conn.close() If the code is exactly as above.. lo ...Show All

• Visual Studio Team System Bug: Compare schema only able to transfer change in one direction

  I can only choose to transfer changes found in one direction. Other DB-tools, e g Red-gate, are able to transfer in both directions. You must add this functionality as well. Sometime you have 20 differences and you want to transfer 5 of them in one direction and 15 of them in the other direction. You should be able to change the arrow's direction. The default should of course be left-to-right as it is. Best regards Niklas Engfelt Niklas - Did you mean transfer in both directions with a single update As Gert noted, today, you can do this as a 2-step operation. If you have DatabaseA and DatabaseB, use A as the source and B as the target, select the updates you want B to receive and them write updat ...Show All

• .NET Development Debugging multithreaded code

  I love a lot of stuff about the VS2005 IDE, but what I don't get is why it is utterly useless for debugging multi threaded code. I've reinstalled my OS a few times now on this notebook, so the IDE has been installed a few times too. My WinForms app is multithreaded, and whenever I go into multithreaded code, breakpoints take ages to work, then the variables can no longer be viewed, and restarting just hangs the app. How is this possible I'm using the MS flagship product and debugging with message boxes !!! Not much different, here is a sample: ThreadStart pts = new ThreadStart (DoConnect); Thread thread = new Thread (pts); thread.Start(); The main difference is just that the method I call is in the same clas ...Show All

• SQL Server RS 2005: Subscription fails with Internal error

  Hi all, I have a (for me) strange problem with subscribing reports. I've setup several reports that I want to create monthly and store to a file share. In BIDS Preview and deployed to the report server everything works fine. Each of my reports has an own schedule (they'll be created step by step), export format is Excel, as credentials I use a local user, all parameters are set porperly. When the time to render the reports has gone, I just see the following behind each subscription: Failure writing file LIS04 : An internal error occurred on the report server. See the error log for more details. The Log file contains the following: (I highlighted what I think to be the key error) ReportingServicesService!library!4!12/19/2006-10:20:35 ...Show All

• Audio and Video Development Playing sounds from markup

  How would one go about playing sounds in markup Specifically, I want to trigger audio from a focused state without passing an event to script. I understand that I can create a wav object, but how is the object sent to Player.audio.effect in markup Thanks! Do you mean that if you have very fast animations (eg, move 1000px over 2 frames) it looks bad Well.... not much you can do there I am afraid. There's only 24 (or 50/60) frames per second to draw in. Make your duration longer or your distance shorter, or you *could* create a version of you graphic that was deliberatly "blurred" and use that so it looks like a smoother animation. ...Show All

• Visual C# How to retrieve value from key

  Hi all, I had a hashtable ht and I had added ht.Add("key1","value1"); May I know how to retrieve value1 based on key1 Thanks The next step is to grab all of the values in a hashtable. This should help. foreach(DictionaryEntry _d in ht) { MessageBox.Show(_d.Key + "-" + _d.Value); } ...Show All