需要从SQL情况访问True或False

Question

在sql案例方法中，声明了真或错误的条件，但是我需要将真或错误设计为图标(正确/错误的图标(。1.倍我附加了我的.NETC＃代码

 char c = 'A';
    int Role = 1, Value;
    string RoleMenu = "";
    this.str_RoleKey = ds.Tables[0].Rows[0]["RoleKey"].ToString();
    foreach (DataRow dr in ds.Tables[0].Rows)   
    {
        if (dr["RoleKey"].ToString() != "")
        {
            this.str_Case += " ,case when " + c + ".MenuKey is null then 'false' else 'true' end '" + Role + "' ";
            this.str_Join += " left outer join (select * from MenuRole where RoleKey='" + this.str_RoleKey + "') " + c + " on Me.MenuKey = " + c + ".MenuKey ";
            RoleMenu += "<td>%%"+ Role +"%%</td>";
            c++;
            Role++;
        }
    }
    RoleMenu = "<td>%%MenuName%%</td>" + RoleMenu;
    string str_sql1 = " select Me.MenuKey,Me.MenuName "
        + this.str_Case
        + " from Menu Me"
        + this.str_Join;

Answer 1

而不是从您的SQL返回varchar('true'或'False'(，而是让它返回bit，其中1个为true，0为false。

<</p>