Eric Wirch's Q&A profile

• Visual Studio Express Editions How do you propagate a SQL Sever schema change to an existing VB 2005 project

  I am working with VB 2005 Express and SQL Server Express. I have an app up and working well based on the current SQL database schema. How can I change the database schema (add a table, change the data type on a column, etc.) and propagate this change into an existing VB 2005 application. I tried this once by trying to reconfigure the database via the Wizard and lost all of the previous customization of the database (queries, fills, etc.) in the VB application. (I resorted to a backup copy.) It will be hard to give a specific solution without knowing the specific schema change, but here goes... In general, do the things needed to change the database from the Server Explorer first, then alter the .xsd file with your TableAdapters t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Three red lights on my 360

  I finished watching a movie and powered it off, I went back about 20 mins later to power on to play a game and the "three red lights came on" I powered it off and waited a while but there was no change. I have not downloaded anything recently. I left it unplugged since last night, so I will see what happens when I plug it back in later. Tokunbo Wpg Please keep these sorts of questions to support at XBox.com. http://www.xbox.com/en-US/support/ WT.svl=nav That page includes knowledge base links for the problem described here. ...Show All

• Visual Studio Express Editions Always On Top Overlay

  Hello, I am designing a program that I Wish to have overlayed in a video game. The Video Game is an always on top program, is there any way my program can overlay an always on top program Set the form’s TopMost property to true and it will be drawn on top of any windows that are not similarly set. I should mention that even setting TopMost cannot guarantee it’s staying on top of all windows all of the time as other windows with TopMost enabled will act just like normal windows with regards to being on top with yours as shell gets the final say and generally doesn’t let anyone have that kind of absolute control. ...Show All

• Visual Basic Failed to import ActiveX control

  I am using VB2005 express and VC#2005 express. With my old friend VS2003, whenever i needed to add flash to my WInforms, all i needed to do was to add the control as a com component and drag it on the stage from the toolbar. Now, when i did the same in new express version, althogh it is added in the toolbars and the references list, but still, whenever i try to drag a shockwave flash instance on my win form, i get the error: Failed to import ActiveX control, please ensure it is properly registered. does some one have any idea how to add flash comntrol as we used to do in earlier versions Please reply this ASAP. Thanks and regards. Syed Mazhar Hasan I have alwats the same problem , i ...Show All

• .NET Development BaseStream.Close

  I have a method that creates a StreamReader of a file and returns it's BaseStream. The calling method will be closing that Stream. Is that enough and safe, or the StreamReader must be Closed too I'd appreciate any help! Thank you, Luis Both StreamReader and Stream implement IDispose, so both should be disposed. You ca use the using construct to accomplish this automatically. The both effectively just call Close in thir Dispose. ...Show All

• SQL Server How Change field value triggered by date?

  In a table i had field called Status and it is of type integer and another two field From and To ... they are of type date ..... what i want to do is to change the value of status field when the current date become equal to the From field and also make another change when the current date become equal to the To field ... So How can i do This on SQL server 2005 You need to run a query to update the rows, something like this UPDATE mytable SET Status = CASE WHEN datediff(d, From, getdate()) = 0 THEN 1 WHEN datediff(d, To, getdate()) = 0 THEN 2 END You could create a calculated column based on the same expression if you want status to always be up to date without running the query first. Otherwise schedule a job to run that qu ...Show All

• SQL Server Problem with SQL Server 2000 DTS Package:Column Delimiter not found

  I am trying to import data from a text file to SQL database through a DTS package. i am always getting "Column Delmimeter not found" error at record number 8000. i copied the 8000th record into the beginning of the file to test if there is any problem with data but still i got the error at 8000 th record. i know it was a problem before and was fixed with sp1. i installed SP4 and still gettting the same error. any help on this is appreciated. Thanks Venki Found the actual problem. The error record number that DTS shows is not accurate. Acutal error was at 8790 th record but the DTS shows that the error is at 8000. The data has Quotes in it which was causing the problem. Thanks Venki ...Show All

• Visual Basic absolute vs relative coordinates

  I have a tabbed form with a main panel on each tab on each main panel i can add and remove subpanels i would like to get the absolute position of each subpanel..how do i do that if there's a button on the subpanel and i do button.parent.location.y i get a relative y position depending on the main panel's scroll bar...ugh.. so if i have the 20th sub panel i would expect it's absolute position to be 2000 but i end up with something between 100-700 depending on how where its scrolled on the screen... thanks! Dan You just have to take the autoscroll position into account. Remeber that it is a negative value: Dim p As Panel = CType (sender, Button).Parent Dim p2 As Pane ...Show All

• SQL Server "The package contains two objects with the duplicate name of "xxxx" and "xxxx"

  Hi all, I am creating a Data Flow custom component in SSIS, and my input/output columns are dynamically created depending on the value of a custom property of the component. Then, as soon as I modify this custom property, I make some job in SetComponentProperty(), that I have overrided in my PipelineComponent, to create my input and ouput columns. After validation, I have the following error message: Error 3 Validation error. Data Flow Task: DTS.Pipeline: The package contains two objects with the duplicate name of "output column "AMOUNT" (4714)" and "input column "AMOUNT" (4711)". Package.dtsx 0 0 I create an input column named "AMOUNT" with an ID 4711 and an output column ...Show All

• SQL Server Unable to cast COM object of type 'System.__ComObject' to interface type 'msforms.Control'.

  I have recently installed Visual Studio 2005, and since then, my Outlook 2003 has started giving me an error. I use Business Contact Manager in Outlook, and when I double click on an Account or Opportunity to view it, it gives me an error and asks me to debug. If I click on debug, Visual Studio Just-In time debugger opens up and says "An unhandled exception ('System.InvalidCastException') occurred in OUTLOOK.EXE[2924]" I click Yes to open the debugger, and Visual Studio debugger opens with the following error: "Unable to cast COM object of type 'System.__ComObject' to interface type 'msforms.Control'. This operation failed because the QueryInterface call on the COM component for the interface with IID" Does anyone kno ...Show All

• Visual C# Writing to multiple files

  Hi, I want to read in a file which contains words ending with ';'. And after that, i want to write the content of it to multiple files. Depending on what the letters the word contains. Suppose the word is 'reader'. Then i want it to cute and paste this word to a doc called "EA-words". I declared and created the files. And i read in the document called "mixedwords.txt" and put its content to an arraylist. This is as far as i got: //declared 15 files to write to. while((linesInArray = sr.ReadLine()) != null) { compareLines.Add(linesInArray); } Anyone any ideas Thanks in advance! I'm too bored this night. Check this: string MyString; int [] mrr = new int [1]; Sy ...Show All

• SQL Server How to upload a file to a Server URL using Web Service Task?

  Hi, I have been trying to setup a web service task to use my http connection manager that connects to a server url. What I want to do is to upload a file to a web server... can this be done using web service task and what is the WSDL and what happens when my target server usis SSL so instead of http, it should use https I need help with this one... can't quite imagine how to get things rolling.. Thanks in advance! Kervy I was able to upload a file to my web server using the Put method.. I don't know why using the Post method fails.. anyway, just to test my http connection manager.. in the URL I put https because I want to test using SSL and I get this" The underlying connection wa ...Show All

• Visual J# newbie question!

  hi im new to J# im using windows application and i couldnt find a way to call a form from another form how can i do that i was using it with vb.net like this form2.show() but the same code doesnt work at J# please i need your help thank u Jaiprakash Sharma i have learnt how to do by the help of yours so we have to make a sample of form,before calling thank u again ...Show All

• Windows Forms Host control in datagridview

  Hi, I have a datetime picker with time format hh:mm:ss as a editing control inside a cell of a datagridview, i have adapted the code from "How to: Host Controls in Windows Forms DataGridView Cells". I have the datagridview binded to a table, I can use the datetimepicker for select a hour but when I try to save the changes with: Me .Validate() Me .SrlistadispBindingSource.EndEdit() Me .SrlistadispTableAdapter.Update( Me .DSTraslados.srlistadisp) the changes aren't saved to the table. this is my code: Public Class timepickercell Inherits DataGridViewColumn Public Sub New () MyBase .New( New CalendarCell()) End Sub Public Overrides Property CellTemplate() As DataGridView ...Show All

• Software Development for Windows Vista When is the first stable release likely? i.e. v 1.0

  Hi, I'm prototyping an app at the moment that will be dev complete feb 9th and as a result I'd need to have fairly solid dates on WWF to be able to justify using it. Does anyone have any definite dates for the first official stable release Regards. Please use WF as an abreviation for Windows Workflow Foundation, not WWF . WF RC5 will probably be the V1 build, links to download it can be found here . ...Show All