Eric Silva's Q&A profile

• SQL Server Can't debug DataFlow Script task

  I have debugged a Control Flow script task and everything went as expected. I put a breakpoint somewhere in my script code, press F5 and execution will break there. However, when I try the same in a Data Flow script, execution does not break! Moreover, when I reopen the code right after I closed VSA, the breakpoint is not there anymore... Any help would be appreciated. Regards, Henk Sebastien Nunes wrote: DouglasL wrote: Interrupt execution and display a modal message by using the MessageBox.Show method in the System.Windows.Forms na ...Show All

• Windows Forms DateTime picker problems

  Hi, I am not sure how to go about explaining my problem. I believe there should be an easy fix. How can I set value to a "DateTimePicker" control that is bound to a database field. My objective is to default the value in a "DateTimePicker" to "Now" in the code when the user adds a new record. I could see the date displayed on the UI, however when I click on "Save", the database field that corresponds to this "DateTimePicker" is DBNull. Here's how I am doing it. I tried to programatically set the "Checked" property as well. No luck CheckOutDate.Value = now CheckOutDate ...Show All

• Audio and Video Development Where can I get MF SDK?

  Where can I get MF SDK People are talking about it's existance and there is docs on it on MSDN, but where is that SDK Am I missing something Hello Igor,    We have started documenting about Media Foundation on MSDN and you can find it here: http://windowssdk.msdn.microsoft.com/library/default.asp url=/library/en-us/MedFound/html/0d355ad1-d674-432e-809a-9fb27ac5f610.asp .  The Media Foundation SDK (documentation, samples etc) also gets shipped as part of the Windows SDK (or what used to be known as Platform SDK). Windows SDK gets shipped as part of the Window ...Show All

• Visual Basic DataGridView Binding to Arrays

  I have a simple example class that has two properties.  The arrays are defined as... Private m_dataDouble() As Double = {1.0, 1.5, 2.0, 2.5, 3.0} Private m_dataString() As String = {"Red", "Green", "Blue"} The Properties are... Public Property Dbls() As Double()    Get       Return m_dataDouble    End Get    Set(ByVal value As Double())       m_dataDouble=value    End Get End Property Public Property Clrs() As String()    Get       Return m_dataString     ...Show All

• Windows Forms Tabs Voluntarily Rearrange Themselves...

  I've heard of lots people with this problem, but I've never seen an official (or unofficial, for that matter) reason, work-around, or bug confirmation for it. My tabs in my application randomly rearrange themselves randomly in debug mode somewhere between F5'ing, saving, and closing/opening Visual Studio.  I can go into the collection in the tab properties and arrange them back the way they belong, but then 15 minutes, an hour, a day later, they've rearranged themselves again in some different order. I've noticed the first tab and the last tab never move...just the ones in between.  Sometimes it's only one tab that moves three, ...Show All

• Windows Forms I want to have darg-drop and onmousedoubleclick for a listview

  If I override the onmousedown method onmousedoulbeclick is never called. How can i solv this Hy, I assume you are using .net 1.1 You can use System.Windows.Forms.MouseEventArgs.Clicks to detect a double-click, however, when a double-click occurs, you'll get a MouseDown with MouseEventsArgs.Clicks=1 and immediately another MouseDown with MouseEventsArgs.Clicks=2. Can you use ItemDrag event instead of MouseDown ...Show All

• SQL Server SQL Impesonate Logon Problem

    Hi. I am currently working on an ASP.NET application which has to log on to SQL using a specific windows user account. As far as I am aware the only way to do this is by adding the Integrated Security=true ; property to the connection string. If you specify a user id and password then it will try to log you in as a SQL user. Is this all correct   To be able to login to the SQL server we explicitly call the LogonUser function from the   advapi32.dll then open a SQL Connection using the Integrated Security=true property. When you look at SQL Profiler it seems that there is two logon calls made when the conne ...Show All

• Visual Studio Express Editions New User Question

  I just downloaded VB Express I need to know where to get started.. what i would like to do is create a program that takes the chat data from another program (.exe file - a game) and then responds to it by pressing F3 so for example if in the other program someone types "hello" I want my program to recognize it and press F3 thats it.. the only difficulty i am having is looking in MSDN and finding out how to make one program affect another (like a macro) Any help would be greatly appreciated! thanks hi, you will need first to learn the basics of vb this thread has links for ...Show All

• Visual Studio Tools for Office Using VSTO to create Excel chart problem..

  When you create a chart in Excel get the option to select "series in column or rows. (like the 3rd pic here : http://www.fgcu.edu/support/office2000/excel/charts.html My VSTO application seems to choose this randomly, how can I hardcode that it does this. Here is the current code : Excel. Chart xlChart = (Excel. Chart ) Globals .ThisWorkbook.Charts.Add(missing, missing, missing, missing); Excel. Range cellRange = oSheet.get_Range( "A1" , "IV500" ); xlChart.SetSourceData(cellRange.CurrentRegion, missing); xlChart.ChartType = Excel. XlChartType .xlLine; Thanks!!! Tom ...Show All

• .NET Development Permissions required to Use System.Diagnostiscs namespace

  Hi, In ASP.NET 1.1, we have developed a module which includes a call to GetProcessById() function of System.Diagnostics.Process. This works fine if the ASP.NET is running under System context or if the ASPNET user is an administrator. The problem is, in the user's machine, the user context under which the ASP.NET is going to run should not have adminstrative privileges. At that time, this shows an exception with the following message. "Cannot get process information from the remote machine". Can you please tell what are all the access the ASPNET user must have , to get the process id Our environment is ...Show All

• Visual Studio Training/consulting on VS Extensibility?

  We are a small ISV that sells a highly customizable base product, and also provide customization services to roughly half our customers. In the absence of something like VSTA in .NET for the last 4+ years, we have built our own proprietary, peculiar IDE and framework in its place. Now that VSTA is coming out, some of us at my company would like to move to it. We need training and consulting to get manager buy-in and "jump start" us on this. The older and "more conservative" at our company will kill off the effort if we do not have outside expertise that can explain and justify the VSTA approach. Where can we get thi ...Show All

• SQL Server How to limit the time Dimension to 24 months

  MSAS Time Dimension Question Well here it goes...I am trying to create a date dimension that will only pull in 24 months worth of date information. Example:  I want the end date to be the current date and the start date to be 24 months prior...as the current date changes (End date) the Start date will also change to reflect the date changes.  I'm thinking something similar to a rolling 12 or 24 month time dimension. NOTE: My time Dimension needs to be similar to that of a Bank account (NOT Accumulative) Ex: May 1 =$ 1.50 May 2 =$ 1.42 ect.. May 31 =$0.65 1-1 relationship on Date to Amount NO rol ...Show All

• .NET Development How to dispose a custom class object

  Hi, I have a custom class who doesn't inherit any system component object. How should I dispose an object of this class My class does not inherit a dispose method, so how should I create one I have read the dispose finalize pattern that suggests to use IDisposable. In this pattern we have managed resource.dispose method. Protected Overridable Overloads Sub Dispose( _             ByVal disposing As Boolean)             If Not Me.disposed Then              &nb ...Show All

• .NET Development Connecting to a database and parameters in sql

  Hi, I am creating a small web app, that searchs a database depending on the information the user enters onto the web form. I create the connection to the database by using the visual studio wizards by binding the data top a grid view. Below is my code SqlParameter word1 = new SqlParameter(); word1.ParameterName = "@tb_1"; word1.Value = TextBox1; SqlCommand cmd = new SqlCommand("SELECT * FROM ApprovedComponents WHERE Vendor = @tb_1"); cmd.Parameters.Add(word1); //Used this in hope after entering cmd into SqlDataSource1.SelectCommand after cmd failed const string command = "SELECT * FROM ApprovedComponents WHERE Ve ...Show All

• Software Development for Windows Vista Runtime Workflow Design

  Scenario: An application allows multiple end users to define their workflow, then run the application based on that workflow. Real-world example: A defect tracking system wants to allow some clients to route new bugs to a manager and others to route directly to a developer. The nearest solutions I can think of are: 1) embed the designer in the application, 2) make the workflow be the most complex case and build in lots of if/elses, and expose those choices in the application. Both have their drawbacks. Any suggestions John Alternatively, embed the designer but have separate workflows for each client. Then each clien ...Show All