This sample shows how to use CSS to create conditional item coloring with DropDownLists and ListBoxes (ASP.Net controls). As you see, in order to show the code here, with a DropDownList and a Listbox, some code lines are doubled. Just use whichever one applies for your useage.
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQLClient" %>
<script language="VB" Runat="server">
Sub Page_Load(Source as Object, E as EventArgs)
Dim conn as SqlConnection
conn = New SqlConnection(ConfigurationManager.ConnectionStrings("YourCnString").ConnectionString)
Dim da as SqlDataAdapter
Dim ds as DataSet
da = New SqlDataAdapter("Select * from Products ", conn)
ds = New DataSet()
da.Fill(ds, "Products")
Dim i as Integer
For i = 0 To ds.Tables(0).Rows.Count - 1
ddl1.Items.Add(New ListItem(String.Format("{0:c}",ds.Tables(0).Rows(i)("UnitPrice")), ds.Tables(0).Rows(i)("ProductID")))
List1.Items.Add(New ListItem(String.Format("{0:c}",ds.Tables(0).Rows(i)("UnitPrice")), ds.Tables(0).Rows(i)("ProductID")))
If ds.Tables(0).Rows(i)("UnitPrice") <= 20 Then
ddl1.Items(i).Attributes.Add("style", "color:red")
List1.Items(i).Attributes.Add("style", "color:red")
Else
ddl1.Items(i).Attributes.Add("style", "color:green")
List1.Items(i).Attributes.Add("style", "color:green")
End If
Next
End Sub
</script>
<html>
<head>
<meta name="GENERATOR" Content="ASP Express 5.0">
<title>Untitled</title>
</head>
<body>
<form id="form1" Runat="server">
<asp:DropDownList ID="DDL1" Runat="Server" ></asp:DropDownList>
<asp:ListBox ID="List1" Runat="Server" ></asp:ListBox>
</form>
</body>
</html>
|
| Author: Chris Jones 28 Mar 2008 | Member Level: Bronze Points : 0 |
Thanks Mohan
|