VB .net, Access Error - specific cast not valid

29 Aug 2006 11:24 AM

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

29 Aug 2006 11:47 AM

Peter Proost

Maybe an NULL value in one of the values you want to add

hope this helps,

Greetz, Peter

--
Programming today is a race between software engineers striving to build
bigger and better idiot-proof programs, and the Universe trying to produce
bigger and better idiots. So far, the Universe is winning. (Rich Cook)

Show quoteHide quote

"amit" <amit.mural***@gmail.com> schreef in bericht
news:1156850654.850422.288600@m73g2000cwd.googlegroups.com...
> 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
>

29 Aug 2006 12:14 PM

amit

Thanks peter,

You solved my problem...