protected void FillTb() { string strSql = "SELECT " + " NamaTagihan" + ",TglJT" + ",NilaiTagihan" + ",NoUrut" + ",Tipe" + ",(NilaiTagihan - (SELECT ISNULL(SUM(NilaiPelunasan),0) FROM MS_PELUNASAN WHERE NoTagihan = MS_TAGIHAN.NoUrut AND NoKontrak = '" + nomor + "') ) AS SisaTagihan" + " FROM MS_TAGIHAN" + " WHERE NoKontrak = '" + nomor + "' and Tipe != 'ADM'" + " ORDER BY NoUrut"; DataTable rs = Db.Rs(strSql); Rpt.NoData(rpt, rs, "Daftar tagihan untuk kontrak tersebut masih kosong."); for (int i = 0; i < rs.Rows.Count; i++) { if (!Response.IsClientConnected) { break; } TableRow r = new TableRow(); TableCell c; c = new TableCell(); c.Text = rs.Rows[i]["NoUrut"].ToString(); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["NamaTagihan"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = ":"; c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = "Rp. "; c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Num(rs.Rows[i]["NilaiTagihan"]); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = new TableCell(); c.Text = " "; c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.DayIndoShort(rs.Rows[i]["TglJT"]); r.Cells.Add(c); c = new TableCell(); c.Text = " "; c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }