imdqa's Q&A profile

• SQL Server Configuration Packages are still in Beta

  I would just like to give my feedback on the configuration packages implementation in SSIS: THIS STUFF SHOULD BE A NO BRAINER AS IT IS A COMMON REQUIREMENT ON ETL PROJECTS. I have trolled through these forums and found that I am not alone on this issue. Note for SSIS Team: Please bring out a HOWTO on this subject that details all the little work arounds because intuitively used it does not work. Consider this: I develop in BIDS on my client and everything runs. I create a config package and I choose only the Name and ConnectionString Properties for each Connection Manager. (Thanks to Jamie for that tip) I build the app and a deployment utility is created. I navigate to the deployment directory, and deploy. I point to a mapp ...Show All

• Visual Studio Tools for Office Dynamic SmartTag-actions

  Hi, we are currently developing an addin for word which makes use of SmartTags. Works fine so far. The problem is that according to the text being recognized there is a variable number of actions and we have found no way so far to create the actions dynamically... Any suggestions See if this blog article provides the information you're looking for http://blogs.msdn.com/eric_carter/archive/2005/06/10/423957.aspx ...Show All

• Windows Forms Disable Datagridview editing

  when the grid is shown i disable the binding navigators add & delete buttons when selecting a row from the grid the binding navigators buttons; the add & delete buttons are enabled I disabled all the editing properties of the datagridview Why is the add & delete button of the binding navigator reenabled when clicking on a row in the datagridview Hi, Rocky82 The BindingNavigator always resets the state as a result of a ListChanged event from the BindingSource. What you are seeing is the BindingNavigator is trying to set the Add or Delete button state based on the current state of the list - and this is happening after you've set the state, so if the bindingsource is allow to add or ...Show All

• Visual Studio a lot of errors

  Hi We have a vss 6.0 database, using vss 2005 client. We had some problems yesterday and did an analyze fixing the problems. a second analyze was reporting zero errors. Today we have some problem when getting a label from the commandline, it only gets the folder-structure, but not the files. trying a little back and forward without actually fixing anything it suddenly works. But the get reports a lot of errors like this File "$/13.0x/libs/comutil" not found comutil is a project and not a file, but it gets all the files below comutil. Why Doing another analyze reveals a lot of error again like these:   The file 'App.ico' (YJPBAAAA) lists 'fwfeaaaa' as a branch, but that file is missing or corrupted or ...Show All

• Visual C# text + image + text save to database

  Dear All How can i save text + image + text to database using one field. e.g hello world and how are you folks. if there is no that like data type then please tell what trick i should have to play. Thanks Hi There is no dataytpe for this in SQL or Access, you will have to save your information in different columns in the database. When you retrive the information you will have to work out the logic in your code to display the text and images combined. Hope this helps. ...Show All

• Windows Forms Using Windows Forms for an intranet application

  Hi all I have to develop an intranet database application for my final project and I'm thinking of using the .NET technology. But I have limited knowledge in this and I am more familiar with Java. So my question is should I use Windows Forms or ASP.NET Which will be more easier to work on an intranet and faster to develop It also involves some parts that require right-to-left language when displaying data and generating reports. Any existing application frameworks out there that can help me jumpstart Thanks :) Hi, The difference between WinForm and WebForm is that WinForm will be compiled as an .exe file and a WebForm will be compiled to a .dll together with .aspx pages. The WebForm needs to be ho ...Show All

• Windows Forms Check if Component is Unique

  How can I give a component the functionality to check itselfe if there is the same ComponentType on a Form or UserControl Try this: Declare one of the methods above in your class, in the load event of a new object of your Component/UserControl, check if the control will be unique or not, if not, through an Exception with a descriptive method. I think that for most user controls and components, Load event will be fired at design time and if the constructor throws an exception, a message will be displayed! The constructor is not the right place to do this! I tried the following in a user control in the load event and it works fine (it displays a message wi ...Show All

• SQL Server Date formats in SSIS

  Hi once again guys, I seem to be struggling with everything in SSIS these days! I have a datetime field and I want to convert it to the following format in my derived column component : yyyy.mm.dd I also have another datetime field but this time I am only interested in the time values and I want to get : HH:MM How do I go about doing this in the SSIS expression builder Please help. You have to surround your conditional statements with parenthesis and then concatenate them with the "+" symbol: (LEN((dt_str,2,1252)DATEPART("mi",btg_opty_start_datetime)) == 1 "0" + (dt_str,2,1252)DATEPART("mi",btg_opty_start_datetime) : (dt_str,2,1252)DATEPART("mi", ...Show All

• Visual C# Rounding a number to a number divisable by 5.

  Hi all, I have an application that will store the time where the minutes need to be stored in increments of 5 (0, 5, 10 , 15 etc). What I want to do is to get the current time, then round this to its nearest number divisable by 5. So if 9 was the returned minute from DateTime.Now (minute) then this should be rounded to 10. Is there anyway of doing this Thanks Tryst How about this: public static int RoundToNearestFive( int num) {     num += 2;     return num - (num % 5); } I think that does what you require. Here's what it does for numbers 0 to 20: 0: 0 1: 0 2: 0 3: 5 4: 5 5: 5 6: 5 7: 5 8: 10 9: 10 10: 10 11: 10 12: 10 13: 15 14: 15 15: 15 16: 15 17: 15 18: 20 19: 20 20: ...Show All

• SQL Server sql server 2000

  I am able to connect to SQL Server located on the Remote System through TCP/IP Programming Now I want to access that Remote Database and retrieve the Records.. How can I do it Which client tool are you using If you can connect to the server, you can change the database and Select from the appropiate tables. Thats all. Depending on your client tool that can achieved in various ways. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual C++ RESOLVED: Mangling Simplified Chinese in a ComboBox

  I have an urgent problem on my hands. I looked through the old posts but found nothing. When I build a list of names (WCHAR) in a ComboBox that include Simplified Chinese, the drop-down displays the chinese correctly. However when I select an item containing the said characters it displays for the first characters, although the codes per each character in debug show the correct value. Writing the string on CBN_SELENDOK to a static text control yields the expected result (with some font tweaking though). Writing it to an edit box or a list box yet again shows the . I am working in VC++ 6.0 Win32. Anyone encountered something similar Any input is greatly appreciated. The file we received from the Chinese ...Show All

• SQL Server Open encryption key in stored procedure

  Hi, I would like to create a stored procedure, which accept RunAsUser, MasterKeyPassword and also ASymmetricKeyPassword. In this stored procedure, it call OPEN MASTER KEY and etc. I put these code in stored procedure so that my support staff can call it when doing maintenance by passing the parameter. I don't expect them to remember OPEN MASTER KEY and etc syntax. However, I hit error "Invalid Syntax" when I run my code as below. Any ideas Thank you -- ================================================ -- Template generated from Template Explorer using: -- Create Procedure (New Menu).SQL -- -- Use the Specify Values for Template Parameters -- command (Ctrl-Shift-M) to fill in the parameter -- values below. -- -- This block of comm ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Content Pipeline code official mesh management

  Hi, I've just browse the code of the Spacewar starter kit and on the SimpleMeshRenderer class, the comment says: /// <summary> /// Workaround class until the content pipeline code handles meshes officially /// </summary> public class SimpleMeshRenderer : IDisposable { ... } What is this related to Thanks http://blogs.msdn.com/xna/archive/2006/08/29/730168.aspx and http://blogs.msdn.com/shawnhar/ have information about the Content Pipeline. It wasn't finished in time to be included in the beta, but will be part of the final product. ...Show All

• Visual C# Best material explaining events and delegates.

  Hi all, I have been developing .NET applications for over 2 years now, and yet I still cant get my head around events and delegates, and how they work. Every now and then I read up on them but still cant grasp it. I really don't know what I am missing. I have read the events chapter from the following book (which does explain it well), but I still cant get my head around it... Book: Pro C# 2005 and the .NET 2.0 Platform So, I thought I'd ask you lot if you know of any online resources, or even MSDN webcasts (I find I learn alot from these) that will help me to fully understand events and delegates. Thanks in advance. Tryst Hi Tryst, I also read that book, I thought it did a good job of explaining the topic, is there something in ...Show All

• Software Development for Windows Vista A Few Notes About Running VirtualPC To Virtualize Vista On Vista

  First, VirtualPC warns that Vista is a bad operating system upon which to run VirtualPC. That's not entirely true. VirtualPC works pretty okay on Vista except for some "issues" revolving around the new software that drives what shows up on the display(s) in front of you. These can be worked around. Second, Vista's installation procedure is maddeningly obtuse in that it gets to a point after you have laboriously entered the Product Key and waited for hours only to find that you have not made its bed comfortable enough: too few feathers in the pillow, a spring that is sticking it in the back. It's solution is for you to make the adjustments and start the installation over FROM THE BEGINNING. Balderdash! (It doesn't like being hande ...Show All