crgsmrt's Q&A profile

• .NET Development use existing store procedure is disabled

  Does anyone to why when I right click on a tableAdapter to add query I don't get the "use existing store procedure" option. All I get is : 1- Use SQL statment and the other 2 are disabled: create a new stored procedure and use existing stored procedure did you ever get this sorted out i'm in the same boat and can't get the wizard to allow executing an oracle sproc inside a package. thanks in advance. ...Show All

• Visual Basic I need help with some clicking functions

  Hello, I'm a newbie with VB and I'm trying to create a RightClick function for a macro program I'm making.   So far I've gotten my LeftClick function to work, but I do not know how the RightClick works.   This is what I'm using for my LeftClick function:   Private Const MOUSEEVENTF_LEFTDOWN = &H2 Private Const MOUSEEVENTF_LEFTUP = &H4    I just need to know what to replace &H2 and &H4 with. Thank you.   ...Show All

• Software Development for Windows Vista Problem with register filters

  Hi all, I have a problem when doing the following line: CoCreateInstance(CLSID_FileSource, NULL, CLSCTX_INPROC_SERVER, IID_IBaseFilter, (void**)&pSource); I get an error REGDB_E_CLASSNOTREG, which means - "A specified class is not registered in the registration database". How can I register it Thanks, Yaniv Looking thru the docs, I don't see any reference to CLSID_FileSource. Perhaps this filter doesn't exist anymore You might try one of these instead: http://msdn.microsoft.com/library/default.asp url=/library/en-us/directshow/htm/directshowfilters.asp ...Show All

• Smart Device Development Building a PDA application, which to choose visual: c# or c++

  Hello everyone, I am interested in building a series of applications for a Windows Mobile 2003 SE device. What would be the best language to do it under Visual C++ or C# The application I plan to write essentially sends a command and receives data from a serial device. I've already written this program in the LabVIEW programming language, but it is too slow. (i.e. to complete one loop in the code takes ~2-3 minutes). Any advice would be greatly appreciated. -George CF is Compact Framework. .NET Compact Framework is a "stripped" version of the full .NET Framework (for the PC) which can run on the Windows Mobile based devices. you should be able to install .NET CF 2.0 SP1 on Windows CE 4.21 ...Show All

• Visual Studio Team System Easy question

  I can view my work items as tasks in the Pending Changes window and check them off as resolved. How can I "check in" these changes so that the work items are actually resolved The system thinks I have no pending changes. TIA, Mike Rodriguez So are you saying that you have files checked out but the system thinks you do not Thanks, Amit Dev, Team Foundation Server ...Show All

• .NET Development Typed datasets & serialization/deserialization

  I have some complex objects that I would like to clone. Some of these member variables are typed datasets and will require deep copies. I would like to serialize/deserialize these objects into and out of binary format. When I serialize my object it won't serialize typed datarows (these are extended from the class datarow) but they are non-serializable. I think I understand why these are non-serializable - the typed datarow itself is not something that would normally maintain state when cloning. I could possibly alter the designer.vb classes for the typed datasets and make the offending methods nonserialized but I don't want to do this. I could also alter my class to make the typed datasets nonserialized and clone these manually into the ne ...Show All

• SQL Server How to do multiple inserts for one row of data?

  I need to insert multiple rows for input rows that meet certain conditions. My input data is as follows. ZIPCode, Plus 4, Range, City, State What I need to happen is that if there is a value in the range column that is > 0 then I need to insert a row for every range item. For instance say I have the following data. 54952, 1001, 10, Menasha, WI What I need imported is : 54952, 1001, Menasha, WI 54952, 1002, Menasha, WI 54952, 1003, Menasha, WI 54952, 1004, Menasha, WI 54952, 1005, Menasha, WI 54952, 1006, Menasha, WI 54952, 1007, Menasha, WI 54952, 1008, Mensaha, WI 54952, 1009, Mensaha, WI 54952, 1010, Mensaha, WI 54952, 1011, Mensaha, WI Any help in pointing me in the right direction would be great. Thanks for your help in advance. ...Show All

• SQL Server package and file location dependencies on deployment

  My parent package calls packages stored in the file system. While developing, I would like to call packages in the project bin directory. In production, I would like to call packages in a different development. Is this possible I can change the package connection string with an expression that refers to user variables PackageLocation1 or PackageLocation2. I would like to do this automatically. Is this something that should be done at deployment time Or is there a run time value that I can check and conditionally use PackageLocation1 or PackageLocation2 Development and deployment is done on the same server, so the same enivronment variable value would be used in an indirect configuration. Same thing applies to a file configuration. ...Show All

• SQL Server The task Transfer SQL Server Objects Task cannot run on this edition of Integration Services. It requires higher level edition.

  Error code: 0xc0012024 Using "Integration Services Project" template in Business Intelligence Studio. Using platforms Visual Studio 2005 along with SQL Server 2005. Getting the error while trying to execute package after loading it programmaticaly. I've just one task "Transfer SQL Server Objects Task" on my Integration Services package. But when I try to execute it from VS 2005 project programmaticaly, it gives the above mentioned error. The commands I use: Package pkg = new Package(); pkg = a.LoadPackage(@"C:\Documents and Settings\abc\My Documents\Visual Studio 2005Projects\lSSIS\SSIS\Package.dtsx", null, true); DTSExecResult dResult = pkg.Execute(); The the error comes like: error: ...Show All

• Visual Studio Team System Controlling the name of the .sql file.

  Is there any way to control the name of the .sql file that is produced by datadude The background to this is that we want to put in a Post-Build step that chnges the .sql file to a name that is short enough for MSBuild to use. We've tried changing the name in TFS Build but thatr doesn't work because we cannot predict what the name of the file is going to be (because it puts the server name in there). Thanks Jamie Hi, What you have to do here is have another set of PropertyGroup as shown below under the Import Project: <Import Project="$(MSBuildExtensionsPath)\Microsoft\VisualStudio\v8.0\TeamData\Microsoft.VisualStudio.TeamSystem.Data.Tasks.targets" /> <PropertyGroup Condition=" '$(Configu ...Show All

• Community Chat What it takes for MS to get a Release out?

  Someone using my freeware commented to me: " Thanks a lot! Just think how much easier life would be if MS could match your reaction time. I'll be back with comments soon." Those are kind words but I've often thought about what it takes for MS to get a release out Vista, Vs2005 and Office are all examples but it seems to me that VS2005 and the operating systems might make an interesting discussion. I've been a lead engineer in a major hardware/software vendor and I have a little experience in this. I must admit that experience is out of date. I often think of the many, many components in VS2005 and the CLR that have to play together and with the operating system and the operating has to support them. Obviously there a ...Show All

• Visual Studio 2008 (Pre-release) Get all bindings on a page?

  Hi all, I'm trying to create an ErrorProvider that I can give a data context to and have it display errors automatically thanks to the IDataErrorInfo interface. Is there a way to interrogate the current page (this is a WPF navigation application) to find all the bindings on the page Thanks, Hi Mike, Thanks for the LogicalTreeHelper - that's exactly what I needed. I've implemented my error provider and I'll blog the code to it tommorrow night at www.paulstovell.net . I'll be sure to thank you and link to your site. Thanks a lot! ...Show All

• Software Development for Windows Vista Activity.TrackData sets wrong value for UserTrackingRecord.ActivityType

  When calling Activity.TrackData to send user tracking records to SQL Tracking Service, the ActivityType property of the resulting UserTrackingRecord is supposed to be " The Type of the activity that emitted the user data." However if the TrackData call is made from an event handler in a composite activity in response to an event raised in a child activity, then the ActivityType property is set to the name of the child activity, not the parent activity that actually calls Activity.TrackData. For example: CustomSequenceActivity ListenActivity EventDrivenActivity HandleExternalEventActivity1 EventDrivenActivity HandleExternalEventActivity2 1. HandleExternalEventActivity1 raises an event to the containing CustomSequenceActivity ...Show All

• Visual Studio Team System how to tf checkin multiple files

  Hi, Has anyone successful "tf.exe checkin" multiple files I get the following error when I try : "Target AfterCompile: "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\..\tf.exe" checkin /noprompt C:\DMDB_CODE\MARS Branch Project\DailyBuild\BuildType\..\Sources\daily build\MARS_Platform\UnitTestFramework\TestSupportFramework\TestSupportFrameworkTest\Properties\AssemblyInfo.cs C:\DMDB_CODE\MARS Branch Project\DailyBuild\BuildType\..\Sources\daily build\MARS_Platform\UnitTestFramework\TestSupportFramework\TestSupportTest\Properties\AssemblyInfo.cs C:\DMDB_CODE\MARS Branch Project\DailyBuild\BuildType\..\Sources\daily build\MARS_Platform\UnitTestFramework\TestSupportFramework\Valid ...Show All

• Visual Basic Questions on a class

  Hello. Some questions please. I created a class that contains a read method and an update method on a file. The first one returns an oledbdatareader (with all found rows) and the last one returns an integer (rows affected). My questions is: what should I return for each classes if there was an exception, what is the correct way to do that Thanks...   depends really. If there was an error I would throw the exception up and handle it or perhaps return nothing but would be ideal to throw the exception and catch it and show it to the user for example or handle it your way. The general rule is to catch the exception and handle it. If a class requires a value back (depends on data ...Show All