Search results for query: *

Ok so I added a contextmenustrip to form1 in a winforms app. I have a standard class elsewhere that takes a treenode as a parameter and does things to it. One of the things I would like to do is set the context menu. The context menu was added to the form manually at design time. I have tried...

I am getting the error: "Cannot perform and aggregate function on an expression containing an aggregate or a subquery." on this portion of my query: (SELECT SUM( CASE WHEN closeDate > '1950-01-01' THEN closePrice WHEN closeDate < '1950-01-01' THEN (SELECT dbo.symbolData.priceClose FROM...

ok, thanks

Hi all, Any ideas why 'pos' is an invalid object name? Thanks in advance, Ben ALTER PROCEDURE dbo.PortfolioReport @portfolioId int AS SELECT AVG(DATEDIFF(day, openDate, closeDate)) as 'Average Length', MAX(DATEDIFF(day, openDate, closeDate)) as 'Longest', MIN(DATEDIFF(day, openDate...

Wow, thanks for all the tips guys! Esp Markros for actually rewriting my rubbish SQL! :-D Sorry for late reply been on holiday. Thanks again. Xavi

Hello chaps, Any ideas why this wont work? Apparently varchar and unique identifier cannot be used with the + operator. New to dynamic SQL so havent a scooby... Thanks in advance. ALTER PROCEDURE dbo.AddPriceDataToExchangeTable @symbolId uniqueidentifier, @date smalldatetime, @dateId int...

Finally figured it out. It was nothing to do with my code but the way Visual C# compiles. Basically it copies across the previous version of the .mdf file (the one prior to the build) back to the working directory after the solution is closed again. Or something similar. I got round this by...

Hi All, Have come back to programming after a lengthy break for a personal project using visual c# and SQL Server Express in a win forms app. The problem I have is that my INSERT INTO statements are not working, while my SELECT statements are working perfectly. While debugging the command...

ah! *Slaps forehead* Thank you very much :) Ben

Hi All, I have added a uniqueidentifier column to an existing table in Microsoft SQL Server. All I want to do is populate the existing records with new Guids. I have tried things based on this to no avail: @GUID uniqueidentifier AS UPDATE sysx_groups SET GUID=@GUID RETURN Any help much...

Hi All, I am trying to find a way to loop through the results of a stored procedure using foreach. Its part of an approach to populate a treeview. I was hoping that some of you could provide an example snippet on how they might go about it. Thanks as always in advance... Ben

i needed to know the position of the applets screen coordinates. i found them by calling this.getLocationOnScreen(); in case antbody else needs to know. 'this' being the applet component itself.

lo all, how can i return an applets screen coordinates. i.e. the origin at the top left corner of applet. thanks...

thanks for that bill, i did this with it: import idi.*; class idi.trimesh { //Mesh data public var vCount:Number; public var vList = new Array(); public var tCount:Number; public var tList = new Array(); public var intext:String; public function trimesh() { vList.Array = null...

Hi all, I need to parse text in a file into an array. The file type im trying to read is an .obj file. In c# i would just create streamreader object and get parsing. But new to actionscript(v8). Obj files store information like this: v 123 145 234 v 234 245 242 ... where v indicates the...

Hi all, I have some questions about socket programming in c#, they may seem really naive but i have never written an application that runs on a web server before, and i am new to .net. Well here goes... 1. I need to write a simple server socket app that will sit on a web server and communicate...

works...thanks, ben

Its impossible to cast a double to a float in c#, yes? Is there a workaround for this?

www.learnvisualstudio.net has some great downloadable videos on c# and has lots of examples where vb and cs examples are shown side by side. B

ok im getting the syntax thanks. re: html and css i know i suck at it, i have a guy that redoes that for me when i get the processes down and i suppose i have never really considered high on my agenda, its on the list after c#, asp, javascript, java, ajax, and sql! if im still sane at that point.