hali1's Q&A profile

• SQL Server Get Analysis Services Version string in c#.net 2.0

  Hi I want to get the version string for AS 2000 and 2005 in c#. Can I use the same object model to connect to both or do I need one for each. I saw a reference to DSO 8.5 which implied you could. Either way could you let me know what DDL I should reference in Visual Studio. Thanks Steve If you are using Microsoft.AnalysisServices.AdomdClient then you can use AdomdConnection.ServerVersion property to obtain textual representation of the version. If you use System.Runtime.InteropServices.Version object then you can construct one to parse such things like major and minor numbers. It works for AS2005 and AS2000. ...Show All

• Visual Studio Tools for Office VSTO processing many files

  Hi All, I'm new in VSTO and I'd like to use it to automate some tasks in .DOC and .XLS files. According VSTO documentation, "a managed code assembly is attached to a Word document or Excel workbook." So, what does it mean Is not possible for example create VSTO app to interact / process many .DOC or .XLS documents My scenario is, I have thousand of .DOC and .XLS files and I'd like to create a solution to open each file and make some changes. How can I do that Thanks, Armand Based off what you're saying you want to do, I would implement this using the standard Word automation interface, via the programming language of your choice ... The VSTO binds a managed solution to a particular template/d ...Show All

• Smart Device Development Help Modifying the Entry Point Property

  I'm modifying my projects Linker properties in an attempt to write a driver. Under Linker and in System, the Subsystem and Driver properties have a drop-down menu that allows one to set these to: Native (/SUBSYSTEM:NATIVE) and WDM (/DRIVER:WDM) However, in Advanced the Entry Point property gives a text box which requires me to type in the entry point function name (DriverEntry). How is this done Do I just type the function name, "DriverEntry", or do I type in "/ENTRY:DriverEntry", or is the syntax similar to the two above and I need to type in "DriverEntry (/ENTRY:DriverEntry)" ...Show All

• Windows Forms Appending rows to a bindingsource?

  Bascially, Im tring to catonate to a bindingsource. Im tring to display all rows from two different tables with a very similar table definition. So I want to load all rows from table a, then add all rows from table b ( using a query of course ). How can i do this thanks, -stellar Hi, You should use Merge method from DataTable or DataSet as per your need. Here is an example, private void MergeTwoTableAndDisplay() { SqlConnection conn = new SqlConnection (); conn.ConnectionString = "data source=localhost;initial catalog=Northwind;integrated security=SSPI;persist security info=False;packet size=4096" ; conn.Open(); SqlCommand cmd = ...Show All

• SQL Server sql problem

  hi, i want to know how to do that: table: costtypes fields : typecode values: amount, vat, duty, table bills: fields:  billid, costtype, amount value bi1      amount    1000 bi1     vat               10 bi2    amount        200 i need to create a view that will display amount, vat, duty as fields. note that these are values in the table. so that i will have billid       amount     vat     duty bi1          ...Show All

• Smart Device Development Makecab Umlaut character problem in filename

  Hi, I wrote a project which will download a cab file from the web and extract (extract utility) and replace the files on the local machine. So before replacing the files I make a cab of the old files with makecab utility. For this i use a ddf file and makecab with the option /f and the ddf filename. The problem is that whenever the file name contains any umlaut character the makecab displays an error file cannot be found. But if i save ddf file again in ASCII format and then try making a cab it works. But i cannot do this as certain characters cannot be represented in ASCII and i cannot avoid the umlauts as I am working in germany, where umlauts are comman. Is there any solution to it. The project is in VB.Net 2005. Thanks ...Show All

• .NET Development Sql server 2005 ==> 1000 times slower than sql server 2000 ! WHY ?

  I'm using the developper edition of sql server 2005 with VS2005. Sometimes it works very very slow. I don't know why ! The processor is at 5% but the execution blocks at adapter.Fill(ds). This is the code: public static DataSet GetDataSet( string sql, params SqlParameter [] parameters) { SqlConnection con=GetConnection(); using ( SqlDataAdapter adapter= new SqlDataAdapter ()) { using ( SqlCommand command= new SqlCommand (sql, con)) { foreach ( SqlParameter p in parameters) { command.Parameters.Add(p); } adapter.SelectCommand=command; DataSet ds= new DataSet (); adapter.Fill(ds); command.Parameters.Clear(); con.Close(); return (ds); } } } Is ...Show All

• Visual C# Cost for Moving controls from one form to another

  My project used some third party code for docking control. I need to close all the opened documents when I changed the document style. For me, it is very expensive to do close->open. I wonder if I can move all the control (mainly an OpenGL rendered control) from the form to a new created form with the right style. I want to know if there is a better way. Thanks. I hope I understand what you are talking. You are talking about moving one control to the other form in design mode , right May be you can consider writing macro in the visual studio environment to help you easy your task. Or you can try some other 3rd party productivity tools like MZTools. ...Show All

• Visual Basic Browse Network place only, howto?

  How can I set my openfiledialog just to open My Network Places(shared) Local Directory not included. If you have the sample code it'll be nice thanks kimble..My computer doesnt appear on openfile dialog! I open "My Network" on openfiledialog, click "Entire Network", click "Microsoft Windows Network", click <group name>, and then my computer not show up How can I view my shared folder when I can't find my computer. How about you does your computer show up ...Show All

• Visual Studio 2008 (Pre-release) CollectionView, Filtering, and INotifyPropertyChanged

  I have a ReadOnlyObservableCollection, and in that collection is a list of objects that implement INotifyPropertyChanged. I am binding to the read-only collection with a CollectionView, which has a filter set up to filter out some of the items. Although filtering items that are added or removed to the underlying list works just fine, items that are updated are never re-filtered, though the PropertyChanged event is indeed firing. Is there a way to force a specific item to be re-filtered I am not able to merely refresh the entire filter, as that is a performance hit that is very noticeable in my application. To update the filter of a collection view, you need to clear out the old filters and add them back in ...Show All

• Smart Device Development Display username from phone book to my own application

  Hi,   I am new in using C#. I am write a program for WM 5.0 pockect PC .I would like to display username on to the listbox from phone book to my own application using C#.   Thanks     thanks   I have already download the sdk file but i still an error. there the error: Error 1 Metadata file '..\..\..\..\..\..\..\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\PocketPC2003\Designtimereferences\Microsoft.WindowsMobile.PocketOutlook.dll' could not be found C:\Documents and Settings\Studadmin\My Documents\Visual Studio 2005\Projects\DeviceApplication8\DeviceApplication8\CSC IncomingCall May i know how to do it   ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Humorous but somewhat serious question about XNA

  Microsoft has claimed the Nintendo Wii as a "kids toy;" however, if XNA can produce graphics and push performance up to what the Wii is capable of handling (games like Half-Life, Sims 2 from most XNA performance claims), does that mean that XNA is a kids toy too True, however, now that you have all this extra free development time to further enhance the world, your game reviews will go downhill on performance :) It's just something to watch out for although you've been sold with all the gained benefits.  ...Show All

• Visual C# Code convention

  Hello, As a development team leader I have a difficulty to exlpain logically the following case: We write code in c#, designing classes that will hold data(stored in SQL DB). Let's say for example a class which will hold the DB user information. The DB table will hold the followin columns: [UserID],[UserFirstName],[UserLastName],etc... Now the class will hold the following properties: UserId,FirstName,LastName. The question is why using "UserId"(as the property name) and not just "ID" like any other native objects in the .net framework Thanks, Itzik Paz. UserId is more descriptive of what the field actually is.  Id is short for Identifier, and could be an identif ...Show All

• SQL Server Equivalent of DTSStepExecStatus in SSIS

  Hi, I am migrating a dts package into SSIS.The dts package has a dynamic property to set the execution status of a data pump task in the package. the dts paskage is setting the DTSstepexecstatus of the datapumptask to 1 or 3 ie waiting and inactive. The dynamic property cannot be migrated to SSIS. May i know any equivalent property in SSIS to DtsStepExecStatus property of Dts. Thanks in advance Neethu You can use expressions on precedence constraints: set some variable in the script task to true/false, connect the script task with the data flow task with precedence constraint, double click the precedence constraint, select expression and enter the @varName ...Show All

• Software Development for Windows Vista State workflow with custom data tracking....

  Hi, Our current application is windows a service based implementation of a business problem having various states. We want to port to state workflow as the model is suitable to implement in real workflow. so we have designed a state workflow having all states. Each state would listen to some external event or has state initialization activity that does automatic checking of some parameters and changes the state to next state. In our original application , we have a logging mechanism that logs almost every activity in DB for future analysis. Since we want to port to WF, can someone tell me how should we port WF activity tracking with our logging mechanism so that we can get all those data associated with WF state and WF activity We wi ...Show All