cdemez's Q&A profile

• Windows Forms Question about creating controls at runtime

  I have several controls that are created at runtime if a user requires them. When not needed the controls should not appear on the form. I created RadioButtons that would create the control (ListBox, TextBox ... etc) when clicked, and when the control was no longer needed I use the Dispose method. I thought that I could create (instantiat ) the control in the OnOptionTreeView_Click method; however, when I did that, I get the following error: 'projectEvents.formEvents' does not contain a definition for 'treeviewNameList' The error does not occur if I put the control creation code in the namespace level. My question then is, can the control instantion be put in the method that creates its properties or, must it be instantiated a ...Show All

• .NET Development Executing a method in a given thread context

  I'm porting win32 code (non visual component or "user control") to .NET. In win32 code, I was using Windows messages between threads to signal events form a worker thread to another thread. This was done to make sure an event handler was executed in the context of the thread having created an instance of the component class. The [non visual] component class use a hidden window to receive the messages from the worker thread it created. Now I'm porting this code to .NET using C# as language. I'm using the socket class and use the asynchronous operation, for example, Socket.BeginAccept to make the runtime use a thread to wait for incomming connections and call my callback function when a connection is available. From the ca ...Show All

• Visual Basic SQL command to Access database in vb2005

  Hopefully someone can shed some light on the problem I’m experiencing. I’m fairly new to vb2005 but I’ve managed to totally confuse myself. Below is an example I’m using to extract data from an access database however when I try to include a "Where/Like" command I’m getting no data returned. The really confusing thing is that if I paste the sql string into access it works fine. The actual sql string I build is:- “Select * from M_Businesses Where Description Like 'B*' Order by Description;” I’ve included code and an access database to recreate. Any comments would be much appreciated. Cheers John Private Sub TextBox1_TextChanged( ByVal sender ...Show All

• Visual Studio Tools for Office Uninstalling or upgrading existing outlook add-in

  Every time we want to install a new version (with changes) of outlook add-in; if it is already installed we have to first uninstall the previous version by going to add/remove programs. Is there anyway to create installer file that will update the existing add-in The following documentation does not provide any information on how to modify the custom action so that it actually uninstalls the previous add-in and installs the new one. http://msdn.microsoft.com/library/default.asp url=/library/en-us/odc_vsto2005_ta/html/OfficeVSTOWindowsInstallerWalkthrough.asp I think you have several options: 1. You can create windows installer patch (.msp file). Your patch will need to install new manifest ...Show All

• Visual Studio Team System Restricting Check-Out on File Type

  I think I know the answer to this already, but I figured I would ask... Is there a way to lock down certain file types that cannot be checked out for certain user groups For example, I don't want to allow our graphics team to checkout any .vb files, but it's cool if they check out .aspx files. So, can I restrict the graphics team group to only allow certain files to checkout Thanks in Advance! There's really not a great way to pull this off, as you've probably guessed. You could set permissions for all existing files of a particular extension, but managing this would be a huge challenge. If you went the permission route, I think it would be easier to manage if you chose to give the group PendC ...Show All

• Visual Studio Team System SQL Integration Services support

  Hello, Is it any special SQL Server 2005 Integration Services support in DataDude Or maybe it will be in next versions Thanks Thanks for that. But actually I mean comparison for example between Integration Services package and database or something like that. So, is there any special Integration Services features in VSTE for DB Pro ...Show All

• Windows Forms Published App Unattended Installation

  Hi Everybody, I'm trying to figure out if there is a way to have a published application perform a completely silent installation. I am running a VB.NET app on a kiosk that has no keyboard or mouse, and would like to be able to just plug in a USB drive with an updated setup file on it, and have it install without any prompting. I've already added functionality to my app to detect and run the installer on the USB drive. Any ideas how one might accomplish this Thanks! I think you might be able to do this if you don't need to run the bootstrapper. If you select the CD installation option, you can go to the Publish properties tab, and select Options, and click the "If you have a CD, auto sta ...Show All

• Smart Device Development get sms from the inbox

  how to get sms from the inbox my develop platform is c# .net cf 2.0 Thank you Try this: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnnetcomp/html/ReceivingSMSMessages.asp   http://www.microsoft.com/downloads/details.aspx familyid=98CCF3D4-DB7C-4A7D-A323-53BBDBBE0420&displaylang=en#RelatedLinks ...Show All

• Visual Studio Express Editions Fill an array from a text file.

  Sir/Madam, I need to fill an array from a text file. My text file looks like this for different people. First Name|Last Name|Address|Phone First Name|Last Name|Address|Phone First Name|Last Name|Address|Phone First Name|Last Name|Address|Phone First Name|Last Name|Address|Phone Do you know of any way to put these into an array from a text file where the "|" symbol seperates the columns Any help would be greatly appreciated! Well, let me see if I can explain the situation better.  This is an assignment for class on taking learning how to build an address book. Develop an Address Book program that will minimally retain the following information: Last Na ...Show All

• .NET Development Login failed

  I tried the following code Sub CreateDataAccessObjects( ByVal db As Database) ' Create relational datasource Dim ds As New RelationalDataSource( "THYROID" , "THYROID" ) ds.ConnectionString = " Integrated Security=SSPI; Provider=MSOLAP.3;Data Source=localhost;Initial Catalog=THYROID" db.DataSources.Add(ds) ' Create connection to datasource to extract schema to dataset Dim dset As New DataSet() Dim cn As New SqlConnection( " Integrated Security=SSPI; Data Source=localhost;Initial Catalog=" & CbDatabase.Text) ' Create the customers data adapter with the ' calculated column appended Dim daCustomers As New SqlDataAdapter( &quo ...Show All

• Visual Studio Express Editions How can my application can know that, file is being copied on the USB Mass Storage device?

  Hello I am working on USB Project, I am searching for any of the API's method in windows , so that my application can sense that a file in the PC is being copied or moved onto the USB mass storage device which is plugged-into my system. I am developing my application in VC++.Net 2005, that is MFC in windows XP. I want this code to work on any windows version of operating system. If this is not possible for all versions of operating systems of windows. What could be the case in windows XP. Can anybody help me out for this.. Where Can I any sample code which can help me.... Thank you Anoo Hello Re: How can my application can know that, file is being copied on the USB Mass Storage device ...Show All

• SQL Server Exporting a table with changing column names to an excel file

  I'm trying to write an SSIS package that exports a table that has changing column names to an excel file. The column names change due to the fact that the table is created by a pivot daily. the only thing I'm missing is the ability to dynamically map the tables' columns to the excel destination. Is this possible I read in another thread that "It is not possible to create packages or new objects within packages using SSIS." I also read in the books online that "The input and the input columns of the Excel destination have no custom properties." To me this means that I cannot programmatically create or remove columns in the excel destination. Please tell me I'm wrong. So, to summarize my research so far. In writing an ...Show All

• Visual Basic Could someone point me in the right direction?

  Not even sure where to start. Need to subtract quantity from inventory table when quantity is added to invoice table. Start with transaction stored procedure Any guidance would be appreciated. As a test database created two tables: Invoice: Field: Item as integer Field: Quantity as integer Stock: Field: Item as integer Field: Quantity as integer Added a record to stock Item = 1 and Quantity = 10. Added a record to stock Item = 2 and Quantity = 10. Added the following trigger: CREATE TRIGGER newstockvalue AFTER INSERT ON invoice FOR EACH ROW BEGIN UPDATE stock SET stock.quantity = stock.quantity - NEW.quantity WHERE stock.item=NEW.item; END; When I insert a record into the Inv ...Show All

• SQL Server Question about rebuild index

  Hi, Here is the result of T-SQL statement,"ALTER INDEX ALL ON MyDB.dbo.MyTable REBUILD;". ---------------------------------------- 5 130099504 1 1 CLUSTERED INDEX IN_ROW_DATA 3 0 99.7014211714703 5 130099504 1 1 CLUSTERED INDEX IN_ROW_DATA 3 1 100 5 130099504 1 1 CLUSTERED INDEX IN_ROW_DATA 3 2 0 ---------------------------------------- The column of the blue is 'index_level' and the red is avg_fragmentation_in_percent. If I issue 'alter index ... rebuild', only changed the first record's(index_level 0 ) avg_fragmentation_in_percent value. And the data file size is grow. Is it normal or has problem ...Show All

• Visual Studio Team System Problem with "RootPath" parameter

  Hi, I started today to make my first steps with VS for Database Professionals. I got a SQL Server 2005 database project from one of my co-workers and I can open it in VS. But then there are several problems: - I can only see one entry in the solution explorer (the main node) and I cannot expand it. - If I click right and choose "Build" I get the following message: The "RootPath" parameter is not supported by the "SqlBuildTask" task. Verify the parameter exists on the task, and it is a settable public instance property. The "SqlBuildTask" task could not be initialized with its input parameters. I don't what the "RootPath" parameter is good for. I think it only specify the path where the source and script files are in. T ...Show All