NorCis's Q&A profile

• SQL Server determining last entry ID in table

  Not sure if this is the right place to post this but hopefully someone can help me. I would like to determine what the last automatically incremented ID is in a table I need to return it as a variable to a VB.NET program but I'm not sure what the SELECT statement would look like for this. Any help would be greatly appreciated. Please don't use @@IDENTTIY. It will give incorrect results if an insert trigger on the table inserted into any other table with identity column for example. It is best and always safer to use SCOPE_IDENTITY to make sure you get only the identity value you are interested. This function can also get identity values at different scopes (SP, DML statement, trigger, and so on) within the same transaction. ...Show All

• Windows Forms Setup dont upgrades previous installation

  hey guys, i've become a bit stumped about the strange behavior of the c# standard setup (i dont use click-once) i installed several versions of my current project on several machines and on some of them (mainly win 2k machines! ) the somewhat.exe is not replaced by the newer version. as my project contains 2 small applications (2 executeable files) i am not able to understand why whatever.exe gets always replaced and somewhat.exe only sometimes and only on some machines. the most annoying thing is that i cant see any pattern in this behavior: sometimes yes, sometimes no, sometimes here, sometimes there. btw. when i uninstall my project using windows / control panel / software all files were left in the target directory. i am sure this is a ...Show All

• Visual Studio Team System Unable to edit Areas and Iterations in some projects

  Recently I created some Team Projects with the MSF Agile Template. In some projects I have problems editing Areas and Iterations. I'm able to add new areas and iterations for a projects, but I can't see them on my workitems. After some investigation I got the event log appended to this message from the TFS application tier. This error occurs everytime I try to create, edit or delete Areas/Iterations. It looks like a database problem in the TfsWorkItemTracking DB. Does anyone know this kind of problem, or do I have to delete those Team Projects If I have to delete the projects is there a way to export/import the stuff to a new project Thanx in advance! Event Log from Application Tier: TF53010: An unexpected condition has occurred in a ...Show All

• Software Development for Windows Vista BUG: Why does the name of a StateMachineWorkflowActivity property appear as "State Machine Worflow"?

  I have a custom activity defined like the following (see below). BUG: When this custom activity is used in a workflow, why, in the VS2005 Property window, the name of the ForkStateMachineWorkflow property appear as "State Machine Workflow" (with the spaces and without the quotes) - instead of ForkStateMachineWorkflow REPRO: You can test this using the CustomActivityBinding .NET 3.0 RC1 SDK sample. Michael. using System; using System.ComponentModel; using System.Workflow.ComponentModel; using System.Workflow.Activities; namespace Microsoft.Samples.Workflow.CustomActivityBinding { public partial class CustomActivity : Activity { public CustomActivity() { Initialize ...Show All

• Visual Studio Express Editions define host application to debug a dll

  Hello, I'm using visual studio c# express edition and I want to debug a dll using a host application. I didn't find that options in the project properties Is there an option thanks, Rats. If you have multiple projects in your solution, do make sure that you selected the DLL project as your startup project... ...Show All

• .NET Development There is already an open DataReader associated with this Command which must be closed first.

  I have a rather large ASP-NET-2.0 project that I've been developing for some time. I'm using System.Data.Common classes for all of my data access, and SQL-2005 as my provider. Up to and including Beta-2, everything was working just fine and dandy. Then, with the release of RC1, I suddenly started to get the following error:: There is already an open DataReader associated with this Command which must be closed first. This totally threw me, but I dutifuly started to trace all of my connections & readers to make sure I was closing & disposing of them properly, and all appears to be correct. After a bunch of tedious and very time-consuming debugging, I've come to the conclusion that from RC1 onwards, the framework is not correctly ...Show All

• Visual Basic Mouse Move on the Panel Control

  I want to catch the mouse move on a panel. I use the following Sub Private Sub Panel1_MouseMove( ByVal sender As Object , ByVal e As System.Windows.Forms.MouseEventArgs) Handles Panel1.MouseMove End Sub But when the mouse is on another control of the panel ( lets say a label ) , the program doesn't trigger the sub. I have to write another mosemove sub for the child control or I have to add handles behind the other sub . But I don't want to do it for each control. Is there a way to solve this issue Below is a code snippet that shows how you can direct all mousemove events with a single mousemove handler. It's real primitive in that you will have to add logic to translate coordinates of chil ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Self-Shadowing Shader?

  A while back I was looking for some HLSL tutorials and came across a rather good self-shading, two-pass shader. At the time, I wasn't interested in shadows, so I didn't take much note of it. Now I can't seem to find the tutorial. All I remember is it had a render of a dark red chair with shadows on itself from a single light source. Can anyone help me find it The DirectX SDK comes with shadow rendering examples along with basic descriptions of how they work: http://www.microsoft.com/downloads/details.aspx FamilyId=09F7578C-24AA-4E0A-BF91-5FEC24C8C7BF&displaylang=en Also, ATI's RenderMonkey tool comes with more advanced shadow examples, such as shadows with soft edges, but they are not explained ...Show All

• .NET Development Raiserror and select statement combination having problem with sqlexception

  I have a stored procedure having following code in it create proc tmpproc as begin Select 'test' raiserror('not cought',16,1) end when i call this proc using sqlCommand the exception doesn't get cought in the catch block. I am catching SQLException. If I remove the select statement from the code it works fine. Now i need some work around as i 100s of SPs that have this kind of code and want call these procs using ADO.net If any body can i help me it would be really great for me Regards, Vikas Bindra set nocount on is also not working, the exception is still not caught. Follwoing is the updated script: select @localvariable 'Localvar' raiserror('not caught',16,1). Is there any other ...Show All

• SQL Server export data

  A have a simple task: I want to export a table from my sql server 2005 into a excelsheet. If I use the Sql Server import and Export wizard. I perform this task from a local installation of enterprise manger. I keep getting the same error: "The product level is insufficient for component" At first I tought it might be a problem with not having the latest service pack on the sql server. So I updated to service pack 1 and updated so all the patches were uptodate on the server and my local machine. Still no result. I did discover that if I run the wizard on the enterprise manager installed on the server itself it works fine. My question is what can it be that is causing the problems on my local machine (on normal ...Show All

• Windows Forms Accessing objects on a form via a class

  I have a form with a text box and I need to access the textbox and some other events within the form class from a seperate class. How can I get access to that textbox The form is making a call to a method within the class class.getCommand(command); and then the getCommand method needs to be able to modify the textbox within the form. Any suggestions would be great! Thanks! Scionwest Thanks, I tried something similar to that already but the method is going to parse a couple houndred different commands and do something different for each one. I want to break them down into manageable pieces of code within a class.  Will something like the following work FORM class: pub ...Show All

• Smart Device Development about bluetooth.help!

  My  english is not good. sorry.   My system is windows mobile 2003SE, when the power Fall below 5%, the bluetooth  is auto close. but this phenomena only  few second. the causation is my  battery is instability. but I can't  change the battery. I have no idea what the solution to this problem. please help me!  I want to edit the reg.  but   I was uncertain how to act. This forum is smart device development related. Since your question is not related to smart device development, it's off topic here. If you’re having a hardware issue, please contact hardware manufacturer or reseller. If you having ...Show All

• Visual C# Properties Question

  I have a C# Class but I am not sure how to do something, I am also working with ClassDiagram's so if it can be done there instead of code let me know how. this relates to shipping orders Class: ShipBoxes Properties: //First Package: PieceNum PackageWeight PackageCOD PackageDVal //second package PieceNum2 PackageWeight2 PackageCOD2 PackageDVal2 Is there a way to only have one set of properties then just add a second set of the same Properties Instead of adding a "2" or "3" etc Soi can have unlimited number of packages if needed I hope this makes sence. Tdar I got it thanks all, public class AddPackage { private Package _Box; public Packa ...Show All

• .NET Development Invoking managed code from unmanged code failed

  I got into a trouble of invoking managed code from unmanaged code. I have a managed assembly A including some COM object and registered for COM interop. and another COM Module B in natived code. Module B import the tlb file generated by Module A and invoke that through that interface. The problem is: afte invoked a couple of times. the application threw an AV and crashed. I runned that in Windbg and it stops at 0:000> k ChildEBP RetAddr 0012e44c 79f1ed6a mscorwks!COMToCLRWorkerBody+0x129 0012e4a8 79f1ec81 mscorwks!COMToCLRWorkerDebuggerWrapper+0x37 0012e67c 00a7aab9 mscorwks!COMToCLRWorker+0x164 ... 0:000> .lastevent Last event: 168c.f50: Access violation - code c0000005 (first chance) 0:000> u mscorwks!COMToCLRWorker ...Show All

• Windows Forms Timer X Seconds

  Hi, How can I create a function to wait for x seconds with a timer Like... wait_seconds(5); // is the timer function DispatchMessage(Usuario+Environment.NewLine); txtLista.Text="-Logar-"+Environment.NewLine; wait_seconds(5); // is the timer functionDispatchMessage(Senha+Environment.NewLine); txtLista.Text+="-Senha-"+Environment.NewLine; wait_seconds(5); // is the timer function DispatchMessage("listenerconfig"+Environment.NewLine); txtLista.Text+="-listenerconfig-"+Environment.NewLine; wait_seconds(5); // is the timer function ... Thanks Why do you want to wait One way is with the Thread.Sleep method. Simply pass the number of milliseconds t ...Show All