MKPK

MySqlConnection vid = new MySqlConnection
              ("DataSource=localhost; Database=moe; user ID=root; Password=root");
            {
                MySqlCommand xp = new MySqlCommand("INSERT INTO `moe`.`formdata` (`formname`, `formtitle`, `formic`, `formiccolor`, `formreligion`, `formtelmobile`, `formtelhome`, `formteloffice`, `formtelemergency`, `formemail`) VALUES (@formname, @formtitle, @formic, @formiccolor, @formreligion, @formtelmobile, @formtelhome, @formteloffice, @formtelemergency, @formemail);", vid);

                xp.Parameters.AddWithValue("@formtitle", DropDownList1.Text);
                xp.Parameters.AddWithValue("@formname", TextBox1.Text);
                xp.Parameters.AddWithValue("@formic", TextBox2.Text);
                xp.Parameters.AddWithValue("@formiccolor", DropDownList2.Text);
                xp.Parameters.AddWithValue("@formreligion", TextBox11.Text);
                xp.Parameters.AddWithValue("@formtelmobile", TextBox9.Text);
                xp.Parameters.AddWithValue("@formtelhome", TextBox13.Text);
                xp.Parameters.AddWithValue("@formteloffice", TextBox14.Text);
                xp.Parameters.AddWithValue("@formtelemergency", TextBox15.Text);
                xp.Parameters.AddWithValue("@formemail", TextBox10.Text);

                vid.Open();
                xp.ExecuteNonQuery();
                vid.Close();