azzyford's Q&A profile

• Microsoft ISV Community Center Forums Comparing and filtering data in Excel?

  I’ve been given the task of comparing two sets of employee data, both of which are in the same layout/format, and am required to filter out those which are duplicates i.e. should leave only new starts. I have been told that a Vlookup function can be used to achieve this but don’t know how it can Would this be easier to accomplish using VBA If yes, could I have a brief structure of the code required To elaborate, the spreadsheet contains a unique employee ID and other details such as department, manger, email, etc. One set of data is from the previous months upload and the other is the latest data pull. I need to compare this months data with last months and see who is present that wasn’t before. Any help is much appr ...Show All

• SQL Server How can I extend the number of characters in MS SQL for text entry?

  Using MS Access as a front end and SQL as a back end how can i get past the 4000 character limmit per table Thanks so much that worked fine. I am a newbee to SQL 2005 or SQL for that matter. got it working. I am posting another question how do I link tables in SQL 2005 is there a paper on this out there I am using access beta 2007 and the linked tabel feature is greyed out ...Show All

• Visual C# report generator program

  I have a report generator program and I want to do the following.. Each report is a DLL or EXE (standalone) file) The user will add the report and assign the DLL or EXE file. The user will select the report from the report generator which will run the DLL or EXE to generate the report.. This way, I make sure I don't have to modify my report generation application.. what do you think and how can I have the standalone DLL or EXE ...Show All

• SQL Server Can the data tables in SQL Express database be printed out?

  Hi, is it possible to print out the data tables If, yes how to go about doing it how to print 1 table per page In my case having a hardcopy of the data is suitable than viewing it on the computer. Is there some way/method of printing out my data Like transfering to a .txt/.doc/.xls file than print from there ...Show All

• Commerce Server MarshaledData

  Can anyone help me understand what is and what is NOT in the MarshaledData Columns I am new to Commerce Server and am helping a client with PCI compliance. In a given table (i.e. CreditCardPayments), are the columns in that table also in the MarshaledData Column Is that column only for properties that are not mapped to columns in the table Is it only for WeaklyTypedProperties Are no StronglyTypedProperties in the MarshaledData Column Are StronglyTypedProperties in the MarshaledData Column if they aren't mapped to a column in the table MSDN indicates that WeaklyTypedProperties are stored there but doesn't say if that's all that's stored there ( http://msdn2.microsoft.com/en-us/library/ms944263.aspx ) My client is using CS 2007. Tha ...Show All

• Visual Studio Team System database dropped

  Ok I'm new to VS for DB and Im a little confused. I created a new project with the help walk through and added an existing schema (myserver.FIRS3) to it. I even check the stuff into visual source safe. I even deployed it. Thats where my question comes in. Does it deploy to the "target database". I assume so. Where does the local database come in I have SQLExpress installed locally. My existing DB was called FIRS3 and the walkthrough create FIRS3_(a big ass number) locally.  After changing the target database (in project properties) to my local express database I have somehow dropped it because it doesn't exist. Now I can't even build becuase the FIRS3_(a big ass number) database doesn't exist. Help! Paul ...Show All

• Visual Studio Release Dates

  Hi, I want to Release Dates of Visual Studio.net 2002 Visual Studio.net 2003 Visual Studio.net 2005 and the related .net Framework Versions. Please provide me the links for proof (from Microsoft site), i tried to find, but couldn't find it.. Thanks The general rule with Microsoft products is that mainstream support is retired 5 years after the release and extended support is retired 10 years after the release. This does change from time to time depending on when the follow product is released. For more information on product lifecycle dates take a look at this site . As for the versions of Visual Studio and .NET Frameworks... Visual Studio 2002 which included .NET Framework 1.0 Visual Studio 2003 which included .N ...Show All

• Software Development for Windows Vista How to turn off Compressed Folders in Vista

  Does anyone know of a 'sanctioned' way that an application can tell Vista to treat Zip files as files and not folders. Earlier versions of Windows allowed you to unregister the zipfldr.dll but Vista produces an error that the entry point DllUnregisterServer was not found. Hello cshea, I would recomend posting this question in the TechNet Vista Forums located here http://forums.microsoft.com/TechNet/default.aspx ForumGroupID=204&SiteID=17 as the MSDN forums are geared more towards developers. Thanks! Matthew Braun ...Show All

• .NET Development ASP.net C#, sending email error-the client was not authenticated.

  Hi, everyone: Hope I can get some help here. I've been working on this problem for two days and checked all the resources, but no luck. I'm a beginner of ASP.net C#. and recently working on an application try to send out emails. Below is my code and error message I got: (I used system.net .mail) ///////// code in web.config < add key = " MailServer " value = " 68.142.198.11 " /> < add key = " EnableErrorLogEmail " value = " false " /> < add key = " ErrorLogEmail " value = " XXX@sbcglobal.com " / > < add key = " ProductsPerPage " value = " 6 " //////code in utilities.cs public static void SendMail( stri ...Show All

• Visual C++ why ok with istream but not with ostream?

  Hi there, In my program, I define a class Mytype. In order to make cin>> and cout<< availbe for Mytype objects, I include iostream and declare ostream& operator <<(ostream&, const dvariable&); istream& operator >>(istream&, dvariable&); But the combiler, visual studio 2003, seems not recognize ostream at all and gives a lot of error messages about the line with ostream, eg, syntax error: ',', 'int ostream': redefinition, syntax error : missing ';' before '&', etc., while the line with istream is fine. Any suggestions are appreciated. rich judging by <iostream.h> you code uses pretty old staff (iostream.h expired like 5 years ...Show All

• Visual Studio 2008 (Pre-release) FatalExecutionEngineError after Lambda.Compile()

  Dear Linq, I compile a LambdaExpression and call into it. On one machine, executing the compiled code causes FatalExecutionEngineError, on another, the app just dies with "The app has encountered a problem" message. The exception cannot be caught. This occurs with Linq version May 2006 CTP: Microsoft (R) Visual C# 2005 Compiler version 8.00.50916 for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727 Any ideas Thanks, George using System; using System.Reflection; using System.Expressions; using System.Query; class Crash2 { public static void Main() { try { Expression<Func<DataReader,int >> lambda = BakeLambda(); Console.WriteLine("Before compile"); Func<DataReader,int > comp ...Show All

• Visual Studio Team System Extraction/validation Rule Code

  Is there anyway we can get coded versions of the built in extractio/validation rules I am writing some custom extraction rules and mine are only slight changes to the build in ones so it would nice to not have to write all of the code. VB code would be cool, but C# is fine now that I found a working convert. http://www.dotnettaxi.com/tools/converter.aspx Thank you to the person here who posted it!! ~Todd you can find some detailed information about creating a custom extraction rule on the following site http://blogs.msnd.com/joshch as far as parsing out your text goes: Here is an expample of looking for a tag with a specific attribute. Then grabbing the value from one of the attributes and parsing it t ...Show All

• Visual Studio Is there any way to automate the data repository mappings?

  Is there anyway to automate the mapping of the stored procedures to the business entities rather then going through the data repository wizard Hi lcj, This forum is for GAX and GAT specifically, if you have questions about any of the factories released by p&p you will get better luck by posting directly to each factory forum, Services Factory one is at: http://www.gotdotnet.com/codegallery/CodeGallery.aspx id=6fde9247-53a8-4879-853d-500cd2d97a83 thanks, -Victor. ...Show All

• .NET Development Validation of webservices

  Hello everyone! I'm new to web services and I have a question I hope somebody can help me with! I developed a new web service to deal with my Car hire software and made several procedures that accept parameters. My question is, how do I determine that the parameter I have in the procedure which is of string type, will accept only six characters Of course this is just an example. In general, how do I validate my procedures' parameters Thank you! <WebMethod> _ Public Function InsertintoRes( ByVal SupplierCode As String , ByVal ClientName As String , _ ByVal CountryOfOrigin As String , ByVal Group As String , ByVal ResPL As String , ByVal CheckOutDate As Date , _ ByVal CheckO ...Show All

• Windows Forms How to determine which windowsform control is about to receive focus

  If a user is currently editing a cell in datagridview and then clicks on a button or hits the hotkey combination for a button, how do I tell before leaving that cell which button control will get focus once focus leaves the cell. There must be some property that I can read that keeps track of this without me having to triangulate the mouse position when the click occured to determine the button or trap the keyboard keys. Thanks for the help, Jim I think it would be easier to answer your question if we had a better idea of how you're going to use that information. Can you describe an example ...Show All