Recent content by Tim8w

Hi, Before the company moved to Office365, we used to be able to connect to the Exchange Server using Imap4 as follows: Private Sub ReadOutlookEMail() Dim imap4 As MailServer = New MailServer(ExchangeServerName, UserName, Password, True, ServerAuthType.AuthLogin...

Sorry, Figured it out. I removed all the queries from the TableAdapter and started fresh with my Query. Worked correctly...

Hi, I have created a DataSet in VB.Net. The Table it is connected to has a PrimaryKey. All works fine as long as my SQL Query is a Standard one like SELECT * from.... I want to use a GROUP BY but when I do I get "ConstraintException was unhandled" with the suggestion that I relax or turn...

I have a custom-shaped form created by setting the Region to an image. I want to be able to highlight the edge of the form when it has focus. To do this I believe I need to get the outline of the form and convert it to a path so I can draw a two-pixel gihlight around the edge of the form. (1)...

I ended up using four different RegEx to catch all the cases: sPattern = "((?<whole>\d+) (?<num>\d+)/(?<den>\d+))" ' 1 1/2 case regExp = New System.Text.RegularExpressions.Regex(sPattern, RegexOptions.Compiled) m = regExp.Match(dgvc.Value) If m.Success Then dDecValue =...

Now only missing the case for "1 3/4" and "2" (No decimal)

I need a RegularExpression that can convert a string from a fraction or decimal like "1/2" or "0.5" to a decimal "0.5". It needs to handle both cases. Input can be either fractional or decimal, output must be decimal...

I finally figured it out. Here's what I had to do: Dim CBox As DataGridViewComboBoxCell = CType(dgvRecipe.Rows(e.RowIndex).Cells(e.ColumnIndex), DataGridViewComboBoxCell) cmbColumnIngredient.Items.Add(e.FormattedValue) CBox.Value = e.FormattedValue

ousoonerjoe, That looks like a plausible solution, unfortunately in CellValidating where I am adding the item, the e variable is of type: System.Windows.Forms.DataGridViewCellValidatingEventArgs which members do not include Row. The member variables are: Cancel ColumnIndex FormattedValue RowIndex

I have a DataGridViewComboBoxColumn that I allow the user to add new items to by typing in the ComboBox and hitting the 'Enter' key. That triggers CellValidating and I do the adding there by the following: cmbColumn.Items.Add(e.FormattedValue) All this works well, except that it leaves the...

As jwavila reminded me on another forum... For iIndex = dgvRecipe.RowCount - 1 To 0 Step -1 dgvRecipe.Rows.RemoveAt(iIndex) Next iIndex

This is such a basic question, I'm almost emvbarassed to ask it. How do I loop through seleted rows in a DataGridView and remove the rows? I've tried this, but it doesn't work. After one row is removed, the index is all screwed up... iIndex = dgvRecipe.Rows.GetNextRow(-1...

Unhnd_Exception on another forum suggested I go directly to the DB instead of using Adapters... Here's the code I ended up using: Dim Connection As New OleDbConnection("...") Dim Command As New OleDbCommand Command.Connection = Connection Command.CommandText = "Delete From tblMasterRecipe...

I have the folloing code using OleDB to manipulate an Access database: Dim adpMasterRecipe As OleDb.OleDbDataAdapter Dim dsMasterRecipe As New System.Data.DataSet adpMasterRecipe = New OleDb.OleDbDataAdapter("SELECT * FROM tblMasterRecipe WHERE MasterID = @MasterID"...

I have a RichTextBox. I process all the formatting and everything works fine. There is an exception. When I have selected text that have two states of formatting in it, the SelectionFont member is set to Nothing. I notice that WordPad recognizes this condition and kindof greys out the affected...