C# MySQL insert data issue

I am currently having an issue in inserting data into the MySQL database. Our code inserts null values when the form is submitted with no errors. This is the first time we are working with MySQL for the first time. We usually work with SQL Server and it works with no problems. We need some one to look into why it is entering in null values. Please see the script below and see if we are doing wrong. string insertSQL; insertSQL = "INSERT INTO vendors ("; insertSQL += "fname,"; insertSQL += "lname,"; insertSQL += "company_name,"; insertSQL += "address_1,"; insertSQL += "address_2,"; insertSQL += "city,"; insertSQL += "state_id,"; insertSQL += "postal_code,"; insertSQL += "phone,"; insertSQL += "fax,"; insertSQL += "email,"; insertSQL += "web_url,"; insertSQL += "password,"; insertSQL += "active,"; insertSQL += "status,"; insertSQL += "date_entered) "; insertSQL += "VALUES ("; insertSQL += "@fname,"; insertSQL += "@lname,"; insertSQL += "@company_name,"; insertSQL += "@address_1,"; insertSQL += "@address_2,"; insertSQL += "@city,"; insertSQL += "@state_id,"; insertSQL += "@postal_code,"; insertSQL += "@phone,"; insertSQL += "@fax,"; insertSQL += "@email,"; insertSQL += "@web_url,"; insertSQL += "@password,"; insertSQL += "@active,"; insertSQL += "@status,"; insertSQL += "NOW());"; insertSQL += " SELECT last_insert_id()"; MySqlConnection connection = null; try { connection = new MySqlConnection([login to view URL]["DataBaseConnection"].ToString()); [login to view URL](); MySqlCommand cmd = new MySqlCommand(); [login to view URL] = connection; [login to view URL] = insertSQL; [login to view URL](); [login to view URL]("@fname", fname); [login to view URL]("@lname", lname); [login to view URL]("@company_name", company_name); [login to view URL]("@address_1", address_1); [login to view URL]("@address_2", address_2); [login to view URL]("@city", city); [login to view URL]("@state_id", state); [login to view URL]("@postal_code", postal_code); [login to view URL]("@phone", phone); [login to view URL]("@fax", fax); [login to view URL]("@email", company_email); [login to view URL]("@web_url", website_url); [login to view URL]("@password", company_name); [login to view URL]("@active", 1); [login to view URL]("@status", 1); int id = [login to view URL]([login to view URL]()); [login to view URL](id); } finally { if (connection != null) [login to view URL](); }