amc's Q&A profile

• SQL Server Using Data Source view in Import export package within same solution is not possible ?

  hello ,   I want to download data from an AS/400 to a SQL 2005 Database. Within Sql server 2000 it was possible to do more than 1 transformation with just 1 source connenction and 1 destination. In SSIS I have created: -  new solution -  data source -  Data source viewer ( I made named queries to format the data as i want it to be in Sql) Although it is possible to view the named query data it does not seem to be possible to import the data in the data viewer into my sql 2005 database. (For each dataflow I have to define each query again) I have added the data source in the connection manag ...Show All

• Visual Studio Express Editions Help with KeyDown or KeyPress

  I am very new to VB but I am progressing well. However, I have tried numerous solutions to this problem and have not found the right answer yet: I want my program to do something anytime a certain key is pressed. It is not going in a textbox or form. So Basically something like this: If (The "5" Key is pressed) Then DoTheseThings() End If I need it to always be active. Any help Thanks!! If you mean a system wide solution, you need a global hook. http://www.codeproject.com/csharp/globalsystemhook.asp ...Show All

• Visual Basic My.Settings For Multiple Users

  Is there a convention for creating seperate My.Settings XML files for different users Example: A user logs in to my app and from there recent documents are stored in a list. When another user logs in to my app, if i pull, say, My.Settings.RecentFiles, then it returns the recent file list for the previous user. I understand the architecture and why this works this way, but is there a way to fire the creation of a new xml settings file for each user, and then call that set of 'settings' according to login or some other mechanism Thanks in advance! J. Clark Yes. When you are in the designer, creating the settings, each se ...Show All

• Microsoft ISV Community Center Forums Subform Problem

  hi all i have a problem that i tried my best to solve it but i can 't till now the problem is i have a form with 2 sub forms in side it built using MS access 2000 currently we moved the database from MS access to MS Sql Server 2000 since then this form no longer works the form idea is that user select the customer id from combo box after update event will do requery for both subforms both sub forms based in a query that select all data from transaction table based on the customer number selected by the user when ommited from the selection the subforms works and displays all the customers regardless the user ...Show All

• SQL Server XMLBulkLoad

  Hi,     I have been working on SQL Server 2005 nearly for an year now. In Beta2, there is class XMLBulkLoad which can be used to bulk copy data from an XML file into SQL Server using a mapping schema. Now I have installed the Yukon April CTP and OMG the XMLBulkLoad class is missing. Does anybody have any idea whether it has been removed or changed to something else It was earlier "unofficially" in the " System.Data.SqlXml" assembly in the namespace "MS.Internal.Data.SqlXml" .     I have been searching for these changes with no success. Can anybody also please tell where to find the changes for thi ...Show All

• Visual Studio Team System Field.IsLiteral and .IsSpecialName

  hi, what is the meaning of these methods I see them used around in example rule codes, but comments dont reveal meaning to me. Where can I see the descriptions of other methods public override ProblemCollection Check( Member m) { Field f = m as Field ; if (f == null ) return null ; if (!f.IsPrivate) return null ; // what is this if (f.IsLiteral || f.IsSpecialName) return null ; string name = f.Name.Name; ..... etc. etc. Thanks! Mob Hold a bit, I just learned the meaning of IsLiteral - thanks to Michael's earlier posting ...Show All

• .NET Development CSimpleStringT::GetBuffer in C#

  Hi all could anyone tell me the equivalent of CSimpleStringT::GetBuffer in C# Regards, Madhu   nobugz wrote: That could have nasty side-effects due to string inlining.  Consider using the StringBuilder class. Yes good point, I should have added a 'however'. However, you should at using the StringBuilder first, (1) Because of the reason nobugz mentioned (as indicated below) and as using the fixed statement can cause performance problems, as it prevents the Garbage Collector from moving the string around and therefore can increase memory fragmentation. String Interning ...Show All

• Smart Device Development MappingName problem

  Hi, i've got two tables. Order and product. Order : id amount product(object) Product : id Description In my code use DataGrid1.datasource = Order[] I create a tablestyle and I start to map the properties with ( MappingName = "PropertyName") But what do I have to use If I want to show the product.description in the datagrid instead of the productobject Grtz Dennis You can not set mapping name to fetch data from another table. You can: 1. Create computed column Description in table Order and set expression to grab value from ta ...Show All

• Visual Studio Express Editions AxShockwaveFlashObjects not found

  hi every1. I tried adding a shockwave flash object on a form but i get an error when trying.. "Failed to import ActiveX control. Please ensure it is properly registered" SO, in the references node from the Solution Explorer i have two newly added references, one being ShockwaveFlashObjects (which look ok) and another being AxShockwaveFlashObjects which has an exclamation mark newxt to it.. In the components list (for the Add Reference function ) i tried to locate AxShockwave.. but could only find Shocwave... (without "Ax").. I added the Shockwave Flash Object to the toolbox first so i don't understand what the problem is or how to fix it. An ...Show All

• .NET Development OleDbDataAdapter.Update not instananeous

  I have the following piece of code that basically duplicates a selected item from a datagrid. You'll notice the commented out Sleep line. When run without the sleep command, the user is redirected to the current page, thus forcing the page to reload from a fresh state but there's a problem. When the page reloads, it shows the same data. If I manually refresh the page after that, everything is fine. When I added the sleep function, eveything is fine on the first try. It seems as though the update command is not happening instantanously. I've also tried closing the connection, or refilling the datagrid, both of which make it work the first tim ...Show All

• Visual Studio Tools for Office VSTO training

  Hi, Is there any training available from anyone for VSTO 2005 Thanks Al We recently posted some labs on the "Visual Studio 2005 Tools for Office Training" Web page at http://msdn.microsoft.com/library/default.asp url=/library/en-us/odc_2003_ta/html/odc_landvsto05_tr.asp . While you're there, you may want to check out the "Visual Studio 2005 Tools for the Microsoft Office System Technical Articles" at http://msdn.microsoft.com/library/en-us/odc_2003_ta/html/odc_landvsto2005_ta.asp frame=true . I hope these are the types of resources that you were looking for. Regards, Paul Cornell Documentation ...Show All

• Visual Studio Express Editions sql express CPT beta 2 fails to install with error 1603

  Have attempted to clean up registery a few times & reinstall, but always get the 1603 error. Any suggestions short of reformating the disk error log says [10/29/05,23:42:23] Microsoft SQL Server 2005 Express Edition April CTP: [2] Error code 1603 for this component means "Fatal error during installation. " [10/29/05,23:42:30] Microsoft SQL Server 2005 Express Edition April CTP: [2] Setup Failed on component Microsoft SQL Server 2005 Express Edition April CTP ***EndOfSession*** TIA, jbm Hi jbm, Thank you for evaluating the Beta version of SQL Express. With the launch of the release version of SQL Expre ...Show All

• Windows Forms Adding button dynamically to an existing control

  Hi all, My current client has a requirement for a datagrid that has a collapse/expand button at the top left corner of the Caption row. This is because there are a lot of datagrids on our forms and some are only relevant/useful to some users (but they all have to be there.) It is nothing to do with drilling down or having child-parent data - it simply needs to minimize the datagrid on the form so only the Caption row is showing. When they click the button again it restores the DataGrid to it's original size. Since we don't have time to do an "owner draw" custom control solution what I've ended up doing is dynamically creating ...Show All

• SQL Server Why do all packages in the project open when running one in debug mode?

  Does anyone know why this happens When I run one of the packages in my project (by hitting the play button in the designer), all of the other packages in that project open before it starts running Thank you. To add more info ... this didn't happen before I copied the project files to a different computer and changed the security settings to "don't save sensitive", modifed the packages, then changed back to "encrypt with user key". But even after I did that, the original issue above didn't start happening right away. That indicates to me this is not the cause. Any ideas ...Show All

• SQL Server unreceivable messages

  Hey guys I have another weird looking problem I have a queue with a certain number of messages waiting in it to be processed. When I try and receive a message from this queue, I get back an empty row; no message. However, when I try and select from this queue, I see all the messages in there. Even sp_spaceused reports that there are rows in this queue. The status of each unreceivable message is 2. What would be the reason why I cannot receive these message I should add that newer messages added to this queue are receivable, meaning that if I add another message to the queue, when I do a receive, I get this new message ...Show All