All I am trying to do is get values from the Stats table and display them in a datagrid. Usually a pretty simple task, but for some reason I keep getting the No value given for one or more required parameters. I have a feeling it is going to be something stupid and simple and I am just not seeing it. Please help.
CODE
Private Sub btnFindPlayer_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnFindPlayer.Click
Try
sql = "SELECT DateofGame, Opponent, FieldGoals, FreeThrows, ThreePointers, Rebounds, Assist, Steals, Turnovers, Blocks, Points FROM Stats Where PlayerID = " & cbPlayer.SelectedValue & " AND SeasonID = " & cbSeason.SelectedValue
ds2.Clear()
daStats = New OleDbDataAdapter(sql, conn)
daStats.Fill(ds2)
dg.DataSource = ds2
Catch ex As Exception
MsgBox("Error: " & ex.Source & ": " & ex.Message, MsgBoxStyle.OkOnly, "Error")
End Try
response = MessageBox.Show("Do You Want To View Player Averages?", "Player Information", MessageBoxButtons.YesNo, MessageBoxIcon.Question)
If response = 6 Then
Averages()
End If
End Sub
| 