Search results for query: *

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...

Basically I found the answer here: http://msdn.microsoft.com/en-us/library/system.windows.forms.richtextbox.selectionfont.aspx It said: If the current text selection has more than one font specified, this property is Nothing

I have a RichTextBox where part of the RichTextBox is Bold and the rest is not. If I do a SelectAll, the SelectionFont member doesn't get set. Anyone know why? In WordPad, with the identical Font and bolding set on part of the text, the SelectionFont appears to get set to the first font it...

r937, That worked fine! Thanks for the help. Maybe I can finish this program for them tonight because of your help! Thanks again!

I am writing this program for a large group of non-profit seminary schools and anyway, I'll list the entire table if that helps although I doubt it will... I realize that to get the answer I need I only need the following tables: Table 1: ClassHeader ClassID ClassName Description Units Major...

I have the following three tables: ClassHeader ClassID Major TeacherClasses TeacherID ClassID StudentClasses TeacherID Major I want to select all TeacherClasses where the a given Major = ClassHeader.Major