Hi Guys,, I'm trying to make background color in repeater with the condition, data come from database and then bind to repeater. I'm use bootstrap class for the background color.
The condition is :
- If status_anggota "AKTIF" it will show background color green ("text-center bg bg-success") on repeater.
- If status_anggota "TIDAK AKTIF" it will show background color red "text-center bg bg-danger" on repeater.
how to do that ?. Anny help could be appriciate.
This is the code bihind
//This code not working
protected void StatusAnggota()
{
string HtmlStringAktif = "text-center bg bg-success";
string HtmlStringTidakAktif = "text-center bg bg-danger";
using (SqlConnection con = new SqlConnection(koneksi))
{
using (SqlCommand sqlcmd = new SqlCommand())
{
con.Open();
sqlcmd.Connection = con;
sqlcmd.CommandType = CommandType.Text;
sqlcmd.CommandText = "Select * From dbo.tbl_anggota";
using (SqlDataReader rdr = sqlcmd.ExecuteReader())
{
if (rdr.Read())
{
new LiteralControl(HtmlStringAktif = rdr["status_anggota"].ToString());
SqlDataAdapter adp = new SqlDataAdapter(sqlcmd);
DataTable dt = new DataTable();
con.Close();
adp.Fill(dt);
Repeater1.DataSource = dt;
Repeater1.DataBind();
}
else
{
new LiteralControl (HtmlStringTidakAktif = rdr["status_anggota"].ToString());
SqlDataAdapter adp = new SqlDataAdapter(sqlcmd);
DataTable dt = new DataTable();
con.Close();
adp.Fill(dt);
Repeater1.DataSource = dt;
Repeater1.DataBind();
}
}
}
con.Close();
}
}
This is the repeater
<asp:Repeater ID="Repeater1" runat="server">
<HeaderTemplate>
<table style="width: 100%;" id="myTable" class="table table-hover table-responsive table-borderless">
<thead class="table table-dark text-center">
<tr>
<th>ID Anggota
</th>
<th>Nama Anggota
</th>
<th>Alamat
</th>
<th>Nomer Telepon
</th>
<th>Tanggal Bergabung
</th>
<th>Status Anggota
</th>
<th>Saldo (Rp.)
</th>
<th>Catatan
</th>
<th>#
</th>
</tr>
</thead>
<tbody>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td class="text-center">
<%#Eval("id_anggota")%>
</td>
<td style="width: 25%;" class="text-center">
<%#Eval("nama_anggota")%>
</td>
<td style="width: 25%;" class="text-center">
<%#Eval("alamat")%>
</td>
<td class="text-center">
<%#Eval("no_telpon")%>
</td>
<td class="text-center">
<%#Eval("tgl_join","{0: dd MMMM yyyy}")%>
</td>
<td style="width: 10%;">
<%#Eval("status_anggota")%>
</td>
<td style="width: 25%;" class="text-center">
<%#Eval("saldo","{0:Rp 0,00.00}")%>
</td>
<td style="width: 15%;" class="text-center">
<%#Eval("catatan")%>
</td>
<td>
<asp:LinkButton ID="LinkButton1" CommandArgument='<%#Eval("id_anggota") %>' class="fa fa-edit btn btn-warning btn-sm" OnClick="LinkButton1_Click" runat="server"> Detail</asp:LinkButton>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
</tbody>
</table>
</FooterTemplate>
</asp:Repeater>