Search results for query: *

Didn't think of that, thanks! There's a thin line between genius, and insanity!

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 =...

Thank you. There's a thin line between genius, and insanity!

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!

After reading your post again I think something like this would be better for you: private void button1_Click(object sender, EventArgs e) { // do something here. ValidateText(); // continue here. } private void textBox1_KeyPress(object sender, KeyPressEventArgs e) {...

Really not sure why you would want to do this, but here's an example of how. In this example, clicking on the button will show the message box. private void button1_Click(object sender, EventArgs e) { textBox1_TextChanged(sender, e); } private void textBox1_TextChanged(object sender...

What you've written works fine, assuming you've declared ctrl as a Control in the 2nd and 3rd parts of your code. What error are you getting exactly? There's a thin line between genius, and insanity!

Thanks RiverGuy, just what I need. T0AD There's a thin line between genius, and insanity!

Can you try using the Like keyword, ie. If sMyWord Like "bing" Then bFound = True Not sure if my syntax is 100% correct - cant check it at the moment, but it's something similar to the above. There's a thin line between genius, and insanity!

If I draw the white circles first, and then the board - the circles cant be seen as the board covers them... There's a thin line between genius, and insanity!

What I'm actually trying to do is animate falling pieces. I create a graphics object, draw a filled rectangle and then several rows and columns of white-filled circles. I want a coloured circle to be drawn in one of the top white circles and fall down through the column. If you've ever played...

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!

Hi Herbie, You just need to create a routine like Scott has shown, but change the code after the Handles key word to represent whatever event you want the procedure to 'handle'. For example: Private Sub foo(ByVal sender As Object, ByVal e As EventArgs) Handles m_pForm_Main.Button1.Click...

Nope, output types available are Windows App, or Console App only :( Never mind, I'm learning C# now and I can compile DLL's in this ...! 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!

Hi stfarm, I don't think VB .NET supports transparent backgrounds for the Label control... Can you get away without using the Label control? If you just need to display some text on the screen somewhere you could use the DrawString method of the Graphics class. Example: Private Sub...

Does it work if you include the New keyword? ie. Dim prmForeman As New SqlClient.SqlParameter = daUpdate.UpdateCommand.Parameters.Add(New SqlClient.SqlParameter("@Foreman", SqlDbType.VarChar, 20)) T0AD There's a thin line between genius, and insanity!

Hi tEkHEd, If you just want to add 5 worksheets to the workbook try this: Dim oExcel As New Excel.Application Do Until oExcel.Workbooks(1).Worksheets.Count = 5 Application.DoEvents oExcel.Workbooks(1).Worksheets.Add Loop Let me know if it doesn't work. (Might need to change the...

I have no experience in Web App's, so the following might not work - but try it just in-case. Place this at the end of the routine that runs when your submit button is clicked. Dim c As Control For Each c In Me.Controls If TypeOf(c) Is TextBox Then CType(c...

The above example is for a windows application, is this what you're using? There's a thin line between genius, and insanity!