Andrew XYZ's Q&A profile

• Software Development for Windows Vista LessThan cannot be used on decimal type ?

  How do you do comparisons on currency values in rule conditions I want to do a simple discount test for a price < 50.00, where price is decimal type. Am I missing something easy Unless I am missing something, this works for me without the extra m on the RTM bits. I used an int OrderValue and in my rule, I compared it to 29.99 and worked just like that. ...Show All

• Visual Studio 2008 (Pre-release) [WPF]C# rotate ellipse

  Hello, i have a problem rotating an ellipse. In previous versions of .NET I rotated them using Graphics, but i couldn't find an example, how to do it in WPF. (Only some XAML examples). Maybe the solution is really simple, but it's late here. :-) Thanks. You need to look at the RenderTransform property. For example: <Canvas xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"> <Ellipse Fill="Blue" Stroke="Red" Canvas.Left="100" Canvas.Top="10" Width="160" Height="90"> <Ellipse.RenderTransform> <RotateTransform Angle="45"/> </Ellipse.RenderTransform> </Ellip ...Show All

• Windows Forms TextbBox size in GridView Edit mode

  I have a GridView with a field that contains long strings of text. I would like to make the grid directly editable, rather than using a details view. I finally figured out how to make the TextBox in the Edit view bigger, but I cannot find option to to make the text in it wrap or for adding scroll bars. Is there a way to accomplish what I'm trying to do, either with control properties or through manual coding Thanks in advance for your advice. Steve I have same problem. I want to change multiline property of one column in Edit mode. Code is here : < asp : GridView ID ="GridView1" Runat ="server" DataSourceID ="AccessDataSource1" DataKeyNames ="ID" ...Show All

• Visual Studio QueryStatus() isn't called until running a command for the first time

  Hi, I am writing an addin to VS 2005. I added 2 commands to the project context menu. I have a code in QueryStatus that controls the status of these commands. the problem is that QueryStatus isn't called until the first time I run one of my commands. after the first time QueryStatus is called whenever the menu opens, which is the correct behavior for me. I put a System.Diagnostics.Debugger.Break() in QueryStatus to verify when it is called. How can I make QueryStatus be called even before the first run thanks. Hi, I have the same problem (I think). I am adding two options two the solution explorer context menu. I want these options to be enabled/disabled depending on the type of item that i ...Show All

• Visual Basic I don t know hoe to use Console.WriteLine

  I place a form and a button then I use Console.WriteLine in my code . But this latter doesn t display anything. where should I watch the output of Console.WriteLine. In which window Thanks Console.WriteLine is for when you have a Console. You do not have a Console when you are developing Windows Applications. If you are not writing output for debug purposes you need to state so and state what you are doing. ...Show All

• Visual Studio VS Team Foundation Server Documentation

  Hello, i want to make the documentation of all the code(xml comments) that i put in my source control folder inside the team project, like i do with NDoc, Is this posibly, Any one can tell me how to.. Thank's Andrew Andrew, Is this a Sandcastle question If it could youplease use Sandcastle: at the beginning of your question. For TFS source control there is documentation available at http://msdn2.microsoft.com/en-us/library/ms181279.aspx If it is Sandcastle then the answer is yes. I have documented them at the FAQ post in http://blogs.msdn.com/sandcastle/archive/2006/07/30/683352.aspx How can change author comments from comments.xml to a different file name Please look at t ...Show All

• SQL Server sorting by a column in a matrix layout

  I have data output like from a matrix in Layout view. Month1 Month1 Month3 personA 5 8 3 PeronB 4 2 5 PesonC 7 9 1 Say I want to sort by the last column in descending order. The interactive sort feature on the column heading field did not seem to do anything. What can I do It is not possible to sort the last column without affecting the order of the other two columns - the row headers need to be reordered. In order for user sort to work in a matrix, you need to set the SortExpressionScope to a group instead of detail scope, e.g. the name of the row grouping. Note it's not allowed to reference the row groupin ...Show All

• Visual Basic Error: "There is already an open DataReader associated with this Connection ....." (VB.NET 2003)

  I am using VB.NET 2003. When I try to execute following code, I get following error at the OleDBCommand given inside the While Loop: "There is already an open DataReader associated with this Connection which must be closed first". -------------------------------- CODE ------------------------------------------------- Private Sub PrepareSingleLedger(ByVal myFirmID As Long, ByVal myDate1 As Date, ByVal myDate2 As Date, ByVal myParty As String) Dim qSL As String = "Select PDate, FirstParty, ItemName, Rate, Qty, SecondParty, Commission, Remark, TranID From PParty_Transac Where FirstParty = '" & myParty & "' or SecondParty = '" & myParty & "' and FirmID = " & myFirmID & " and PDate between #" & Format(myDa ...Show All

• Visual Basic Updating in code

  Hello everybody, I am a VB2005 newby and I have the following problem: I have a datagridview, and with my code I can populate my datagridview. I also have a button "save". When I hit save I want the changes and additions made in my datagridview to be saved to the database. This is my code so far but I get an error message when I hit save. Imports System.Data Imports System.Data.OleDb Public Class Form1 Dim strConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=D:\Johnny\SOSOL\Klanten\Mutlu\Projecten\TextielCode\Data\Textielbedrijf2000.mdb;" Dim objConnection As New OleDbConnection(strConnectionString) Dim objComm ...Show All

• Windows Forms Confirm Update before Leaving

  I am using a table adapter and binding source to 'Table01' When I close the form I want to confirm updates before leaving, how would I know if anything has been changed if you used a dataset to hold your records and for it to be modified in, check the dataset hasChanges() method, which returns true or false (boolean) if (theDataSet.HasChanges()) { 'confirm update } does this help ...Show All

• SQL Server Issues With SQL 2005 Encryption

  Are there any pitfalls i should look out for when using the encryption in SQL 2005 That is really strange. The key ring is session based, may it be possible that you are using 2 different sessions to open the key and to alter it If not, I will appreciate if you can give us some more information to try to repro this problem (what client you are using, the script you are trying to run, etc.) BTW. You can run SELECT * FROM sys.openkeys to see the keys opened in the key ring. Thanks a lot, -Raul Garcia SDE/T SQL Server Engine ...Show All

• Visual C# How to know Is Serializable?

  How can I know whether a type(e.g. BindingList<>) is Serializable, both in design time and run time Thanks   Kennon2005 wrote: How can I know whether a type(e.g. BindingList<>) is Serializable, both in design time and run time That's a really vague question. A class can serialize data in many ways. Many of which you'd never be able to know about. If your question is, how can I tell if a class implements standard .NET serialization (ergo ISerializable), then you can simply try and cast the object to an ISerializable object. E.g.: System.Runtime.Serialization. ISerializable serializable myObject as System.Runtime.Serialization. ISerializable ; if (myObject == null ) { MessageBox .Show( "Obj ...Show All

• .NET Development Always inherit from MarshalByRefObject?

  When using .NET remoting, it's obvious you must have some way of passing object values and refrerences to the remote server; but should you apply one of these practices always as a matter of course public class Password : MarshalByRefObject { ... } [ Serializable ()] public class Password { ... } I have noticed that the .NET framework inherits most (if not all) of it's objects from MarshallByRefObject. I seem to find myself now doing the same. Also, when is it best to use Serializable() instead of MarshallByRefObject I'm curious about this as well. DispatcherObject, hence DependencyObject, hence UIElement, hence almost none of the WPF components inherit from MarshalByRefObject ...Show All

• SQL Server Connecting to Oracle on 64-bit (x64) machine

  Hi, Has anyone received the following error when trying to create a connection to an Oracle database using SSIS installed on a 64-bit (x64) machine "Test connection failed because of an error in initializing provider. ORA-06413: Connection not open" The reason this is funny to me is because I have the same Oracle/SSIS setup on a 32-bit (x86) machine and I can connect successfully. On both machines I have SSIS RTM, Oracle 9.2 and using the Microsoft Ole Db Provider for Oracle. Thanks, - Joel it seems the oracle patch should apply on client and server. patch 3807408, unfortunately, the patch is available only for the currently certified versions (9.2.0.7, 10.2.0.1) and not on our current version (9. ...Show All

• SQL Server How to change configured value for the ServerName property of a Connection via DTEXEC

  I am launching a package the following way: DTEXEC.EXE /SQL "\ProcessReportingDatabase" /SERVER RTG23SQLDB01 /REPORTING V /SET "\Package.Variables[User::RunID].Value";35 /SET "\Package.Connections[RSAnalytics].Properties[InitialCatalog]";"Fnd Prj 1 Dec29" /SET "\Package.Connections[RSAnalytics].Properties[ ServerName ]";"RTG23SQLDB01\UAT1PROD" The problem does not happen with the [User::RunID] variable or the [Initial Catalog] property of my [RSAnalytics] connection object. But I am not successful in setting the [ServerName] property. What happens when executed is that the package retains the ServerName property of the deployed package (Value=" RTG23SQLDB01\UAT1QA & ...Show All