Fizgig's Q&A profile

• Visual Basic Read File and Write New Info to file

  I have and Excel spreadsheet saved as XML file...I replace the data in the cell's to my datareader.Items...I want to open the new Excel file with the info.......Is there anyway you can change file extension in code I want to write "templines" to my new xls file and then open the xls file in Excel.....any help or do i need to be a lil bit more clearer Dim xls As FileStream = New FileStream("c:\NewSpread.xml", FileMode.Open) Dim s As StreamWriter = New StreamWriter(xls) s.Write(templines) MsgBox(templines) ds.EnableRaisingEvents = False ds.StartInfo.FileName = "c:\NewSpread.xml&quo ...Show All

• Visual Studio Cristal Report by a Typed Dataset

  Hi, Im kinda new to programming on C#. I was told edit a series of reports that has most of its logic on SQL. My job is to pass all that logic to C# so C# do most of the job. We are thinking on creating methods that generate an output and a dataset will recover all the outputs from the methods. Im trying to send the dataset to crystal report but I dont know if it possible, if it is I am doing something wrong. Any aditional info will be appretiated. Thanks... You can certainly pass a dataset to a Crystal Report.  Check out this thread for some specific details:  http://forums.microsoft.com/MSD ...Show All

• SQL Server Missing data source"....

  I wanted to demonstrate how SSIS can easily read an Excel file into a database. I started up the wizard (dtswizard) looked and looked by couldn't find "Excel" in the list of datasources. Next I started up the SSIS IDE, found an Excel Destination, and created a flow that errored out on the copy to Excel step. >>> SSIS package "Package.dtsx" starting. Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning. Error: 0xC0202009 at Package, Connection manager "Excel Connection Manager": An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. S ...Show All

• Visual Studio Express Editions Too long to compile?

  Hi, i'm having a freak problem. When i'm trying to compile the code, Visual says: "error compiling, sub rutine too long. I know it's long, but... Can someone tell me if this is normal How can I compile a large sub rutine Thanks That's interesting, how many lines are in it Your solution is to break it up into managable subroutines: it sounds like a complete nightmare to debug/maintain. As a general rule of thumb, a subroutine/function should be no more than a single viewable page. ...Show All

• Audio and Video Development Questions on DXVA2.0 and Media foundation

  Hi 1. How does IDirectXVideoAccelerationService, IDirectXVideoDecoderService and IDirectXVideoProcessorService differ 2. Will IDirectXVideoProcessorService make it possible to program the Video Processor as such on the nVidia Geforce 6/7 series, so ISV's could implement their own algortihms for tasks like noise reduction and deinterlacing 3. How does the different DXVA2_SURFACETYPE's differ 4. What are the main differences between the Enhanced Video Renderer and the Video Mixing Renderer 9 5. When can one expect to see more documentation ; ) Regards Mikkel Hi Mikkel, I have forward ...Show All

• .NET Development MSMQ Serializable Hashtable subclass causes a hang when extracting Message.Body

  To start:   I get no error message; just a hang condition.   If I could get an Exception, I could probably figure this out for myself.   Instead, .NET just hangs, cold and unresponsive.   Here's the short concept of what I'm doing (no code examples here as the concept should be simple enough to implement by any interested troubleshooters): Make a struct called KeyValuePair with two fields:   a Key and a Value, both String types.   Mark the KeyValuePair struct as [Serializable]. Make a subclass of Hashtable called HashSet and override the Add method to guarantee that all Keys are unique at a ...Show All

• Architecture Serviced component architecture issues (State management/ OOD).

  I've seen serviced components abused and misused due to inherent limitations in how COM operates and now I’m looking to architect a web based, OO, n-tier system and wish to avoid the same mistakes. In my system there are two architectural problems: Much of the data is common across users, complex and potentially quite large, which leads to a large number of objects when using standard OOD (not so good for COM as I understand). Some (but not all) update requests need to be processed in serial, all others concurrently. I’m considering a windows service application that can hold all the user independent dat ...Show All

• Visual Studio classic chm Help doesn't link to MSDN Library

  on new PC, reinstalled VS and Library again, but links to commonly inherited NET members like "string" display a Page Not Found error, yet the help 2 versions work in VS and in H2 Viewer... is this a registry problem does this relate to MS article 827054 or 318945 thanks >> I have to make sure I understand this enough to explain it to my bosses: The type of links created by a classic Help 1 chm file depends on the edition of Visual Studio.NET IDE on the Technical Writer’s PC at the time The classic .chm compiler would generate .chm specific types of links. It would not have any built in support for l ...Show All

• SQL Server Changing Column size/type with Derived Column

  I have a number of date columns that are parsed as DT_WSTR (6) and I have written a Derived Column converting them into DT_DATE via this (found on the forums) type expression: (DT_DATE)(SUBSTRING(Date,6,2) + "-" + SUBSTRING(Date,8,2) + "-" + SUBSTRING(Date,1,5)) But I really want to replace the current column, not create a new one. If I use "replace" the data is forced to be a DT_WSTR (6), and I get a truncation error at run-time. Simeon A column is identified by it's lineage Id. Deleteing a column and adding it back, even with the same name and same data type properties will cause it to change lin ...Show All

• Windows Forms Progress Bar in StatusBar control issue

  I am using the code below to create a Progress bar in my status bar on my MDI parent form.  The code works well.  However, when it is finished I want to reset the progress panel to its original state and cannot figure out how to do it.  How do I get the panel's color back to windows gray.  Any ideas Thanks, Mike //**************Cod ...Show All

• Microsoft ISV Community Center Forums Defining objects within a cell range

  Hey,     I've been working on writing a code where the user inputs different names into a worksheet, then the code selects these files and defines it: Sheets("Variable Output Order"). Select FieldStr1 = [A2:A21]   Then, I use that defined object to use in a recordset: Set rs1 = db.OpenRecordset(" SELECT " & FieldStr1 _         & " FROM R00" & TestNumber & "DATA " _         & "ORDER BY RECORD_NUMBER")   Also,the TestNumber is defined also, but that doesn't seem to be the problem. Any thoughts ...Show All

• Architecture Lazy linking pattern

  Lazy loading is a familiar pattern for hydrating business objects but has the drawback of being expensive when many objects need to retrieved (through many SQL queries). In a situation where there are perhaps 20 classes of object each with only 5 to 100 instances of each class, it may make sense to load each of the instances of each of the classes in one go. However linking these classes might be best done as required (hence 'lazy linking') especially if there are large numbers of interconnections to sort out. I am assuming the objects are cached once loaded and indexed on their ID. I am also referring to foreign key mappin ...Show All

• Visual C# Error when trying to delete row from GridView

  I'm trying to delete a row of data by using the Delete button inside a GridView, but I'm getting the error below . The datarow contains a cell with xml datatype data, but the row I'm trying to delete actually contains a null value for that cell. Anyway, I don't know where the nvarchar is coming from...is that the default value for the parameters Any ideas about how to fix this Thanks ==================== The data types xml and nvarchar are incompatible in the equal to operator. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about ...Show All

• Visual Basic detecting click event in a graphics region

  I wonder how we can detect a click event in a region.  Pls advise! thanks so much! You sure can! Dim path As New System.Drawing.Drawing2D.GraphicsPath   Private Sub Form1_Load( ByVal sender As System. Object , ByVal e As System.EventArgs) Handles MyBase .Load     path.AddEllipse(60, 60, 100, 100)     path.AddRectangle( New Rectangle(10, 10, 50, 50)) End Sub   Private Sub Form1_Paint( ByVal sender As Object , ByVal e As System.Windows.Forms.PaintEventArgs) Handles Me .Paint     ...Show All

• Visual Studio How can I remove a copy of .NET Framework 2.0?

  I have recently had a Virus attack.  After cleaning up the virus I had problems with a number of my programs including WindowXP Pro so I reinstalled WindowsXP without doing a complete reinstall.  Everything started working.  I then went to the Microsoft Update site and installed all the updates but one fails.  Microsoft .Net Framework 2.0 the problem I think is that I had the 2.0 frame work already installed as I can see it in the  Administrator Level but when I went to remove it so I could reinstall it the Add and Remove programs does not show where to remove it.  My question is   Is there a MS KB artical ...Show All