public string CreateMahasiswa(Mahasiswa mhs)
{
string msg = "GAGAL";
SqlConnection sqlcon = new SqlConnection("Data Source=DESKTOP-O339P25;Initial Catalog=TI UMY;Persist Security Info=True;User ID=sa;Password=dede162700");
string query = string.Format("Insert into dbo.Mahasiswa values ('{0}', '{1}', '{2}', '{3}',)", mhs.nama, mhs.nim, mhs.prodi, mhs.angkatan);
//NIM = '{0}'", nim
SqlCommand sqlcom = new SqlCommand(query, sqlcon); //yang dikirim ke sql
try
{
sqlcon.Open(); //membuka connection sql
Console.WriteLine(query);
sqlcom.ExecuteNonQuery(); //mengeksusi untuk memasukkan data
sqlcon.Close();
msg = "sukses";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine(query);
msg = "GAGAL";
}
return(msg);
}