Terence Blyth's Q&A profile

• SQL Server SQL Server Agent control

  I have a SSIS package that is scheduled to run at the same time every hour/day/whatever using SQL Server Agent. If the package fails then I don't want to run the package again until I've fixed the problem. For this reason i want to disable the agent job at the start of the package and then enable it again at the end. Has anyone done any work on controlling SQL Server Agent jobs from within an SSIS package How have you done it Any advice would be much appreciated. I feel a custom task coming on...    Is there an API for SQL Server Agent Thanks Jamie So far my list of custom components is as follows: Enhanced Error ...Show All

• Visual Studio Express Editions Visual Web Developer and Sub Folder Applications

  How do I set a subfolder to be an application in Visual Web Developer I cant seem to find the setting. (I can change it in IIS however relative links arent being created properly in Visual Web Developer) Any help is appreciated. Z Hi, The best place for asking ASP.NET questions is on the ASP.NET community site, and in the forums there. Check out http://www.asp.net/welcome.aspx tabindex=1&tabid=39 . HTH, PEte ...Show All

• .NET Development copying multidimentional array to another one

  I have developed this class to read from file public class ReadFromFile { FileStream f = null ; string fileName = "c:\\myData.data"; char [] separator = {' '}; string [] strArray; public int [,] pattern ; public int [,] target; int total = 0; static int count=1; static int num = 0; public ReadFromFile() { try { f = new FileStream(fileName,FileMode.Open,FileAccess.Read); StreamReader r = new StreamReader(f); string data = r.ReadLine(); for ( int s=0;s<count;s++) { total = 0; strArray = data.Split(separator); pattern = ...Show All

• Visual C# Arraylist of Arrays

  When a try to assign an arraylist of arrays to a datagrid, the datagrid columns that i get to see are, Issynchronized, Is anonymous etc... instead of the databade columns i have assigned in the array. What could be the reason Thanks & regards Kitty Arrays don't carry any information about your database schema, just the column data. I guess the datagrid falls back on listing the Array type members instead. ...Show All

• Windows Forms VB.net crashes when loaded, please help

  I just installed VB.net.  When I launch the program, a windows installer comes up and closes the application.  I have tried timing it where I can hit cancel, but it still closes the application.  I have also tried opening a VB application and it does the same thing.  How can I get the windows installer to not run and close the  ...Show All

• SQL Server Getting more information of a Job / Aborting a render-request

  Hi, I'm developing a webapplication where users can view reports very fast (no login required, reports are directly shown as pdf->no annoying prompt). Therefore I gave ASPNET some permissions and all currently processed reports(jobs) have the owner ASPNET. In some cases a report could take a long time, so I want to give users the possibility to cancel their report (to free server resources). How do I do this I can cancel the corresponding Job, but how do I identify the right job All jobs have the owner ASPNET and its possible that two users requestet the same report. So I've no cance to find out the correct job. I've tried ...Show All

• Windows Forms double click for button

  hi, i would to make my button to listen to double click event with the following code, but it seems does not work...or m i using a wrong method can anyone help me Private Sub Button1_DoubleClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.DoubleClick        MessageBox.show("It is a double click") End Sub thank you I've tried your code but it doesn't work. I found that the new button will treat my single mouse click as 2 clicks. If I double click, I will get 4 click event instead of 1 double click event. What's wrong with that ...Show All

• Visual Studio 2008 (Pre-release) try rebooting...

  Beta Page http://msdn.microsoft.com/windowsvista/getthebeta/default.aspx WinFX Components - Dec CTP http://www.microsoft.com/downloads/details.aspx familyid=BD3BA2D5-6ADB-4FB2-A3AA-E16A9EA5603F&displaylang=en Windows SDK - Dec CTP http://www.microsoft.com/downloads/info.aspx na=46&p=1&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=2297BDC9-B5AE-4B8A-B601-EEF54A52867A&u=http%3a%2f%2fdownload.microsoft.com%2fdownload%2f0%2f7%2f3%2f073d42b8-e2ba-4293-ad97-28365dc2d655%2f6.0.5270.0.9.WindowsSDK_Vista_idw.DVD.Rel_Update.img Tools for VS, including Orcas - Dec CTP http://www.microsoft.com/downloads/details.aspx FamilyId= ...Show All

• Visual Studio Tools for Office Error when Implement the DragDrop

  Hi! Why do I always get a COMException error (message: Invalid FORMATETC structure (Exception from HRESULT: 0x80040064 (DV_E_FORMATETC))) when I'm implementing the DoDragDrop Method.  Can anyone share their ideas on how to handle this Thanks in advance. Hi, When you drag over a window, COM will check to see if that window has a drop target registered.  If it does, it will call IDropTarget::DragEnter to give the drop target the opportunity to indicate whether it can accept drops from the drop source.  To do this, it calls IDataObject::QueryGetData against the source IDataObject with any and all formats that it can s ...Show All

• Windows Forms Cannot modify DataGridView properties in inherited control

  I have a WinForms UserControl (A) that contains a DataGridView. I have another control (B) that is a subclass of A (B inherits from A). Everything works fine, except that I can't make any changes to the properties of the subclassed control (B). Is there any way to allow this I need to resize/move the DataGridView on the child control (B). I added the DataGridView to a Panel, and I could resize that, but I'm using this pattern a lot, and all the Panels really slow down the resizing of the form. Thanks, Erick What So what you are saying is that if we have a project that is based on the inher ...Show All

• Visual Studio Team System Make a new field depending on "Assigned To"

  I added a new field called "Responsibility" to the Bug workitem. And I was trying to make it dependent on "Assigned To". Say, when "Assigned To" is set to user A, "Responsibility" will show "QA". Below is what I did for the new field, but it doesn't work properly. My problem here is the new field value won't get updated correctly, unless I empty the "Assigned To" box first and then select user. Any help is greatly appreciated. <FIELD name="Responsibility" refname="MyCompany.VSTS.CMMI.Responsibility" type="String" reportable="dimension"> <HELPTEXT>The responsibility of the defect</HELPTEXT> <ALLOWEDVALUES> < ...Show All

• Smart Device Development connection string error

  [code]      Dim rdaOleDBConnectString As String = "Data   Source=WINWIN;Initial Catalog=HOME; " & _             "User Id=<username>;Password = <password>" [/code]   Error Message = A required property is not specified. [ Property name = SubscriberConnectionString ]   can anyone tell me what is the error by the way what is DATA source and Initial Catalog means if the user id and password is blank is it put like <password> Hi, In case of SQL Server, the keywords mean: Data Source -> The name or ...Show All

• SQL Server Cannot install SQLExpress after uninstalling June CTP

  I try to install SQL Server Express after uninstalling its beta and get the following error in the log file.  Can anyone help me   Thanks.   Microsoft SQL Server 2005 Setup beginning at Thu Dec 15 20:28:39 2005 Process ID      : 110612 c:\e7b4645908c60721e3107fa330d0184a\setup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2005/11/15 20:28:38 Complete: LoadResourcesAction at: 2005/11/15 20:28:38, returned true Running: ParseBootstrapOptionsAction at: 2005/11/15 20:28:38 Loaded DLL:c:\e7b4645908c60721e3107fa330d0184a\xmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAc ...Show All

• Visual Studio Team System VS Itchy Trigger Finger on Solution/Project File Checkouts

  Has anybody else seen this where folks using VS 2005 Team Edition have a project or solution checked out and they didn't even realize it   I just a co-worked to a "Get Lastest" on our Src dir from the VS Source Explorer tool window and it asked him to check out the main solution file.  Why does this happen If you do a Compare on the files that were auto-checked-out, do any diffs show up ...Show All

• Visual Studio Team System MFC80.dll and MFC80U.dll dumped into C:\ on a TF Client install

  FYI, after we install VSTS RC1 but before we install TF Client Beta3 the C:\ dir is clean.  After installing TF Client Beta 3 the following two files are put in C:\ 08/30/2005  10:09 PM         1,093,632 mfc80.dll 08/30/2005  10:09 PM         1,079,808 mfc80u.dll I would expect these files to be installed in SystemRoot somewhere. Yes, this was a bug we discovered very late and were not able to fix in time for the Beta.  I can't remember if we tried to get it into the upcoming Beta 3 refresh.  I'll send mai ...Show All