Problem Solved
<asp:Repeater ID="Repeater1" runat="server" OnItemDataBound="OnItemDataBound">
<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 runat="server" id="row">
<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%;" class="text-center">
<%#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>
The Code Bihind
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ShowData();
}
}
public void ShowData()
{
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";
SqlDataAdapter adp = new SqlDataAdapter(sqlcmd);
DataTable dt = new DataTable();
adp.Fill(dt);
Repeater1.DataSource = dt;
Repeater1.DataBind();
con.Close();
AutoNumberIDAnggota();
}
}
}
protected void OnItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
string HtmlStringAktif = "text-center bg bg-success";
string HtmlStringTidakAktif = "text-center bg bg-danger";
HtmlTableRow row = e.Item.FindControl("row") as HtmlTableRow;
if ((e.Item.DataItem as DataRowView)["status_anggota"].ToString() == "AKTIF")
{
row.Attributes["class"] = HtmlStringAktif;
}
else
{
row.Attributes["class"] = HtmlStringTidakAktif;
}
}
}