0bject reference error

[compdrmt]

here is the code that causes the error

I have tried the same thing various ways and always get the same error

object reference nt set to instance of object

Private conn As New OleDbConnection(sconnstring)

Dim adapter As New OleDbDataAdapter
Dim cmd As OleDbCommand

ssql = "INSERT INTO assets (desc, col2value,col3value) "
ssql = ssql & "VALUES ('" & desclist.Text & "','" & desc2.Text
ssql = ssql & "','" & desc.Text & "')"

cmd.Connection = conn
cmd.CommandType = CommandType.Text
cmd.CommandText = ssql
cmd.ExecuteNonQuery()



Any ideas


Compdrmt

Debugging is the process of removing bugs. Programming is the process of putting them in.

 

[chrissie1]

perhaps this

Dim cmd As new OleDbCommand


Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting