Trev Hunter's Q&A profile

• SQL Server Trigger question

  I would like to know how many records there are in the INSERTED & DELETED tables at once when a trigger fires. I'm looking at a trigger that checks for COUNT(*) in both tables (INSERTED & DELETED) and will perform a different T-SQL statements base on COUNT(*) being 1 or greater than 1. I always thought that triggers fired for every record in a INSERT, UPDATE, DELETE transaction. If so, there should not be more than one record in neither table (INSERTED & DELETED). That much depends on what you want to achive within the trigger you will have to know that the Inserted / deleted tables exist in ...Show All

• Visual Studio Express Editions C# codes

  hi, where can i find small C# prgrames (questions and solutions) for practising hi, this thread has many links http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=448078&SiteID=1 hope this helps ...Show All

• .NET Development RegEx replace question

  I have no regex experience, so this is probably pretty easy. I have this string: //33// CD23//2D //48// and it should like like this: ! CD23//2D 0 What I need to do is replace the bolded values with the char equivalent, so "//33//" would replace to '!' and "//48//" would be 0.  I'm using "//" as my int seperator, but the only time i need to replace would be if there is an int value between the two that would resolve to a whitespace or printable ascii character. Just hoping RegEx would be faster than looping through the string characters. (This is due to Base-64 string restrictions). Thanks. ...Show All

• Software Development for Windows Vista Pause a workflow

  Hello, Is it possible for the host to 'pause' a workflow's execution at the completion of a specified activity and then resume execution from that activity I know one could define special activity types within the workflow that listen for external events and effectively pause the workflow in that manner, but I'm thinking of the more general case, where the workflow is not specifically designed to wait for external events. I'm primarily interested in a sequential workflow but would also be interested in if this is possible with a state machine workflow. Thanks, Notre Thanks for the reply Paul, but ...Show All

• Visual C++ converting c++ stl strings --> Tchars? (NO MFC)

  How would I go about doing this Thanks! Maybe there is no need to convert something is the program is not UNICODE and you are using std::string ot it is UNICODE and you are using std::wstring, You can use the ATL. (USES_CONVERSION, A2T). You can use the CRT mbstowcs, wcstombs. ...Show All

• Visual C++ How do you start it up????

  #include "stdafx.h" #include <stdio.h> int main() {  printf("hello world");  return 0; } okay i got this written in Visual Studio C++ Express Edition Beta2. How do i start it up please tell me the steps i need to do. Thank You i never wanted to fight with people online but u (Mr. Brian Kramer) made me very mad. how do u know i know everything eh You dn't knw anything about me! You think i'm testing others how much they know wow u sure something. Is there wrong with a 14 yr old kid that lives in japan to question others in MSDN If u think this is a lame question for others why don't you look in the book store in japan ...Show All

• SQL Server Failure Audit: Login failed for user ''. The user is not associated with a trusted SQL Server connection. client (xx.xx.xx.xx)

  Hi, I am working on September CTP.  After I attached the required database when I try open the pages thru web in a app-web-db architecture, everything is working fine and there there are no problems at any place. But when I try to run microsoft ACT script which involves testing my application for scalability, I am getting an error in DB server saying "Login failed for user. The user is not associated with a trusted SQL Server connection. client [xx.xx.xx.xxx]".  This error comes as soon as I start my ACT script and wont repeat further in my test.  Thought this error is coming, it is not creating any problem as once the er ...Show All

• Visual C# import CSV file

  I need to import csv file to SQL tables with c# application. User can select columns band table mapping table fields. I like to create something similar to MS SQL import. User can draw line to two mapping column and fields. How I can do it in C# window application Which controls I need hi, you can find some examples here http://www.codeproject.com/csharp/#Graphics hope this helps ...Show All

• Audio and Video Development SDK Media Foundation Sample doesn't work on Vista Beta2?

  I built Feburary CTP SDK's sample BasicPlayback(MF_BasicPlayback.exe) with Visual C++ 2005. However, this sample doesn't work on Vista Beta2. The operating system prompted me that "Could not initialize the player object (HRESULT = 0xC00D36E3)"  Has anyone experienced the same thing Is there any solution Hi Becky Thank you for your detailed explanation and solution. I have downloaded the Beta2 SDK and rebuilt the sample. Now it works fine! ...Show All

• SQL Server Row Number Tranformation

  I have looked to no avail... Anybody see a dynamic way to set the seed in the Row Number Transformation I do not see any expressions property and the only property that takes a variable is the FINAL number... I would have though that a very common use would be to get the maximum IDENTITY from a table and use that value (after adding one) as the starting number for the rows being imported... See if this help http://www.sqlis.com/default.aspx 93   ...Show All

• Visual Basic Sharing classes across projects

  Hi, Here's my problem: I create one project that uses two classes and another project in another solution that uses the same two classes (as links from the *one* version of the source in the other solution). Now, I am trying to set variables via properties in an interface that is referenced from a DLL from both solutions. But when I actually do: ClassThatImplementsInterface.MyProperty = MyObject I get an "unable to cast" exception. I believe this is because each solution (and the interface) does not use exactly the same version of my class. they classes in each solution and the interface have the same source code, but are comp ...Show All

• Visual C# passing string variable from form1 to form2

  How can i pass a string that i got in form1 to form2. Thanks.. ok..i got it.. just declare public static string v_val; //v_val is a string variable and fot the form2... just call it with, let say: textBox1.text = Form1.v_val; Thanks... ...Show All

• Visual Studio Express Editions Visual C# Express Edition Installation

  Hi, I already have Visual Web Developer Express Edition installed on my pc. I need to instal the Visual C# Express Edition too on the same pc. Can I install this directly or do I need to first uninstall the Web Developer edition and then instal the new software. Can't I have both software side by side Any inputs are welcome. Thanks, Sailesh hi, when you try to download VC# it will ask you to remove all .net products that doesn't mean you cann't have both, i have both on my computer and its running fine, i guess they ask that because vC# suppose to be installed first or something like ...Show All

• Windows Forms dotNet Mdi App and win32 Client Forms

  Hi Everyone, Is it possible to create a dotNet MDI app (C#) and use pinvoke to create win32 client forms   This would mean using the CreateWindowEx function and possibly sending over the dotNet parent Handle.  If you can do this, what steps should I take and watch out for   For example, do I need to send over the HINSTANCE of the app and/or do&nbs ...Show All

• Windows Forms how to add more panels in splitContainer

  hi, in standart split container is 2 panels divided by splitter, i wnat to add moe panels and more spliters of course, maybe someone can offer something 1. Put a SplitContainer on your form 2. Set Orientation to Horizontal 3. Put another SplitContainer in the lowest panel of the first SplitContainer (Panel2) 4. Set its Orientation to Horizontal If you don't want one of the splitters to move, set the SplitContainer's IsSplitterFixed property to true. ...Show All