I'm having a major brainfart today and can't think straight.
I'm binding my DataGridView to a BindingSource, and then binding the BindingSource to a DataTable like this:
I'm getting an error on the Fill method:Code:Private Sub(ByVal part As String) ' SET CONNECTION STRING Me.PartReqsCon.ConnectionString = DataBaseTools.GetConnectionString("PartReqs") ' SET COMMAND STRING Dim cmdString As String = "SELECT * FROM PartReqs_tbl WHERE PartKey = " & part ' RENEW DATA ADAPTER Me.ReqsDataAdapter = New OleDbDataAdapter Me.ReqsDataAdapter.SelectCommand = New OleDbCommand(cmdString, Me.PartReqsCon) ' CREATE COMMAND BUILDER FOR DATA ADAPTER Dim commandBuilder As New OleDbCommandBuilder(Me.ReqsDataAdapter) ' CREATE DATA TABLE AND SET LOCALE Dim table As New DataTable() table.Locale = System.Globalization.CultureInfo.InvariantCulture ' FILL DATA TABLE Me.ReqsDataAdapter.Fill(table) ' BIND DATA TABLE Me.ReqsBindingSource.DataSource = table ' DATAGRIDVIEW IS BOUND FROM DESIGNER End Sub
"No value given for one or more required parameters."
I created a breakpoint and it looks like all of the requirements are there. What am I missing?




Reply With Quote