Alastair Q's Q&A profile
SQL Server Update DB
I'm trying to do an update in a table in the end of my data flow. I've read various posts about the subject but i cant seem to find a problem like mine. That's because in order to do this update i've to compare a row that it's comming in my dataflow with one from the table. It's like this: update table_name where set column_name=column_name where(column_name==InputColumnFromDataFlow) Because i'm going to put the values from the inputcolumn into the Column_name from the database. Thanks Hopefully I'm reading your question correctly. If this is your requirement then you can do something like this inside an OLE DB Command Transform Update inCustomers Set Firstname = where CustomeriD = Where the first is a column in the pip ...Show All
Gadgets Open a webpage in a Flyout?
Hi I wonder if there any way to open a webpage in my Flyout ! I've something like this: Hi, here I'm again. :) I'm curious if there any way to apply a css style (external file) to the content of Flyout (a webpage) Would be very nice. ...Show All
SQL Server Backup and restore databases and access rights
Hi, I am creating a way of working in order to "copy" databases from a master SQL Server 2000 database to the developers local machines. I want to create a master SQL Server at our office location. Whenever our developers works on site the master is used. To be able to work locally, a backup has been created of the master and is distributed to the developers. On their local machines, they restore the database to be able to develop locally. I have created a backup on my laptop using on my domain account (not the account that created the database, but I can use it when developing). I moved the backup file to another computer and restored it using my domain account on that computer. I could not see all of the tables, users ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Can't create texture on WM5.0 PPC
Hi all, I invoke IDirect3DMobileDevice->CreateTexture to create a texture, but what annoyed me is CreateTexutre always return error D3DMERR_DRIVERUNSUPPORTED while it can work correctly on WM5.0 PPC emulator. the device I used is Dell AXIM X51V, and sample code as follows: // create d3d object. m_pD3DMobile = ::Direct3DMobileCreate( D3DM_SDK_VERSION ); RECT rtClt; ::GetClientRect( hWnd, &rtClt ); D3DMFORMAT format = D3DMFMT_R5G6B5; D3DMPRESENT_PARAMETERS param; memset( ¶m, 0, sizeof(D3DMPRESENT_PARAMETERS) ); param.BackBufferWidth = rtClt.right; param.BackBufferHeight = rtClt.bottom; param.BackBufferFormat = format; param.BackBufferCount = 0; param.MultiSampleType = D3DMMULTISAMPL ...Show All
Software Development for Windows Vista need write filter
i need filter which listens to multicast. input is TS and output should be 2 pins audio and video ES. i decided to remake dsnet.ax such a way. but i can not understand what happens in code:( please give me some documentation which will help me. sorry for bad english ...Show All
.NET Development RFID Reader Project
Hello, I'm currently working on a project which involves a serial port RFID Reader. I have connected the Reader to COM2 of my PC and i'm trying to get the signals from the RFID Tags. I'm using Visual C# and SerialPort class. The problem is that i can't read or write to the port. I even tried to write something to the port using port.Writeline("string") and then read it with Readline() but it seems that nothing is written and nothing can be read. When i set the RtsEnable to TRUE the BytesToRead property changed from 0 to 9 no matter what i did and still i couldn't read anything. I also wanted to ask you if you have any code samples to send me or if any of you has written a similar program that works. I need to fix t ...Show All
SQL Server Null Values in Destination
Hi to all! I created a simple package – data flow task, containing OLE DB Source, with Data Access Mode – SQL command and OLE DB Destination. My SQL command is update support_incident set date_closed = rn_edit_date where status_text = 'Closed' and date_closed is null DECLARE @CMonth as datetime DECLARE @LMonth as datetime SET @CMonth = '10/1/2006' SET @LMonth = DateAdd (m, -1, @CMonth) select @LMonth as Reporting_Date, (select count(support_incident_id) from support_Incident where rn_create_date >= @LMonth and rn_create_date < @CMonth) as Opened, (select count(support_incident_id) from support_Incident where Date_Closed >= @LMonth and Date_Closed ...Show All
Game Technologies: DirectX, XNA, XACT, etc. loading textures "in game"
Hi I know how to load a texture when the game starts, but how to load a texture when the game has already startede ex. 10 min in the game You can load a texture at any time during the game. If you're using the content manager it would be content.Load<Texture2D>(AssetName); and that can be anywhere in the code if you wish. If you want to do it simply from a file(PC only), it would be Texture2D myTexture = Texture2D.FromFile(FileName); also can be put anywhere in the code. on this one, make sure you get rid of it when you don't need it anymore. ...Show All
Visual Studio Team System Running ASP.NET Unit Tests on Remote IIS
I'm having a problem with running remote asp.net unit tests and would like to pickup this conversation . The problem: When I run the asp.net unit test I've created it fails with the following message, The URL specified http://dev.domain.com/aeden/project does not correspond to a valid directory. Tests configured to run in ASP.NET in IIS require a valid directory to exist for the URL. The URL may be invalid or may not point to a valid web application. Background: Facts about the dev server * Windows 2003 * No host headers used My dev machince is * Windows XP * VSTS Team Suite I'm able to browse to the url in the UrlToTest attribute. The Test: <TestClass()> _ Public Class PageTest Pri ...Show All
.NET Development exception when closing stream
I get this error when I close stream (i not using asynchronous request ) The remote server returned an error: (450) File unavailable (e.g., file busy)." I only get this exception when using with FtpWebRequest . I don't get such exception when using with httpWebRequest. this only happen if i abort before finish whole file. m_response = m_Request.GetResponse() m_Stream = m_response.GetResponseStream() ..... ..... while true m_ReadSize = m_Stream.Read(m_writeData, 0, m_ReadSize) ... ... if abort = true then exit while end if end while '//////exception will occur if abort is true. but if the process read untill finish then no problem m_Stream.Close() m_Stream = Nothing why how to resolve this thanks I d ...Show All
SQL Server The use of databaseFields in ReportHeader
Hi, I'm trying to use a database field in my reportheader. Normally this won't work but with the workarround with the 'hidden textbox' it works. But i have another problem. If that textbox is not on the same page as the header for instance, the subreport is two pages. My first page will show the field in the header as the second page won't show. Is there anyone who has another workarround to solve this problem greetz Hello, One way to do this would be to create a new dataset that depends on the same parameters of your main dataset and houses the value you are looking for. so the data set will have a sql statement that returns a 1 row 1 column result set. Create a parameter call it what e ...Show All
Smart Device Development Networked Media Device BSP not appearing in list of BSP's
I've installed CE 5.0 with Source support and I've installed the NMD add on and i've rolled up CE with the latest roll up, but I'm still unable to get the NMD to be accessaible from within the IDE per the KBA's I've read. Any assistance would be most appreciated. In the Post about "NMD_UI sample not working" someone had mentioned downloading the Networked Media Device Wizard. I've tried that several times, but each download seems to be corrupted. When I try to run the file it states that the "WinZip Self-Extractor header is corrupt. Possible cause: bad disk or file transfer error." ...Show All
Visual Studio Team System TF30177 trying to create a new project
I've got a new install of wss 2.0 SP2, TFS 1.0 and I can't create new projects. I've walked through the doc and created the TFS accounts and made them members of the local admin on the server. However, I get the error when trying to create a new project. Error The Project Creation Wizard encountered an error while uploading documents to the Windows SharePoint Services server on CHEF. Explanation The Project Creation Wizard encountered a problem while uploading documents to the Windows SharePoint Services server on CHEF. The reason for the failure cannot be determined at this time. Because the operation failed, the wizard was not able to finish creating the Windows SharePoint Services site. User Acti ...Show All
Visual Studio Tools for Office Error - Available resources - Excel VBA
I have a problem saving a xl file using VBA. The file which I am trying to save is about 2.35mb and has external links. When I try to save in VBA a error pops up 1. Excel cannot complete this tast with available resources . Choose less data or close other application. Have any experience this kind of problem Hi Helge This forum is specifically for questions concerning the VSTO technology - a .NET Framework-based substitute for VBA in Word and Excel documents. You really need to ask this question in a place where VBA and the Excel object model are the main topics: the excel.programming newsgroup . When you ask over there, be sure to mention the version of Excel you're working with. ...Show All
Visual C++ C/C++ cross-development environment
Hello everyone, I read some beginner materials for C/C++ cross-development environment, which consists a host machine and a target machine. The host machine can produce binary executable code for the target machine, which has a different hardware architecture compared with the host machine. For example, the host machine can be x86 CPU, but the target machine can be ARM CPU. How mysterious it is! I am wondering what mysterious things do the host machine have in order to produce the binary code for a different hardware architecture machine. I think the host machine should contain, - compiler/linker which works on host system but produce binary output for target system; - .h header files for target system; - dynamic library for target system ...Show All