Krishan Ariyawansa's Q&A profile

• Microsoft ISV Community Center Forums Color Index

  I want to use a custom color palette in Excel, by redefining some of the default colors. I'm trying to choose the colors in the default palette that most closely match the custom colors. Looking at colorindex 11 and 25, 5 and 32, and some others have the same RGB value. Does this mean that they are the same color And can I set my own default RGB value to duplicates with impunity Phineas The color is defined by the RGB values. If two different palette items (two different color index values) have the same RGB, then they are the same color. ColorIndex is merely a shorthand way to access the 56 colors in the Excel palette. You can red ...Show All

• SQL Server Dynamically Create Connection Managers @ Run time

  Is there a way to dynamically create a connection manager @ run time I would like to do this from a data set of connection strings so I can link them into a union all component. No. You cannot change package structure at run-time. You can dynamically read information in at run-time, so you can change your connection string for example. The best method is the build in Configuration support. You can also drive most properties through Expressions and supply a variable to set the property. Variables can be set in several ways, including other expressions and script tasks. To load data from multiple sources, ...Show All

• Windows Forms Windows XP development and Windows 2003 server development PLEASE PLEASE HELP HELP !!!!!!!!!!!!!!!

  Hi All this time I was developing in Windows XP and there were no problems. When I opend the project in the server  (W2003 server), my postbacks keep on being redirected into the login default.aspx page. This is driving me nuts. When I open the project in win XP machine NO PROBLEMO !! I did check the IIS configs on both machines. In both mach ...Show All

• Windows Forms custom controls

  I have 2 classes. myTextBox and myLabel. I am trying to implement this: when i drag myTextBox onto a Form I want it to have two labels next to it. i want the textbox to know of these labels and if the position of the textbox changes then the position of the label must change with it. All this must occur at design time in VS.&nb ...Show All

• .NET Development Strange connection string persistence issue

  I’m connecting to a MySQL database using a third party component (MySQLDirect).   The issue I’m having does not seem to be a bug in the third party component as no other users are reporting issues with it and they seem unable to help.   I would really appreciate if someone could give me some inspiration on how else I can think about tracking this issue down.   The weird issue is:   I have my MySQL database connection string in the app.config file.   I’m using the MySQLDirect components in a component designer using VB.Net 2005.   When I change the database name in the config file to another database, t ...Show All

• Visual Basic getting files from FTP

  Hey, I got a Windows application that processes Excel files and transfers all data to a DB. These Excel files at the moment are being sent to Malta from Germany via FTP........ the user copies the files to another location (as the FTP directory is not accessible) and then browses for them using an Open File Dialog.... the application then does the processing needed! I would like to automate this a bit more. 1. How can I access the FTP server (NOT anonymously!) 2. How can I check if the folder is empty 3. How do I retrieve files (preferably removing them from the FTP server and placing them in another location) Thanks for your help ...Show All

• Visual Basic VS 2005 seems unusable for large VB converted project. How do I turn off the background compiler.

  VS 2005 seems unusable for large VB converted project.  How do I turn off the background compiler. I have a fairly large project that I migrated from VB6 to VS2005.  This is the RTM version of VS2005.  There are many issues that I need to fix up in the code, but every time I change one line of code, my system runs 100% CPU for 30 seconds. This is not even close to usable.  You might think I have a slow machine, but I am running this in a P4 3.5 GHZ with 1GB of RAM, and a SATA 150 hard drive. I will be forced to abandon use of VS 2005 for this project unless I can find a work around for this issue. Please help! ...Show All

• Windows Forms listbox issues

  I've had a problem with listboxes not firing the SelectedIndexChanged event. I tracked this back to what appears to be a bug in the ListBox class, where the Clear operation simply does not fire the event, although Remove/RemoveAt do. Is there any chance for a fix for this in the near future. I can provide details on this if necessary. Thanks This is probably by design, but I would agree, for the sake of consistency the event should be raised. As a workaround, you could call the ListBox method ClearSelected before calling  Items.Clear . This is not perfect though because in your SelectedIndexCha ...Show All

• .NET Development DirectX BadImageFormatExceptions

  Hi all, i try to compile and run my solutions with Visual c# 2005 Express on Windows XP Pro 64bit. Which works fine on my Windows Xp Pro machine, but throws BadImageFormatExceptions on my 64bit OS. I tried DirectX and SDL .NET... it seems like the DLLs are not valid... cant find any help on MSDN or on the net. Please help me! Thanks, Marre From http://msdn.microsoft.com/directx/sdk/readmepage/default.aspx : There is no support for installing the DirectX 9.0 SDK on IA64 bit platforms. IIRC, this platform will be supported in November, when VS2005 is released. ...Show All

• SQL Server Upgrade from Sql 2000 Ent edition to Sql 2005 Std edtion

  Hi I am looking is it possible to Upgrade from Sql 2000 Ent edition to Sql 2005 Std edtion if yes is it standard upgrade\migration process or some trick involve and also what will happen to lic Appriciate any help Thanks Alps Can you show me where this is documented It's not in the link above. We were thinking that we were going to have to upgrade via backup and restore after uninstalling each instance so that we can keep the same instance names. I would like to know if that is not the case. We are going from SQL 2000 Enterprise to SQL 2005 Standard. ...Show All

• Windows Forms Installation location

  Hi, Can I change default installation location of application like “c:\myapp\”. What about creating application shortcut on desktop. For ClickOnce Installed Apps You can not change the install location A start --> program --> shortcut to your app will be created by ClickOnce but not desktop icon. -Thanks Sreekanth ...Show All

• SQL Server Using UniqueIdentifier as Primary key

  Hello, is it a good idea to set an UniqueIdentifier field as primary key why i can't set an indentity specification How can i do Thanks a lot You can only specify an identity attribute for fixed precision data types and always returns an integer based value (i.e. non-decimal). For example int, bigint, numeric, etc. As for if it's a good idea to use a uniqueidentifier as the primary key, that's always up for debate, but you definately can do it. It will be unique, so that's good, and not only is it unique in the table, but also globally unique. Depending on how you are indexing the given column, you will find that the ...Show All

• Visual C# how to write a correct regular expressions?

  how the regex should be written if i want to subsitude the value into it for example this is the regex i have.. (\\w\\d+ *Months) *( \\d+\\. \\d *) i want to replace the word Months with exactly a certain string, like string subsitude ="2Months"; then the regex would be something like this... (\\w\\d+ * subsitude ) *( \\d+\\. \\d *) wat is the proper way to write this Hi check your last Post http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=284501&SiteID=1 I have answered that hope that this will help you out. ...Show All

• Visual Studio Express Editions SQL Server Reporting Services

  Hi There http://msdn.microsoft.com/vstudio/products/compare/default.aspx    States that Express Editions supports - SQL Server Reporting Services........... I would like to Generate Reports using these Services.... How Do I Do It Thanks Cheers Bronco Billy "Beer and Fast Women are Ok... No Cigarettes or Hard Liquor Allowed Actually, the comparison chart shows that SQL Server Express is supported, but not reporting services. Visual Web Developer Express, however, does support SQL Server Reporting Services if you install the SQL Server Express add-in. For Windows development of reports ...Show All

• Visual C# Beginner

  hi all, I've just got myself into dot net (C#), do let me know the online resources available, for me to get acquainted with the technology.  Regards Arun Hi, The Visual C# Developer Center on MSDN is a great place to start exploring about C#. Take a look here: http://msdn.microsoft.com/vcsharp/programming/ Regards, Vikram ...Show All