VB .net, Access Error - specific cast not valid

  • Thread starter Thread starter amit
  • Start date Start date
A

amit

Hi guys

I am trying to use Access Database with VB .net.
In the stock database I have Fields Code and DrugName; Data Type of
both is Text.

In the following code line marked with *** gives the error "specific
cast not valid "

The type of both code and drugname is same so logically it should not
give any error.

Plz help me...


ocmEmpresas.CommandType = CommandType.Text
ocmEmpresas.CommandText = "Select Code,DrugName from Stock"
Dim dr As OleDbDataReader
dr = ocmEmpresas.ExecuteReader()
While (dr.Read() = True)
ListBox1.Items.Add(dr.GetString(0))
****ListBox2.Items.Add(dr.GetString(1))****
End While



Thanks & Regards
Amit
 
Maybe an NULL value in one of the values you want to add

hope this helps,

Greetz, Peter
 
Back
Top