private void bnBug29877_Click(object sender, EventArgs e)
        {
            MySqlConnection conn = new MySqlConnection();
            conn.ConnectionString = "DataSource=localhost;Database=test;UserID=root;Password=tonchika;PORT=3306";
            conn.Open();
            MySqlCommand cmdCreateTable = new MySqlCommand("DROP TABLE IF EXISTS Bug29877", conn);
            cmdCreateTable.CommandTimeout = 0;
            cmdCreateTable.ExecuteNonQuery();
            cmdCreateTable.CommandText = "CREATE TABLE Bug29877 (" +
                "id INTEGER UNSIGNED NOT NULL auto_increment," +
                "tinyint_value TINYINT UNSIGNED,"+
                "smallint_value SMALLINT UNSIGNED,"+
                "mediumint_value MEDIUMINT UNSIGNED,"+
                "int_value INT UNSIGNED,"+
                "bigint_value BIGINT UNSIGNED,"+
                "datetime_value DATETIME,"+
                "date_value DATE,"+
                "timestamp_value TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,"+
                "time_value TIME,"+
                "year_value YEAR,"+
                "char_value CHAR(10),"+
                "varchar_value VARCHAR(10),"+
                "binary_value BINARY(10),"+
                "varbinary_value VARBINARY(10),"+
                "tinyblob_value TINYBLOB,"+
                "tinytext_value TINYTEXT,"+
                "blob_value BLOB,"+
                "text_value TEXT,"+
                "mediumblob_value MEDIUMBLOB,"+
                "mediumtext_value MEDIUMTEXT,"+
                "longblob_value LONGBLOB,"+
                "longtext_value LONGTEXT,"+
                "enum_value ENUM('TINYINT','SMALLINT','MEDIUMINT','INT','BIGINT'),"+
                "set_value SET('TINYINT','SMALLINT','MEDIUMINT','INT','BIGINT'),"+
                "PRIMARY KEY  (id)"+
            ") ENGINE=InnoDB DEFAULT CHARSET=utf8";
            cmdCreateTable.ExecuteNonQuery();

            MySqlCommand cmd = new MySqlCommand("SELECT * FROM Bug29877", conn);
            cmd.CommandType = CommandType.Text;

            MySqlDataAdapter da = new MySqlDataAdapter(cmd);
            DataTable dt = new DataTable();

            System.Data.DataSet ds = new DataSet("Bug29877");
            System.Byte[] SystemBytes = new System.Byte[] { (byte)'a', (byte)'b', (byte)'c'};

            da.Fill(ds);//, "Bug29877");
            ds.Tables[0].Columns[0].AutoIncrement = true;
            ds.Tables[0].Columns[0].AutoIncrementSeed = 0;
            ds.Tables[0].Columns[0].AutoIncrementStep = 1;

            DataRow dsdr = ds.Tables[0].NewRow();
            dsdr["tinyint_value"] = 1;
            dsdr["smallint_value"] = 2;
            dsdr["mediumint_value"] = 3;
            dsdr["int_value"] = 4;
            dsdr["bigint_value"] = 5;
            dsdr["datetime_value"] = "2007-08-09 12:34:56";
            dsdr["date_value"] = "2007-08-09";
            dsdr["time_value"] = "12:34:56";
            dsdr["year_value"] = "2007";
            dsdr["char_value"] = "abc";
            dsdr["varchar_value"] = "abc";
            dsdr["binary_value"] = "abc";
            dsdr["varbinary_value"] = "abc";
            dsdr["tinyblob_value"] = SystemBytes;
            dsdr["tinytext_value"] = "abc";
            dsdr["blob_value"] = SystemBytes;
            dsdr["text_value"] = "abc";
            dsdr["mediumblob_value"] = SystemBytes;
            dsdr["mediumtext_value"] = "abc";
            dsdr["longblob_value"] = SystemBytes;
            dsdr["longtext_value"] = "abc";
            dsdr["enum_value"] = "INT";
            dsdr["set_value"] = "INT";
            try
            {
                ds.Tables[0].Rows.Add(dsdr);
                da.Update(ds);
            }
            catch (Exception ex)
            {
                Assert.Fail(ex.Message);
            }
            Console.ReadLine();
        }