将布尔值恢复为真到假

在我的程序中，有一种方法可以备份如下：

INSERT INTO `vente` VALUES('1','101','Mehdi','Ismail','3','107','Serpina'
,'1','Ephese','3','1','0','0','2014-05-20','0615','Pacha','9','0','60','0','0',
'False','True','1','5','1',
'2014-07-02 05:14:45','1','2015-01-05 03:17:47')

当我恢复时，True 字段存储为零

我使用 StreamReader 读取 CSV 文件并使用命令 ExecutNonQuery（）

该列在 mysql 5.5 中设计为 bool。

在恢复期间，此字段是否转换为字符串？

如果我使用加载数据文件而不是我的方法，这可以解决这个问题吗？

这是我恢复数据的方法（它有点长，但有些人要求看看我为此做了什么）

    private void RestoreData()
    {
       // some declaration for labels and textboxes
        DirectoryInfo d = new DirectoryInfo(pathname);
        FileInfo[] Files = d.GetFiles("*.sql");
        if (Files.Length == 0)
        {
            MessageBox.Show("There is no sql files in this folder.");
            return;
        }
        for (int i = 0; i < Files.Length; ++i)
        {
            string filename = System.IO.Path.Combine(pathname, Files[i].ToString());
            TotalRows = TotalRows + File.ReadAllLines(filename).Length;
            MyArray[i] = File.ReadAllLines(filename).Length.ToString();
        }
        using (MySqlConnection conn = new MySqlConnection(PublicVariables.cs))
        {
            conn.Open();
            for (int i = 0; i < Files.Length; ++i)
            {
                string filename = System.IO.Path.Combine(pathname, Files[i].ToString());
                string tblname = Files[i].ToString();
                tblname = tblname.Substring(0, tblname.Length - 4);
                DialogResult result = MessageBox.Show("Would you restore the table " + tblname + " ?", "", MessageBoxButtons.YesNo);
                MySqlCommand cmd;
                if (result == DialogResult.Yes)
                {
                    cmd = new MySqlCommand("TRUNCATE TABLE " + tblname, conn);
                    try
                    {
                        cmd.ExecuteNonQuery();
                    }
                    catch (MySqlException e)
                    {
                        MessageBox.Show(e.Number.ToString() + " -> " + e.Message.ToString());
                        conn.Close();
                        button5.Visible = true;
                        return;
                    }
                    int RowsNbr = Convert.ToInt32(MyArray[i]);
                    System.IO.StreamReader file = new System.IO.StreamReader(filename, Encoding.UTF8, true);
                    for (int a = 0; a < RowsNbr; ++a)
                    {
                        string cmdstr = file.ReadLine();
                        cmdstr = cmdstr.Replace("'n'r", string.Empty);
                        cmd = new MySqlCommand(cmdstr, conn);
                        try
                        {
                            cmd.ExecuteNonQuery();
                        }
                        catch (MySqlException e)
                        {
                            MessageBox.Show(e.Number.ToString() + " -> " + e.Message.ToString());
                            button5.Visible = true;
                            file.Close();
                            return;
                        }
                        cmd.Dispose();
                        ++counter;
                        int barvalue = (counter * 100 / TotalRows);
                        progressBar1.Value = barvalue;
                        barproceed = true;
                    }
                }
                if (!barproceed)
                {
                    counter = counter + Convert.ToInt32(MyArray[i]);
                    int bar1value = (counter * 100) / TotalRows;
                    progressBar1.Value = bar1value;
                }
                barproceed = false;
            }
        }

SELECT d.d
     , d.d + 0
  FROM ( SELECT 'foo' AS d
          UNION ALL SELECT 'True'
          UNION ALL SELECT 'False' AS d
          UNION ALL SELECT 'a1'
          UNION ALL SELECT '123def'
          UNION ALL SELECT ' -12-345-67'
          UNION ALL SELECT '+42'
       ) d
d            d + 0  
-----------  ------
foo               0
True              0
False             0
a1                0
123def          123
 -12-345-67     -12
+42              42