Search results for query: *

Hi, I've got a simple MSI installer for my VB.Net WinForms application and I have it set to insert a single registry key into the computer's HKEY_LOCAL_MACHINE node. This usually works, but if the user doesn't have access, the MSI spits out an error. Is there any way in the MSI installer to...

I've got a tab control that I dynamically create tabs for each record in a dataset. In each tab, a web browser control is dynamically created as well. It looks like this: For Each Row As DataRow In DataSet.Tables("Pages").Rows TabControl1.TabPages.Add(Row.Item("tab_title")...

I'm moving into a new data center. I don't consider myself a network engineer or anything but I do understand the basics. The new data center I am moving into routes my network to me a bit differently than my old data center, so I thought I'd post here and ask for some help. The IOS on the...

I've got an app where I want to pull data from a MySQL database into a DataSet, then take the data in the DataSet and insert its records into a SQL Server database table. What is the best way to accomplish this?

I've got a type TEXT field where users are putting in values such as: Field 1: [VALUE1] Field 2: [VALUE2] Field 3: [VALUE3] Is there any way in SQL to take that single TEXT field and create a field for FIELD 1 with the value, FIELD 2 with the value, and FIELD 3 with the value? The value would...

Is there any way to have a sub routine do an "Exit Sub" on the sub it was called from? I.E. In the following, I would want the "Test" MsgBox not to show if the variable > 0. Effectivly, Sub Test() would terminate execution of Sub Main(). Sub Test() If variable > 0 Then *** EXIT SUB MAIN BELOW...

Is there any way to have empty values converted to NULL on an insert or an update? I've got an application that will inserted '' rather than NULL if a textbox is left blank. My desire is to have it insert a NULL. I was hoping to find a solution that would enable me to not have to do all this...

...But I have a combobox that is bound to a data source. I have fields on the same form that display data based on which item is selected in the combobox. Everything is working fine. My question is, when the form loads, the first item is selected with all of its data shown. Is there a way to...

I have a simple combobox that I don't want to bind to a data table. I just want to add a few items to it. combobox_status.Items.Add("Active") combobox_status.Items.Add("Inactive") I want the user to see the descriptions above, but when selected, I want to be able to use a value instead of the...

Am I the only one that needs to be able to allow a WinForms application to modify and SAVE an application-scope connection string at runtime? Seriously though, am I the only one who needs to do this, because apparently the only way to do it is edit the stupid XML app.config file, which is great...

I have an application that executes 5 external commands via the shell function. There are times where a command can take 5 seconds to open and close, and sometimes 5 minutes. When executing the commands via the shell function, I have specified the wait option with a -1 timeout. I don't want the...

I've got a form with a tab control where I have different settings on each tab. The settings are stored as user settings. I'm having a problem where settings are erased unless I flip through ALL tabs. I can't figure out whats going on. I.E. TAB 1 contains a folder path TAB 2 contains a...

I have an SSIS package that starts with an FTP task that downloads all files in a remote directory to a local folder using a wildcard... The remote directory will sometimes have files in it and sometimes not. The package runs fine when files are in the remote directory, however if the package...

I have a simple Visual Basic application that I've created (I'm a beginner) that essentially pulls data out of a SQL table and presents it in a table. Very simple. It was created in VS2008. One of the things I'm trying to figure out is how am I able to give the user the ability to tell the...

Is SSIS capable of monitoring a folder for a file? I'd like to monitor a folder that will have an XML file put into place by another system, and as quickly as possible import and process this file. If this is possible, how flexible is this folder monitoring. For example, can SSIS reconize when...

I've got an application that has an embedded insert statement that I do not have access to edit. It hits the MySQL 5.0 server like this: INSERT INTO TABLE (PATH) VALUES ('D:\Reports\') MySQL is complaining about this, because it looks like the slashes are being treated as escape characters. Is...

What's the best way to handle the following scenario in SQL Server 2005? I have a table with claims in it that get transferred from one entity to the next, sometimes once, sometimes 10 times. The table has the following format. My goal is to group all the claims with their INITIAL claim...

I have a situation where I have a bunch of fields like this: ZX827256BC XYZ90393SD CBZ933II What I really want to do is find a function that just strips out non-numeric characters, leaving me with just the numbers. Is this possible?

I'm new to Visual Studio 2008 and have built my first application using Visual Basic. Super simple. 1) Added new data source which points to an ODBC data source. 2) Drug the table to the form which gave me a data grid view. Everything works find. It works when I take it to another computer...

I have a single field in MS Sql Server 2005 that has the following format: NOTES ----- {VALUE1} AAA {VALUE2} BBB {VALUE3} CCC What I'm trying to do is parse this field out to throw each value into another table. So it would parse it out like so: VALUE1 VALUE2 VALUE3 ------ ------...