private void Bind() { DataTable rs; string strSql; rs = Db.Rs("SELECT DISTINCT YEAR(TglKontrak), MONTH(TglKontrak) FROM MS_KONTRAK WHERE Project = '" + project.SelectedValue + "' AND CaraBayar='KPR'" + " ORDER BY YEAR(TglKontrak), MONTH(TglKontrak)"); for (int i = 0; i < rs.Rows.Count; i++) { thnKontrak.Items.Add(new ListItem( Cf.MonthnameEnglish((int)rs.Rows[i][1]) + " " + rs.Rows[i][0].ToString() , rs.Rows[i][0] + "," + rs.Rows[i][1] )); } thnKontrak.SelectedIndex = thnKontrak.Items.Count - 1; strSql = "SELECT * FROM REF_JENIS WHERE Project = '" + project.SelectedValue + "' ORDER BY SN"; rs = Db.Rs(strSql); for (int i = 0; i < rs.Rows.Count; i++) { string v = rs.Rows[i]["Jenis"].ToString(); string t = v + " - " + rs.Rows[i]["Nama"].ToString(); jenis.Items.Add(new ListItem(t, v)); } strSql = "SELECT DISTINCT Lokasi FROM MS_KONTRAK WHERE Project = '" + project.SelectedValue + "' ORDER BY Lokasi"; rs = Db.Rs(strSql); for (int i = 0; i < rs.Rows.Count; i++) { lokasi.Items.Add(new ListItem(rs.Rows[i][0].ToString())); } }