Advertisement
| 11.20.2008 at 08:32AM PST, ID: 23922021 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: |
Public Shared Function UpdateUniv(ByVal university As frmUnivEdit) As Boolean
Dim connection As OleDbConnection = GetConnection()
Dim updateStatement As String
updateStatement = " UPDATE University SET website=?, address=?, state=?, zipcode=?, BOFmanager=?, phone=?, fax=? WHERE UnivName=?"
Dim updateCommand As New OleDbCommand(updateStatement, connection)
updateCommand.Parameters.AddWithValue("?", university.txtWebsite.Text.Trim)
updateCommand.Parameters.AddWithValue("?", university.txtAddress.Text.Trim)
updateCommand.Parameters.AddWithValue("?", university.cboState.SelectedItem)
updateCommand.Parameters.AddWithValue("?", university.txtZipcode.Text.Trim)
updateCommand.Parameters.AddWithValue("?", university.txtBOFmanager.Text.Trim)
updateCommand.Parameters.AddWithValue("?", university.txtPhone.Text.Trim)
updateCommand.Parameters.AddWithValue("?", university.txtFax.Text.Trim)
Try
connection.Open()
Dim countUniv As Integer = updateCommand.ExecuteNonQuery
If countUniv > 0 Then
Return True
Else
Return False
End If
Catch ex As Exception
MessageBox.Show(ex.Message & vbCrLf & vbCrLf & ex.StackTrace, ex.GetType().ToString())
Return False
Finally
connection.Close()
End Try
End Function
Private Sub enableChangeMode()
'Disable the Change button and enable the Update button
btnChange.Enabled = False
btnUpdate.Enabled = True
'Disable all text boxes
txtUniv.ReadOnly = True
txtWebsite.ReadOnly = False
txtAddress.ReadOnly = False
cboState.Enabled = True
txtZipcode.ReadOnly = False
txtBOFmanager.ReadOnly = False
txtPhone.ReadOnly = False
txtFax.ReadOnly = False
End Sub
Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click
If StudentDataClass.UpdateUniv(Me) Then
MessageBox.Show("Record was updated in our database. ", "Database Information")
Else
MessageBox.Show("Unable to save the record. ", "Database Error")
End If
initialUnivFields()
End Sub
|
Advertisement