protected void PopulateRekapDosen() { string CS = ConfigurationManager.ConnectionStrings["MainDb"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { try { con.Open(); SqlCommand CmdDosen = new SqlCommand("" + "SELECT bak_dosen.prodi, bak_prog_study.jenjang, bak_prog_study.prog_study, COUNT(*) AS jumlah " + "FROM bak_dosen INNER JOIN " + "bak_prog_study ON bak_dosen.prodi = bak_prog_study.id_prog_study " + "WHERE aktif = 'yes' AND tim = '0' " + "GROUP BY bak_dosen.prodi, bak_prog_study.jenjang, bak_prog_study.prog_study " + "ORDER BY jenjang, prog_study asc" + "", con); CmdDosen.CommandType = System.Data.CommandType.Text; CmdDosen.Parameters.AddWithValue("@prodi", this.Session["level"].ToString()); DataTable TableDosen = new DataTable(); TableDosen.Columns.Add("KODE"); TableDosen.Columns.Add("PROGRAM STUDI"); TableDosen.Columns.Add("JUMLAH"); using (SqlDataReader rdr = CmdDosen.ExecuteReader()) { if (rdr.HasRows) { while (rdr.Read()) { DataRow datarow = TableDosen.NewRow(); datarow["KODE"] = rdr["prodi"]; datarow["PROGRAM STUDI"] = rdr["prog_study"]; datarow["JUMLAH"] = rdr["jumlah"]; TableDosen.Rows.Add(datarow); } //Fill Gridview this.GvRekapDosen.DataSource = TableDosen; this.GvRekapDosen.DataBind(); } else { //clear Gridview TableDosen.Rows.Clear(); TableDosen.Clear(); GvRekapDosen.DataSource = TableDosen; GvRekapDosen.DataBind(); this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('Data Tidak Ditemukan');", true); return; } } } catch (Exception ex) { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('" + ex.Message.ToString() + "');", true); return; } } }
protected void PopulateDosen() { string CS = ConfigurationManager.ConnectionStrings["MainDb"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { try { con.Open(); SqlCommand CmdDosen = new SqlCommand("" + "SELECT bak_dosen.no, bak_dosen.nama, bak_dosen.nidn, bak_dosen.nik, bak_dosen.nip, bak_dosen.pangkat, bak_dosen.jabatan, bak_dosen.tmlahir, bak_dosen.tglahir, bak_dosen.pendidikan, " + "bak_dosen.prodi, bak_dosen.hp, bak_dosen.alamat, bak_dosen.aktif, bak_prog_study.prog_study " + "FROM bak_dosen INNER JOIN " + "bak_prog_study ON bak_dosen.prodi = bak_prog_study.id_prog_study " + "WHERE prodi = @prodi AND aktif = 'yes' AND tim = '0' ORDER BY nama ASC" + "", con); CmdDosen.CommandType = System.Data.CommandType.Text; CmdDosen.Parameters.AddWithValue("@prodi", this.Session["level"].ToString()); DataTable TableDosen = new DataTable(); TableDosen.Columns.Add("NIDN/NUP/NIDK"); TableDosen.Columns.Add("NAMA"); TableDosen.Columns.Add("AKTIF"); using (SqlDataReader rdr = CmdDosen.ExecuteReader()) { if (rdr.HasRows) { while (rdr.Read()) { DataRow datarow = TableDosen.NewRow(); datarow["NIDN/NUP/NIDK"] = rdr["nidn"]; datarow["NAMA"] = rdr["nama"]; datarow["AKTIF"] = rdr["aktif"]; TableDosen.Rows.Add(datarow); } //Fill Gridview this.GvRekapDosen.DataSource = TableDosen; this.GvRekapDosen.DataBind(); } else { //clear Gridview TableDosen.Rows.Clear(); TableDosen.Clear(); GvRekapDosen.DataSource = TableDosen; GvRekapDosen.DataBind(); this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('Data Tidak Ditemukan');", true); return; } } } catch (Exception ex) { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('" + ex.Message.ToString() + "');", true); return; } } }