Thiru_'s Q&A profile

• SQL Server update query

  Posted - 01/16/2007 : 07:01:40 Remove the ISNULL function on your update query and Pass the NULL value on @UnderlyingIndexId parameter.. update tblTest set IsActive = isnull(@IsActive, IsActive), UnderlyingIndexID = @UnderlyingIndexID, LastUpdatedUser = @ActiveUser, LastUpdatedDate = getdate() where IndexID = @IndexID ...Show All

• Software Development for Windows Vista OwnershipTimeoutSeconds does not work

  Hi, In order to be scalable we have two servers running our workflows. Any server should be able to take over at any time. The workflows running on the servers make asynchronous requests via msmq to other services. The replies should be able to come back to any one of the servers and still be processed. What happens is that when the reply comes back to a server which did not make the original request (and then wait on an event), the server cannot fire the event on the persisted workflow, because it's still "locked" for use by the workflow. I am currently configuring the workflow instance ownership to be 2 seconds, and it takes longer than that before the response comes back to the server. I'm using the released version o ...Show All

• Visual C++ View invalidate problem ...

  Hello, I am developing an MFC SDI app using VC++ 2005. The view area of the app is divided into four areas (rectangles), each of them contains some icons, texts ect. I am drawing all the things from within "OnDraw" method of the view class. I need to invalidate the areas depending on the change of data from the other dialogs of my app. I can invalidate the view area from within the main frame. But how do I invalidate the view area from other dialogs To inform views about changes of data you can use UpdateAllViews that is located in the CDocument class. UpdateAllViews takes also some hints that might be useful to update just parts of your information. See the Scribble sample. So after a dialog changed some data ...Show All

• Software Development for Windows Vista FaultHandler causes workflow members to be lost!

  Hi, I'm running a state machine workflow with some code within a TransactionScope and a FaultHandler in the EventDriven activity that contains it. I'm intentially throwing an exception within the TransactionScope code, and within the FaultHandler's Code activity I want to do some conditional processing depending on what the exception was. I have a private member object within the workflow class which holds all the information relevant to the incoming event, which I need to be able to query within the FaultHandler to be able to do anything useful. The problem is, as soon as the Faulthandler's code begins to execute, the member object is set to null. I must be missing something here, but I can't for the life of me work out why, and ...Show All

• Smart Device Development how to knew whether a specifical database is exist at the handset

  how to knew whether a specifical database is exist at the handset with c# .net cf code such as, the database name is test.sdf. I want that if the database is exist then access it, else create the database. How to do it Thank Simply check if "test.sdf" exists: if (!System.IO. File .Exists(@"\full\path\to\test.sdf")) { // Create database here. } Please make sure to use full path as Windows CE does not support relative paths and has no concept of current folder. ...Show All

• Windows Forms DataGridViewCheckBoxColumn values

  Hi there, I'm using DataGridViewCheckBoxColumn, when a check box is unchecked sometimes I get the value {} (it's not a string value) instead of false. I want to get the value false or true. Does anybody know why do I get the value {} and how can identify this value programatically Thanks in advance, Elvia PS: Windows application in Microsoft Visual C# 2005 Hi Erik, I have set the ThreeState property to false and I still have the problem whit that unknown value {}. Thank you, Elvia ...Show All

• Visual C# DataGridView_CellFormatting - Formatting dates cells in column dates

  Hello, I currently have a grid that I want to check the date entered is valid and format it into a short date time. This seems to work OK except that the even keeps firing and wont allow the user to re-enter the value in the cell if incorrect. Any suggestions (code below) Thanks private void CommissionDataGridView_CellFormatting( object sender, DataGridViewCellFormattingEventArgs e) { DataGridView dataGridView = (sender as DataGridView ); // Validates that the effective date entered if (dataGridView.Columns[e.ColumnIndex].Tag.ToString() == "EffectiveDate" ) { if (e != null ) { if (e.Value != null ) { try { e.Value = DateTime .Parse(e.Value.ToString( ...Show All

• Windows Forms Getting Button size to match the standard?

  The Windows XP Visual Guidelines say that buttons should be 75x23 pixels. If you drag a button onto a Form in designer, this is the default size. However, it doesn't look right. It is definitely too small. Has anyone come across a good answer to this problem Is there a bug in VS Thanks. I don't understand what is the problem. When you drag a button from toolbox, size is 75x23. It is not small, that is normal size. It will be small if you use 1600x1200 monitor resolution, but if you use 640x480 it will be really big. Nobody stops you to change buttons size. There is no such thing like a standard of button size. I have seen really small buttons, but also seen really big ones. ...Show All

• SQL Server ASCMD executing multiple MDX commands in one batch file

  Has anyone got an example of ASCMD executing multiple MDX commands in one batch file Or are we restricted to one MDX command only We haven't been able to use multiple commands. The doc at http://msdn2.microsoft.com/en-us/library/ms186692.aspx states that you can have multiple xmla commands. < Command > < Batch Transaction="Boolean" ProcessAffectedObjects="Boolean" > < Bindings > ... </ Bindings > < DataSource > ... </ DataSource > < DataSourceView > ... </ DataSourceView > < ErrorConfiguration > ... </ ErrorConfiguration > < Parallel > ... </ Parallel > <!-- One or more XMLA commands --> ...Show All

• SQL Server Behaviour issue with remote inserts

  I have an issue doing remote inserts and don't understand why there is a behaviour difference between local and remote inserts. So far i have not been able to find an answer. It may be something to do with parametised query execution but i`m not sure yet. Below is the scenario If i do a insert into server.db.dbo.remotetable select * from dbo.localtable and the local select returns say 3 values, 3 inserts will occur on the destination server where as if the insert into is local only 1 insert would occur! Why Is it possible to get the remote query to behave like a local and do the 3 records in 1 insert Its currently playing havoc with a trigger i have on a production box. To test this i've supplied some very si ...Show All

• SQL Server Problem deploying reports

  Hi, I have an application that involves 3 components one of which is Reports. My system's configuration: SQL 2000 - Default instance SQL 2005 - Named instance (Instance1). I provide the user with an option of selecting the SQL Server instance. If the user chooses Instance1, then I need to deply the reports in SQL 2005. The exceptions encountered during installation are logged in the Event log. When I do the installation for the in a machine, I always get the following error in the event log: Could not connect to the Report Server Database http://<MachineName>/ReportingServices.asmx . I tried giving the rs.exe options from commandline. I got an error like: Error in DetermineReportUrlSecurity(). I don't have the exact error ...Show All

• Visual Studio Team System Another suggestion for treediff

  It would be very useful to display the last modification date of the files in the tree and if comparing server items, display the changeset number. This would allow easier determination of which file has more recent changes. Also, possibly allow merges to occur between two server paths. ...Show All

• Windows Forms ClickOnce install triggers firewall block as exploit

  On a customer's SonicWall firewall, our ClickOnce installation is detected as an OBJECT tag exploit , and the installation is blocked. The installation is successful when the firewall rule is removed. Is this a known issue Is there a server-side workaround Thanks, Paul Whitaker ...Show All

• Visual C# auto ID in xml

  public class AddAnnouncement { public void _AddAnnouncement() { XmlDocument newAnnDoc = new XmlDocument (); newAnnDoc.Load( "~/App_Data/Announcement.xml" ); XmlNode newAnn = newAnnDoc.CreateNode( XmlNodeType .Element, "ann" , null ); XmlNode Id = newAnnDoc.CreateNode( XmlNodeType .Element, "annID" , null ); XmlNode Title = newAnnDoc.CreateNode( XmlNodeType .Element, "annTitle" , null ); XmlNode Body = newAnnDoc.CreateNode( XmlNodeType .Element, "annBody" , null ); XmlNode Date = newAnnDoc.CreateNode( XmlNodeType .Element, "annDate" , null ); XmlNode Priority = newAnnDoc.CreateNode( XmlNodeType .Element, &q ...Show All

• Visual Basic does picturebox have ruler grid??

  how can I make ruler grid on the picturebox (on top side and left side) You will have to draw them, which all depends on how you want to draw them (it's up to you). However, if you are interested in drawing, you can look up all the drawing methods of the Graphics object. A good place to start is to look at the paint event of the picturebox. One of the parameters is the graphics object of the picturebox, with which you can DrawLine , FillRectangle , etc. ...Show All