Advertisement
| Hall of Fame |
|
[x]
Posted via EE Mobile
|
||
Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
||
| Question |
|
[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: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: |
Private Sub btnAccept_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAccept.Click
If dgResults.Rows.Count = 0 Then
MsgBox("cannot accept empty trailer.", MsgBoxStyle.OkOnly)
Exit Sub
End If
'delete contents of tbl_Current_Wave from database.
Dim oledbConnection As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source='I:\Wave_Selection\Wave_Selection.mdb';Persist Security Info=False")
oledbConnection.Open()
Dim oledbCommand As New OleDb.OleDbCommand("DELETE * FROM tbl_Current_Wave", oledbConnection)
oledbCommand.ExecuteNonQuery()
oledbConnection.Close()
'get julian date. prompt for trailor name. check if exists.
Dim x As String
Dim iCheck As Integer = 0
'Dim sJulian As String
'sJulian = Now.DayOfYear.ToString.PadLeft(3, "0")
x = InputBox("Name the Trailor", "Trailor Name")
If x = "" Then
Exit Sub
End If
Dim stringSQL As String = "SELECT [WAVE] FROM tbl_Waves GROUP BY WAVE "
Dim zAdapter As New OleDbDataAdapter(stringSQL, connectionString)
Dim tCheck As New DataTable
zAdapter.Fill(tCheck)
Dim dview As DataView = tCheck.DefaultView
For z As Integer = 0 To dview.Table.Rows.Count - 1
If dview.Table.Rows(z).Item("WAVE") = x Then
iCheck = iCheck + 1
End If
Next z
If iCheck > 0 Then
MsgBox("Trailor Name already exists", MsgBoxStyle.Exclamation)
Exit Sub
End If
iSkip = iSkip + 1
'Set datatable equal to the datagridview.
Dim tSorter1 As New DataTable
tSorter1.Clear()
tSorter1 = dgResults.DataSource
'set adapter to tbl_Current_Wave. Store dgResults data in tSorter.
Me.Validate()
Dim cn As New OleDbConnection(connectionString)
cn.Open()
mAdapter.SelectCommand = New OleDb.OleDbCommand("SELECT * FROM tbl_Current_Wave", New OleDb.OleDbConnection(connectionString))
Dim cb As New OleDb.OleDbCommandBuilder(mAdapter)
'Add column that will hold wave name
If Not tSorter1.Columns.Contains("Wave") Then
Dim WAVE As DataColumn = New DataColumn("WAVE")
WAVE.DataType = System.Type.GetType("System.String")
tSorter1.Columns.Add(WAVE)
End If
'Insert name into wave column
Dim dv As DataView = tSorter1.DefaultView
For y As Integer = 0 To dv.Table.Rows.Count - 1
dv.Table.Rows(y).Item("WAVE") = x
Next y
'Update Database
mAdapter.Update(tSorter1)
cn.Close()
'clear contents of grid.
mAdapter.SelectCommand = New OleDb.OleDbCommand("SELECT * FROM tbl_Waves WHERE OAPS = 'Z' ", New OleDb.OleDbConnection(connectionString))
Dim clearTable As New DataTable
mAdapter.Fill(clearTable)
dgResults.DataSource = clearTable
'remove totals from dgvtotal.
Dim iColumnCount As Integer = 7
Do Until iColumnCount = 20
dgvtotal.Item(iColumnCount, 0).Value = ""
iColumnCount = iColumnCount + 1
Loop
'Show form with current wave selection
If F9 Is Nothing OrElse F9.IsDisposed Then
F9 = New frmVarify
End If
F9.Show()
F9.Activate()
End Sub
|