[VB.net][Orcale][Resolved] A first chance exception of type "System.ArgumentNullException" occurred in Orcale.DataAccess.dll

ERROR MESSAGE

A first chance exception of type "System.ArgumentNullException" occurred in Orcale.DataAccess.dll

System.ArgumentNullException: 值不能為null

參數名稱: command

於 Oracle.DataAccess.Client.OracleDataAdapter.Fill (DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, DbCommand commad, CommandBehavior behavior)

於 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)

於 test.frmUsr.tbSearch_Click(Object sender, EventArgs)於 ....frmUsr.vb: 行138

The thread 0x5b0 has exited with code 0 (0x0)

Source

With dbCommand

  .Connection = gConn

  .CommandType = CommandType.Text

  .CommandText = "SELECT * FROM liblnk_group"

  dr = .ExecuteReader()

  dataAdapter.Fill(dsUsr,"liblnk_group")

  Me.dgvData.DataSource = dsUsr.Tables("liblnk_group")

  While dr.Read()

    Debug.WriteLine(dr.Item(0)+","+dr.Items(1)+","+de.Item(2))

  End While

End With

Amendment

With dbCommand

  .Connection = gConn

  .CommandType = CommandType.Text

  .CommandText = "SELECT * FROM liblnk_group"

  dr = .ExecuteReader()

  dataAdapter.SelectCommand = dbCommand

  dataAdapter.Fill(dsUsr,"liblnk_group")

  Me.dgvData.DataSource = dsUsr.Tables("liblnk_group")

  While dr.Read()

    Debug.WriteLine(dr.Item(0)+","+dr.Items(1)+","+de.Item(2))

  End While

End With