Search results for query: *

Yes, Thanks John, I guess I will need to add a dialog with checkboxes to accomplish what I need here, in conjunction with that code project code.

Is there an option to run the application after installing from a .NET msi install? Is there a key to turn this on that I am missing? Most install packages you see have a check box asking if you would like to run after installation.

Thanks JM, yeah I tried to sneak that one in there. :anonymous: I can post that separately.

I have a .NET install package in my solution (msi). I see there is a key to Remove Previous Versions (RemovePreviousVersions). However, it seems if I make code changes then rebuild the package it no longer is able to uninstall the previous version with the package but it tells you to go to the...

Does your catch block look like this ? Catch Ex as Exception

Do you think that ODBC may help with this instead of connecting directly through JET? I realize that would require decent amount of code changes and setting up each local workstation to connect to the database. Also, I am not sure this would be any different.

You may find this post helpful from the stack overflow forum: Is MS Access (JET) suitable for multiuser access? - Stack Overflow

Each column has a name property and you could convert that column to a date and based on that value hide or leave that column. Dim dc As DataGridViewColumn For Each dc In DataGridView1.Columns Dim dtVal As Date = CDate(dc.Name) If dtVal < pickedDate...

I have not personally used this object before, but you could look into the .NET URI object: Uri Class (System)

The IO.File.Copy method has an optional third parameter to overwrite. You could copy (and overwrite) the file and delete the original.

The state method is probably nothing because the object to which that property belongs is nothing. You must re-instantiate your connection object (= new Connection) and attempt to reconnect again.

You should use a while loop because this is not possible (to my knowledge) in a for loop: Dim i as integer = 0 While i < StudentList.Items.Count - 1 If Ready = True Then i += 1 Else 'do nothing End If End While Be careful because you could get stuck in an infinite loop...

The main hold up here is probably Excel, I have run 100's of programs like this one. But one main difference in mine is that I always used DataReader to iterate through the data you may see some sort of speed increase from doing things that way. Also I have done a neat trick where you place the...

I would use the Format function to get the dates into the proper format. Format(SchDateFrom.Value.Date, "MM/dd/yyyy") I am not quite sure what your problem is exactly.

Module Module1 Sub Main() ReadValuesAndSumNumbers() End Sub Private Sub ReadValuesAndSumNumbers() Dim done As Boolean = False Dim numbersDbl As Integer = 0 Dim ReadDblValue As Double = 0.0 Dim srtInput As String Dim summation As Double...

.Fill method of the DataAdapter should be where your exception occurs. Put a try block around that method and catch the SQLException and you should have all of the information you need in the SQLException object: Try DataAdapter.Fill(DataSet) Catch Ex as SqlClient.SqlException 'There are...

What connection string are you using to connect? Should look something like this: DSN=myDsn;Uid=myUsername;Pwd=myPwd; I receive this error when the Data Source Specified in my connection string does not exist.

The filenames property refers to the files that were selected by the dialog. I am not sure where this history comes from but I do know to what you are referring. I do not think there is a way to do this through code but there may be some way to do this through the OS or some other way.

You are correct this is because the connection you are attempting to open cannot find the data source, which in this case is looking for a local instance of sql express.

'exec YourSpName' is the sql code that will return the data you would like to use. You either fill a dataset with this command or use a datareader to perform the operations you want. You could then use executenonquery on the command object to update the database or call another stored proc as...