如何获取列值为true的列名 [英] how to get column name for which column value is true

问题描述

i want to find out all column name which value is true in database by linq query and want to show as text in label

var power = from st in obj.admin_login_tables
                       where st.user_name == uname
                       select new {a = st.user_detail_edit,b = st.Order_status,c = st.Order_status_edit,d = st.user_detail_show,f = st.book_post, };

so above is my query in which m try to finding the true values column but m not  this 
and thanx in advance

推荐答案

嗨
试试这样，

修改你的需要。

Hi Try like this,
modify as for your needs.

DataClasses1DataContext obj = new DataClasses1DataContext();

        string name = "somename";
        var power = from st in obj.admin_login_tables
                    where st.User_name == name
                    select new { a = st.user_detail_edit, b = st.Order_status, c = st.Order_status_edit, d = st.user_detail_show, f = st.book_post, };
       var temp =  power.FirstOrDefault();
       if (temp != null)
       {
           if (temp.a)
               lbl.Text = "a,";
           if (temp.b)
               lbl.Text += "b,";
           if (temp.c)
               lbl.Text += "c,";
           if (temp.d)
               lbl.Text += "d,";
           if (temp.f)
               lbl.Text += "f,";
           lbl.Text = lbl.Text.Trim(',');

       }

这篇关于如何获取列值为true的列名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！