如何将DataGridView中的“True”更改为Yes？

Basically it says it all in my question. I don't know how to that. I've tried this (replace true/false in datagridview columns) but it doesn't work for me. My SQL code is:

基本上它在我的问题中说明了一切。我不知道该怎么做。我试过这个(在datagridview列中替换true / false)但它对我不起作用。我的SQL代码是:

create table ejemploc
(
id int not null,
nombre varchar(35),
opcion1 varchar(5),
opcion2 varchar(5),
opcion3 varchar(5),
constraint pkid primary key (id)
)engine=innodb;

and my code to populate my DataGridView is:

我填充DataGridView的代码是:

private void CargaDataGridView()
        {
            conexion.Open();
            dataGridView1.Rows.Clear();
            try
            {
                cmd.CommandText = "select * from ejemploc";
                rd = cmd.ExecuteReader();

                while (rd.Read())
                {
                    this.dataGridView1.Rows.Add(rd.GetValue(0), rd.GetValue(1), rd.GetValue(2), rd.GetValue(3), rd.GetValue(4));
                }
                conexion.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
            }

I'll appreciate any help. Thanks!

我会感激任何帮助。谢谢!

EDIT:

I got the answer, thanks to https://*.com/users/491243/jw and https://*.com/users/1711633/vond-ritz

我得到了答案,感谢https://*.com/users/491243/jw和https://*.com/users/1711633/vond-ritz

change "cmd.CommandText = "select * from ejemploc";" to

更改“cmd.CommandText =”select * from ejemploc“;”至

cmd.CommandText = "SELECT  id,nombre, CASE WHEN opcion1 = 'True' THEN 'Sí' ELSE 'No' END opcion1, CASE WHEN opcion2 = 'True' THEN 'Sí' ELSE 'No' END opcion2, CASE WHEN opcion3 = 'True' THEN 'Sí' ELSE 'No' END opcion3 FROM ejemploc";

1 个解决方案

#1

SELECT  id,
        nombre,
        CASE WHEN opcion1 = 'True' THEN 'Yes' ELSE 'No' END opcion1,
        CASE WHEN opcion2 = 'True' THEN 'Yes' ELSE 'No' END opcion2,
        CASE WHEN opcion3 = 'True' THEN 'Yes' ELSE 'No' END opcion3
FROM    ejemploc

or if true = 1 then,

或者如果true = 1那么,

SELECT  id,
        nombre,
        CASE WHEN opcion1 = 1 THEN 'Yes' ELSE 'No' END opcion1,
        CASE WHEN opcion2 = 1 THEN 'Yes' ELSE 'No' END opcion2,
        CASE WHEN opcion3 = 1 THEN 'Yes' ELSE 'No' END opcion3
FROM    ejemploc