string constr = "server=localhost;User Id=root;password=root;Database=test";

            MySqlConnection mycon = new MySqlConnection(constr);

            try

            {

                mycon.Open();

                MySqlCommand mycmd = new MySqlCommand("insert into ksk_member(nickname) values('小王')", mycon);

                if (mycmd.ExecuteNonQuery() > )

                {

                    Console.WriteLine("数据插入成功！");

                }

                Console.ReadLine();

            }

            catch (Exception ex)

            {

                return false;

            }

            finally

            {

                mycon.Close();

            }