how to change listbox item color based on condition from datatable c#

Question

Hi Team,

I have values in DataTable from DB in the following way

GID GName GCnt
1 Test1 2
2 Test2 1
3 Test3 2
4 Test4 1

In my list box i have to display the data and color the items based on GCnt value, If GCnt is 2 then red color and if its 1 then Yellow color. DataTextField should be GName , DataValueField should be the GID. Based on the selection i have to get the GID. Can someone help me please

Answer 1

Hum, ok, assume a list box list like this:

Then code to fill above like this:

Sub LoadData()  
    Using conn As New SqlConnection(My.Settings.TEST4)  
        Using cmdSQL As New SqlCommand("SELECT GID, GName, GCnt from Products ORDER BY GName", conn)  
            conn.Open()  
            Dim rst As New DataTable  
            rst.Load(cmdSQL.ExecuteReader)  
  
            ListBox1.DataSource = rst  
            ListBox1.DataBind()      
            Dim iRow = 0  
            For Each lRow As ListItem In ListBox1.Items  
                Dim sHex As String = Hex(rst.Rows(iRow).Item("GCnt")).PadLeft(6, "0")  
                lRow.Attributes.Add("style", "background-color:#" & sHex)  
                iRow += 1  
            Next  
        End Using  
    End Using  
End Sub  
  

and the output is this:

And our data table was this:

Regards,
Albert D. Kallal (Access MVP 2003-2017)
Edmonton, Alberta Canada

Answer 2

Hi @Shagil A ,
First, you can bind the listbox to the database, and then match the value of Gcnt according to the database, and then change the color of the row corresponding to the listbox.
The code:
WebForm1.aspx

<form id="form1" runat="server">  
        <div>  
            <asp:ListBox ID="ListBox1" runat="server"  
                DataTextField="GName"  
                DataValueField="GID">        
            </asp:ListBox>  
        </div>  
 </form>  

WebForm1.aspx.cs

SqlConnection conn = new SqlConnection(***);  
        protected void Page_Load(object sender, EventArgs e)  
        {  
            if (!IsPostBack)  
            {  
                DataTable dts = new DataTable();  
                string str = "select * From GTable";  
                SqlDataAdapter adp = new SqlDataAdapter(str, conn);  
                adp.Fill(dts);  
                ListBox1.DataSource = dts;  
                ListBox1.DataBind();  
                for(int i = 0; i < ListBox1.Items.Count; i++)  
                {  
                    var GCnt = dts.Rows[i].ItemArray[2];  
                    var a = ListBox1.Items[i];                    
                        if (GCnt.ToString() == "1")  
                        {  
                            a.Attributes.Add("style", "background-color:red");  
                        }  
                        else  
                        {  
                            a.Attributes.Add("style", "background-color:yellow");  
                        }                    
                }                
            }  
        }  

The Result:

Best regards,
Lan Huang

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.