A.J. Mee's Q&A profile

• SQL Server execute SQL task with in a For Each Loop

  hi guys, i'm trying to do a bulk insert through a t-sql which accepts 3 params. i frist run a SQL statement to get a list of DB's to update through a SQL task, then i save the output to a variable object. which is been used by the For each loop. i've done the mapping with the object fine. but i want to call a SQL task within for each loop, and parse the above results as parameters. i tried parsing it as exec mysp3 @[User::fundid], @[User::dbCode], @[User::subfund] where fundiid, dbcode and subfund are user defined variables that gets updated by the ado recordset. this fails with the error msg: SSIS package "SP test ...Show All

• SQL Server Combining tables

  Here's an issue I am having, I am currently getting data from a customer table, sales table, and a definitions table, it has 2 inner joins, It creates a temporary output table. Now, this table only includes data from the customers that actually had sales. I need a way to select into that temp table all the customers that are not currently in that table. Is there a way to do this Any help would be greatly appreciated. Jim Hi, therefore better use a LEFT JOIN which will be also applied to those customers which don’t have any entries in the joined tables. But this is just a common approach which *could* fit to your needs. Before givin ...Show All

• Windows Forms Creating a Data Library

  Hello, How do I call methods and use classes from a VB.Net class library project  I have a UI project and a seperate class library for CRUD processing on datasets. I am new to the platform and don't know how do what I need to do. I have added a project reference to UI project, but when I try to call the methods from the CRUD na ...Show All

• Visual Studio setup problem of beta2

  Hi all, I have a problem installing vs.net 2005 beta 2 on my laptop. I have a fresh setup of winxp sp2 without nor previous versions of .net framework 2.0 beta neither any other .net framework installed in this machine. The setup stops installing the .net framework itself. I've also tried downloading the .net framework alone from msdn but I obtain the same error. Looking at setup log what I found is: MSI (s) (C4:88) [18:26:44:242]: Executing op: ActionStart(Name=DD_CA_Regtlb_mscoree.tlb_X86.3643236F_FC70_11D3_A536_0090278A1BB8,,) 06/04/05 18:26:44 DDSet_Exit: RunProcess ended MSI (s) (C4:88) [18:26:44:242]: Executing op: CustomActionSchedule ...Show All

• Smart Device Development Voice Command and Mobile PC

  I am about to begin developing an application for Mobile PC that requires the user to dictate a string of letters and numbers into the computer and have that string of number and letters appear on the form. Is Voice Command 1.5 capable of this I have read the rather sparse manual that comes with the software and it looks like it is only capable of predefined operations, however, I am hoping someone has had experience with this type of operation and can give me some advice. If VC cannot do what I need it to do are there any suggestions on alternative voice recognition software Thanks in advance! I believe that Voice Command is an app wri ...Show All

• Windows Forms browsing open forms

  In VBA there was a collection of open forms (Forms). How can I check, in VB .NET the open forms , and detect which one has the focus, all that from code If you are using Visual Studio 2005 then you can use the OpenForms collection: Application.OpenForms and then enumerate (using a for..next loop) and check which form's ContainsFocus property is true.   If you are not using 2005, then there isn't any way to enumerate open forms -- you'll have to write code each time a form is opened and save a reference to that form in a collection.   -mark Program Manager Microsoft This post is provided "as-i ...Show All

• .NET Development Strange behaviour from web.config

  Hi, I have a web service running in Window 2003 that make some call to a DCOM. As default, ASP.NET doesn't have any permission to execute a DCOM. To enabled that, I add in a <identity> tag to impersonate an account that has the permission to execute DCOM. Instead of put in a clear text username/password, I have used aspnet_setreg tool to encrypt username/password and stored in registry. The issue here is that once I called the web service, other user that call this web service will hit an error in web.config saying failure when read pasword from registry. But strange enough, after left the web service idle for some times, another ...Show All

• SQL Server Conditionally adding a column to my custom component

  Hi, I am building a custom component have a IDTSCustomProperty90 property that can take the value 'True' or 'False'. Depending on its setting, I want to include (or not include) a column in the output. Any advice on how to go about doing this (with some sample code) would be much appreciated! Here's how I'm declaring the property in ProvideComponentProperties() IDTSCustomProperty90 IncludeErrorDesc =  ComponentMetaData.CustomPropertyCollection.New(); IncludeErrorDesc.ExpressionType = DTSCustomPropertyExpressionType .CPET_NONE; IncludeErrorDesc.Name = "Some Name" ; IncludeErrorDesc.TypeConverter = typeo ...Show All

• .NET Development .NET High Speed Timers - Precision/Accuracy

  There are 3 timer types in .NET (System.Windows.Forms.Timer, System.Timers.Timer and System.Threading.Timer) From the documentation the System.Windows.Forms.Timer timer interval precision is one-eighteenth of a second (55.55 milliseconds). http://msdn.microsoft.com/library/default.asp url=/library/en-us/vbcon/html/vbconlimitationsoftimercontrolsintervalproperty.asp I cannot find any details on the other timers precision/accuracy. I want to plot graphical data on a periodic basis - every 10 milliseconds. Will this be achievable with timers Which timer would be the best to use Would I have to change anything in the underlying PC archi ...Show All

• SQL Server use multiple databases as source for report builder

  I have table's in multiple databases. I am trying to access them in the report builder. I tried view's but it doesn't display them. any Idea's. You need to open model designer, open the DSV based on views and for all views define PK/FK columns. This is require by model generation wizard - otherwise it can not generate entities and roles. ...Show All

• Software Development for Windows Vista Vista CTP on MSDN???

  I was told that the vista CTP would be on MSDN, but I don't see it yet. Does anyone here know where it is at the moment. I am dying to get my hands on this build. The winhec build ended up not showing up on MSDN. Will this one have the same fate If you don't know when it will be on MSDN, do you know who I can call at Microsoft to find the answer I tried MSDN online conceirge and they don't even know the build exists according to the person I talked to. Adding on to what Lori said about version matching, here are two more valuable resources that should help: http://www.longhornblogs.com/rrelyea/archive/2005/ ...Show All

• Windows Forms datagridview woes

  Alright folks, I have a datagridview that is for viewing purposes only, no editing is done via the datagridview itself. I'm manipulating the database with oledbcommand's via code. So I have to find some other way to update the datagridview because apparently It won't do it on its own. I guess you could call it a hybrid. When I first started this, the datagridview would not update at all, that's a given. So I created a sub to update it. Private Sub FillFactoryDataView() Try Me.OleDbDataAdapter1.Fill(Factory1) Me.FactoryAQueueBindingSource.DataSource = Factory1 Catch ex As Exception End Try ...Show All

• SQL Server T-sQL questions

  Hi: Some basic T-SQL questions please: 1) When I make changes to a stored proc (drop and recreate ) I have to reissue EXEC permission to users. Is there a keyword that helps to avoid that 2) In a SP I have multiple select statements. I'm only interested in the results of the last statement. When I run the SP from Query Analyzer it returns a result set for each select statement and When I call it from ASP.net I get .rowcount = 0. What am I doing wrong 3) Is there a way to return a result set from a SP to another SP that avoids cursors I'm using a temp table in the outer proc and filling it in the inner proc. Thanks, B. ...Show All

• Software Development for Windows Vista ASP.NET need to shutdown runtime.. WHY? BUG?

  I am finding that if I do not shutdown the runtime (last line of sub) then the workflow I am calling does not execute again. I do not want to have to incur the performance cost to start the runtime again, but have not found a way around this. Any ideas Private Sub StartWorkflow() ' Set up the parameters Dim parameters As Dictionary( Of String , Object ) = New Dictionary( Of String , Object )() parameters.Add( "FirstName" , txtFirstName.Text) parameters.Add( "LastName" , txtLastName.Text) parameters.Add( "Company" , "" ) Dim workflowRuntime As ...Show All

• .NET Development Stripping certain part of XML for info...

  Hello, I posted this on the Visual Express Forum, but not many replies. I thought that the XML place could help me bit more... This is used on Visual Basic Express,just to let you know... Well, I need to strip out: http://img.maps.yahoo.com/mapimage MAPDATA=eJz6K.d6wXVM6myr2yRPfx6.kl.uMGgD3Tu4JtDQzr_33pFEsTTSaosZ9OCtsiDrsLv9t65fzjz0CJm6JO2v_ZIHLflY9gto.xWMK9ovlRJVmrBLO4FoSsh3Ipsr from: < xml version="1.0" > < Result xmlns:xsi =" http://www.w3.org/2001/XMLSchema-instance " > http://img.maps.yahoo.com/mapimage MAPDATA=eJz6K.d6wXVM6myr2yRPfx6.kl.uMGgD3Tu4JtDQzr_33pFEsTTSaosZ9OCts ...Show All