Search results for query: *

Hello. I have the following code in a SQL trigger: SELECT @XML = SELECT * FROM inserted FOR XML PATH ('MyEntity'), ELEMENTS, ROOT('Inserted'), TYPE); I want to add the deleted records to this too, but my code below just overwrites the @XML variable. How do I add to it? SELECT @XML =...

I have a simple query like this: SELECT ColA, ColB, ColC FROM TableA I want to return all of the rows where there is more than 1 row where the values in these three columns are the same, ordered by ColA (including the duplicate rows!). Any ideas? There's a thin line between genius, and insanity!

Is it possible to draw or paint behind something using GDI+? For example, if I paint a small filled circle, can I then draw a larger filled circle around it - but behind it - so that the first circle is completely visible. There's a thin line between genius, and insanity!

I can create a user control, but I can't compile into anything except .exe. I have VB.Net and C#.Net Standard Editions, does anyone know if it's becuase this feature isn't available in the standard editions? Thanks T0AD There's a thin line between genius, and insanity!

Feel like an idiot asking, but I can't seem to compile a usercontrol, I've tried messing around with the Build options with no success... can anyone help please? T0AD There's a thin line between genius, and insanity!

I've created a class, and I'm passing an array to one of it's methods. The problem is, the original array's contents change even though the argument is declared ByVal. The code in the method only refers to the array that's passed as an argument, not the original... does anyone know why the...

myString = String.Format("{0, 35}, {1, 10}, {2, 10}", myTxt1, myTxt2, myTxt3) The above code seems to centre the text variables within the space I've allocated. Does anyone know how to align them? ie. so the result of a few iterations of the above could be something like...

Hello. Here's a simple slice of code that isn't doing what I'd expect! It should be flickerless - because I've 'turned on' the Form's double-buffering. Does anyone know why it isn't working? Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles...

I have created an off-screen graphics object like so: [code]Dim bmpOffScreen As New Bitmap(Me.Width, Me.Height) Dim gOffScreen As Graphics.FromImage(bmpOffScreen)[\code] I can draw to this okay, and flip it to my on-screen graphics object, but for some reason I can't clear the off-screen...

Is it possible to disable the X button on an MDI child form? Or, make it so that when the X is clicked, the form hides rather than closes? T0AD

Does anyone know how to create a 'canvass' in memory to draw on? In VB6 I achieved this by using the CreateCompatibleDC(), CreateCompatibleBitmap(), and SelectObject() API calls. I realise I can still call API's from .NET but is there a way to do this with the System.Graphics NameSpace - or...

Here's the code for my control: Option Strict On Option Explicit On Public Class ucReel Inherits System.Windows.Forms.UserControl #Region " Windows Form Designer generated code Private p_ReelImagePath As String = "E:\Reel.BMP" Private p_TotalImages As Int32 = 9...

Hello there. I've just switched from VB6 to VB .Net and I'm having a bit of trouble with the following: I have an image, which I load using: Dim myBitmap As New Bitmap("C:\myImage.BMP") Now this image is about 640 pixels high and 64 pixels wide, and I want to draw part of this...