Bob Bamber's Q&A profile

• SQL Server SSIS From SQL2K5 to MySQL

  Hi, We recently migrated from a SQL 2K to 2K5. We had an automatic DTS scheduled every night that would transfer data to a MySQL server on one of our client’s machine. It worked like a charm in SQL 2K. I am trying to figure out how I can connect to a MySQL data source using SSIS in 2K5 as I don’t see an ODBC Destination anywhere in the Data Flow Task; and run the same transfer using 2K5. Do I have to add a reference of some kind or does 2K5 doesn’t support ODBC destinations Thanks I had the same problem while doing a data migration project. I found a strange feature that helped me out of the ...Show All

• Visual Studio Express Editions Directory listing

  I am currently working on an archiving project. I have got it to work to some degree. It uses a folderBrowserDialog box to locate the directory to zip. Parses the string and creates the save location. It then zips and compresses the files by recursing through the directories and obtaining a list of files to be added to the zip file. Now here is my question. How could I select multiple folders in one pass And also is it possible do delete folders through C# you can use GetDirectories from System.IO to recursively obtain all the sub folders in one pass. see below string[] dirList = Directory.GetDirectories(@& ...Show All

• Visual Studio Tools for Office Dynamic Range in Excelsheet

  Hi, Actually I am having some problem while getiing dynamic range. I dont want to get range through Excelsheet column's alphabet i.e. through A, B, C etc, Suppose I want to get the range between A to D upto 100 rows in the Excelsheet then we can write code as follows: Excel. Range objRng = this .Range[ "A1:D100" , System. Type .Missing]; BUT I want to find the same area of range without using alphabets A & D, only through numbers. How can I make it possible it in VSTO Thank you The most flexible way to get ranges dynamically is using Cells[row, column] as par ...Show All

• Windows Forms howto set "display" text of dg Column headers @ design time?

  hi, I have a datagrid that pulls data from the database. the fields in the db are as follows: 1) companyId 2) companyName etc This casues the headers to appear as: 1) companyId 2) companyName etc ...not very neat :-( I want the column headers in the datagrid to be: 1) Company ID 2) Name etc IOW, I want to be able to assign the text for the column headers, via the&nbs ...Show All

• Visual FoxPro Visual foxpro 9.0 resource

  Dear Visual Foxpro, I was a developer using primitive versions of foxpro. I now again want to get into development, but I could not find any resource / Book on Visual Foxpro 9.0, and I believe there is a major change in technology. Is it possible to get ISBN # of any book on Visual Foxpro 9.0 Thanks, Ashish http://www.hentzenwerke.com is one of the sites where you can find VFP related books. ...Show All

• Visual Studio 2008 (Pre-release) Using Binding inside Binding

  Hey, I've got a question concerning the Data Binding. First I've got a TreeView that is binded to a list that each item contains a list of Ids. What I want is that the ListView next to the TreeView show all item corresponding the the Ids of the List selected in the TreeView. But for that, I need first to retrieve the data from a HashTable with the id. Here is the code that I was thinking was right. The Binding of the ListView: < ListView Margin = " 0,0,0,0 " Grid.Row = " 1 " x:Name = " ListView " RenderTransformOrigin = " 0.5,0.5 " IsSynchronizedWithCurrentItem = " True &q ...Show All

• SQL Server Couple of Questions about RS2005

  My client was using Reporting Services 2000, but is currently leaning toward Crystal Reports XI.  The reason being is that most of their data is filtered through DLLs providing business logic.  In RS2000, the only way to use the DLLs as a data source was to write an extension and essentially hard code the calls to methods and parameters inside the extenstion.  Their complaint was that every time they had to add something they had to recompile the extension, send it to the server admins, wait for installation and so on. With CRXI, all they had to do was point to the DLL as a data source and they were prompted for the me ...Show All

• Visual Studio 2008 (Pre-release) How do I access child ui elements of a ListBoxItem

  Is it possible to get the child UIElements from a ListBoxItem created via a DataTemplate The Context property in this case is set to the bounded data object. Hi guys, This is really good feedback. We would like to fully understand the scenarios that can not be done without walking the visual tree. If you have a scenario that required you to do so, please explain it in this thread. This will help us plan better for the next version of Avalon. Thanks! Bea ...Show All

• .NET Development How to process this XML in a loop?

  Hi Guys! I have the following XML: I hope you see the picture. Otherwise you find it here http://christians.homedns.org/SomePics/XML.jpg You have "Body"-Elements with Subelements "Category". I need every "Item"-element and also need to know in which Category it is. So, I want to create a Category-Instance with a number composed of all parent-Category-elements. This Category-Instance should contain a list of all subsidiary Item-Elements. The problem is, that there can be an infinite number of category-elements at the same level and up to 7 category-levels one below the other. The Item elements are always at the lowest layer of category-elem ...Show All

• Windows Forms Missing object in Office.Word.Interop.MailMerge

  I have a piece of code that has worked in the past with no problems.  Now as I do some work on somthing not related to the code no longer works.  Can anyone please help me with this issue Here is the code in question:         Dim wordApp As New Microsoft.Office.Interop.Word.ApplicationClass()         wordApp.Visible =&nbs ...Show All

• .NET Development Using the Beta 2 TreeView

  The Beta 2 TreeView control is real nice. I've thrown several XML files at it with various file extensions and the XML data structure is mapped to the tree which is exactly what I need.  As we have learned, a given schema may include child elements with the same name as other child elements neither of which are neccessarily derived from the same parent node. An <image> element comes to mind. I could use some help understanding how to use the SelectedNodeChanged event to determine which parent a given instance of an <image> element is derived from and how to then send the name of that element as a Que ...Show All

• SQL Server Print Preview button doesn't work

  Hi, I made a smart client sample project and added reportviewer control to the winform. It's by VS2005 Beta 2 and Sql 2005 CTP. Open the Smart Tags panel of the ReportViewer control by clicking the triangle on the top right corner and click report server and select <ServerReport>. value is : report server = " http://localhost/reportserver " report path = "/report1" the problem is, when I select a <ServerReport>, print preview button is enabled but doesn't work, nothing happened. But I change to existing report - use local report definition - from <ServerReport>, It works. Showing Preview report image and ...Show All

• Visual Studio Team System Check-in and get latest for other users

  Is it possibe to check-in other tfs users' changes myself (remotely, not from their machines) and also get latest The way to do it would be to have the user shelve his or her changes. You could then unshelve the changes and check them in. If you want to check in the changes on behalf of that user, you can use the /author:otherUser switch on the checkin command in tf.exe (you must have the CheckinOther permission for this to succeed). If by "also get latest" you mean get latest on that user's machine, the answer is no. You have to run get on the machine. Buck ...Show All

• Windows Forms Is there an underline control or clever workaround?

  Hi, I'm looking for an 'underline' control or some clever way of creating a similar effect. I want something to look just like this Eclipse dialog (link below); http://home.swiftdsl.com.au/~spurrymoses/pics/eclipse_dialog.jpg There is an underline underneath to top section and then underneath the 'Enclosing Type' checkbox. I tried fiddling with existing controls and looking for something in the Toolbox References but couldn't work anything out. Will I have to write my own custom control here. That would probably good practice but I just want to make sure I'm not reinventing the wheel first. On the sam ...Show All

• Windows Forms Formatting of DateTime, TimeSpan in a DataGrid

  When DateTime and TimeSpan are bound to a DataGrid, I don't like the way they're formatted. As I understand it, DateTime has fairly limited customization through the column Format property and TimeSpan has no customization ability. I'd like to subclass both and override ToString, but, I can't do this because they are structs, not classes. So: I am making wrapper ...Show All