Stephane Beauchemin's Q&A profile

• .NET Development Operation must use an updateable Query

  Hi, I am using VS 2003 and C# with OleDb connection to read and write from Excel spreadsheets. I have no problem reading Excel data but when writing to Excel I got this error on this line: oleCmdInsert = new OleDbCommand(@"INSERT INTO [Sheet1$A1:A1] VALUES ('ABC')", _oleConn); oleCmdInsert.ExecuteNonQuery(); Here is the error: System.Data.OleDb.OleDbException: Operation must use an updateable query. at System.Data.OleDb.Ol ...Show All

• Visual Studio Team System Will IntelliSense be supported in final release of T-SQL Editor?

  As of subject. It would be simply marvellous.... FYI: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=444298&SiteID=1 -Jamie ...Show All

• Visual Studio Team System How do we implement MSF Agile successfully in our organisation?

  Dear MSF- and TFS-gurus To save your time I’ll state my questions first: Questions: Where do we start learning MSF Agile And how do we implement this process successfully in our organisation It might be helpful for us to have external help. Do you have knowledge of any true experts on MSF Agile residing in Europe or maybe even Denmark/Scandinavia I have a feeling that most consultants here either hav ...Show All

• SQL Server Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance

  No wonder Microsoft is giving it away for free. It’s not worth anything. I am very disappointed in this version of SQL server. I decided to start learning VB so I downloaded and installed VB 2005 express edition and SQL 2005 express. I tried to build a personal website using the starter kit. I kept getting the following error message, for which I have seen numerous postings on this forum. “Failed to generate a user instance of SQL Server due ...Show All

• Windows Forms Form.Parent

  Hi, i need put a form into a panel. I'm trying use the Form.Parent property, but, it's don't work. How can i do it I'm not sure if you can put a form into a panel.  If anything, it would be something like panel ...Show All

• .NET Development Wow.

  This will be my new coding standard. Always hated nulling objects. Thanks again microsoft! .NET is the way it always should have been. You welcome ...Show All

• Visual Studio Team System Update multiple Work Item Fields

  Scenario - How can I update the "Assigned to" field of 10 work Items or update the "status" of 5 work items Something like ... - select all the work items - update the field - save the changes (the changes should rollback if any workitem is locked by any other user) Thanks We don't have any "bulk edit" feature in the Team Explorer. There are a few ways to do it: The recommended app ...Show All

• Windows Forms Reporting in VB.NET 2005 B2

  Wow kind of options do we have for built-in reporting capabilities with VB.NET 2005 B2   If there are none, what are some alternatives ...Show All

• Visual Studio Team System Team project creation failed

  After some day's of hard work I succeeded in installing Visual Studio 2005 Team Foundation. But when I want to create a new Team Project I an error message: Initialisation for plugins "Microsoft.Pcw.wss", "Microsoft.Pcw.currituck" failed. I have Team Foundation Servr and Client installed on the same machine, and I am always logged in as machine administrator. The site http://test-jb2dms7g05:8080/bisserver/EleadWebService.asmx is available, als ...Show All

• SQL Server Link SQL Server To Intersystem's Cache Database

  Using ODBC, I can link to a Cache database using MS Access. I have tried to do the same with SQL Server 2000, but all I can do is copy tables, which I don't want to do. Is there a way to link SQL Server to Cache  The DB is read-only. Cache is the DB for an Eclipsys Patient Accounting System used at the hospital where I work.    There are two ways to do it: 1. use ODBC + OLE DB Provi ...Show All

• Windows Forms Determining Application Startup Form at run time

  Anybody know of a pattern for determining the startup form of a .NET application at runtime Since the startup Main method is static, Template Method and other inheritance based patterns are problematic. Have not found any answers via Google either. I've seen the example using a derived class from the ApplicationContext class that allows setting of the MainForm property but that still leaves the "chicken and egg" problem of starting ...Show All

• Visual Studio How to insert BoxObject from WindowForm into a section of CrystalReport ???

  Hello Krishna, - Can I insert a BoxObject from windowForm in C# into CrystalReport - Please take a look my code below: private void CreatCircle() { CrystalDecisions.CrystalReports.Engine. BoxObject boxObject= (CrystalDecisions.CrystalReports.Engine. BoxObject )_crystalReportDraw.Section3.ReportObjects[ "BoxObjectCircle" ]; //CrystalDecisions.CrystalReports.Engine.ObjectFormat objectFormat = (CrystalDecisions.CrystalReports.Engine.Obj ...Show All

• SQL Server The Poor VB6 guy - database help

  I have a production applicaton today ran by 120 businesses across the nation. Today our application is a VB6 front end with an Access 2000 backend. The problem. Access 2000 is suffering from corruption every once in a while. our users are running 1-8 computer systems at a time on the access database. We want to move to something that will allow our users to run 10 computers simultaneously if needed. Question.. What do we do for a ...Show All

• SQL Server Join query

  I have two tables Table1 and Table2 Table1 columns: CustomerNum varchar(12) InvDate smalldatetime Table2 columns CustomerNum varchar(12) MaintDate smalldatetime Dis float Table1 Data (sample): CustomerNum InvDate 995169 2/4/2002 995169 11/4/2002 995169 1/1/2003 995169 3/4/2003 995169 10/4/2003 995169 1/4/2005 995169 5/4/2005 995169 11/15/2005 Table2 Data (sample): CustomerNum MaintDate Dis 995169 10/3/2001 1.07 995169 10/3/2002 1.1 9 ...Show All

• SQL Server Query Results Truncated in SSMS

       I'm running a query in SSMS that returns a large result set.  The query runs fine without error.  However, in the results pane the query results are truncated.  I've tried adjusting every option I can find.       I think I'm running into a limit on the number of characters displayed in a column in the results pane.  I've already bumped up the amount to the max (8192) setting i ...Show All