Ohad Oz's Q&A profile

• SQL Server Deleting a database

  I would like to delete a database from Analysis Services from the command line, but I have been unable to find a way to accomplish this. Is there a utility or a script that can accomplish this Hi In MSAS 2k ,You can a write a VBSCRIPT using DSO object in DTS for deletion of OLAPDB.Then run this DTS from DTSRUN "DTS Package name" from commnad line. Thx and regards Pankaj ...Show All

• Visual Basic fileter one dataset into another dataset

  HI, I am trying to filter one big dataset into another dataset based on some criteria such as employee number. I know I can use the datatable.select function, but the function give you array of tablerows and how can I put those datarows into the second datatable can someone show me some sample code Thanks First, select just the rows you want in your datatable by your initial SQL, then you can use the DataTable.Clone method. http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpref/html/frlrfsystemdatadatatableclassclonetopic.asp Or if you're using the .Select method then NewDataTable = OldDataTable.Select(...) ...Show All

• Microsoft ISV Community Center Forums printing .doc, .xls, and .pdf files from a list of filenames using an excel vba macro

  Hello all! I'm Jim from Western NY. Forgive me if I have posted in the wrong forum. If I have, just let me know and I'll comply. Here's my question: I am wanting to develop a macro for excel which will read (from a worksheet) a list of hyperlinks to pdf, .doc, and .xls files and print them using the appropriate application ( acrobat, word, excel). Theoretically, I know I would have to use some kind of for-next and/or case structure but I don't know how to implement it. Someone has helped me get started, but the code I have (predictably) only works for Word documents: Sub PrintDocuments() 'Must set a reference (Tools ...Show All

• Visual C++ _itoa "identifier not found" once ported to VS 2005

  I have recently installed VS 2005 and loaded my VS 2003 project. I quickly realized that I needed/wanted to define "_CRT_SECURE_NO_DEPRECATE" bc I need to be up-and-running with a clean compile fairly soon. After adding the underscore to many of my string related calls, my only remaining problem is with four existing _itoa() function calls. I get the following compile errors: error C3861: '_itoa': identifier not found Sure, it seems that I have just forgot to include stdlib.h, but of course this is not the case as this is old code. What am I missing I have even created the simplest of VC++ Win32 test programs and adde ...Show All

• Visual C# abstract/virtual events

  If you have an abstract base class which has an event that children may implement, and none of the base class methods connect or raise the event, then what's the difference between declaring that event as either abstract or virtual I can't find much of anything in the docs about abstract or virtual events. An abstract method declaration provides no actual implementation, there is no method body; the method declaration ends with a semicolon no braces ``{ }''. public abstract void MyMethod(); The implementation is provided by an overriding method which is a member of a non-abstract class. Vi ...Show All

• Visual Studio Express Editions Convert BitArray to byte[]

  A question for those that, for one reason or another, have ever had to deal with binary on a Commercial Project. Converting a Byte into its Binary representation is done as follows: BitArray Name = new BitArray (byteobject); The BitArray can then be indexed to work with the data and process it. However when trying to put the data BACK INTO THE FILE, a problem arises. BinaryWriter Streams only accept bytes and other data to be written to the data stream; Converter Class DOES NOT have any method which accepts a BitArray; BitConverter Class also DOES NOT have any method which accepts a BitArray; So, if one wante ...Show All

• Visual Studio Express Editions SOS:VC2005 B2 Express VC++ Directories Problem

  I downloaded and installed VC2005 B2 Express, I can't set "VC++ Directories". screenshot: http://member.netease.com/~lilong/temp/VS2005ExOpt.jpg is this bug this is a BIG PROBLEM!! How about removing C++ Beta2 ane replacing it with Beta1   Will this work   I am thinking about trying it.   ...Show All

• .NET Development unable to consume web-service on .NET2005 (though its working in 2003)

  hey, i have a problem consuming a web reference on the VS.NET2005, im getting errors refering to- Reference.map Settings.settings the errors are about not recognizing elements in the namespace. this is weird because i succesfully comsumed this WS in .NET2003. any ideas naama Please post this in the WebServices forum. There could be some changes and there may be some workarounds. In any case the web services guys are the right people to help. In the mean time, it does not hurt to be ready with a netmon trace. http://blogs.msdn.com/dgorti ...Show All

• Visual Studio Team System Single FxCop project for Debug and Release Assemblies

  Hello, Is it possible to have just one FxCop project that will work with both my Debug and Release builds NUnit has a capability like this. Thank you for your help, Hi, If you open the FxCop ui and rightclick on the assembly to analyze, you get a dialog where you can replace the physical path of the assembly to a path with environment variables. The only problem when you do this is that if you have exclusions against code that only exist in one flavor of your assembly, you will lose those exclusions if you save your project opened against the other flavor. Regards, Jeffrey ...Show All

• Visual Studio Is there documentation for the T4 engine somewhere?

  Inquiring minds want to know. Hi Aaron, What level of documentation are you looking for Currently we don't really have any documentation for any aspect of the DSL Tools apart from the walkthrough documents.  Rest assured, our User Education team are working on remedying this as soon as they are able. However, there is a fairly comprehensive description of the T4 syntax on my blog at http://blogs.msdn.com/garethj/archive/2005/06/01/T4Syntax.aspx I note that this isn't googlable using the keyword T4 as I always refer to it as "Text Templating" in print.  I'll put up an entry to try and remedy t ...Show All

• .NET Development peer-to-peer connection

  hi i want a example that shows peer-to-peer connection As Durga notes, please detail the functionality you are looking for. We are currently considering adding further P2P support to System.Net - I am interested to hear about your scenario. ...Show All

• Visual Studio Express Editions how to limite data displayed in a listbox?

  I have a listbox "listboxServices" and an ACCESS db table "services", when i set the listboxServices' databinding to the default dataset, the listbox will show all the data in the services table. Instead, I want to list all services that have a null value in "DatejobDone" column in table "services" (i.e. all pending services). please help. btw, I created a new query for table "services" ---- "FillByPendingServices(), GetDataByPendingServices()", the sqlquery is something like : "SELECT ............ FROM .......... WHERE DatejobDone IS NULL " but no idea if it's what ...Show All

• Windows Forms Design a wizard

  Hi all, I'm very new to C#, coming from VB.NET. I need to design a wizard inside my application (you know, a long image on the left, "back" and "next" button on the bottom and choosable options on the center). I was wondering... how is this achieved I mean, how to dispose stuff on the form Many thanks! I would create a main form with next and back buttons. For every step, you can create a usercontrol, and have this usercontrol implement a custom interface that maybe looks like this: public interface IWizardStep { IWizardStep NextStep { get; } IWizardStep PreviousStep { get; } void Execute( ...Show All

• Visual Studio can i use inputs and outputs

  I know the inputs, but I do not know the outputs until I'm in the logic of my custom Task. Is there anyway to still use inputs and outputs in my .targets file to control when things will build, or do I need to implement this myself in my Task class Thanks, Mike We have a VS Package that we are developing for our language. The class we inherit from for our project system is ProjectNode. This class has a property called BuildLogger. This is what we set assign our custom Logger to. Our logger is using the following event handler's: BuildWarningEventHandler, BuildErrorEventHandler, BuildMessageEventHandle ...Show All

• Visual Studio Team System Web test failing RequestFailed: The value of the date string in the header is invalid.

  All webtests I run from VS2005 RTM are failing with a response of: RequestFailed: The value of the date string in the header is invalid. The request looks like this: GET /Angel63/sidebar.asp HTTP/1.1 User-Agent : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Accept : */* Accept-Language : en-US Host : 600m01 Cookie : ASPSESSIONIDSATDSCQA=LMGPKPGDJNEPFDPPJKBKILEP Accept-Encoding : gzip I can successfully run the same test using the beta 2 release of VS2005.  The only thing I can see that is different is that the request is slightly different. Request from VS2005 beta 2: GET /Angel63/sidebar.asp HTTP/1.1 User-Agent : Mozilla/4.0 (com ...Show All