public string Post(Tb_Tahun_Pelajaran tbtp) { try { string query = @" INSERT INTO [dbo].[Tb_Tahun_Pelajaran] ([Tahun_pelajaran]) VALUES" + "('" + tbtp.Tahun_pelajaran + "')"; DataTable table = new DataTable(); using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["LSPdb"].ConnectionString)) { using (var cmd = new SqlCommand(query, conn)) { using (var da = new SqlDataAdapter(cmd)) { cmd.CommandType = CommandType.Text; da.Fill(table); } } } return("Insert Successfully"); } catch (Exception err) { return(err.Message); } }
public string Put(Tb_Tahun_Pelajaran tbtp) { try { string query = @"UPDATE [dbo].[Tb_Tahun_Pelajaran] SET " + " [Tahun_pelajaran] = '" + tbtp.Tahun_pelajaran + "'" + " WHERE Tahun_pelajaran =''"; return("Update Successfully"); } catch (Exception err) { return(err.Message); } }