avinash kundal's Q&A profile
SQL Server HowTo: read/write package level variables in custom task
Hello all, I have been struggling trying to read and/or write package level variables from within my custom task. I'd like to be able to get and set values from within the Execute method of my custom task. I have searched this forum and the books online and can't seem to find the answer. I thought maybe I could use an expression on my task (mapping the package variable to a custom task public property) but that doesn't seem to be working for me. I also would have thought I could use the VariableDispenser object from within my task but the collection is empty. I have 3 package level variables configured and can't seem to find a way to access them (with intentions of getting/setting). Cou ...Show All
Windows Live Developer Forums major problem with the map.ReSize method - huge amounts of ram are consumed - hundreds of megabytes.
I have a major problem with the map.ReSize method. When I call map.resize IE 7 just sits and consumes mega amounts of ram (100's of megabytes + counting) and becomes unresponsive. The code below shows this problem, just enter a new size and click resize button Can anyone else replicate this chris <html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <script src=" http://dev.virtualearth.net/mapcontrol/v4/mapcontrol.js"></script > <script> var map = null; function GetMap() { var DefaultZoom = 5; var DefaultLat = "-33"; var DefaultLng = "140"; map = new VEMap('MapContainer'); map.LoadMap(new VELatLong(DefaultLat, DefaultLng), Defa ...Show All
SQL Server How to hold report generation till "View Report" is clicked ?
I have a report, for which I have defined queried multi-valued default values for all the parameters.Now when I click on the report, it picks the default values automatically without clicking the “View Report” button. Can we control this feature,so that unless user clicks on the “View Report” button, the report is not generated The only way to get this behavior is to put a parameter on the report which is not nullable and has no default value. The viewer control will require the user select a value for this parameter before executing the report. Another option is to not use the built-in UI, and instead use the viewer control in your application. ...Show All
Windows Forms binding 2 xml files to one DataGridView?
Greetings, [C#] I have a DataGridView that I need to load key values from two XML (resx) files both with the same layout & keys... the DataGridView has 4 columns (Name, Value, Comment & DataX). The Name, Value & Comments are taken from one xml file & the DataX is taken from the 'Value' key in the other xml file. I can't seem to get them to load, I get "Column 'Name' is constrained to be unique. Value 'FirstName' is already present." Do I need to do an inner foreach loop private void BindResXtoDataGridView() { XmlDocument doc = GetXmlDocument(); // loads xmldata.xml XmlDocument docX = GetXmlDocu ...Show All
Visual Studio Express Editions turn off button highlight
how can i turn off the button light when the mouse enters.I have a flat style button with an icon for picture i don't want it to highlight when the mouse enters it. Thanks If you expand the FlatAppearance entry in the button properties window you will see an entry for MouseOverBackColor. If you change this to be the same as the buttons BackColor then it won't "light up" when the mouse passes over it. ...Show All
Windows Forms Programmatically editing rows in bound DataGridView
I have a DataGridView which I have bound to a datasource. bindSource = new BindingSource(); bindSource.DataSource = eventList; bindSource.DataMember = "Events"; eventsGrid.AutoGenerateColumns = false; eventsGrid.DataSource = bindSource; The user can enter data only through a form, which is displayed as a modal dialog. After he fills it in and clicks OK, the data he entered should be added to the DGV as a new row. eventsGrid.EditMode = DataGridViewEditMode.EditProgrammatically; eventsGrid.BeginEdit(false); eventList.Events.Add(tempEvent); this.BindingContext[eventsGrid.DataSource].EndCurrentEdit(); The problem is that when I do this, I get the following error message : "Operation ...Show All
Microsoft ISV Community Center Forums Compatibility Issue Excel 2000 and Excel 2003
I wrote a macros for a customer in Excel 2003. He didn't tell me he used Excel 2000 until after the project and like an idiot I forgot to ask. The macros will not run on his version of Excel 2000. A compile error shows up. So he got a version of Excel 2003 and the macros will still not work for him. I have tested this macros on other machines using 2003 and they all work correctly for me. I live in the US and the customer lives in the UK. When he runs the macros it immediately goes into the debugging window and highlights a bit of code that simply references the path of the existing folder to a variable. The exact code is: DestFolder = ThisWorkbook.Path & "\" There is a compile error with a message that the data fold ...Show All
SQL Server Differing results on identical systems.
I have a staging environment and a developement environment set up on the same machine. Both environments consist of two databases, a staging area and a data warehouse. On the staging system when I run a query of the form: select count(*) from [StagingArea].[dbo].[saTable] join [DataWarehouse].[dbo].[dwView] on saTable.col = dwView.col join [DataWarehouse].[dbo].[dwTable1] on dwTable1.col = dwView.col join [DataWarehouse].[dbo].[dwTable2] on (dwTable1.col = dwTable2.col AND dwTable2.col = saTable.col) I get an answer returned in 2 seconds. When I run the same query on the developement system it never comes back with an answer (after 3+ hours). The data in both systems is identical. But it would appear that the query optimizer i ...Show All
SQL Server Calculated Members and Aggregation
Hi, I am still in AS 2000 and would like to know if it is possible to have calculations performed at lowest granular level of the cube before aggregation. Perhaps I am missing a basic understanding on this but what I am hoping to achieve is to hold parameters at the lowest level in a separate measure ‘Param’ (separate column in the Fact table) and then reference to those parameters in a calculated member with the resulting values held in the default measure of the cube before being rolled up in the aggregations to higher levels. Currently in the higher levels input parameters are being aggregated before determination of the calculated member value. Will much appreciate your suggestions on whether it is possible ...Show All
Visual Studio Team System TFS Product Key
I originally had TFS Trial installed, and have since purchased the Team Suite MSDN that comes with TFS Workgroup Edition. How do I get the product key for the workgroup edition so I can update the trial license I tried that, but during the repair process I get this error: Error 1309.Error reading from file: D:\Program Files\Microsoft Visual Studio 2005 Team Foundation Server\Microsoft Visual Studio 2005 Team Foundation Server - ENU\Program Files\TFS\Web Services\WorkItemTracking\bin\Microsoft.TeamFoundation.WorkItemTracking.Server.Dataaccesslayer.dll. Verify that the file exists and that you can access it I checked and this directory does not even exist: D:\Program Files\Microsoft Visual Studio 2005 Team Foundation Server\M ...Show All
Windows Forms DataGridViewLinkColumn
Hello there I am working with datagirdviews and have bumped into a problem, I have a column to display the type of file, i have linked that column to the file path, i made the subprocedure for cell click event, and tried opening the file using openfiledialog, and setting the filename to the path of that file, but that didnt work. still when i click on the link, the file doesnot open automatically, any one has an idea of this do i need to open the file in someother way, or change the path somehow,(i also tried using file://(full path to file) but that didnt work, still when i click on it, nothing happens what i want is the file to automatically open, the type of files are txt files, and some wav files. so when a user clicks on the ...Show All
Internet Explorer Development IE7 HP Director Problem
I can't use HP Directors or Solution Center after install IE7. I installed fresh HP software and updates. But problem persist. When reinstall IE6 back, problem solved. who knows anyway or have ideas Please help me. Thank you, jadopp wrote: Found on another forum, there is a workaround until HP issues a fix: Click (or double-click) on the Director Icon like you normally do to run it... the program is starting, but hiding. After a second or two, hit <ALT><Space> on the keyboard. That will "pop-up" a dialog box... click "Minimize" (may have to click it twice). You will then see the Director icon appear in the taskbar. Click the taskbar Director button and the program will then c ...Show All
Windows Forms Treeview drag & Drop Termination
I am trying to implement drag & drop within a TreeView control. There are 2 types of nodes in my tree: departments & employees. I want to disallow dropping an employee on an employee so I set the Effect to DragDropEffects.None. The problem is that when this is set, the DragDrop event never fires. This might be OK except that some other events need to act differently when a drag & drop operation is in progress. So, my flag telling me if a drag & drop operation is in progress never gets cleared if the user drops an employee on an employee. My question is: How do I know the drag & drop operation was cancelled because the user dropped the tree node when e.Effect is DragDropEffects.None Here is a summary of what I hav ...Show All
.NET Development Invalid Binary Format
I so much need your help here. I have a simple application ... and its going to get big :) if I figure out the .NET remoting part. It just wont work. Its based on configuration files. I use VS 2005 - .NET 2.0 - IIS 6.0 to host the remoting objects and a simple Form GUI to test. I use binary format. thats the code : web.config - server : <system.runtime.remoting> <application> <service> <wellknown mode="SingleCall" objectUri="Mail.rem" type="RemotingServer.MailManager, RemotingServer" /> </service> <channels> ...Show All
Windows Forms Heavy operation and Windows.Forms.Timer
Hello. I have a form that display time in seconds resolution in the status bar. The time is used for some calculations during GUI operations. I have "Load Run Data" action which does several communications and then setup and load received XMLs into DataSet object. I do it in the UI thread in order to block menu and mouse input. Sometimes the loading operation takes more than 1 second so the displayed time becomes invalid. I need to find a valid solution to do the loading without hurting timer. I tried to use Threading.Timer without effect. It continues working but hurted by the higher priority thread (UI thread), so the time is still incorrect. Any suggestions. I am interested to know what Microsoft's default approach for this ki ...Show All