MouleeswaranSwaminathan's Q&A profile

• SQL Server Type 1 Dimension Insert/Update

  Hi I'm trying to put together a integration package that loads in type 1 dimensional data. If the item is new then the data is inserted if it already exists then it is overwritten. My approach has been to use the lookup operator to match the source values against a generic mappings table. The data that is matched goes off into the error flow and is inserted as new rows in the dimension table. The matched lookup rows are sent through into an update operator. the problem comes when there are no new rows for the lookup operator to find it still want to do the inserts and so exits with an error code. I tried to change the data flow so that ...Show All

• SQL Server creating a database, tables, records, and fields in a Sql server 2005 express

  I am at my wits end as to how to do this. I have downloaded Sql server management Studio and tried to create a database but I can't figure it out. There is an almost nonexistant help file so I am lost as to how to start. I have succeeded in looking at some system databases but that is about the extent of it. Can someone show me the proper procedure Am I using the wrong tool Thanks, Paul If you are using the managment studio, right click on the Databases node, --> New Database. If you are using a script tool for this, the fastest way to create a database is CREATE DATABASE <name>, which stores the d ...Show All

• Windows Forms Order events are fired in form

  I don't know if I'm perhaps following bad coding practice, but here we go: I've got an application that is dynamically opening child forms. In the form_Load event for one of my forms, I am populating some combo boxes. That works beautifully. Here's where it gets interesting: The combo boxes have sorts and filters applied when they are loaded. All three combo boxes are related to each other. I would like to figure out a way to change the text showing in the other 2 combo boxes whenever a user selects (or types) something in one of the other two combo boxes. This would be done using a combobox.findString with a string based on a query to ...Show All

• Visual Basic Making a picturebox have a transparent background

  I have a picture of a panda with a pink background (panda_down.bmp) and I was wondering: how do I get that pink background to be transparent Draw the image yourself in a paint handler, and use the imageattributes class to make 255/0/255 ( magenta ) transparent. ...Show All

• Windows Forms Sluggish performance 2005 final release - Us or MS?

  We have a windows application, originally developed in VS 2003, now in VS 2005 final release, using Visual Basic.  It has become painfully sluggish to design in, though the speed when running the app is fine.  My PC is a Pentium 4, 2.5 ghz with one meg ram. I can not tell if the problem is with us and the way we designed the solution, or if it has something to do with Microsoft and Visual Studio as a whole.  I realize that you are capable of having a field day on my ignorance but hope you will resist the temptation. When opening the app it takes 3 minutes before we can actually get anything done. The Solution Explor ...Show All

• Windows Forms Sending an Image via web service

  Is it possible to convert an image to xml, and send it to a web service cheers. I've done this before.  Just convert the image into a binary array and send it as a parameter to a webservice, should work just fine. ...Show All

• Software Development for Windows Vista How to bring up Infopath form on a task of the workflow

  Hi, I want to know how to show an infopath form when a task is edited in a workflow. Please let me know what steps to follow to do the same. Regards, Ketaki Hi, I have sloved this problem. Regards, Ketaki ...Show All

• Visual Basic Books on Visual Basic 2005 (express edition)?

  Hi Guys, Can anyone recommend any GOOD books on Visual Basic 2005 (i got the express edition) I really wanna learn this. Also, sooner or later, I'd like to upgrade to the normal edition of Visual Basic 2005 or Visual Studio, which ever It's called. What's gained by doing this what all is included with the Studio program... I'm hope C++,C#, J, Basic, ect... anyhow... thanks! -Chuck K8CPA chuck, check out this book. http://msdn.microsoft.com/vbasic/learning/introtovb2005/ ...Show All

• Software Development for Windows Vista loading workflow from xoml file

  i save workflow in xoml file now when i load it back its loads fine but i had to cast it into prope type can any body give me better way of doing it ..... XmlReader xmlReader = XmlReader .Create( "seq.xoml" ); WorkflowMarkupSerializer serializer = new WorkflowMarkupSerializer (); seq. Workflow1 wf1 = (seq. Workflow1 )serializer.Deserialize(xmlReader); WorkflowInstance wfInstance = wfRuntime.CreateWorkflow(xmlReader); wfInstance.Start(); I mean simply using Activity type for wf1 not works .... If you are trying to deserialize a workflow from a XOML file you do the following: XmlReader xml ...Show All

• .NET Development SslStream and SSL protocol not recognized (i think)

  i wrote this simple apps to connect to an IRC server but it doesn't work :( using System; using System.Collections.Generic; using System.Text; using System.Net; using System.IO; using System.Net.Security; using System.Net.Sockets; using System.Security.Cryptography.X509Certificates; namespace provaSSL { class Program { static void Main( string [] args) { try { string certName = "" ; TcpClient sslClient = new TcpClient (); sslClient.Connect( "irc.discostars.de" , 7000); SslStream sslStream = new SslStream (sslClient.GetStream(), false , CertificateValidationCallback); ss ...Show All

• Smart Device Development mobile 5.0 native time events

  I have tried to the State and Notification broker TIME event (under HKLM\System\State\DateTime\) to try and launch an application at a given time and cannot get it to work. I also tried to just launch an app that displays a MessageBox every minute and could not get that to work either. Any suggestions Here is an example of what I was trying to do: --------------------------------- HRESULT hr; NOTIFICATIONCONDITION nc; nc.ctComparisonType = REG_CT_ANYCHANGE; nc.dwMask = 0xFFFFFFFF; nc.TargetValue.dw = 0; RegistryNotifyApp( SN_TIME_ROOT, SN_TIME_PATH, SN_TIME_VALUE, TEXT("CETIME"), TEXT(" \\Windows\\ca ...Show All

• SQL Server attribute date of type numeric to datetime...!

  hi everyone..!! how can I turn an attribute date of type numeric of a table and pass it to another table (using SSIS) as datetime Can you provide an example of what those 'dates' look like /Kenneth ...Show All

• Visual Studio Team System Issues with Windows Sharepoint Services while Installing TFS

  Hello All, I am installing TFS. while installing TFS we are geting following errors " Error 32000.The Commandline '"C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\60\Bin\Stsadm.exe" ...' returned non-zero value: -1. " and then doing everything what MS says we get this error. " Error 32000.The Commandline '"C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\60\Bin\Stsadm.exe" ...' returned non-zero value: -2130246864 " Can somebody please tell me what is this. I am so excited about using TFS as my Development environment. And we are not able to s ...Show All

• Visual C++ ::GetWindowLongPtr() and cast errors

  It seems that ::SetWindowLongPtr() and ::GetWindowLongPtr() are defined to just map to set/get window long in 32-bit windows. The problem with this is that, even though I use the correct casts and functions, I still get a warning from VC++ about possible loss of data (because I stuff a pointer into this field). Is there any way of writing code that calls ::SetWindowLongPtr() and ::GetWindowLongPtr() that doesn't issue this warning, without turning off the warning using command line options or #pragma warning You're probably gettings warnings because the casts won't work in 64-bit code. To disable: Project + Properties, Configuration ...Show All

• .NET Development hyperlink and insert value in datagrid

  need some help Q1>insert value in database by using datagrid control .in this grid i add checkbox using itemtemplate .now i want inserts values in db those are checked by clicking command button.if any one help me then plz. Q2>i bound datagrid uing dataset and using itemtemplate colume for hyperlink.now i want,after binding datagrid each row in grid act as hyperlink and when i click rows in datagrid it redirect in some page (eg. a.aspx).each redirect in different link how i do that plzz. help me (*urgent*) Hi, Questions regarding asp.net should be posted in forums.asp.net . You would have a higher chance on getting you ...Show All