RStanton's Q&A profile

• Visual Studio Tools for Office Formatting columns in tables

  I have a code behind word document where I populate a Word table.  Once the table is created, I need to format cells based on a column.  There doesnt seem to be a way to select a column range and apply formatting, like paragraphformat.alignment.  I have searched high an low and the only solution I can find is to loop through each cell an apply formatting manually. for i as integer=1 to tbl.rows.count     & ...Show All

• SQL Server Find my Syntax Error!! (Because i cant see it)

  Im getting an syntax error in the insert into statement is what my error message says, but i cant see it. So if you could take a look and maybe find the problem it would greatly help. You need to delimit all column names that have spaces. Change Contact Name to [Contact Name] , etc. A good way to debug a SQL statement that you generate is to look at the commandtext string either from debugger or by printing it out and inspecting from SQL ...Show All

• SQL Server Applying styles to page headers

  hi all  i have a set of reports and i want to apply same style to all report page headers  can i do this using CSS   if yes how or is there any other way to do this plz help me. ...Show All

• .NET Development What is remoting?

  Please suggest a book or some example   Vikram wrote: Hi, While I agree with Hussein and Nicholas, I would still recommend you read the blog of Matt Tavis where he has some recommendations regarding the usage of .NET Remoting. http://blogs.msdn.com/mattavis/default.aspx Regards, Vikram http://dotnetupdate.blogspot.com/    It should also be noted that remoting is not going to be enhanced beyond 2.0, and that E ...Show All

• SQL Server best practices for installation and deployment of our packaged BI applications based on SQL Server Standard Edition

  Hi, Problem We are seeking guidance on best practices for installation and deployment of our packaged BI applications (based upon SQL Server STD edition via the ISV Royalty program) including management of SP deployments. These applications are targeted to SMB clients who require simple, reliable, "Wizard" like install procedures with minimal end user intervention. "Experts!! I need urgent help for the above...... Please reply ASAP...... ...Show All

• Visual Studio Team System Team menu item disappears

  I am running VSTS, on a server which I am connecting to over the web. It's worked fine for a while now. The only problem I've had is that the 'team' menu item does not always appear, but I've found if I go to the 'team' tab and browse, it appears. My 'team' tab has disappeared, and I can't find how to reinstate it, and my menu item is not appearing either. I can check code in and out of VSTS, I am connected to it, just the team menu is gone. Wha ...Show All

• .NET Development error while attempting to insert new record in dataset through web service

  Hello I designed an 3-Tier Application in Vs2003.NET I used ASP.NET web service which contains a component class called CustomerClass which contains an OracleDataAdapter and dataSet class called CustomerDs and there are a database in oracle 9i and a windows Application that contains a reference to a web service in one interface I have a datagrid that its datasource is a dataset assigned to a table called Customer and I want to ...Show All

• Software Development for Windows Vista a state delay in a state workflow machine

  I have an application which host a state workflow machine, In this application , I have to define a delay for certain state, so I define an additional driven event who is managed by a delay activity , I defined the this event an the raiseEvent method in the communication service interface.. the problem I don't find the way to bind the drivenevent (in the designer) with the event which I already defined in the communication service interface..so ...Show All

• .NET Development Request SQL-Server-List

  Hi! Is there a possibility to retrieve a list of SQL-Servers, which are on a remote/local Server Greets reg3x Add a refernce to the micrsoft sql server dmo object library in the com tab using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; namespace cSharpSqlServerList {   /// <summary>  /// Summary description for Form1.  // ...Show All

• Visual C# How to free up memory in C# apps?

  hi.. In my application so many variables and XML files are used .. eventhough after finishing off the work with the file, im closing that. It works fine with few number of files but when i uses more than 50 files the application crashes... So. is there any way to resolve this by clearing the memory. need help !!! You need to make sure you call Dispose on any variable that has that method, before ...Show All

• Software Development for Windows Vista Dependency Property

  I have a custom activity derived from HandleExternalEventActivity that I have generated from a interface using the wca.exe tool. On this activity there is a dependencyproperty Approved (type bool) generated. The value of the property is set in the eventhandler for the activity. I have placed my activity inside a while activity that I have set up to have a Declarative Rule Condition that is set up like !this.pageApproved.Approved When I deb ...Show All

• SQL Server The REAL Warehouse Sample V6 database

  Regarding the code/db from the REAL project that just got released, I have no problem attaching the "REAL Sample V6" database, but the "REAL Warehouse Sample V6" database requires ENTERPRISE edition, because the default copy uses Partitioning (i.e. the PT version, although the document stated that the multi-table (MT) version is the default). I only have the STANDARD edition of SQL 2005, is there a workaround Appreciate an ...Show All

• Windows Forms Menu location on the form?

  Hello, Is there a way to change the default location of the menu I want the menu to appear in other position in my form and not in the top of the form Thanks! As far as I know, no, you can't do this in VS.2003. You can& ...Show All

• Visual Studio Team System Is there any limitation about unit test of VS 2005?

  Is there any limitation about unit test of VS 2005 Can the unit test feature in VS 2005 be used to test another project which writen by VC6 Someone said that it can only be used to test the codes written by .NET, is that true Indeed, it has his limits. But every UnitTest environment does have some limits. Testing various languages is not a point i'm satisfied about. So, i test all the C# work with Nunit an ...Show All

• Visual Studio 2008 (Pre-release) Error generating metadata

  Hi If I define my servicecontract with a namespace without the prefix http when I try visit the base address with the explorer I get the follow error: The service encountered an error while generating metadata. See the trace files for more details. [ ServiceContract (Namespace= "mycompany.com/ShopOnline" )] --> Error But If I set the prefix all works fine: [ ServiceContract (Namespace=" http://mycompany.com/Sho ...Show All