Try changing from
insertCommand.Parameters.AddWithValue("@f_name", DS.Tables(0).Rows(0).Item("First_name"))
insertCommand.Parameters.AddWithValue("@l_name", DS.Tables(0).Rows(0).Item("First_name"))
insertCommand.Parameters.AddWithValue("@customer", DS.Tables(0).Rows(0).Item("customer_name"))
to
insertCommand.Parameters.AddWithValue("@f_name", DS.Tables(0).Rows(0).Item("First_name"))
insertCommand.Parameters.AddWithValue("@l_name", DS.Tables(0).Rows(0).Item("Last_name"))
insertCommand.Parameters.AddWithValue("@customer", DS.Tables(0).Rows(0).Item("customer_name"))
I am just guessing that
Last_name
is the proper column name.
Be advised that this is not a good way to code.
With all these hard coded indexes you are bound to run into errors eventually.