Cyril Mathey's Q&A profile

• Architecture Programming modal selection

  Hi All,   My application is a CRM based application. There is a Framework and application(s) who access it in a webfarm environment. (consider distributed computing)   So usually which programming methodology or project cycle should be selected (best fit) 1) Agile 2) eXtreme 3) Iterative (Okay though, takes time) 4) Spiral 5) Waterfall (not recommended) 6) Any other ...   Kindly respond with your experience   (IMO Agile is usally good for smaller projects. But what about the larger iterative projects. I think Iterative method works out well. )   thanks... When you are going to use an iterative method. Keep in mind that when ...Show All

• Windows Forms Removing Componets (exp Checkboxes )

  If I wanted to lets say... have a few checkboxes right... and I wanted to remove the ones that are checked... how do I do that Like.. remove the checkbox right along with its value. What exactly do you mean by "remove". I'm gonna guess that hiding the checkbox would be sufficent: foreach (Control ctl in panel1.Controls) { CheckBox chk = ctl as CheckBox; if (chk != null && chk.Checked) { chk.Visible = false ; } } ...Show All

• SQL Server copy file in stored procedure

  All I want to do is copy a text file and add a 1 after the name in a stored procedure that already cretes this file. CREATE PROCEDURE [dbo].[sp_export_req] AS DECLARE @trenutniRed varchar(30), @tableRow1 varchar(3000), @sql varchar(4000), @sql1 varchar(4000), @firstColumnName varchar(30), @HTMLfile varchar(1000), @columnNumber varchar(30), @fs int, @ole int, @file int declare @body as nvarchar(225) CREATE TABLE #temptableHTML (code nvarchar(225)) select @HTMLfile = 'c:\test_new.txt' This is the start of the procedure that creates the test_new.txt file. I want to copy the test_new.txt file and name it test_new1.txt. Any help is appreciated. thank you ...Show All

• Internet Explorer Development Internet Explorer Toolbar (Menu Bar) disappeared after installing IE 7

  I use yahoo as my homepage, when the "Get IE7 now!" appeared in the toolbar, I clicked on it and installed it. Big Mistake so far...Here's the problem, after installing my IE menu bar (toolbar) containing "File, Edit, View, tools, help" vanished and I can't figure out how to retrieve it or get it back. I have checked and it is not hidden behind another toolbar. Along with that, The IE blue bar at the top & small bars at the bottom contain no information of the URL (webpage) when pages are loaded. In the Yahoo toolbar, under the pencil icon- there is no standard toolbar listed anymore. Also my tabs disappeared from yahoo and under the toolbar options there no longer is a check box to "Enable Tabbed Browsin ...Show All

• Visual Basic Problem with Design view

  I am writing an application which manipulates many fields of data. Today, I implemented a new datatable which contains over 50 fields of info. I dragged this onto the Design view as "Details." The controls were placed one above the other with the last ones well off the screen area. I have spent a few hours moving, aligning, re-sizing etc. to get them properly laid out. However, I am unable to expand my Form in the design view to be able to grab the last few fields at the bottom and drag them up into the space I have created for them. The handle lets me expand the form to a certain point then stops, before I can see the last few controls! I know that these other controls are there as when I run the application (obviously ...Show All

• Architecture DataSet Performance issue

  HI We are using a oracle stored procedure which returns a refcursor. For queries with like search which returns large number records the dataadapter.fill() is really takes time. For a case whcih returns 14000 records it took 3000 ms to perform the fill method, eventhou gh we are filtering by 99 recodrs using fill(ds, start, maxrecords). As the number of records increasing the time varies even if the filtering happens only for 99 records. Any idea how we can improve the performance. Or any other we can call the SP which gives any improvement We cannot modify the SP. And the DAL used by many diffrerent componenets. Thanks in advance Sharmila The call to fill with not improve mu ...Show All

• Smart Device Development How to debug my phoneime.dll on windows mobile emulator for smartphone?

  hi, all When I start debugging, compile and deploy sucessfully, but notify me non-exeute file,no debug. My input method can't be called out also. Then I revise regedit,inputmethod can be called out. Then debug, deploy failed: Deployment and/or registration failed with error: 0x8973190e. Error writing file '%CSIDL_PROGRAM_FILES%\phoneime\phoneime.dll'. Error 0x80070020: The process cannot access the file because it is being used by another process" . What's problem Thanks. ...Show All

• Visual C++ FYI: ATL::CSimpleArray doesn't call a copy constructor during reallocation (resizing).

  Whend ATL::CSimpleArray needs resizings. It makes one without calling a copy constructor. BOOL Add( const T& t) { ................................................. if (m_nSize == m_nAllocSize) { aT = (T*)_recalloc(m_aT, nNewAllocSize, sizeof (T)); if (aT == NULL) return FALSE; m_nAllocSize = nNewAllocSize; m_aT = aT; } InternalSetAtIndex(m_nSize, t); m_nSize++; return TRUE; }   as a result when you store complex objects with internal refernce a program can fail. class A{        int a;         public:              A(): a(0), b(a) //refere ...Show All

• SQL Server HowTo: read/write package level variables in custom task

  Hello all, I have been struggling trying to read and/or write package level variables from within my custom task.  I'd like to be able to get and set values from within the Execute method of my custom task.  I have searched this forum and the books online and can't seem to find the answer.  I thought maybe I could use an expression on my task (mapping the package variable to a custom task public property) but that doesn't seem to be working for me.  I also would have thought I could use the VariableDispenser object from within my task but the collection is empty.  I have 3 package level variables configured and can't seem to find a way to access them (with intentions of getting/setting).  Cou ...Show All

• Visual C# Redim in C#

  Hello everyone, is there a way to simulate VBs redim function in C# Thanks Bear in mind that that's obsolete (only needed for .Net 1.x). For .Net 2.x and later, use Array.Resize<T>() as stated previously. ...Show All

• Visual Studio Team System GenCheckinNotesUpdateWorkItems and BuildId

  Hello, I have the following question: When calling the GenCheckinNotesUpdateWorkItems task from code, is it possible to "ignore" the BuildId parameter of this task and set it to a dummy value or empty string This question has the following background: We use our own Build Solution (FinalBuilder) but use the Team Foundation Version Control as Source Code store. What we want to use is the features the Task GenCheckinNotesUpdateWorkItems provides. - What ChangeSets and WorkItems are affected by th build, and close automatically resolved workitems... What we have is the current and the last label used when building the solutions, because FinalBuilder has it's own Label task that use the Version Control Label mimic. Thank you in Adva ...Show All

• SQL Server Accessing the variable in Execute SQL Task

  I have a variable SYear with the data type Integer and the value 2005. Connection type is OLE DB, and my sql statement is: DECLARE @MyYear Int SET @MyYear = I have set the variable User::Syear as Input with the parameter name=0, there is no result set. I set BypassPrepare both True and False. However, this simple statement does not work. I keep having an error. If I put integer value directly into @MyYear, it is fine. What is wrong in here Somebody help me! What do you mean by code 2 doesn't work You need to have result set set to something other than "None" if it returns a record set. That is what is generating the error you are seeing. My guess from the code you posted is, SQL is implici ...Show All

• SQL Server Integrated Security doesn't work - "Not associated with a trusted SQL Server connection." Error

    Hi, I have a piece of Java code that needs to connect to SQL 2000 (SP4) using Windows Authentication. It's running on Windows Server 2003 SP1. I tried JDBC v1.1 and followed the code from the following blog: http://blogs.msdn.com/angelsb/default.aspx p=1 But still get this error as shown below. Any help appreciated. I am using JDK1.4.2, "sqljdbc_auth.dll" is located under "E:\SQL2005JDBCDrv\sqljdbc_1.1\enu\auth\x86", also made a copy under "E:\JavaTest" and "C:\Windows\System32" but still won't work. Cheers Allan   =========================================================== E:\JavaTest>javac -classpath ".;E:\JavaTest\sqljdbc.jar" TestW2.java E:\JavaTest>java -classpath ".;E:\JavaTest\sq ...Show All

• .NET Development Best way to compine datatables

  Hello, I have to deal with x number of datatables to make one compined datatable. I was wondering what would be the most efficient way to do this. I am quite new to VB .NET. So the case is that I got bunch of datatables where colum name is the price and the rows indicate the amount of purchases for current time. Would it be best first to read all datatables to datatablescollection( ) or should I just build the new table as I read the tables. What would be the best way to compine same the columns There is alway the same amount of rows. When the column names(numbers) match the values for the current times are summed. well to add datatables into a "collection", you could add it into a dataset to hold the datatables ...Show All

• Visual Basic Tool Tip in vb.net - Handle is not initialized

  I am developing a windows application using VS-2005, vb.net, net framework 1.1 and SQL. Following is the code for utilizing tool tips in the form: Private Sub frmEMS_Incident_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Dim tTip As New ToolTip ' Set up the delays for the ToolTip tTip.AutoPopDelay = 1000 tTip.InitialDelay = 1000 tTip.ReshowDelay = 500 ' Force the ToolTip text to be displayed whether or not the form is active tTip.ShowAlways = True ' Setup the ToolTip text for selected fields and buttons on the form tTip.SetToolTip( Me .cmd902Update, "Auto-fill of da ...Show All