[2008] Insert mysql

whats wrong with this insert function

Code:

---

m_con = New SQLiteConnection(ConfigurationManager.ConnectionStrings("constr").ToString)
            m_con.Open()
            m_sqlstate = "" : m_sqlstate = "INSERT INTO support_action (case_id,product_id,member_id,support_id,action_datetime,action_text)" & _
                                      "VALUES ()"
            m_da = New SQLiteDataAdapter(m_sqlstate, m_con)

---

No values specified, and the use of a data adapter over a command to execute a non-query statement. Also, initialising the m_sqlstate string twice ;)

Parameterized commands: http://www.vb-helper.com/howto_net_d...zed_query.html

Quote:

---

Originally Posted by wence

whats wrong with this insert function

Code:

---

m_con = New SQLiteConnection(ConfigurationManager.ConnectionStrings("constr").ToString)
            m_con.Open()
            m_sqlstate = "" : m_sqlstate = "INSERT INTO support_action (case_id,product_id,member_id,support_id,action_datetime,action_text)" & _
                                      "VALUES ()"
            m_da = New SQLiteDataAdapter(m_sqlstate, m_con)

---

---

If you get any exceptions or error messages, always mention them. It doesn't matter if the answer is obvious.