Peter Mooney's Q&A profile

• SQL Server How to add SQL statements to the package created by Export Data wizard?

  How to add SQl statements to the package created by Export Data wizard I need to add SQL coming from file, the flow would be like this: 1) SQL would drop all objects: (views, tables, stored procedures) etc 2)  SQL would create all objects: (views, tables, stored procedures) etc 3) Export Wizard SSIS package would execute Also is there a dynamic way to add more tables do the package once created in SQL database I would like to put the whole task on a scheduler too... I was asking simple questions, some of them are not in the online books (I checked). Like why the controls are greyed out...   ...Show All

• Windows Forms Duplicating the Print. . . and Send To functionality

  I have read through a few threads dicussing printing the active window form.  I also would like to to do this plus duplicate the Sent To functionality where the form could be sent to a printer or an email. The threads I saw were not very encouraging.  It appears, it would be better to render the form as a report and print or email&n ...Show All

• Windows Forms Edit datagrid cell via combobox

  I need to edit a value in datagrid cell, but its value mast be set from dictionary, so I'd like to use a combobox. I've properly data loaded combobox, but I don't know how to insert this combobox into datagrid cell & then retrive a selected value. Any help or tips <A HREF="http://www.syncfusion.com/FAQ/WinForms/default.asp#44">Check item 5.8&l ...Show All

• Visual Studio Team System Question about authentication through VPN??

  Hi, We have some long term contract developers that work for us - we provide them a VPN account to get into our network and I was wondering if that will work the the TFS client   the user logs into their computer using either the domain account or local account (not sure which one) then VPN's to our network - question is, with the TFS integration with AD, does that work through only a VPN connection or does the user "really have to be logged into our domain" Also with the proxy server addition, if we place a proxy server at their site, does that have to be part of the domain   I would assume that needs a VPN connection too s ...Show All

• Visual Basic Use string value as variable name

  How do I use a value of a string as a public variable name/object that I can then change.... dim var1 as integer dim var2 as integer dim var3 as integer...ect... Dim vroot as string = "var" Dim i as integer = 1 Do var + i.tostring 'this returns "var1" 'now how do i use this var1 returned value to act like a variable i=i+1 loop until i = 15 Also how would i do this with objects....say i had a series of labels named label1, labe2, label3...ect... to call these through a "label + i.tostring + .text" script also...... Catch my drift....is this possible Thanks! For the issue with variable names, here is ...Show All

• Windows Forms Using Clickonce to install MSI?

  Hey everyone, I'm not sure if this question has been answered before - so forgive me if it has already.... I was thinking of using Clickonce to install an MSI file (which would be installing services), and then using Clickonce to download new versions of the MSI file and install them.  I believe that the MSI files can configure the services (e.g. stop the service from running, install the new one, and start it.)  Does anyone know if this is a solution to my problem I'm sorry once again if this has been answered already, and I would appreciate a link to that thread if applicable. Regards, Jon ...Show All

• Windows Forms Error msg of pre-requisites??

  Hi, I am creating a Setup and Deployment project for creating a Windows Installer. I have to check for pre-requisites of SQL Server, If SQL Server is not installed i have to abort the installation. I did this using the Launch Condition Editor, but soon after I run the .msi the error message pops up saying SQL Server is not installed, before the Welcome screen appears. I want the error message to pop up after the welcome screen. Also I tried writing a custom action which throws error message if SQL Server is not installed, this message pops up only when starting installation, but soon after my error message comes, another message is thr ...Show All

• Software Development for Windows Vista GoTo Activity

  Hi Is there a custom activity which implements the functionality of GO TO thanks Bobs A possible solution to bypass the lack of GOTO in a SequentialWorkflow may be to use the EventHandlingScopeActivity . For a description of the technique and a sample project, you can see here . ...Show All

• .NET Development Finding all indices of a substring in a string

  Hi,   How can I find indices of all occurences of a substring within a string   THanks,   In C#: String strSourceString = "as as as as as"; String strSearchString = "as"; int intStartIndex = 0; int intNumIndices = 0; while (strSourceString.IndexOf(strSearchString, intStartIndex) > -1) {     intNumIndices++;     intStartIndex = strSourceString.IndexOf(strSearchString, intStartIndex) + strSearchString.Length; } // intNumIndices = 5 You can also use Regular Expressions. ...Show All

• .NET Development access data from a Deleted DataRow

  Hi! I have a DataRow marked as deleted. How can I get the data behind the row I tried to use Table.Select with several parameters but didn't succeed. I always get a System.Data.DeletedRowInaccessibleException when I try to do something like: pkID=myRow["pkID"] or in VB syntax... pkID=myRow("pkID") would it be too much to ask for an example Which indexer are you talking about DataTable.Rows does not seem to have such an overload. ...Show All

• Smart Device Development CF Camera wrapper in PPC2003

  Hi Anyone know how to capture picture from CF camera in PPC2003 I'm using Visual Studio.NET 2005 Thanks in advance Please see this: http://forums.microsoft.com/MSDN/Search/Search.aspx words=Camera%20capture&localechoice=9&SiteID=1&searchscope=forumscope&ForumID=33 ...Show All

• .NET Development Catching unhandled exceptions in services

  All - Is there anyway to catch unhandled exceptions in a windows service or is this completely impossible These are exceptions thrown from background threads running in the service Thanks. Actually this works and you'll see the assert if the service can interact with the desktop. frefre namespace Service2005 { public partial class Service1 : ServiceBase { Thread thread = new Thread(ThreadFunction); public Service1() { InitializeComponent(); } static void ThreadFunction() { throw new ApplicationException(); } protected override void ...Show All

• Visual Basic How do I load a picture from resource file into a picturebox?

  -Visual Basic Express 2005- I have a resource file and have included all my images into. I need to load hundred.jpg into a picurebox when a certain event occurs. I hope to get the simplest line of code possible to do this Can anyone please help Thanks in advance :) PictureBox1 .ImageLocation = "C:\Documents and Settings\Owner\My Documents\Visual Studio 2005\Projects\ Project Name \ Project Name \Resources\hundred.jpg" The italicized Project Name should be replaced with the name of your project file, as should PictureBox1 be replaced with the name of the picture box. I pulled all of this from memory, so if t ...Show All

• Visual Studio Express Editions Is The OOP Microsoft.VisualBasic.IIf Equivalent To the Procedural If Then?

  Is the OOP Statement Microsoft.VisualBasic.IIf equivalent To the Procedural Statement If Then Thanks Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim a As Integer = 0 Dim b As Integer = 1 Dim c As String = "True" Dim d As String = "False" Microsoft.VisualBasic.IIf(a < b, c, d) MessageBox.Show(c) MessageBox.Show(d) End Sub One of the major flaws in vb. . . the heavy iif statement - both sides get evaluated. so if the right side is erroneous, the thing blows u ...Show All

• Visual C# Active Directory Events

  Hello. I need some help with Active Directory changes tracking. I find an example  in MSDN, but it's in C++. So... How can I track changes from C# Has someone example code for this or similar task Thanks. Yes, of course. But I cant find any events there... ...Show All