Um...did you check your parameters?
cmd.Parameters.AddWithValue("@VendorName", vendorName);
cmd.Parameters.AddWithValue("@PhoneNo", website);
cmd.Parameters.AddWithValue("@Website", email);
cmd.Parameters.AddWithValue("@Email", contactPerson);
cmd.Parameters.AddWithValue("@ContactPerson", address);
cmd.Parameters.AddWithValue("@Address", city);
cmd.Parameters.AddWithValue("@City", state);
cmd.Parameters.AddWithValue("@State", country);
cmd.Parameters.AddWithValue("@PinCode", phNo);
cmd.Parameters.AddWithValue("@Country", pCode);
Aren't you putting the wrong values in the wrong parameters, except for the vendor name?
The phone number is getting the website, the website is getting the email, ...