private void SearchAmbilKtm() //select dari simak { SqlConnection conn = null; try { string konekKe = null; string queryUse = null; cQuery qr = new cQuery(); cKoneksi koneksi = new cKoneksi(); if (rbMahasiswa.Checked == true) { konekKe = "2";//2 = ke simak queryUse = qr.qSearchMhsAmbilKtm(nik, nama); } else { konekKe = "4";//4 = ke payroll queryUse = qr.qSearchAmbilKartuPeg(nik, nama); } conn = new SqlConnection(koneksi.konekMsSql(Convert.ToChar(konekKe))); SqlCommand cmd = null; //--------------------------------- cmd = new SqlCommand(queryUse, conn); //--------------------------------- conn.Open(); cmd.ExecuteNonQuery(); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds, "Authors_table"); //--------------------- dataGridView1.DataSource = ds; dataGridView1.DataMember = "Authors_table"; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); conn.Dispose(); } }