SPWilkinson's Q&A profile

• .NET Development AcceptChanges

  The code below works correctly -- the data is applied to the Access 2000 DB as expected. But, the Date Modified in the Access DB Table does not reflect the new date (date the data was added). When I use TransferSpreadSheet to originally populate the data set, the date does reflect the date the data was added. What am I missing / <code> ' Create Adapter strAccessSelect = "SELECT * FROM " + dbTableName ' + ":" dbAccessCommand = New OleDbCommand(strAccessSelect, dbAccessConn) dbDataAdapter = New OleDbDataAdapter(dbAccessCommand) dsCommandBuilder = New OleDbCommandBuilder(dbDataAdapter) ' Create the DataSet with data dsDataSet = New DataSet dbDataAdapter.Fill(dsDataS ...Show All

• Visual Studio 2008 (Pre-release) Binding to Custom Property

  How do I bind to a custom property More specifically, I'm trying to bind the Fill color of a Path to a property of the Window. The Window property is defined in the CS file. I'm not sure whether it should be a Brush or a string at this point... Seems simple enough, but this doesn't work: < Path Fill = " {Binding ElementName=myWindow, Path=fillColor} " Data = " F1 M 53.795410,18.108398....Z " /> You do not need to do anything to make it refresh. The binding system should update the property on the Element and that will be propigated to the render tree. The binding should be bi-directional by default, so unless you did something special that should not be an issue. You ca ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. problem after collision

  hello all..   i do a collision check..   this is working..   if a collision is detects the movement stops...   but how can i reactivate the movement (after changing the direction of my vehicle - because the bounding boxes still collide )   can you give me an advice please.. here comes the code   public void UpdateVorwarts( Spieler _Spieler, float _SpeedVor) { _Spieler.Aktiv.BoundBox = new BoundingBox ( new Vector3 (_Spieler.Aktiv.FzgWorldPos.X, _Spieler.Aktiv.FzgWorldPos.Y, 0), new Vector3 (_Spieler.Aktiv.FzgWorldPos.X + 48, _Spieler.Aktiv.FzgWorldPos.Y + 48, 0)); Boolean AllowMovement = true ; foreach ( Fahrzeug Obj in Game1 . ...Show All

• Audio and Video Development Sample Script Key Handler

  I've been handling all key/remote commands from the Markup. I now have a scenario where I need to capture some key events in the script. Can someone post or point me to a simple key handler I could not find a clear description in the spec. Thanks. function doKeyEventUp(evt) { switch (evt.key) { case 0xFA: // Do stuff for VK_PLAY break; case 0xB3: // Do stuff for VK_PAUSE break; } evt.stopPropagation(); evt.preventDefault(); } addEventListener("controller_key_up", doKeyEventUp, false); This is pretty simplified. I'd normally have a set of variables VK_PLAY etc assigned to the key values for readability. You can find the values in Annex V . You can also experiment with controll ...Show All

• Software Development for Windows Vista Debugging asp.net application gives a strange error

  Hello - When i try to debug asp.net application (Framework 2.0) a strange error is logged in the eventviewer. EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'. And I ensured that the Enable Sql Debugging flag is unchecked in the project properties Can anyone please help how to get rid of this error. Thanks- Shyam ...Show All

• Visual Studio 2008 (Pre-release) Publish Xbap application with Visual Studio 2005

  Hi all, I have been trying to publish an xbap using VS2005. I have worked through some problems but there are still more issues that I am hoping to get help with. Here are somethings that I have done. BTW, I am running Windows Vista Ultimate. I did ensure the proper MIME types were set for IIS7. I have copied the necessary files into the C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages location. I did select .Net 3.0 Framework and .Net 2.0 Framework as necessary prerequisites. Create setup program to install prerequisite components Download prerequisites from the same location as my application I am publishing to a file location because when I select publish to local IIS it says I need to be an ad ...Show All

• Visual Basic How to insert textbox string to datagrid (Windows Application)

  pls help me with this asap ...Show All

• SQL Server Optimising Merge Replication for both server and client subscribers

  I need to merge replicate data to two different types of subscribers: Clients subscribers which will have a very small percentage of the data from the central database. The data on these machines will be managed using dynamic filtering on host_name() Server subscribers which will manage a copy of all the data from the central database There will be far fewer server subscribers than client subscribers. As I see it I have two options for the configuration 1) Use two separate merge publications – one which is filtered and one which isn’t 2) Use a single merge publication and setup the filtering so that the server subscribers receive all the rows Which option is likely to lead to better performance ...Show All

• SQL Server Access Permissions on server scoped objects for login

  We are having problems with the response times from UPS WorldShip after switching from SQL Server 2000 to 2005. I think that the problem can be fixed from the database end by setting the permissions correctly for the user/role/schema that is being used by WorldShip to connect to the server but, I'm not sure how to do it. The Setup Client UPS WorldShip 8.0 running on XP Pro SP2 Connecting via Sql Native Client via SQL Server Login Connection is over a T1 via VPN Server - SQL Server Standard Edition on Windows Server 2003 2x3ghz Xeon processors w/ 4gb ram The user that is being used to connect runs under it's own schema and role and only needs access to two tables in a specific database on the server. What UPS WorldShip see ...Show All

• SQL Server Programmatically adding a script component to Data Flow Task

  Dear all, I am developing tools for automatic creation of data warehouse tables, cubes and SSIS packages. Generating the SSIS Data Flows works very well using the SSIS components for OLE DB Source, Derived Column, Lookup and OLE DB Destination. However for some of the advanced functionality I need to use Script Component. I have managed to add it in the Data Flow with all inputs and outputs, but how do I populate it with my code I've seen there is a component property called "SourceCode" and one called "BinaryCode". The "SourceCode" contains the code, but also some extra metadata. Questions: Do you know if there is any programmatic support to generate the Source Code property with the metadata ...Show All

• SQL Server Help with LinkTarget

  I am trying to access the Employee Summary Report in reporting services examples using URL access. I want to open the sub-reports in this report to be opened in a different window. Here is the url I am using http://ReportServer/ReportService2005.asmx/ %2fAdventureWorks Sample Reports%2fEmployee Sales Summary&rs:Command=Render&rc:LinkTarget=_blank I was assuming that when I click the sub-report it will open in a browser since the LinkTargete is to _blank. Please let me know why this is not working . Thanks!! SqlNew So the main report is loading in an iframe, correct By subreport I assume you mean a drillthrough report which is displayed after the user clicks on a hyperlink on t ...Show All

• Visual C# What is the difference b/w running 2.0 web sample by directly pressing F5 key and CTRL+F5 keys?

  Please let me know the difference between running 2.0 web samples by directly pressing F5 key and CTRL+F5 keys. Every time while I run the new web sample if asks both the option like “ Run with out debugging ” & “ Add a web config file with debugging enabled ”. I have a web config file globally in root directory. So I need to disable this option and run all the samples with out debugging. Thanks in advance. As long as i know, the startup page information setting is not found in web.config. If any one find it, please tell me. Thank you ...Show All

• SQL Server SQL2k5 Maintenance Plan Save Failure (no description found)

  I've got SQL 2k5 - no svc packs - Developer ed. - SSIS is installed and active. Using SSMS, when I create a simple maintenance plan (tran bkup task on DB with full bkup model and a full backup) and (update stats task) without the wizard and I try to save it, I get a popup error ("no description found"). That is all I get. No errors in the app log. No SQL Svr errors. No Agent errors. I searched the SSIS and Tools forum. I searched Technet. I searched KB. Hundreds of responses only 2 semi-relevant, only in KBase. The only references  to that error msg referred to having Viso 2003 and as a result using the wrong msxml dll. Supposedly, this was fixed in Visio 2003 SP1. I have SP2 Visio 2003 installed. Also mentioned in th ...Show All

• SQL Server Problem with write-back and parent-child dimension

  In AS 2000, Parent-Child dimension property “Members with Data” had 3 possible values: “Leaf Members Only”, “Non-Leaf data hidden” and “Non-Leaf data visible”. In SSAS 2005 the first option was dropped, and non-leaf members can always have data. The absence of the “Leaf Members Only” option cause 2 problems, in a situation in which non-leaf members shouldn’t have data: First, if, by mistake, the fact table contains data for non-leaf members, SSAS will accept this data. However, these figures will be hidden, and the user will see wrong data. This problem can be fixed with better cleansing of the data. The more sever problem is with allocation of write-back data. If you’ll enter data to a non-leaf member using MDX’s ...Show All

• Windows Forms Add an Installer withinh my installer

  Hi, I am working with VS2005 (VB) and my application requiers another installation (I am working with ArcGis, and need to install the ArcGis Engine), How can I make my setup project to Install that software Please help!! Yael We have built several extensions for use with ArcGIS, including installers. I think that trying to include an installation of ArcGIS in your distribution would be difficult, as their install is quite complicated. Additionally, have you considered that many users may require a particular version to support other uses of ArcGIS Our customer has some applications that won't run on 9.2, while our latest version does work with 9.2. Your best bet if you require ArcGIS to ...Show All