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

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

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

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

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

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

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

Hi all, Can anyone tell me why im getting the error : " Cannot implicitly convert type 'double' to 'float'. An explicit conversion exists (are you missing a cast?) "? The compiler is highlighting the 1.0f but thats a float and i already declared magSq a float so im guessing its something to do...

Hi, im trying to turn some text in a repeater into a hyperlink that sends a primary key to another page in the url. in php i would just break into the html and pop the field in like: <a href="article_view.php?=<? echo($articleID); ?>">Link name</a>.... etc etc Well heres the repeater. The bit...

Hi, Im getting the error "The name 'Application' does not exist in the current context" with the piece of code below. Which is strange becuase i thought application fields were global. Im getting the errors with the server.transfer methods as well. Im thinking it may have something to do with...

Hi guys, Im an asp.net c# newbie, and this is my first post, so i hope im submitting it in the right place (not sure whther it should be here or SQL. Anyway, hopefully this will be an easy one for someone. Im trying to get a date into an SQL smalldatetime column using...