freeaaron's Q&A profile

• Windows Forms Using the DataSet designer in an n-tier application

  We've finally converted over to Visual Studio 2005 and .NET 2.0. We're planning out and prototyping our next application. Due to its size and complexity, we've decided to adhere to a strict n-tier design, separating the design from the business logic, and the business logic from the data access logic. We've started looking at the DataSet designer feature of Visual Studio 2005. It looks like it can simplify a lot of the annoying data access code we do for each class. Our question is: is the DataSet useful for building n-tier applications or only 2-tier (designer and data access) Here's a simple example we can use: Customer Class: st ...Show All

• .NET Development Events as References for Garbage Collection

  Do events count as references for the purpose of garbage collection For example, lets say I have to object instances, A & B. A is in scope and contains an explicit reference to B (storing it in a field). B is listening to (consumes) events raised by A. The reference to B in A is cleared (i.e. the field is set to NULL), but B is not told to stop consuming events from A. Is B eligible for garbage collection, or is A still implicitly referencing it in order to notify B of events Hello, Technically, the reference from A [for notification purposes] is to the delegate itself. In your scenario, the delegat ...Show All

• Visual Studio Add-In registration in VS 2005 Beta 2

  We developed Add-In for VS 2005 using Dec CTP and we are registering it according to the new VS 2005 Add-In reg rules: http://whidbey.msdn.microsoft.com/library/default.asp url=/library/en-us/dv_extcore/html/d5c018ff-4dcb-4ff3-9dd4-0a66fa17d593.asp   This worked perfectly fine with the Dec 2004 CTP. But Feb 2005 CTP Add-In Manager doesn't see the Add-In nor the Beta 2 Standard Edition I just downloaded from MSDN Subscriber Downloads. Has anything changed since the Dec CTP Or Feb CTP and Beta 2 don't fully support Add-Ins yet Hi, In my addin file it is already Microsoft Visual Studio, still the problem persists. Any other so ...Show All

• Visual C# How to global a variable in C#?

  Hello! How can I "global" a variable in C# Thank you! the checkbox is in another "private void" thingy I assume you mean the check box event is private.  It returns void.  Your checkbox cannot be void. it can't access another's private void'S variables  No function can access the variables that exist solely in the scope of another function. I take it the check box is on a different form to the text box.  If not, then the code you posted just needs to go into the 'private void thingy' which is the event for the checkbox check.  If it is, then you need to create a delegate. http://www ...Show All

• Windows Forms Possible to specify SelectionStart/SelectionLength on a TreeView label?

  Hello, I have a treeview control, and upon right clicking and selecting an option, one of the nodes becomes editable (I call BeginEdit() on it).  Is there a way to selectively highlight a specific portion of the text before the user gets control Textboxes have a SelectionStart/SelectionLength to facilitate this. I can't seem to find a way to do it with a TreeView.  Any ideas Thanks.  - H Alrighty, thanks. I've only been using C# for about 2 days now, so if anyone feels like trying to tackle this one, let me know... :)  - H ...Show All

• Software Development for Windows Vista More information on ITypeProvider

  Hello, Will the Beta 2 WF documentation be more complete for ITypeProvider   (That is, will it give more documentation, beyond method signatures).  Please see http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=177366&SiteID=1&PageID=1 for further discussion. Thanks, Notre Take a look here for more information. ...Show All

• SQL Server Is this possible?

  Lets say I have an integer value 2002012, I want to convert it to a string so I can cut the value 4 spaces so that it reads 2002 and then convert it back to an int to add one to it. The name of the field is PERIOD. CONVERT(Int, SUBSTRING(CAST(PERIOD As Varchar),1,4)) + 1 Is that possible at all or will I get an error Is that possible at all or will I get an error Give a try, then. It's easy, isn't it ...Show All

• SQL Server Need a function to return a comma delimited string from multiple columns and rows

  Columns in a rows are ClaimID,LineNo, Code1, Code2, Code3, Code4 A claim id can have multiple detail lines. I want to return a comma delimited string for all the codes found for a claim id. I have not created a function before. How do I loop thru a table similar to this While Table.claimid = @ClaimID Set @MyString += Code1 +"," + Code2 + "," + Code3 + Code4 Loop   You do not need a UDF to generate the CSV string. You can use expression below: select Claimid, substring(coalesce(',' + adj_cde, '') + coalesce(',' + adj_cde2) + coalesce(',' + adj_cde3) + coalesce(',' + adj_cde4) + coalesce(' ...Show All

• Visual Basic VB 2005, Cell in an Access Database Newbie question

  Hi, In my program, how can i select values from my Datasource eg. A particular row or column etc etc, for example for a text box to display a single cell's value from the table. Thanks in advance Craig Hi, You'll have to bind the textbox to the datasource of your grid. ex: dataGrid1.DataSource = mydatatable textBox1.DataBindings.Add("Text", mydatatable, "field1")   cheers, Paul June A. Domag ...Show All

• Visual C++ why _tcsrchr and exception are no longer working in VC++ 2005

  when I compiled my code with VC++ 2005, I get following errors: error C3861: 'exception': identifier not found for exception even I include <exception> error C2440: '=' : cannot convert from 'const char *' to '_TCHAR *' for _tcsrchr  Thanks in advance Its very simple: You provided a const char * to the function and you can get only a const char *! The old functions were unsecure and gave a non const * back even if you pass a const pointer into the function. Show us more code. ...Show All

• SQL Server How do I load the Sample SSIS Components?

  Especially interested in the CodePageConvert. Installing the .msi just creates a project folder in my Visual Studio directory. I'm unclear how to get from this point to being able to choose this component from my Toolbox items in SSIS. There was a readme file that talked about gacutil.exe and .snk files that was a above my head. Can anyone dumb it down for me Marjorie, Firstly, you need to compile the project. Right-click on the project and select build. That will place the created assemply (i.e. a DLL file) into the debug folder of the project in the Visual Studio directory. In order to use it ...Show All

• Windows Forms Ambient Properties Question

  I'm trying to make a property of my control act just like BackColor does. Here's the code that I have that's not quite working. Private _AlternateBackColor As Color = Color.FromKnownColor(KnownColor.Control) <Category("Appearance"), AmbientValue(GetType(KnownColor), "Control")> _ Public Property AlternatingBackColor() As Color Get If _AlternateBackColor.Equals(Color.FromKnownColor(KnownColor.Control)) AndAlso Not Me.Parent Is&nb ...Show All

• SQL Server Input column collection in script component?

  Does there exist an input column collection in script component What I mean is that if I have 10 input columns with names: a,b,c,d...i,j Then, within the script component, can I access any column collection such that column[0] has value for column named 'a', column[1] has value for column named 'b' and so on.. Using Row.a , Row.b, Row.c and so on does not give the flexibility to get/set values in a loop. thanks, Nitesh Hi Simon, thanks a lot for your hint with the unpivot function. I never used it before and it works perfect in my situation. SSIS really rocks!!! Thanks, Dirk ...Show All

• Visual C++ 'DWORD_PTR' : undeclared identifier

  Ok, I have seen several others here post questions concerning the problem of getting: error C2065: 'DWORD_PTR' : undeclared identifier ; however, I have not seen any solutions I can use. Has anyone figured out what is going on I have tried the same suggestions that others have made to no avail, including adding <windows.h>, etc. I just installed VStudio 2005 Standard on a machine that I just did a new install of W2K w/SP4, so there is nothing in there that should be fouling anything up. All my stuff from a previous version of Visual Studio is isolated and VStudio 2005 Std was installed into a separate new set of folders. Also ...Show All

• Visual Basic Process Lock Up

  Is there a way to monitor processes to see whether or not they are doing anything, then kill them if not   The reason I need this is that I have .NET dlls that alter Excel Spreadsheets, and I close them down correctly, but sometimes for some reason the EXCEL process will simply lock up and stop the other files from processing.  I want a tool that checks the EXCEL processes and if one isn't doing something, then I want the tool to kill it.  Is this possible   If so, how   I appreciate any suggestions. Thanks, ACFalcon2001 You can use getprocessbyname to get a process object. From this ...Show All