Dancoe's Q&A profile

• SQL Server RDA problem

  I am attempting to execute an RDA.pull from my master database and it is generating exceptions the second time I attempt the pull. NOTE: I always drop the table prior to executing the pull. It seems that after the first time I execute a pull against a particular table name on the PDA I get the following: "A duplicate value cannot be inserted into a unique index. [ Table name = __sysRDASubscriptions,Constraint name = c_LocalTableName ]" Given that the table doesn't exist when I do the pull (I have already dropped it, and verified it's non-existence via the Query Analyzer), why does this error appear It's almost as thoug ...Show All

• SQL Server Add Temp Parameters to a function

  I am writing a set of functions and then a stored procedure to allow me to view some data in Reporting Services. I have written the first part of the function as shown ; set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER FUNCTION [dbo] . [fnWTRTerrierData] ( @vch_site_ref nvarchar ( 3 ), @dt_src_date datetime ) RETURNS @WeeklyTerrierRSPI TABLE ( Areacode varchar ( 2 ), siteref nvarchar ( 3 ), estatename nvarchar ( 100 ), Securitised nvarchar ( 255 ), unitref nvarchar ( 15 ), unittype nvarchar ( 30 ), unittype_count int , tenantname nvarchar ( 100 ), tenantstatus ...Show All

• Visual Studio Express Editions Array Null Reference Exception (noob)

  i will try to as spesific as posible. i have an object (non primitive) array, that every time that am trying to assighn a value into one of his members am getting the Exception the code is look like that: public void vsAircraft( int number) { Acft [] acftArr = new Acft [12]; acftArr[0].name = "test" ; } ok, asume that ther is only one member i the Acft Class, so will not have lot of code her in the forum. but in the real Clas i got afew more members from types int and float. the class is look like that: using System; using System.Collections.Generic; using System.Text; namespace ...Show All

• Visual Studio Formating Questions

  1) When I format my date fields, its always MM/DD/YYYY format. How do I change it to DD/MM/YYYY 2) I have a group header row, which has a blue background. txtGroupSales is one of the text boxes in the row. I've set txtGroupSales to toggle invisible when txtGroupName is clicked. Unfortunately, this also hides the blue background for the text box. So I have a white gap in the blue bar. Any ways around this 3) Is it possible to save that the report should always be printed in Landscape Thanks Vayse Hi, Vayse, for 3), set the PageSize property on design mode ( e.g. 11in, 8.5in ), that should give you a ...Show All

• Windows Forms Does anyone know of a good alternative to a datagrid?

  Hi All, I have a datatable that which I want to display. Clearly I can bind this to a datagrid and use styles to make it look nice but to be honest it is rubish. It doesnt fill the datagrid area, it doesnt resize its hard to affect cells (although I have done this base on content of the cell). What I realy want is something sim ...Show All

• Visual Studio Remote SQL Debugging

  Is there anything special needed to set up debugging into T-SQL. 1.  Debugging windows app from a workstation using a full fledged SQL server on a different machine 2.  Debugging web app from a client machine, remote web debugging on dedicated IIS server, and remote SQL server 3.  Is the debugging backward compatible with SQL 2000 SP4 Thanx, This section of online Help contains all the information relevant to setting up debugging for SQL Server. http://msdn2.microsoft.com/library/s4sszxst(en-US,VS.80).aspx Habib Heydarian Program Manager Visual Studio Debugger ...Show All

• Visual Studio Team System Reports node in Team Explorer sticks at Working...

  I'm running TFS beta 3 refresh in a dual-server installation. I had a lot of problems getting Sharepoint working again (see my other threads) - that may have something to with what I'm seeing now. Per the migration instructions, I went into the report server and manually created all of the reports for my projects.  I made all of the necessary configuration changes and tested every report. In my project portal sites, reports do appear in the report placeholders (although they're all showing no results, but that's probably something else). The thing that's not working is the Reports node in the team explorer.  It sticks a ...Show All

• Visual C# How to check string is number or not in C#

  Hi! Enveryone: I am new in C#. I want to check whether the user input to a text box is a number or not. What is the string function to check it I do not want to use try and catch. Thank you very much! CLC In the TextBox_TextChange check the charater by using the following code for (int i=0; i<this.textbox1.text.length; i++) { if (char.IsDigit(this.textbox1.text )==false) // give any error } ...Show All

• Windows Forms Forms inside Splitcontainer

  Hi all, In my application "Main Form" I have a splitcontainer which has a treeview control on the left container... What I want to do is load forms inside my applicaition into the right container... Is this possible, and how can I do it Thanks Why not create UserControl custom controls rather than actual Form instances. If you must use a Form then you need to set the owner of the form as the main form and tell the form to have no border. Phil Wright http://www.componentfactory.com Free user interface controls for .NET2 ...Show All

• Visual Studio Team System TFS Explorer and Solution Explorer - how they compare?

  Hi folks, i've been struggling with the idea of the TFS explorer and the Solution explorer. I've been programming with VS2002 and then VS2003 and have no problems understanding the Solution explorer in that piece of software. For example, we have 4 class libraries and 2 web applications in my main solution i use. Now with TFS explorer installed in my VS2005, i'm confussed between the two and the relationship of sourcesafe. For example, previously i could have my own solution that contains various projects found in sourcesafe. My collegue could have their own solution which could contain _some_ of my sourcesafe projects, and o ...Show All

• .NET Development Can .NET Remoting App be both Client and Server?

  There will be a question in here so stay with me, I'm providing some background first. I just started working on an existing app with the programmer that originally wrote the code.  My contribution will be to make one instance of the app running on one workstation on a network talk to another instance of the same app running on a different workstation on the network. To provide the services I want to use .NET Remoting (eventually Web Services for more flexibility) so I've created a class derived from MarshalByRefObject.  I've compiled this class into the existing app. Most of the documentation on MSDN for .NET remoting gives exampl ...Show All

• SQL Server Advice needed for connection to DB2

  I am writing a report in RS and my query is supposed to pull transactional records from a certain date (yesterday). The table I am querying contains roughly 1.5 million records. This is on an AS400 dB2 system. Mostly I use ODBC with no problems, however this query ran for about two hours and was still running before I killed it. I am thinking of using SSIS to copy the records into SQL. If I go this approach (which should be much faster), is there a way to just copy over differential records each day Or does anybody have any other suggestions What is Linking a Server Thanks for the information. I am using SQL 2005 ...Show All

• Windows Forms Unable to Reinstall ClickOnce Application

  Dear VB Experts, I'm having issues with reinstalling/updating an application on a client's computer after an initial install went okay. I'm trying to provide an update and the client gets the following detailed error message after the initial warning saying, "Application cannot be started. Contact the Application Vendor." PLATFORM VERSION INFO Windows : 5.1.2600.131072 (Win32NT) Common Language Runtime : 2.0.50727.42 System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200) mscorwks.dll : 2.0.50727.42 (RTM.050727-4200) dfdll.dll : 2.0.50727.42 (RTM.050727-4200) dfshim.dll : 2.0.50727.42 (RTM.050727-4200) SOURCES Deployme ...Show All

• Visual Studio Javascript Error with report viewer 'oReportDiv' is undefined.

  Why do I get the Javascript error on the page when I am using the Report viewer in local mode. This is my RV declaration on the page..Appreciate a prompt response and things to try to get rid of it.   Thanks   < div id ="DataContainer" runat ="server" visible ="false"> < table id ="ghsdfgjkhfsdkg" width ="100%" border ="0" runat ="server" cellspacing ="0"> < tr > < td class ="tabletext" align ="left"> < rsweb : ReportViewer ID ="ReportViewer1" BackColor ="GhostWhite" ShowToolBar ="false" runat ="server" CssClass ="tabletext" ShowParameterProm ...Show All

• Visual Studio More than one Diagram / File - Extension for a single model?

  Hi everybody! I've downloaded the latest CTP (Nov2005CTP) of the DSL Tools. After installing I've read the Walkthroughs and have done some experiments. What I want to achive is to provide a way to use more than one Designer for my model. Let me give you an example of what I want to achive: 1. The "root" Designer I a kind of Class - Designer witch shall allow to define classes with Fields, Inheritance and Interface implementations. This is no problem so far. I would name this kind of Diagram an "Object Diagram". There shall be only one Object Diagram within a Project. 2. This is the step where I have no idea how to implement it: T ...Show All