public string UpdateMahasiswaByNIM(Mahasiswa mhs) { string msg = "Gagal"; sqlConnection = new SqlConnection(connectionString); string query = string.Format("Update dbo.Mahasiswa set Nama = '{0}', Prodi = '{1}', Angkatan = '{2}' where NIM = '{3}'", mhs.nama, mhs.prodi, mhs.angkatan, mhs.nim); SqlCommand cmd = new SqlCommand(query, sqlConnection); try { sqlConnection.Open(); cmd.ExecuteNonQuery(); sqlConnection.Close(); msg = "Sukses"; } catch (Exception ex) { Console.WriteLine(ex.Message); Console.WriteLine(query); } return(msg); }
public string CreateMahasiswa(Mahasiswa mhs) { string msg = ""; SqlConnection sqlcon = new SqlConnection("Data Source=TSAQIFJR\\MSSQLSERVER01;Initial Catalog=\"TI UMY\";Persist Security Info=True;User ID=sa;Password=2021Lulus"); string query = String.Format("insert into dbo.Mahasiswa values ('{0}', '{1}', '{2}', '{3}')", mhs.nama, mhs.nim, mhs.prodi, mhs.angkatan); SqlCommand sqlcom = new SqlCommand(query, sqlcon); try { sqlcon.Open(); Console.WriteLine(query); sqlcom.ExecuteNonQuery(); sqlcon.Close(); msg = "Sukses"; } catch (Exception ex) { Console.WriteLine(ex.Message); Console.WriteLine(query); msg = "GAGAL CREATE"; } return(msg); }