DanR1's Q&A profile

• Visual C# Debugging Tools

  Hi I'm new to the C# area. Please can someone let me know what tools i can use to monitor what resources the application uses, what class/procedures are using up a lot of CPU/memory. Events being fired off. Please let me know the tool Where i can find it What it does Thanks in advance There is limited support for code profiling in the following editions of Visual Studio 2005: Visual Studio Team Edition for Software Developers Visual Studio Team Suite See Visual Studio 2005 Team System Editions Comparison . I don't know if there are some free profiling tools available to the community but considering the complexity of the .NET Profiling API this doesn't surprise me. ...Show All

• Visual Studio Team System Unable to check in when Solution Explorer is open

  One of our developers is having trouble checking in a file when the Solution Explorer is open. (When he invoke "Checkin pending changes, the file in question is not listed) However, when he closes the solutions explorer, he is then able to check the file in. Any idea how this could be Thanks, Maggie It is a toolbar button in the Pending Changes toolwindow (or Pending Changes dialog) that is just to the left of the workspaces combobox. It can be toggled on or off. --Ben Ryan ...Show All

• Visual Studio Express Editions please help me

  i want work project finger print useing vb how,where start you need to explain ALOT more than that. what exactly do you want to do from what I understand you want a finger print reader app correct it requires access to your finger print reader device. you also require to interact with it via SDK or some dll API calls. ...Show All

• Visual C# Disable automatic refactoring

  Hi, I'm working on a rather slow computer and have no real use of the refactoring function right now. When designing in the class designer it goes through the entire project for every change, which takes long time. Is there a way to turn off automatic refactoring Best regards Carl BTW, I was finding refactoring to be distruptive to my workflow, but Karen is correct. If you turn off "Warning when build errors exist", you might see various indications for a few moments at a time, but code editing is not distrupted, and everything runs smoothly. Thanks Karen. ...Show All

• Microsoft ISV Community Center Forums Access Doesn't Close after ActiveX is inserted

  I've created an ActiveX control to be inserted in an Acces Form. This Control uses data from the database (file.mdb) where it is inserted and from other .mdb files more. Everything works well except that when I try to close the application the database is closed but a empty Access Widow stays opened (and it is not possible to close except using the TaskManager). Does anybody knows why it is happening and how to solve it If it could help...I think that the problem came from the use of DAO objects. The ActiveX control uses the object Workspace (workspaces(0)) and Database (CurrentDb) given by the access aplication, more objects Databases (in the same workspace) and recordsets to access the other .mdb files. The Access aplication us ...Show All

• Internet Explorer Development Microsoft FrontPage 2002 (IFPMarkUpServices)

  How do i use this interface (IFPMarkUpServices) in the context of VC++ in MFC Dialog based application for Microsoft FrontPage 2002 Eg. How do u remove an active element from a page window   PS: Is there also any documentation for this interface read the The Annotator Sample for the usage of IMarkupServices. This code sample may be useful as well. ...Show All

• Visual Studio Tools for Office Bookmarks alternatives?

  I'm using VSTO 2005 to write a Word 2003 customization that uses bookmarks to remember specific document ranges between sessions. Even though I'm using hidden bookmarks, it seems like there must be a better way to do this. Roughly, my customization creates hidden bookmarks when my users highlight a part of their document and click a button I've created to store special structured annotations about the text they've highlighted. The annotation object stores the name of the bookmark, and when the annotation is clicked, the bookmark is selected. One problem (among other limitations with bookmarks) is that the users can still check the "show hidden" box and delete my hidden bookmarks. Is there another structure that functions like ...Show All

• SQL Server Access functions to SQL Server

  I'm upsizing MS-Access to SQL Server 2005. I need to convert the following functions: TRANSFORM PIVOT FORMAT MID Are there any similar functions in SQL Server Also I have a query as follows: SELECT Mid$ ([AccountNumber], 3 , 8 ) AS [Account#], Format ([checkamount]* 100 , "000000000" ) AS Amount, IIf ( IsNull ([statusdate]), " " , Format ([statusdate], "yyyymmdd" )) AS [Date] FROM tblResult; How do I convert this in SQL Server query Hi, SELECT SUBSTRING ( [AccountNumber] , 3 , 8 ) AS [Account#] , RIGHT( '000000000' + CAST ( [checkamount] * 100 AS VARCHAR ( 9 )), 9 ) AS Amount , ISNULL ( CONVERT ...Show All

• SQL Server sql datatypes

  i hope this is the right board for this. i want to have a table for members of a club/society and i wnt to be able to maintain the structure of their member id numbers, eg com212 for a committee member, or mem019 for ordinary members. is there a way to automate this using some sort of auto-incriment function and use this as the primary key for the table thanks in advance, mark Hi Mark, Please see the below code for creating the table and stored procedure. Create Table Members(MemId Char(6) Primary Key,MemberName Varchar(100),Age Int) Go Create Procedure spMemUpdate(@Type Char(1),@MemberName Varchar(100),@Age Int) As Begin Declare @Id as Int Select @Id=isnull(max(Cast(right(Isnull(M ...Show All

• Visual Studio Tools for Office Getting Outlook 2003 Contact Items into a DataSet

  Hi: I'm using VSTO developing Outlook 2003 add-in. Wonder if there is any efficient way to have all Contact Items (and other such as mail, appointment, and task items) be stored into a dataset Or the only way is to iterate all items in the Contact folder and add into the table row by row. Thanks in advance. Hello Jan, as I kno - there is no other way. However - In Outlook 2007 there is a Tableobject that maybe could be faster - havn't tried yet. Also you could try to use CDO (not recommended) and if You have an Exchangeserver, you could fetch your data directly into an DataSet by using WebDAV. Or - You could use an SQL Server to link the Exchangeserver directly into an SQL -Table. If all ...Show All

• SQL Server first form normalizations and second form normalization

  Hi everyone, What is the main difference between first form normalizations and second form normalization In my opinion, they are both generated for the same operation which is to prevent redundancy(in other words; duplication of data in several records). So would you please explain it to me Thanks Taken from: http://databases.about.com/od/specificproducts/a/normalization.htm First normal form (1NF) sets the very basic rules for an organized database: Eliminate duplicative columns from the same table. Create separate tables for each group of related data and identify each row with a unique column or set of columns (the primary key). Second normal form (2NF) further addresses the concept of removing duplicative data: ...Show All

• SQL Server Two Dimensions Sharing same Parent Table

  Hi, I have a serious problem when I explore my Dw Model. I have one Fact table and Two Dimensions: Brand Dimension and Department Dimension. Both Dimensions share at Top Level Company Attribute. The Schema is like this : Brand Dimension : Brand (Brand Table), Brand Group(Brand Group Table), Company (Company Table) Department Dimension : Department( Department Table), Department Group(Department Group Table), Company (Company Table) Almost forgot..The Company attribute is present on all tables because is a key member. At this point everything was ok. But when I started to explore on AS (Browser) my problems has just started. I realize that, for AS, the Company attribute is not the s ...Show All

• Visual Studio Rename projects in multi project template

  Is there a way to have multi-project templates rename a few of the projects names I tried $safeprojectname$ and it didnt do anything, even with replaceparameters = true. Is there a way around this A hack or addin way of changing the names Thanks you, Corby Nichols Houston, TX Unfortunately, we do not have a way of renaming projects when rendering multi-project templates. The best thing that you can do is to create a wizard extension that captures the appropriate callbacks and rename the project at that time. Craig ...Show All

• SQL Server problem with recursive cte query

  I am running into 2 problems with this cte query. First off, it's not returning the results in the right order. What I mean is that, as you can see from the graph, the first row (tabid=4) should be followed by rows 3,4 and 5 but it's throwing in a row between. No matter how I try and order the results, it's not working as it should. The tabindex field is a user defined field as to what order the tabs should show up for the user so I have to order by that field at some point. ParentTabId TabId Title Link TabIndex 1 4 Personal Info /Employee/employeeAdmin.aspx 1 1 5 Employment Info /Employee/positionInfo.aspx 2 4 8 Dependents /Employee/dependents.aspx 3 4 169 Emergency Contacts /Employee/Contacts.aspx 2 4 170 Demographics /Emplo ...Show All

• SQL Server Need help in migrating from Access to SQL express

  Hi there, I am totally new at SQL/SQL express.I have downloaded the sQL express server and wanted to know how i can go about exporting my tables which i created using MS access into SQL express. Also my application is currently working by using Access and ASP...what will be the changes i would need to incorporate in my code other than the queries and Data connection string. How would the data connection string in SQL look like if i am using it in my asp code Any help or useful links would be a very good help! thanks in advance smita Try the SQL Server Migration Assistant. http://www.microsoft.com/downloads/details.aspx FamilyID=d842f8b4-c914-4ac7-b2f3-d25fff4e24fb&DisplayLang=en ...Show All