JayPi's Q&A profile

• SQL Server XSL template for multiple worksheets in excel

  I'm stuck on this one. I've got this package working for dynamic output based on an XML statement (yea!!!). It's actually a really simple package that has a few execute sql tasks and an xml task. I pass in a sql statement and get out raw xml that I use in the xml task and I use an XSL file to combine the xml into an excel document. My next obstacle is how to handle multiple worksheets in the same spreadsheet. Given the following code, xsl and xml, what changes would I need to make excel recognize that there is more than one worksheet XSL: <xsl:stylesheet version="1.0" xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:xsl=" http://www.w3.org/1999/XSL/Transform " xmlns:msxsl="urn:sch ...Show All

• Visual Studio Express Editions Listbox items filtered by textbox onchange

  i have a textbox and listbox on a form. The listbox is bound to items from a database. When the user begins to type in the textbox I'd like the listbox items to be filtered onchange as he types. So according to what is being typed the items listbox will lessen according to what matches what is being typed. *This is not an autocomplete function.* Can someone please point me to some sample code to be able to achieve this Thanks ! Here is a bit of code "borrowed" from Herfried K. Wagnor (hope I have his name correct) that will highlite text in a Listbox dependent on what is typed in a Textbox. (I changed that part from his original) It will only highlite the word in the Listbox if it is spelled E ...Show All

• Visual J# creating setup

  I create the program, and now i want to share with other users, how to create setup for my program Yes i'm using Visual Studio 2005 . I have already created program, just i need make a setup for it. Ofcourse i want that user will have just program, that he will not be able su see the code, just use program. Also i want that that it automatically create icon on desktop and in the Start menu. Tell me step step everythink :) ...Show All

• Visual Studio 2008 (Pre-release) XAML/C# Singleton class?

  What is the best way to implement a singleton pattern in XAML/C# Haven't gotten this to run correctly... I guess it's the way the XAML and C# are tied together... You just need to replace the XAML in my example above with: < Window xmlns = " http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x =" http://schemas.microsoft.com/winfx/2006/xaml " x:Class = " Singleton " /> ...Show All

• SQL Server Migrating from Oracle 9i to SQL Server using SQL Server Data Transformation Services

  Hi, I am new to DB migration and we are migrating our DB from Oracle 9i to SQL Server(sitting in a shared environment 1) Is it possible to migrate it using SQL Server Data Transfornation services. Our DB has only indexes and tables as the queries are handled in the front end itself. 2) If yes can we connect to an oracle server using SQL Server  DTS. Do we need an oracle client also to be installed in the system from which we perform the migration task. Has MSN provides an OLE to connect to an Oracle Server though an SQL Server client Can some one list me the steps and the concerns that should be addressed    I am only a front end programmer. Please give me your suggestions       ...Show All

• Visual Studio Team System Start Date and Finish Date on Tasks

  There does not appear to be a way to enter values for these two fields. How doe the start date and finish date get populated into a task You could always go into the work item type, and modify the type to allow you to edit those fields. Currently, those fields aren't editable (as you have seen). Otherwise, you are correct, the only way to modify them is to open your work items in Project, make changes there, and then synch back up. ...Show All

• Visual C# map DLL functions in C to C#

  Hello, Here are declerations of DLL functions with defines in C: #define PV_PTR_DECL * #define PV_DECL __declspec(dllexport) __stdcall typedef unsigned short rs_bool; typedef char PV_PTR_DECL char_ptr; typedef short int16, PV_PTR_DECL int 16_ptr; typedef void PV_PTR_DECL void_ptr; typedef void_ptr PV_PTR_DECL void_ptr_ptr; typedef unsigned long uns32 PV_PTR_DECL uns32_ptr; typedef struct { uns16 s1; /* First pixel in the serial register */ uns16 s2; /* Last pixel in the serial register */ } rgn_type, PV_PTR_DECL rgn_ptr; typedef const rgn_type PV_PTR_DECL rgn_const_ptr; /* DLL functions */ rs_bool PV_DECL pl_cam_get_name (int16 cam_num, cha ...Show All

• Windows Forms DataGridView setup problem

  I have put a DataGridView on my Win Form and thru code, initialize the column settings. One column requires a checkbox and the code below was "borrowed" from the V.S. Online Help. However, when I run this, I receive this error: "The following exception occurred in the DataGridView: System.FormatException: Formatted value of the cell has a wrong type. To replace this default dialog please handle the DataError event." I put the two try/catch statements in and the error still tells me to "handle the DataError event". This error occurs on the line " dataGridViewMemberList . Columns . Insert ( 0 , dgChkBox )". I've removed this line and the form loads and the DataGridView is i ...Show All

• SharePoint Products and Technologies Insufficient rights when configuring SSO

  When I'm setting up SSO I get the following error: You do not have the rights to perform this operation. The service is started, the service account is a part of the local administrators group; dbcreator, securityadmin on the database; a member of the sharepoint farm administrators group.  I'm loooking at the docs at http://technet2.microsoft.com/Office/en-us/library/841080ca-3e3b-4dbc-a081-43c29c76b3551033.mspx mfr=true  and I noticed the Central Administration site doesn't have a "Reader" group.  The event log shows the following: Type:  Error Date:  1/18/2007 Time:  6:40:24 PM Event:  6517 Source:  Office SharePoint Server Category: SSO User:  N/ ...Show All

• Visual C# How do I write text to an RTF Text Box

  I'm adapting the UsingMenusStatusStripsToolStrips example (in CS101 samples) which puts some example text in an RTF box and allows a user to type in the box. Instead I have a class that receives text via an IP socket and I want to place this text in the box. I tried adding a public "WriteToForm" method in Form1.cs, but code in the IP listner object can't access this method. Is there a trick to this Thanks Scott Are you getting an exception regarding something about "Cross-thread" I had a similar problem earlier with my application because I was using asynchronous sockets and callback methods. Since the callback methods uses threads from the thread-pool, this was the only way to go since I was looking for scalabilit ...Show All

• SQL Server Using SQLExpress on a network

  Hi, I have a VS2005 application that I run with a SQL server 2003 database. In order to make the application distributable, I'm trying to get it to run with SQLExpress. I've installed SQLExpress on a spare machine and changed the connection string in my application to use SQLExpress c:\databases\mydatabase.mdf (and the database is obviously in that location!). This works fine on the spare machine. However the problem is getting the application to run on another machine but using the same database. I note that SQLExpress won't let me put the database on a networked drive. On another machine I've also installed SQLExpress, I've enabled the tcpip stuff and the browser but to be honest don't really know what I'm doing! How do ...Show All

• Visual Studio Tools for Office Is Outlook Explorer Active?

  Hi, Is there a way to know if explorer that i referenced now is active wihout usinf the ...Active() method, but i only need to check IsActive(). Anyone Tnx in advance You need to register for Explorer.Activate Event to know whether the current Explorer is the activeWindow I presume this is what you are trying to validate. You could use some WIN32 API calls to look at window handles but again this is not the best method, Events is the way Regards ...Show All

• Visual Basic Starting my application automatically

  I need to write an application for a friend that will start automatically when Windows XP Pro boots. The application is very straightforward - 3 buttons and a web browser control. The caveat is the users must not have access to the start button, start menus or any other applications on the system. Also, when the application exits the computer needs to shut down. I am using Visual Basic 2005 Express. Thanks, Mark Start-up: Put your app in the registry HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Run or HKEY_LOCAL_COMPUTER\Software\Microsoft\Windows\CurrentVersion\Run Shutdown: System.Diagnostics.Process.Start("ShutDown", "/s") Remove start button: http://www. ...Show All

• Windows Live Developer Forums Help required with XML problem

  Hi, I've created an XML file http://www.dreweatt-neate.com/xmlout/resprop.xml to link to our page http://www.dreweatt-neate.com/live.asp however it will just not display the XML. I cannot see any reason for this. Any pointers would be great. I can click on the web page and see your XML file is loading on the map for me. But all of your points are in the Atlantic, just west of GB. Looks like maybe your've got the longitudes wrong ...Show All

• Smart Device Development Problem Installing .Net CF

  Hi, I have an Acer N30 running Windows Mobile 2003 ( 4.2) and a Samsung S3C2410 processor. When I try and install the .Net CF I get the message below "Microsoft .Net 2.0 failed to install on your device because the installation file is not intended for this version of the device" I have tried both the first release of the CF and the service pack version and both give the same error. I am almost 100% certain I am using the correct version of the setup file. Its the one found here http://www.microsoft.com/downloads/details.aspx familyid=9655156b-356b-4a2c-857c-e62f50ae9a55&displaylang=en I am updated the ROM on the PPC and this made no difference. I am using Active Syn 4.2. Could someone please help as I ...Show All