Chris Eytcheson's Q&A profile

• SQL Server Sorting records in a Group By

  Hi, I've a problem with the following stored procedure Select . It does compile and run, but doesn't return the sorted result I wanted, which was to have the records from tblPieces (alias Pcs) sorted by (in order) Pcs.fkBatchId, Pcs.fkProfileCode, Pcs.Colour. What happens instead, I think, is that the correct records are selected, but in the record creation order. CREATE PROCEDURE dbo.LoadOneBatch ( @BatchId int, -- the pkBatchId of the batch required @OnlyNew bit -- If true, only consider batches that haven't ever been loaded. ) AS SET NOCOUNT OFF SELECT Bat.pkBatchId, Pcs.* FROM tblBatches AS Bat JOIN ( SELECT Bat1 ...Show All

• .NET Development Accessing variables in a class.

  Hello, I would like to enumerate all local variables in my user defined class. Is there a way to access the local variable scope Thanks, Arijan. Are you sure you mean variables Maybe you're talking about fields class Foo { int field; void Bar( int parameter) { int variable; // code } } ...Show All

• Visual C# timer problem

  I've a timer (interval = 1000) in my app. When the timer is working parallelly a big loop is also working. but I found out untile this loop not finished the timer won't work. How can I force the timer to alwasy work every second I found this article about using threads in c# ( http://abstractvb.com/code.asp A=1028 ) but when I tried to compile this sample the compiler return this error: The type or namespace name 'CallBack' could not be found (are you missing a using directive or an assembly reference ) ...Show All

• Windows Forms What's wrong with my FolderBrowserDialog?

   Hi, I use the FolderBrowserDialog in installer class. However, when the dialog box is open, I did not see anywhere where a user can select a folder. It has just three buttons. Using MessageBox, I saw folder_browser_dialog.RootFolder = "personal". It does not looks like a path. What is the problem here Or FolderBrowserDialog cannot be used in installer class Please help me. Many many thanks. Below is the code. FolderBrowserDialog folder_browser_dialog = new System.Windows.Forms.FolderBrowserDialog(); folder_browser_dialog.Description = "Select the directory that you want to use to create tickler letters."; folder_browser_dial ...Show All

• SQL Server Setup of sql server

  I am trying to get an instance of sql server working on my computer. In visual studio under the server explorer there is a server there but it does not accept my logon info.  I read something about a sawpd but don't know much about it. mark ...Show All

• Visual C# Hidden text and viewstate

  I have a dropDownListBox being populated from a database with name records of around 7,000. The viewstate for this control is set to be true.But when the application run,and if I opened another pages (more than one or two) and when I try to go back to the previous pages the back arrow of the IE will be disabled and the former pages are lost.I discovered that it is due to the size of the list in the drop down being big in size and deside to make the viewstate false and put the value in a hidden text so that after postback its value will be used to populate the list box.I think I have to use some client side scripting and some more coding.So ...Show All

• Visual C# Other application windows appear between forms when showdialog called.

  I have a non-MDI form that I am using as the base form for my application. This parent form calls showdialog on several child forms when menu items are selected, which in turn shows those child forms in front of the parent form. If there is another application opened behind my application I have some issues when the child forms are shown as dialogs. If the other application is maximized, then the base form for my application disappears behind the other application and only the child form shows. If the other application is not maximized, then the window for that application gets placed between my parent and child forms. Is the ...Show All

• SQL Server Execute Process Task; How to use user variable as an argument

  I am trying to call a executable that takes an argument.  I am using an "execute process task" and have declared a user string variable "file_name" (c:\file.txt) How do I use this variable so that the executable will see it as an argument. You can use expressions to define the path and parameters of you executable... Then you don't pass the variable but construct the "command line" with an expression including the parameter (which is the value of your variable)... ...Show All

• Visual Studio VS Web Site Project

  Hi Kevin, Sorry for your frustration.  Building web sites is a bit tricky because they don't support the same set of platforms as normal client projects.  After talking to the Team Build folks, it appears that what you have to do is ... open up the .PROJ file (e.g., TFSBuild.proj) that gets created when you create a new Build Type.  Look for the property called "PlatformToBuild".  It probably has the default value of AnyCPU.  Instead, try changing this value to "Mixed Platforms" if your .SLN contains a mix of web sites and client projects, or change it to just ".NET" if your .SLN contains only web sites.  In the ...Show All

• SQL Server Grouping a query in 30 seconds

  Hi, How can I make a query and group the registries in a interval of 30 seconds...like for each line I have a datetime field that have all the day, and I need it to return just like TIME Contador_type1 Contador_type2 Total 01-01-2006 00:00:30.000 2 5 7 01-01-2006 00:01:00.000 3 7 10 It's just an example...but that's the result that I need and my table is data_hora -- datetime field tipo - 1 or 2 -- count nrtelefone - that's is the number dialed. Thanks Hi there and welcome to the groups, see ...Show All

• Visual Basic Block Scope and For Next Loop

  Inside a function, I have a variable named Combined inside a For Next block of code. As an example without actual code.... Private Function(yadda,yadda) as integer For a as integer = 0 to myarray.length - 1 Combined += Combined next a Return Combined 'Does not work because it lost its scope outside For Next block End Function Was hoping someone could tell me a workaround for this that will allow me to return the value of the variable that's located inside the For Next Loop Thank you in advance Mike Private Function(yadda,yadda) as integer dim Combined as integer = 0 For a as integer = 0 to myarray.length - ...Show All

• Visual Studio Team System Project alerts exception

  Added a project alert for "A build completes" and added three email addresses. Started a build and got this error in the Event Log: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff. Technical Information (for the administrative staff): Date (UTC): 2005-11-10 15:37:48 Machine: TEAMSYSTEM Application Domain: /LM/W3SVC/3/Root/services-1-127760976098191996 Assembly: Microsoft.TeamFoundation.Server, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727 Process Details:   Process Name: w3wp   Process Id: 2 ...Show All

• Windows Forms Combobox

  How to make a combobox uneditable. Thanks Hi, You can change the DropDownStyle to DropDownList to do so. Regards, ...Show All

• SQL Server Previous Row Calculations

  Hi all  I am wondering if anyone know a way that you can look up a value from the previous row to do a calculation on. I have a field that I need to subtract the same field from the previous row to validate. Is this possible in a query Thanks Kenzie Slight simplification, you can use only the CTE in the self-join like: WITH t_seq AS ( select ROW_NUMBER() OVER(ORDER BY <column_list>) AS seq from <table> ) select ... from t_seq AS t1 left join t_seq AS t2 on t2.seq = t1.seq -1; ...Show All

• Windows Forms "the operation could not be completed" in the deployment setup.

  Hi, I have got a problem in the Setup and Deployment Project. Every time I choose a setup project the message "operation could not be completed" appears. I tried even making the project from the solution explorer on the right. The project has been added but I cannot right click on it to add files. I would appreciate it if you have a solution to this. Thanks in advance. Edit: Actually I'm not getting the error, its simply a silent fail, I try to add either a file or assembly, it says nothing, does nothing. I'm having this issue along with another member of my team, what is the cause of this or how can ...Show All